LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 9
Default Email Copy and File Not Found Message

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
Search this Thread:

Advanced Search
Display Modes

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
macro to copy value from 2nd file, if a word found in a correspondingrow of both files [email protected] Excel Discussion (Misc queries) 5 September 2nd 08 10:51 PM
FOUND LOST FILE BUT COPY IS MISSING NITRAM RENRAS Excel Worksheet Functions 0 January 26th 06 08:03 PM
If not found get a message Fgomez Excel Programming 2 March 16th 05 10:28 PM
Copy and Paste from Excel into Outlook Email message TroyB[_2_] Excel Programming 0 November 10th 04 08:01 AM
"file not found" error message when launching source file Lisa[_9_] Excel Programming 4 April 6th 04 02:54 PM


All times are GMT +1. The time now is 01:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"