Specify a certian sheet with Transferspreadsheet action

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

stickandrock - 27 Apr 2005 20:45 GMT

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

Reply to this Message

John Nurick - 27 Apr 2005 21:34 GMT

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

>I am trying to build a macro to import from excel a certain sheet within an
>excel file for a specific range
[quoted text clipped - 9 lines]
>
>not sure of the formatting neccessary

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

Reply to this Message

Klatuu - 27 Apr 2005 23:37 GMT

What function are you using do to the import?

> I am trying to build a macro to import from excel a certain sheet within an
> excel file for a specific range
[quoted text clipped - 9 lines]
>
> not sure of the formatting neccessary

Reply to this Message