How to launch an excel workbook using VBA

**calibra** · 04-25-2012, 04:57 PM

Hi
Several years ago I wrote some VBA for refinery tank product ullage monitoring. It was developed over 2 years and was an impressive program once completed. However that was written in excel 97 and will not run on anything newer as the code is to different from current versions.

I have begun a much simpler program based around a recipe book. I need to launch the workbook immediately, instead of launching excel then choosing open file. I am sure it can be launched with VBA but can`t remember how this is done.

Hope this makes some sense.....

Thanks

Calibra

**Paul** · 04-25-2012, 05:28 PM

Hi Calibra,

You should be able to double-click an Excel file and have it open, without using the File > Open menu within Excel. Through VBA you would use something like:

Please Login or Register  to view this content.

**calibra** · 04-26-2012, 04:55 AM

Yes I realised that after posting........Still not sure how to make a file to launch my workbook. Are we talking about a batchfile ???
I am sure I did something like this in the past, but just can`t remember how !!!

**Paul** · 04-26-2012, 01:26 PM

If you want to launch a workbook from VBA (Visual Basic for Applications), you would have to do so from within such an application - like Excel, Word or Access. If you want to be able to do it from outside an application you'll have to create a batch (.bat) file, or build an .exe (or similar) file to do so. I'm not sure I really understand why you would do that when you can just double-click the file itself, or a shortcut to the file, or schedule a task to open the file at a specified time, or.. ??

**calibra** · 04-26-2012, 02:54 PM

I want to be able to launch the workbook with certain criteria e.g. full screen no menus etc......or with an introductory message.
Not sure how to do this.

Thanks