Runtime Error 1004

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

smcq - 21 Mar 2006 17:01 GMT

All = firstpart + SECONDPART + thirdpart + ".xls"
MsgBox "File about to be saved under name of C:\My Documents " + All

ActiveWorkbook.SaveAs FileName:=All, FileFormat:=xlExcel4

Using this code, a user logs into their own desktop computer and tries to
save an xls spreadsheet (using Office Xp and Windows XP Pro Sp2), they are
faced with the above error, however, when they log onto another pc the
Filename does get saved.

I would appreciate any help...

stephen

Reply to this Message

Tom Ogilvy - 21 Mar 2006 19:38 GMT

All = firstpart & SECONDPART & thirdpart & ".xls"
MsgBox "File about to be saved under name of C:\My Documents\ " & All

Signature

Regards,
Tom Ogilvy

> All = firstpart + SECONDPART + thirdpart + ".xls"
> MsgBox "File about to be saved under name of C:\My Documents " + All
[quoted text clipped - 9 lines]
>
> stephen

Reply to this Message

smcq - 22 Mar 2006 10:56 GMT

This makes no difference Tom. I can open the .xls and run the code and save
the file on and pc in my work using my name and password in Windows XP, BUT
any other user who tries similar gets the runtime error and cannot save the
file. However, if user selects, File Saveas from top menu, and then presses
the command button (which the code is assigned to), the file can be saved.

UPDATE: just found out...C:\My Documents will not work under Windows
XP...permissions. I reasssigned the pathname to C:\temp and it works now.

thanks for your help anyhow

> All = firstpart & SECONDPART & thirdpart & ".xls"
> MsgBox "File about to be saved under name of C:\My Documents\ " & All
[quoted text clipped - 12 lines]
> >
> > stephen

Reply to this Message