Opening a program through VB

[bradth]

I have a program that was written, that when executed brings up a print interface that prints barcodes. I have a custom form with a button on it in VBA. What I would like to do is when this button is clicked, it will open the barcode.exe file and bring up that program. Is this possible? Thanks.

Brad

 

[jgillin]

Hi bradth,
I have good news and bad news.
The good news is yes, this is possible.
The bad news is that I don't know the exact code at this moment.
I think it might be the Shell command. Look that up.
-hth
Jeff

 

[MiggyD]

as jgillin suggested look up the "SHELL" command in the help files.

Also, don't forget at this juncture it will require a static path.

--MiggyD

--> It's a bird! It's a plane! No, it's an OS update patch! Ahh!! <--

 

[bradth]

Ya, I used the shell command and it works good. Thanks.

Brad