How to launch one other program with VBA code?

Question

I'm trying to launch another program install in my system from my Access application. Or to open another file from Access, how can I do it?

EX: There's a file barcode_12mm.lbl, I want to use VBA code to launch it in one program that edits this bar-code label file.

Thanks!

Does the shell know about that program that edits this bar-code label file? In other words, does that program run when you double-click an lbl file in an Explorer window? — Frédéric Hamidi
– Frédéric Hamidi, Commented Jul 20, 2011 at 19:40

David-W-Fenton · Accepted Answer · 2011-07-22 21:50:49Z

2

You have multiple alternatives in Access:

Shell() (see the Help file)
Application.FollowHyperlink (see the Help file)
ShellExecute() -- access.mvps.org/access/api/api0018.htm

The first requires you to know the path of the executable you are calling and is generally kind of fussy about getting the arguments properly formatted (you'll need double quotes for arguments with spaces in them, for instance).

The last two are for registered applications, such that if the file extension has an association defined, it will open the application associated with it. FollowHyperlink is easier, but ShellExecute provides more options.

ASIDE:

Note that many people think that using barcodes in Access requires an outside program or an ActiveX control. Barcodes are just fonts, so if you understand the format of the barcode encoding, it's really simple to just create your own barcodes within Access and not worry about any outside dependencies. Tony Toews has an article rounding up lots of information on the subject.

edited Jul 22, 2011 at 21:50

answered Jul 20, 2011 at 22:00

David-W-Fenton

23.2k4 gold badges48 silver badges59 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

darkjh Over a year ago

Thanks, I take the ShellExecute().

darkjh Over a year ago

Is that possible to pass some value to the program that I launched?

David-W-Fenton Over a year ago

If you have to pass an argument, you'll have to use Shell() (or ShellWait(), which is available on the same site as ShellExecute() is from).

Collectives™ on Stack Overflow

How to launch one other program with VBA code?

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related