Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

importing from excel

Status
Not open for further replies.

R9772

Technical User
Aug 15, 2002
76
0
0
US
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.

can anyone help me with this?

Thanks.
 
Hi,

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?

Hope that's been of help


[PC2]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top