Possible to build a script to run and process an excel file VBA macro?

[songhaegyo]

Hello,

I am new to VB and i have a question.

I have a new file (.csv) everyday that is full of data and i typically arrange this in excel with a Macro manually. I was wondering if This could be automated, i.e. setting up a scheduled job everyday to run the macro to tidy the csv file, before uploading this up into microsoft Access database.

How do I write this code? Furthermore, the file name changes everyday (it's named by XXXX(Insert DAte).csv) . Is this possible to automate? I have saved the excel vba module to a personal project, so this should be available to all files.

[DEXWERX]

it's possible, but it might be easiest to convert you macro to VBScript