Firstly, very many thanks indeed for picking up my problems.
- I don’t know any other way to apply a standardised macro to successive Work Sheets
- You will see from the “two” examples enclosed that the Macros are specific to the class of downloaded CSV
- The following is a snapshot of my automation so far.
My Test Samples. I am sorry I discovered at the end that communication channels to the forum do not permit my transferring these files to you. If you have any other conduit I can send you the necessary attachments.
Using Apple Computer and System 10 12 6
I have prepared foreshortened (for your convenience) test files with some substitutions in narrative detail for security. These files represent downloads from my Bank and Credit Card. There are at the moment two other sources which are broadly the same. These I haven’t bothered to send you because the automation problems are the same for all data sources.
To use the examples,
Save following Files to Documents:
Save following Files to Downloads:
By running c) all four files will be loaded to the Screen
Take d) and invoke Macros with Developer in Excel’s Menu
Name the Macro as Work1 and press return
Copy and paste Work1 into the Macro (don’t duplicate the Sub Name and End Sub)
Run or step through the Macro, which reformats the csv for WorkBook1, ready for uploading to my Accounting software.
Do likewise for e).
Don’t worry about Comments in the draft Macros Work1 and Work2. These are just development history which I have yet to tidy up.
My aim, of course is to embrace all stages with a single Apple Script (item c). However, I don’t know how to begin to translate Work1 and Work2 into Apple Script or even Call the ‘VBA’ within a Scripted Commands file such as c).
The initial download of WorkBooks 1 & 2 has, I think, got to be a manual operation, because logging into the Bank, Credit Card or whatever is protected in most if not all cases by demands for a random selection of characters from passwords and identity strings. Further, successive Downloads must have a Common Name which is handed on from job to job.