02-21-2010 05:18 AM
Hi guys, When I use a gmail VI which is downloaded from internet to send a email that has a excel attachment, I found that when the VI finished sending, the excel document is still be opened, so that I can't write the file in the following processing. So, could anybody has a way to close or release the excel doc?
02-21-2010 10:26 AM
Does the VI you have attached have anything to do with the question???? Seems completely unrelated!
(Maybe you could instead attach the actual gmail VI, or at least provide a link to where you found it.) 😉
02-21-2010 10:36 AM
Please don't attach VI's that use crazy character sets in their file name. I tried to open it and it crashed LabVIEW saying it couldn't find ????.vi
Only after I saved the .vi to my desktop and renamed it to a proper filename was I able to open it.
Only post VI's that use normal English characters.
02-21-2010 11:26 AM
02-21-2010 11:28 AM
Ravens Fan wrote:Only after I saved the .vi to my desktop and renamed it to a proper filename was I able to open it.
Interesting. It opened just fine here directly from the browser (Chrome. Filename in windows title shows as "!!!.vi").
(This is in 2009SP1).
02-21-2010 05:41 PM - edited 02-21-2010 05:43 PM
Vista Home Premium 64 bit, IE8, LV2009SP1. When opening from the browser, things kind of flash open closed.
Copy to desktop, open from there, it flashes open then closes.
Open new blank VI, try to drag and drop on there. Nothing happens.
From blank VI, Select a VI...., and browse to the original name on my desktop, I get this error.
Rename file so it uses actual English characters, it opens fine. Constants and icon labels contain some garbage characters, not chinese,japnese, but characters out of the upper half of the ASCII set.
02-21-2010 05:58 PM - edited 02-21-2010 06:01 PM
Sorry about the characters I used, next time I will use standerd English. guys, you can find the traditional gmail version here. The question is if you write a while loop using this gmail VI with one excel attachment and after mail finished then you write data to the excel , you may find "Error 5: file has opened". Is that means the gmail VI do not release the excel attachment ? Anybody has the same question?
My OS: windows XP sp3,
My Office: Microsoft Office 2007
02-21-2010 06:10 PM - edited 02-21-2010 06:10 PM
The example VI doesn't close any references. The most important one in your case is to close the attachment reference, but good programming would be to close all references opened in the VI.
02-26-2010 07:54 AM
I added "close reference" to the gmail.vi, but nothing got better. And then I killed the "Excel" process in command window(use system exec.vi) when the gmail.vi process was finished, but the error was still there. So I feel that the problem may not be in gmail.vi but in "MS office report". I rewrite the programme with excel toolkits and replace the "MS Office report". Now the problem is solved.
Thank your helping.
02-26-2010 09:05 AM