Transfer excel sheet 3

[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!!!

 

[Ken Snell [MVP]]

see my reply in the original thread.