I don't know why that's happening as the code runs fine for me (from within
Excel). You might try it without the extension as Excel will add the right
extension anyway based on the file type:
Excel.Application.ActiveWorkbook.SaveAs "c:\test1", 52
If that doesn't work then try to save it as any name that works and then
rename it.
--
Jim
| right sorry what i ment to say is i get an error when i specify the c:\
| before the file name...
|
| when i try this i get:
|
| Run-time error '1004':
|
| this extension cannot be used with the selected file type. change the
file
| extension in the file name text box or select a different file type by
| changing the save as type.
|
|
| "Jim Rech" wrote:
|
| > Excel saves to the current folder if you do not specify one. (In my
example
| > I specified c:\).
| >
| > So add the path in the file save or change the current folder (ChDrive
and
| > ChDir).
| >
| > --
| > Jim
| > | > | ok i got this to work...kind of...
| > |
| > | what i can run is:
| > |
| > | Excel.Application.ActiveWorkbook.SaveAs "test.xlsm"
| > |
| > | and that will work...but i can only get it to save into the documents
| > | driectory. how can i change where to save it to?
| > |
| > | "Jim Rech" wrote:
| > |
| > | >
| > | > Excel.Application.ActiveWorkbook.SaveAs "c:\test.xlsm", 52
| > | >
| > | > --
| > | > Jim
| > | > "Tim Williams" <timjwilliams at gmail dot com> wrote in message
| > | > | > | > | Excel constants and named arguments aren't available to you when
| > | > automating
| > | > | Excel from script.
| > | > | Try substituting the actual values of the constants, and omitting
the
| > | > names
| > | > | (they must be in the default order of course...)
| > | > |
| > | > | Excel.Application.ActiveWorkbook.SaveAs "c:\test.xlsm", 1 'just
| > guessing
| > | > the
| > | > | value here - look it up in the Excel object browser
| > | > |
| > | > | Tim
| > | > |
| > | > | | > | > | > Thank you for your quick reply Jim,
| > | > | > I have tried the line that you supplied me, and i get error:
| > | > | >
| > | > | > the requested action with this item has failed....
| > | > | >
| > | > | > is this a vista permission error?
| > | > | >
| > | > | > "Jim Rech" wrote:
| > | > | >
| > | > | >> Your quotes don't look right:
| > | > | >>
| > | > | >> ActiveWorkbook.SaveAs Filename:="c:\test.xlsm", _
| > | > | >> FileFormat:=xlOpenXMLWorkbookMacroEnabled
| > | > | >>
| > | > | >>
| > | > | >> --
| > | > | >> Jim
| > | > | >> | > | > | >> | hello I am trying to figure out how to program excel to save
a
| > | > templete
| > | > | >> | through the save as function.
| > | > | >> |
| > | > | >> | this is what I am trying in my vb script...
| > | > | >> |
| > | > | >> | Excel.Application.ActiveWorkBook.SaveAs
| > ("Filename:=c:\test.xlsm",
| > | > | >> | "FileFormat:=xlOpenXMLWorkbookMacroEnabled")
| > | > | >> |
| > | > | >> | but when i run this command i get an error stating that the
| > string is
| > | > | >> | invalid...i have searched on msdn for how to do this ...and
that
| > is
| > | > the
| > | > | >> way
| > | > | >> | they said to do it...what am i missing
| > | > | >> |
| > | > | >> |
| > | > | >>
| > | > | >>
| > | > | >>
| > | > |
| > | > |
| > | >
| > | >
| > | >
| >
| >
| >
