how to open a file in a macro?

[mike999]

<TABLE class=tborder id=post1611117 cellSpacing=0 cellPadding=6 width="100%" align=center border=0><TBODY><TR vAlign=top><TD class=alt1 id=td_post_1611117 style="BORDER-RIGHT: #ffffff 1px solid">If my database program contains the line "Runprogram C:\myfolder\excelprog.xls" it will run excel and automatically open a macro. I want to be able to pass an extra parameter being the file to be opened by using "Runprogram C:\myfolder\excelprog.xls filetouse.csv". How can I achieve this in the macro please.
Thanks,
Mike
<!-- / message --></TD></TR><TR><TD class=alt2 style="BORDER-RIGHT: #ffffff 1px solid; BORDER-TOP: #ffffff 0px solid; BORDER-LEFT: #ffffff 1px solid; BORDER-BOTTOM: #ffffff 1px solid">

</TD><TD class=alt1 style="BORDER-RIGHT: #ffffff 1px solid; BORDER-TOP: #ffffff 0px solid; BORDER-LEFT: #ffffff 0px solid; BORDER-BOTTOM: #ffffff 1px solid" align=right><!-- controls --></TD></TR></TBODY></TABLE>

 

[Smitty]

Welcome to the Board!

So you want excelprog.xls to open "filetouse.csv"?

If you open excelprog.xls and record a macro opening the .csv file, you can add the resulting code to excelprog.xls' Workbook_Open event. When your db code opens it, it will then open the .csv file.

Hope that helps,

 

[mike999]

Thanks Smitty, however, I want the filename to be variable. So one day I might want to open filetouse.csv and tomorrow it might be filetouse2.csv. I'd like to pass the name in the command line from the DB.
Cheers,
Mike

 

[Smitty]

What db program are you working with?

 

[mike999]

I'm working with Powerflex. I use the command "Runprogram" which is effectively the same as running a program from the DOS prompt. So if excel can handle DOS prompt commands like:
C:\myfolder\excelprog.xls variableprogramname
using the macro to read in the program name from the command line that would be perfect.
Thanks again for your efforts,
Mike

 

[Kenneth Hobson]

Store the parameter to pass in something like a TXT file with a common name and location or store in the registry. Excel would contain a method to read the parameter information that it needs from that external storage.

 

[mike999]

I'm getting ever closer to what I want but not quite there yet. I'm in a multi user environment. Two people might want to call excel with different csv file names at the same time which would defeat this latest approach I believe. I admit I don't know much about excel but I can't believe there isn't a simple command in excel or VB that takes the next "word" from the calling command line.
Cheers,
Mike