Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Difficulties with SaveAs method
Help please.
I'm attempting to automate a File/SaveAs process with a password. The Excel document is created by a DataJunction/Pervasive conversion. I've incorporated other Excel formatting and save functions post-conversion without issue, but have run into a roadblock with the SaveAs method. I've tried the following code (and many variations thereof), and encounter one of two errors. Sample obtained (and modified slightly to meet DataJunction syntax requirements) from Microsoft TechNet(http://www.microsoft.com/technet/scr...5/hey0207.mspx) Set objExcel = CreateObject("Excel.Application") objExcel.Visible = True objExcel.DisplayAlerts = FALSE Set objWorkbook = objExcel.Workbooks.Add Set objWorksheet = objWorkbook.Worksheets(1) objWorksheet.Cells(1, 1).Value = Now() objWorkbook.SaveAs "C:\Test.xls","" ,"%reTG54w" objExcel.Quit If I try this exactly as it is, I receive the following: Runtime error 124: Property or method failed (Microsoft Excel: Unable to get the SaveAs property of the Workbook class) With other variations, I've been able to save the document, but it receives a new name (i.e. "c:\test.xls, %reTG54w.xls"), where it imbeds the value of the password parameter into the filename. Any ideas? Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem using SaveAs method | Excel Discussion (Misc queries) | |||
SaveAs method error | Excel Discussion (Misc queries) | |||
Error on ActiveWorkbook.SaveAs method | Excel Programming | |||
Question Using SaveAs Method | Excel Programming | |||
SaveAs method | Excel Programming |