Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
compile/syntax error to save active book to new location on networ
I'm just a beginner at writing macros. And I'm really lost with proper
syntax in order to point to the desired directory location where we need the file saved. I recorded the macro, and then edited respective to tab names, etc. I'm thinking it's maybe the syntax around the TimePeriod string. I'm also not familiar with all the SaveAs conditions. Here's the statement that where I get the error: ActiveWorkbook.SaveAs([Q:\Finance\Forecast\2007\"&(TimePeriod"\TRG\Prelim Actual vs Forecast],[.xls],[""],[Normal],[""],[""],[False],[False],[""],[""],[""],[""]) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
help with this error-Compile error: cant find project or library | Excel Discussion (Misc queries) | |||
VBA Error Message "Compile Error...." | Excel Discussion (Misc queries) | |||
Macro Error when moved Xcel Sheets from User's Home Dir to Networ | New Users to Excel | |||
How do I get rid of "Compile error in hidden module" error message | Excel Discussion (Misc queries) |