Why the excel file can't be created by the vi after I build it.

[hugoliang]

Dear All,

        My vi can work well and creat the excel file before being built.

        But after I build it, the excel file can't be build and no error message is displayed.

        During the process of building, I have checked "enable activeX server".

        And the log file is:

Microsoft (R) Type Library Generator  Version 2.20.4048
Copyright (c) Microsoft Corp. 1993-1995.  All rights reserved.

Successfully generated type library 'pal2com.tlb'.

        I don't know why.

        Please help me and give me a suggestion.

       Thank you.

Hugo

[TiTou]

   Hi,

How do you generate the path of the excel file you create ?
If you use the "current vi's path" + one "strip path" then it is normal that when you run the exe it doesn't work.
When running as an exe (application.exe for instance) the vi's path is not C:\name.vi but C:\application.exe\name.vi

To make it work both in edit mode and exe, you can plave a "strip path" in a while loop and get oout of the loop only if the path points to a folder 😉

Hope this helps

[hugoliang]

Thank you for your reply.

Yes, you are right. I have used the "current vi's path" + one "strip path" .

But I can't understand "you can place a "strip path" in a while loop and get out of the loop only if the path points to a folder"
How can I do that?

Thank you.

The vi is attached.

Thanks.

Hugo

[Dennis_Knutson]

Here's another way. It uses the application property App.Kind wired to a case structure. In the Run Time System case, the extra strip path is placed.

Message Edited by Dennis Knutson on 12-11-2006 09:44 PM

[TiTou]

Hi,

As Dennis showed, there are different way to get the path of the containning folder that will work also in exe.

Here is an illustration of what I meant :



😉

Message Edité par TiTou le 12-12-2006 07:45 AM

[hugoliang]

oh,Thank you very much:)

Hugo