External operations... (1 Viewer)

[border20]

I have a couple pf external operation i would like to control from access and I dont know if i can be done... for instant, I would like to be able to open an excel document. And I would like to be able to perform a copy o peration..(copy an excel document from a folder to another)

can this be done ?

thx

 

[jfgambit]

How are you getting at the excel document (i.e. from a form, from a command button, etc.)

You can create hyperlinks to excel documents or create a command button that can open Excel from Access.

Can you expand on what you would like?

Thanks.

 

[border20]

I want to open an excel document preferably from a command button. (after an export)

but before the export, i would like to be able to replace the target excel document with its template...

 

[jfgambit]

Sorry, One last question....

Does the "export" come from a Query or Table?

 

[border20]

It comes from a query wich has conditions... the conditions are defined on the form where the export is done

 

[jfgambit]

See the attached. I believe it will help you complete your database.

 

[border20]

thx but i already got the export working... all i need to do now is execute a .bat file and then open the excel document...

 

[jfgambit]

The code at the end of the attachment I provided shows how to open the excel document from Code.

HTH