|
-
Aug 25th, 2009, 04:50 AM
#1
Thread Starter
Lively Member
cdo attach fails - file in use
my program creates an .xls and after saving it, i thought i closed down everything to do with the file,
ExcelWorkbook.SaveAs workDir & Format(Now, "yyyyMMdd") & "topSites.xls"
ExcelWorkbook.Close
ExcelApp.Quit
Set ExcelApp = Nothing
Set ExcelWorkbook = Nothing
Set ExcelSheet = Nothing
at a later point trying to attach the file to an email with cdo
objMessage.AddAttachment newTopSiteFile
and i get -2147024864 80070020 process cannot access the file because it is being used by another process.
there is nothing else running on the machine that could possibly be using the file, somehow the program still has it tied up?
even the 'unlocker' utility finds no locking handle?
after the program ends if i restart it, and go directly to the attach, it works then
something else with excel needs to be released?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|