Excel

[jemmy]

Hi,

I have to generate report by copying the template exel file and insert the data into the new file.

My issue is I am able to do this in development mode.

Once I create the .exe of the application it is just copying the file but not modifying the data..

I am using all abosolute path for file ref..

Please advice...

Tahnks in advance.

Jemmy

[Elsa Fung]

not sure if this will help:

bottom of [link removed]

LabVIEW Add-on Toolkits

This section lists some of the LabVIEW add-on toolkits that might require additional support files:
1) Database Connectivity Toolset
This add-on toolkit does not have to be installed on the target machine; however, you have to make sure the Microsoft Data Access (MDAC) is. Refer to the Building Application Chapter in the Database Connectivity Toolset User Manual linked below. Also make sure all the Data Links (*.UDL) files are included. If your application required an ODBC driver, you have to make sure it is installed on the target machine.

2) Report Generation Toolkit for Microsoft Office
Note for 1.0a version: you must add the _wordsub.llb and _exclsub.llb libraries as support files. These two libraries contain subVIs that the high-level Report Generation VIs can call dynamically. They are located in the <LabVIEW>\vi.lib\office directory.

3) The Internet Toolkit
Please follow the link below to learn how to deploy such an application:

See Also:
Database Connectivity Toolset User Manual
KnowledgeBase: How Can I Embed the G Web (HTTP) Server into an Executable? 

you probably need to use the installer to deploy your exe to include the library files, but i'm not sure

good luck,

See-Ming

[jbrohan]

There are many "gotchas" with Excel. Is it the same machine? Maybe one has Excel97 and the other Excel 2000? One approach I find useful is to get it working **somehow** first, and therefore I'd suggest writing the file out to a new name, there are some issues with file permissions in Excel and you need to set the updateable property correctly.
Good Luck
JOhn

[jemmy]

Hi,

Thanks for that info..I am learing those ref docs.

But what surprise me is that, on development mode the system works perfectly, it creates new file, insert the data everything it supposed to.

Only once I create the .exe it has this problem.It just copy the template no data are inserted furhter.While trying to capture error it shows Refernce mismatch in Dispose.vi, which is part of Excel toolkit..But how come it works on development mode with out error.

Any idea??Please help.

Thanks all.

Jemmy

[Elsa Fung]

oh... so you're running the exe in the same computer you developed it?  I thought you were running it on a different computer...

anyway, in that case, can you post your code?

See-Ming

[jemmy]

hi,

please find the code attached,

Regards

Jemmy

[Elsa Fung]

There's a note in the Report Generation folder:

>> These 4 libraries contain Office 2003 compatible VIs. _exclsub.llb and _wordsub.llb must be added as support files when building an application or a dynamic link library with the application builder.

The 4 llbs are in the ~\LabVIEW 8.0\vi.lib\addons\_office folder.  I'm not sure how to add llbs to project (I tried, it kept saying the llb already exists, and so and so, and it keeps corrupting the 4 files.  I had to keep repairing the Report Generation toolkit everytime I did something wrong.  So have your CD handy ^_^).

Sorry couldn't help much... but I really think if you can add the 4 llbs to the project as support files, you're good to go.

Good luck!
See-Ming