"Output to" Macro and specifying an excel worksheet

  • Thread starter Thread starter Sorry Novice
  • Start date Start date
S

Sorry Novice

I'm trying to set up a Macro that with dump data into a
specified worksheet in and excel file and I can't get the
path right. Here is what I have c:\\desktop\monthly
report.xls\march.

I know, I know they shouldn't give the keys to the car to
someone who doesn't know how to drive, but can anyone help?
 
Dear Novice,

Your path below is obviously wrong; there should be no double backslashes in
it for a local drive.
C:\desktop\... MAY be correct if your OS is Win98 or earlier (if memory
helps, that is, I've been away from Win98 for 3 years or so).
If your OS is Win2K or later, then the path to the desktop must be something
like:
C:\Documents And Settings\UserName\Desktop
If you already have the file on your desktop (the file itself saved on the
desktop, not just a shortcut), right-click on it and check the full path
where it reads "Location:" on the General tab.
If not, a good way to verify the correct path is to open your Windows
Explorer and find the target folder (desktop). When you select it, the
correct path will appear in the address box right below the toolbar.

HTH,
Nikos
 
Hi, I am also a novice and had the a similar problem. After I found the right path the "output To" action would replace my entire workbook rather than just the specific work sheet. I found that the "TransferSpreadsheet" action was what I needed. There I can specify the work sheet I want to repeatedly update by entering its name in "Range" in the action arguments. I placed a Command Button on my form to run this macro

Gle

----- Sorry Novice wrote: ----

I'm trying to set up a Macro that with dump data into a
specified worksheet in and excel file and I can't get the
path right. Here is what I have c:\\desktop\monthly
report.xls\march

I know, I know they shouldn't give the keys to the car to
someone who doesn't know how to drive, but can anyone help
 
Back
Top