Specify a certian sheet with Transferspreadsheet action

S

stickandrock

I am trying to build a macro to import from excel a certain sheet within an
excel file for a specific range

Under the filename if I reference :

S:\PMPC\ManpowerForecastingTracking\Labor Forecast Models\Project Hour
Dollar Tracking\Project Hour Tracking.xls

It will do the cells I want but will default to the first sheet in the file

I want it to pull those same cells, but for sheet named: MONTHLY

not sure of the formatting neccessary
 
J

John Nurick

Put the sheet name in the Range argument of the macro, followed by a !
or $ (I can never remember which), e.g.
MONTHLY!
 

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

Copy Data from One sheet to Different Sheets 1
Conditional Formatting to Compare Two Sheets of Data 1
Contract / P&L management tool sought - simple is best 2
Macro to copy portion of each sheet and paste into the first sheet asa picture 1
Using TransferSpreadsheet Macro to import a single sheet from exce 1
Code execution is correct but generates Error :The file you aretrying to open is in a different form 3
Generic Resource Substitution 3
Importing Excel Sheet into Access Database using VBA 2

Top