Convert Excel. xls to .exe

[Myrna Rodriguez]

Happy Friday!

Is there a way to convert an Excel file into an .exe (executable file)??

This is what I want to do:
- design and develop a userform in Excel that the user can run from
their PC without opening Excel.

-the userform simply has three command buttons that will open a file
when clicked.

-I don't have Visual Basic, so my only way to run this userform is by
opening Excel.
Is there a shortcut to bypass opening Excel?

Thanks for looking and you're help is appreciated.

happy day!

 

[Chip Pearson]

Is there a way to convert an Excel file into an .exe

(executable file)??

No, there is no way to do this. The user must have Excel
installed on his machine.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Myrna Rodriguez]

The user will have Excel installed on his machine.
I want the user to open the .exe from their (desktop)and launch the
Excel Userform.

Is it possible or should I refer to VB?

Now, if I developed the userform in VB, will the user need to have VB
installed on their machine?

Thanks!

happy day!!

 

[Guest]

Why not load the form using the file's Workbook_Open event?

 

[Guest]

Kevin answers your real question of using an Excel Form so that as soon as
the excel file is open, the Thisworkbook "module" contains code in the
Thisworkbook_Open sub routine to go directly to your form, and then when the
form is done, to close out the excel file.

As for creating something in VB (not VBA), you would be able to compile the
code to create an EXE file and not need VB installed on the machine. It may
require some additional DLL files, depending on how complex you make things,
but for what you are talking about it should run when fully compiled without
any additional software installed.