Transfer excel sheet 3

M

Maxwell

Help

Making a macro to pull in a specific sheet within Excel
thru use of macro function 'TransferSpreadsheet'.

My pathway is c:\SalesHistory\Sales2003.xls

This pathway only brings up the first sheet.

How do I specify 'Sheet3'?

Please write down how my pathway is suppose to look like.

Thank you much!!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Transfer from Excel pathway 3
Automating Excel to run an auto open macro in the sheet. 4
Exporting from Access to multiple sheets in excel 0
Word to Excel: Export comments with text and line number 0
Excel Data Transfer Issue (strange situation) 1
Excel VBA - macro that copies the sheets to another workbook 3
Using TransferSpreadsheet Macro to import a single sheet from exce 1
How to "freeze" all cells in Excel sheets? 1

Top