Standalone Executable

[CanOfWorms]

Hi all,

I'm an experienced OO programmer (Delphi), but took on a project to pick a txt file from a drop downlist box, import it into excel, do some parsing and save it as an xls file, then auto-terminate with no user interaction after the initial file selection (ie: forced overwrite if target file exists). But I'm not sure where to start.

I think this can all be done with VB which looks integrated with the version of excel they have. So how do I make an exe file? And can anyone point me to a skeleton program that is structured for this kind of thing?

Thanks in advance....
"once you open a can of worms, the only way to get them back in is to use a bigger can"

 

[vb5prgrmr]

Your question would be best asked in forum222.

Once you have the coding of you application done goto the menus (file>make "project name" exe). This will compile your program into an executable. From there you will then need to use the P&DW (Package and Deployment Wizard) to create an installable for you.

Good Luck

 

[CanOfWorms]

I don't have a "make" option... hmmmm. I think I'm in VBA for Excel, and it has "Import File", "Export File", and "Close and Return to mSoft Excel".

I think I may need a book with all the file i/o functions and objects, properties and methods outlined in some hierarchy ... any suggestions on a title, author or publisher?

 

[vb5prgrmr]

My fault, I thought you were talking about the vb design environment and not any of the Office VBA environments.

You will need the vb environment if you want to make a stand alone exe, however you may be able to create a macro/vba code that will do what is needed, but this will allow user to change code and could cause problems later on.

There are several books that I like but all for different reasons. Best bet is to goto book store and grab one and flip through it. Do until you have found one you like.

Good Luck