Macro to Excel - HELP!!!

[Toyotagrl]

I am really bad at macros
What is a simple macro for putting info from a query into an Excel spread sheet.

Would it be to much trouble for someone to explain it all to me?

Thank you so much

 

[ColinEssex]

Hi

I haven't done this for ages but if I remember correctly, its the "transfer spreadsheet" bit in the macro then fill in the appropriate boxes at the bottom to specify stuff.

Not sure if I've helped really!!

I'll check it out when I can and be a bit more precise if nobody else can help you

Col

 

[Mario]

DoCmd.TransferText is the command you are looking for. Look up the help to see what are the arguments...