VBA & Excel

[Khalil Handal]

Hi,
I don't know a lot about VBA.
I need to make an Exe file with VB to give 3 buttons each button starts an
excel work book (book1, book2,book3). I am thinking of a form that appears
on the screen.
When the "Exit" button is cliked it will make an other copy of the 3 excel
files on another folder (say: d:\data) for example (like a back up copy).

Can any one help

thanks

 

[Harald Staff]

Hi

You can not make exe files with VBA. If you can use VB5 or VB6 instead then
adapt the VBA code from
http://www.erlandsendata.no/english/index.php?d=envbaolecontrolexcel
see also
http://www.erlandsendata.no/english/index.php?d=envbaoleolebasics
on referencing Excel from the project.

HTH. Best wishes Harald

 

[Khalil Handal]

Hi,
My knolidge of VB5 or VB6 is very poor.
Khalil