MACRO'S

[Joey]

I've used macro's in several several programs so i understand how they work,
I've just never used them in Access 2003.... Can I create a macro in access
that will open files on my computer... basically I need to create a macro
that opens a program and exports the info to an excel sheet so that I can
link that excel sheet to access to use to run a report..I know how to do the
linking and everything else..jsut need to know if access can do that or do i
need to get a different external macro creator to do it for me.

 

[Douglas J. Steele]

I doubt very much that it can be done using a macro.

Depending on the application you need to control, you might be able to use
VBA to Automate the application.

 

[Allen Browne]

If you use VBA code rather than a macro, you can use:
- TransferSpreadsheet to export the file, then
- FollowHyperlink to open it.

 

[John W. Vinson]

I've used macro's in several several programs so i understand how they work,
I've just never used them in Access 2003.... Can I create a macro in access
that will open files on my computer... basically I need to create a macro
that opens a program and exports the info to an excel sheet so that I can
link that excel sheet to access to use to run a report..I know how to do the
linking and everything else..jsut need to know if access can do that or do i
need to get a different external macro creator to do it for me.

Access has both macros and Modules - the latter are VBA code, much closer to
the Excel macros with which you are familiar. I'd use a VBA module rather than
an Access Macro; VBA code is much more powerful and will be more familiar. You
can do anything in Access VBA that you can do in Excel VBA, and in essentially
the same way.

Do note that since Microsoft lost a lawsuit a couple of years ago, you can no
longer link to an Excel spreadsheet and update it directly; but you can still
use the TransferSpreadsheet method (see the Help) to transfer data from a
table or query into Excel.