Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
We have an excel file that has a code that many of us use were the code
sets up an email and attaches a file to the email. The file has been working fine for quite a while, but we now have two users were the file gets the following message: File not found: 'C:DOCUME~1\username.DSR\LOCALS~1\Temp\VB1C1.temp' We also get a debug at the following code: (Highlighted on this line) Sheets("Tasks").Copy ActiveWorkbook.SaveAsFilename:="S:\Info\blanks\Tas kfiles.xls", FileFormat:=xlNormal, _ Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, _ CreateBackup:=False On my system and many others, the file works fine, but on two users is were the problem is. We tried using a system that the file works on using the username of the person that the file doesn't and we have the same problem. Any help would be greatly appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
macro to copy value from 2nd file, if a word found in a correspondingrow of both files | Excel Discussion (Misc queries) | |||
FOUND LOST FILE BUT COPY IS MISSING | Excel Worksheet Functions | |||
If not found get a message | Excel Programming | |||
Copy and Paste from Excel into Outlook Email message | Excel Programming | |||
"file not found" error message when launching source file | Excel Programming |