Output to macro question

  • Thread starter Thread starter Slacker
  • Start date Start date
S

Slacker

I'm trying to Output to a specific worksheet in an excel
file and I can't get the path correct. Can someone tell
me how to specify the specific worksheet?
C:\\Desktop\Monthly Report.xls\March doesn't work.
March is the specific worksheet
 
Try
C:\\Desktop\Monthly Report.xls!March
You use it the same way you would if you were using a cell formula to access data in a different workbook

----- Slacker wrote: ----

I'm trying to Output to a specific worksheet in an excel
file and I can't get the path correct. Can someone tell
me how to specify the specific worksheet?
C:\\Desktop\Monthly Report.xls\March doesn't work.
March is the specific workshee
 
Back
Top