Recrod a macro? in MS Access?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all,

Is it possible to “record a macro†in access like you can in Excel? I cant
seem to find a similar function

Basically I want to create a macro that will be used on a daily basis. It
would import a specific sheet from a specific excel file. And just do the
same settings each time like “first row contains headers†saves table with
the same name, then execute query “xxxx†then query “xxxx†then Export file
to c:/data/xxx.xx

Can anyone point me in the right direction for some info? Thanks in advance!

Ernest
 
Ernest,

No, there is no provision to "record" a macro in this way. You need to
write the macro in the macro design window. From your description, it
sounds like for a start you would need these actions in your macro:
TransferSpreadsheet
OpenQuery
OpenQuery
TransferText
 
worked a treat thanks very much



Steve Schapel said:
Ernest,

No, there is no provision to "record" a macro in this way. You need to
write the macro in the macro design window. From your description, it
sounds like for a start you would need these actions in your macro:
TransferSpreadsheet
OpenQuery
OpenQuery
TransferText
Click to expand...
 
Back
Top