Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
method 'SaveAs' of object '_Workbook' failed
I created a macro where the code has been password protected.
The macro uses the .SaveAs method and the FileFormat argument is set to xlText. This combination of the .SaveAs to xlText and the password protecting of the macro causes it to fail. Any idea how to get around this. I do not want the users to have access to the code. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
method 'SaveAs' of object '_Workbook' failed
Kishi,
xlText is a value for the PivotFieldDataType; its value is &HFFFFEFC2. The values of xlFileFormat that you want to use with .SaveAs are typically: xlTextMSDOS: &H15 xlTextWindows: &H14 So, fix the value of the file format you are using and see if it helps. NickHK P.S. The Object Browser can help you with the arguments/value as well as showing you which properties/methods/events are available for each object. xlText is not a valid value "Kishi" wrote in message ... I created a macro where the code has been password protected. The macro uses the .SaveAs method and the FileFormat argument is set to xlText. This combination of the .SaveAs to xlText and the password protecting of the macro causes it to fail. Any idea how to get around this. I do not want the users to have access to the code. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Method 'CheckIn' of object '_workbook' failed | Excel Programming | |||
Urgent help Runtime error ‘1004’ Method ‘SaveAs’ of object’-Workbook’ failed ????? | Excel Programming | |||
error 1004 Method SaveAs of Workbook failed | Excel Programming | |||
_Workbook::SaveAs(...) | Excel Programming | |||
Error Excel: 1004 SaveAs method of Workbook class failed | Excel Programming |