I have a bit of VBA Code written specifically for excel macro.
Now this macro needs to be run on a bunch of excel sheets, after which the sheet needs to be imported to access.
I was wondering if there is a way that I can run the macro(code) from within Access, as it would help automate the entire process.
I really don't want to set up a macro in the traditional way since the sheets change daily. and copying & pasting is out of the question.
So basically teh point is :
There is a new sheet everyday. Some lines need to be deleted etc. and cells need to be reformatted. Then the sheet is saved as text and imported into Access.
How do I automate this process using VBA code. Can i run it from within access??
Pls Help
Thanks
Now this macro needs to be run on a bunch of excel sheets, after which the sheet needs to be imported to access.
I was wondering if there is a way that I can run the macro(code) from within Access, as it would help automate the entire process.
I really don't want to set up a macro in the traditional way since the sheets change daily. and copying & pasting is out of the question.
So basically teh point is :
There is a new sheet everyday. Some lines need to be deleted etc. and cells need to be reformatted. Then the sheet is saved as text and imported into Access.
How do I automate this process using VBA code. Can i run it from within access??
Pls Help
Thanks