LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

How could gmail release excel attachment?

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?

0 Kudos
Message 1 of 10
(4,033 Views)

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.) 😉

0 Kudos
Message 2 of 10
(4,020 Views)

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 ????.viSmiley Mad

 

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.

0 Kudos
Message 3 of 10
(4,017 Views)
I'm assuming the poster is referring to the GMail example here. I was able to send an Excel workbook attachment with no issues. The workbook did not remain "open".
0 Kudos
Message 4 of 10
(4,005 Views)

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).

0 Kudos
Message 5 of 10
(4,004 Views)

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. 

 

Message Edited by Ravens Fan on 02-21-2010 06:43 PM
0 Kudos
Message 6 of 10
(3,978 Views)

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

 

 

Message Edited by nomore on 02-21-2010 06:01 PM
0 Kudos
Message 7 of 10
(3,970 Views)

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.

 

Message Edited by dan_u on 02-22-2010 01:10 AM
0 Kudos
Message 8 of 10
(3,960 Views)

       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.

 

0 Kudos
Message 9 of 10
(3,899 Views)
You never mentioned anything about using the Office Toolkit. That was an important piece of information.
0 Kudos
Message 10 of 10
(3,889 Views)