Results 1 to 7 of 7
  1. #1
    Join Date
    Jan 2004
    Posts
    7

    Question Unanswered: compile .exe files with vba?

    Hi,

    I'm working on a project in excel. I start of with one .xls file which auto opens a form. This form has different buttons to open different .xls files.
    It would be nice if i could compile the first form to a .exe as i only need the form and not the .xls file that opens it.
    Does anyone know if this is possible in vba? Or is it only possible in VB?
    Thanks in advance!

    Cheers,
    Arie

  2. #2
    Join Date
    Sep 2003
    Location
    Cincinnati, Oh USA
    Posts
    203

    Re: compile .exe files with vba?

    Not to my knowledge. The difference beween VB and VBA is that VBA can not be compiled. You could of course create a VB application.

    Originally posted by arie ribbens
    Hi,

    I'm working on a project in excel. I start of with one .xls file which auto opens a form. This form has different buttons to open different .xls files.
    It would be nice if i could compile the first form to a .exe as i only need the form and not the .xls file that opens it.
    Does anyone know if this is possible in vba? Or is it only possible in VB?
    Thanks in advance!

    Cheers,
    Arie
    Rick Knight
    KnightShift Office Solutions and Horse Breaking
    VB, VBA, FileMaker, Access Solutions, Web Solutions

  3. #3
    Join Date
    Jan 2004
    Posts
    7
    thanks for making that clear rick, guess i'll have to use vb then.

    cheers,
    Arie

  4. #4
    Join Date
    Oct 2003
    Posts
    706

    Red face

    Not so fast... you're doing the work in Excel and so you're always going to have to open Excel sometime. You can "open an Excel spreadsheet or form as an OLE object" or somesuch to change the appearance of what is happening, but there's no EXE in the world that's going to be able to do this job without an MS-Excel environment initialized and present (visible or not). "If you're in for the penny, you're in for the pound." May as well keep with status quo, IMHO and JM2CW.
    ChimneySweep(R): fast, automatic
    table repair at a click of the
    mouse! http://www.sundialservices.com

  5. #5
    Join Date
    Jan 2004
    Posts
    7
    thanks for that reply.
    I've made the form in vb now and i want to open excel and eventually the excel file when i click a button. But i can't get it to work (compile error - sub or function not defined) i'm a bit new to vb so i guess this will be a n00b question, but what i'm i doing wrong?

    Private Sub Command1_Click()
    AppExecute Command:="Excel"
    End Sub


    Cheers Arie

  6. #6
    Join Date
    Dec 2003
    Location
    Östersund Sweden
    Posts
    60
    Arie,

    Following KB-article will get You started:

    http://support.microsoft.com/default...;en-us;Q219151

    Kind regards,
    Dennis
    Kind regards,
    Dennis

  7. #7
    Join Date
    Jan 2004
    Posts
    7
    thanks XL-Dennis, on a first quick look this article seems to do the job for me.
    Thanks!!!

    cheers
    arie

Posting Permissions

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