Thread
:
Runtime error 1004/ Save As method help
View Single Post
#
2
Posted to microsoft.public.excel.programming
[email protected]
external usenet poster
Posts: 113
Runtime error 1004/ Save As method help
Hi,
Make sure your Range("F6").value doesn't include these :
*; [],\ etc ...
Check your file name tosave first,
halim
menuliskan:
Thank you so much for your help so far. However, I have another
question. In my script I would like to save my workbooks to a mapped
drive. I filled in the blanks for the save code and tried it out. It
goes up to the third entry saves it and by the fourth I get a error
message. Runtime error 1004 - MS Office Excel cannot access the file
"\\blah\blah\blah" There are several possible reasons. It gives four
options but the contiue button is grayed out. Can you help?
Dawn
Here is the sample code:
bk.SaveAs Filename:="\\syslea222\busserve\Credit Logs\Archer
Project\Master Customer List\" & Worksheets("PD").Range("F6").Value &
".xls"
bk.Close SaveChanges:=False
ThisWorkbook.Activate
Reply With Quote
[email protected]
View Public Profile
Find all posts by
[email protected]