STUCK! Start Excel ReportTest.xlt ReportData.txt ......

[Tim_Field]

Hi All,

This is something that appears to have been answered elsewhere but all the solutions aren't working.

I'm trying to open a text file and apply my template to it (contains a macro). Doing the command Start Excel ReportTest.xlt ReportData.txt
just loads excel twice.

The following doesn't return a string so I can't read off the arguements:
Dim CmdLine As String
CmdLine = GetCommandLineA

same with this:
Dim CmdLine As String
CmdLine = GetCommandLine

I'm using Windows XP Pro and Excel 2000

Can anyone help!? I'm totally stuck.... This code will actually be called from C# so I MUST use a command line.

Thanks! Tim

 

[Andrew Poulsom]

Welcome to the Board.

Look at Laurent Longre's solution here:

http://www.j-walk.com/ss/excel/eee/eee002.txt

 

[Tim_Field]

No chance! Already tried that.....

I've already done this solution and it doesn't work.....

please note my origional msg....

-The following doesn't return a string so I can't read off the arguements:
-Dim CmdLine As String
-CmdLine = GetCommandLineA
-same with this:
-Dim CmdLine As String
-CmdLine = GetCommandLine

Thanks Tim

 

[Tim_Field]

FULL INFO BELOW....


Trying to achieve:

Open with a template and a txt file...
This template (containing a macro) should format the text.

Tried:
1)
start excel ReportData.txt ReportTest.xlt
and
start excel ReportTest.xlt ReportData.txt

Opens up two workbooks (separate).

2)
Create an environment variable from within C# *in this case just in Cmd prompt
Read the variable in VBA.... Doesn't work

3)
Create a command line with parameters...
e.g.
start excel "/e/ReportTest.xlt/ReportData.txt"

This reference the command object from VBA
Declare Function GetCommandLine Lib "kernel32" () As String
OR
VBA.Command$
OR
MsgBox GetCommandLineW
OR
MsgBox GetCommandLine


All give nothing back.

 

[Andrew Poulsom]

Another possibility would be to store the name of the file you wish to process in a text file. Then read that file name from the text file in your Workbook_Open event procedure.