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

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.

thanks for making that clear rick, guess i'll have to use vb then.

cheers,
Arie

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.

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

Arie,

Following KB-article will get You started:

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

Kind regards,
Dennis

thanks XL-Dennis, on a first quick look this article seems to do the job for me.
Thanks!!!

cheers
arie