I believe that is one of the major differences between VBA and VB. In VBA, you cannot create a stand-alone .exe.
I am finishing up a program using excel that does a lot of nice things, and seems to be working. I want it to be used by anyone, even if they do not have Excel. I want it to be *my* program completely, w/o Excel being a part of it anymore. Is there a way to compile an excel file and turn it into an EXE file so there is no need for an excel program to run it?
Are you saying you have written something use the VBA within Excel that uses no part of excel?
anyhow have a read of this previous post
So you do not use any cells or ranges. No workbooks to hold data even if you are only reading it. No formula.
If so one has to ask the question why use excel?
There are currently 1 users browsing this thread. (0 members and 1 guests)