VBA Shell Command Help

[Macro81]

Hi

I've having trouble with the VBA shell command. I can use the basic command to launch a file directly from VBA and obtain the task ID.

E.g., ProgID=Shell("C:\addressofprogram.exe ""C:\addressoffiletobeopened.doc"""), vbNormalFocus

I'm sure this is simple. However, I can't work out how to input the program and file address into the shell command if I already have them as variables in my code.

E.g., This doesn't work: ProgID =Shell(ProgAddress & FileAddress), vbNormalFocus

Please can someone help.

Many thanks in advance.

 

[FormR]

Hi, you could try something like.

Shell(ProgAddress & " """ & FileAddress & """")

 

[Macro81]

Hi, you could try something like.

Shell(ProgAddress & " """ & FileAddress & """")

Hi,

That worked... Brilliant thanks. The problem I'm having now is that when using AppActivate to move back to the file window it's not selected (in focus)... Although the file window does appear. I don't understand this as my original shell command includes maximized and focus statements. Any ideas?

Thanks,

 

[FormR]

Any ideas?

Hi, the topic is not something that I'm readily familiar with to be honest, but for anyone to stand a chance of helping you're probably going to have to post the code you are having trouble with.