i am attempting to import multiple tabs from a single excel file. each tab has a different name and i have over 50 of them. unfortunately,i have been unable to pull them all in without manually importing each one.
I'm in the process of doing something very similar.
You can import a spreadsheet by creating a macro and using the TransferSpreadsheet command, and then filling in the action arguments. You'll find help file for completing these in if you have any problems.
Unfortunately I'm stuck with the Range action. I need to upload several cells, for example B16:E20, C20:C27, ... etc. Maybe, if you manage that action argument you could help me?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.