Posted to microsoft.public.excel.programming

kenji4861[_7_] kenji4861[_7_] is offline

external usenet poster

Posts: 1

Thisworkbook.SaveCopyAs - Does it work on Excel on IE?

My users are opening Excel sheets through IE.

I'm trying to run this macro...

Sub Macro1()
ThisWorkbook.SaveCopyAs "c:\temp.xls"
End Sub

But it will give me a
run-time error 1004.
Method 'SaveCopyAs' of object '_Workbook' failed.

If I go to debug mode and play again.. it will go through. Thanks fo
any tips

--
Message posted from http://www.ExcelForum.com

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to 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
Excel SaveCopyAs COMException 0x800A03EC	Jim McLeod	Excel Programming	0	May 25th 04 12:26 AM
SaveCopyAs does not work	Hank[_4_]	Excel Programming	3	April 2nd 04 07:24 AM
SaveCopyAs does not work	NickHK[_2_]	Excel Programming	0	April 1st 04 02:45 AM
ThisWorkbook.Saved does not work!	Niklas[_3_]	Excel Programming	5	November 25th 03 01:26 PM
Code in ThisWorkbook crashes Excel	Pat Beck	Excel Programming	6	August 25th 03 09:07 AM

All times are GMT +1. The time now is 05:37 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us