102830 Posted October 21, 2004 Share Posted October 21, 2004 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 Link to comment Share on other sites More sharing options...
MCT Posted October 21, 2004 Share Posted October 21, 2004 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 Link to comment Share on other sites More sharing options...
102830 Posted October 21, 2004 Author Share Posted October 21, 2004 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 Link to comment Share on other sites More sharing options...
MCT Posted October 21, 2004 Share Posted October 21, 2004 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.wmvstart /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 quotesthen 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 Link to comment Share on other sites More sharing options...
102830 Posted October 22, 2004 Author Share Posted October 22, 2004 ok thanks very much, extremly helpful and has done the job.thanks again,chris Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now