+ Reply to Thread
Results 1 to 5 of 5

How to launch an excel workbook using VBA

  1. #1
    Registered User
    Join Date
    04-24-2012
    Location
    UK
    MS-Off Ver
    Excel 2010
    Posts
    9

    How to launch an excel workbook using VBA

    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

  2. #2
    Forum Moderator Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,881

    Re: How to launch an excel workbook using VBA

    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.

  3. #3
    Registered User
    Join Date
    04-24-2012
    Location
    UK
    MS-Off Ver
    Excel 2010
    Posts
    9

    Re: How to launch an excel workbook using VBA

    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 !!!
    Last edited by Paul; 04-26-2012 at 01:24 PM. Reason: Removed quote of full post.

  4. #4
    Forum Moderator Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,881

    Re: How to launch an excel workbook using VBA

    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.. ??

  5. #5
    Registered User
    Join Date
    04-24-2012
    Location
    UK
    MS-Off Ver
    Excel 2010
    Posts
    9

    Re: How to launch an excel workbook using VBA

    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1