I know there are loads of previous posts on this but I cant find any that i can apply/understand
I am running a macro in excel, but half way through I need to run an exe file in C to retrieve a text file to do some fancy stuff and produce a name that my macro can use. The user specifies the text file.
To pause it I have simply put in a msgbox that asks if the file has been selected. This stops the code running away with itself.
But it is not very eloquent and would rather no user interaction to do this. Also I cant rely on a wait for 5 seconds function for example because the user may be too slow.
Has any one got any ideas?
code is simply -
msgbox - do you want to extract a file (yes/no)
yes - go to seperate sub and run C++ program
have you selected file (yes/no)
no - assumes data is there and carries on
PLease help
Andrew299
I am running a macro in excel, but half way through I need to run an exe file in C to retrieve a text file to do some fancy stuff and produce a name that my macro can use. The user specifies the text file.
To pause it I have simply put in a msgbox that asks if the file has been selected. This stops the code running away with itself.
But it is not very eloquent and would rather no user interaction to do this. Also I cant rely on a wait for 5 seconds function for example because the user may be too slow.
Has any one got any ideas?
code is simply -
msgbox - do you want to extract a file (yes/no)
yes - go to seperate sub and run C++ program
have you selected file (yes/no)
no - assumes data is there and carries on
PLease help
Andrew299