How to read data from a CSV file wVBA to copy from one workbook and Update to another automatically

[Sebasti]

Hi There,

I have a CSV file with a variable name “Daily Postings DDMMYY″ but the date DDMMYY keeps changing every day when a new CSV file is created in my folder :S:\My Documents.

Basically i need a VBA to open this CSV file using a notepad and copy the data to my Excel Master workbook “Sample file.xlsm” Sheet “Postings” using the Delimiter Semicolon.
Since i am new to macro im finding it difficult to achieve this…Appreciate if someone can help since this action would fully automate the remaining tasks in my daily reporting.

Cheers

Sebasti

 

[Marc L]

Hi,

no need Notepad 'cause Excel yet opens any text file !
Activate Macro Recorder, call either Open or
From a file (via Data menu) and well answer to the assistant :
you will get your code !
​

 

[Sebasti]

Hi,

no need Notepad 'cause Excel yet opens any text file !
Activate Macro Recorder, call either Open or
From a file (via Data menu) and well answer to the assistant :
you will get your code !
​

Thanks Marc for your answer. however as i stated in my query my CSV file name is variable with each day's date along with the text "Daily Postings.....".

 

[p45cal]

Still do as Marc L suggests and post the code here when you have successfully got one file to be imported as you want it. We/someone will tweak your code to deal with filename changes.
Would you want the filename to follow the current day's date, or perhaps bring up a dialog to allow you to choose the file?

 

[Marc L]

Using GetOpenFilename method, follow its sample in VBA inner help …

​