Hi all
I'm looking for a method to run a set of macros in an existing excel spreadsheet, by clicking a button in Access.
Here is the scenario I have some data in a spreadsheet that I run a macro on that macro opens another excel workbook and imports some data then I run a further macro on that data to enter data into another spread sheet, from there I click a button in Access that imports the data I require into the database.
I know there is probably a much easier method to this but I have inherited the original spreadsheets and my employer wants to keep the method I'm looking for a way to automate it from Access
I can run the first macro no problem, but how do i run the macro from the open book1 that completes the manipulation of the spreadsheet data
I already have a solution for importing the data from the final spreadsheet
so in short what i am lookin to do is
Open Spreadsheet1 and run macro1 (I can do this)
Run Macro2 from the spreadsheet that macro1 opens
any ideas??