hi i'm using excel '97 and i want to create a macro so that it will open ms project and open the file, then go back to excel. but when recording the macro in excel, it doesn't record the fact that i have opened project, so it doesn't work. how can i get it to record the program change? thanks

u wanna open a program then when thats done u wanna open another?

start /wait %path_to_program%\program.exe "%path to file u want to open%

welcome to msfn

ps: the above code is for a batch file

sorry this doesn't seem to work, i type it in the visual basic editor and it still doesn't work, can you give me the whole code again but with an example within it please. thanks for your help

ok, say your program name is "My_Program.exe" & its located in C:\My_Program & the file u want to open is C:\Windows\Something.wmv

start /wait %systemdrive%\My_Program\My_Program.exe "%windir%\Something.wmv"

place the above code into NOTEPAD.exe , goto file > save As > type "MY_program.bat" With the quotes

then all u have 2 do 2 run it is double click My_program.bat whereever u saved it in no need for VB in this case, nor any other programming language, good ol dos

ok thanks very much, extremly helpful and has done the job.

thanks again,

chris