script for importing and merging multiple Excel Worksheets

[RogerC]

Hi Brad,

When I run the Concat programme nothing happens.

When I run the excert you recomended I get the error: "Variable is undefined: 'ConcatGroups' "

Thanks,

Roger

[Brad_Turpin]

Hi Roger,

You either need to uncomment the last 2 lines from the "Concatente Groups.VBS" and run that or you need to use "ScriptInclude(AutoActPath & "Concatenate Groups.VBS")" within your new script (that you've saved to the same folder as "Concatenate Groups.VBS").  The error you're getting is that the new VBScript you ran doesn't contain the function definition for "ConcatGroups()".  You either need to have the subroutine call in the same VBScript as the subroutine definition or you need to link to the subroutine definition using "ScriptInclude()".

I apologize that I told you to run the "Concatenate Groups.VBS" by itself without any changes.  When I originally created that script it did work that way, and I guess that's the way I was still remembering it.  But in the meantime I've added a host of new parameterization and switched to calling it with "ScriptInclude()" instead of "ScriptStart()".

Brad Turpin

DIAdem Product Support Engineer
National Instruments

[RogerC]

Hi Brad,

Sorry, I don't understand what I need to do.

Thanks,

Roger

[Brad_Turpin · Accepted solution]

OK Roger,

Here's an example of how to do what I described in my last post.  Just detach this ZIP file to your hard drive and unzip it-- you should get a new folder with 2 VBScripts in it (one of them you already had).  Load your data so that you have several Groups that you want to concatenate, then run the "Concat Groups (Del).VBS" script om that unzipped folder in DIAdem-SCRIPT.

Brad Turpin

Poduct Support Engineer
National Instruments