Posted to microsoft.public.excel.programming

Kishi

external usenet poster

Posts: 1

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Method 'CheckIn' of object '_workbook' failed	Bill Schanks	Excel Programming	1	May 9th 06 10:04 PM
Urgent help Runtime error ‘1004’ Method ‘SaveAs’ of object’-Workbook’ failed ?????	funkymonkUK[_155_]	Excel Programming	4	May 4th 06 12:56 PM
error 1004 Method SaveAs of Workbook failed	Maury Markowitz	Excel Programming	2	October 25th 05 08:45 PM
_Workbook::SaveAs(...)	Fritz Hilgemann	Excel Programming	2	June 16th 05 03:39 PM
Error Excel: 1004 SaveAs method of Workbook class failed	sebastien	Excel Programming	0	August 13th 03 09:59 AM

All times are GMT +1. The time now is 07:43 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us