-
Sep 28th, 2017, 05:39 AM
#1
Thread Starter
Registered User
Possible to build a script to run and process an excel file VBA macro?
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.
-
Sep 28th, 2017, 12:42 PM
#2
Re: Possible to build a script to run and process an excel file VBA macro?
it's possible, but it might be easiest to convert you macro to VBScript
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|