Export from access to specific worksheet and specific cell in exce

[Kevin]

Hi I am trying to find code that will allow me to export a report to sheet 3
Cells 6,8. in an exisiting spreadsheet. I have looked all over and can not
find the code please help.

 

[pietlinden]

Hi I am trying to find code that will allow me to export a report to sheet 3
Cells 6,8. in an exisiting spreadsheet. I have looked all over and can not
find the code please help.

one of these should work:
http://www.mvps.org/access/modules/mdl0035.htm

 

[ryguy7272]

This is how I would do it...
Create a New Macro
Action = TransferSpreadsheet
Transfer Type = Export
Spreadsheet Type = Microsoft Excel 8-10
Tabe Name = (yourTable)
File Name = (yourFile)
Has Field Names = (up to you...)
Range = Sheet3!A6:A8 (you said 6 to 8; I don't know which column though...)

Eventually, you can save the Macro as a Module, manage the code, and
automate the process if you want. Hope you can get by with that.

Regards,
Ryan---

 

[Kevin]

Thanks Ryan, I will give this a try and feedback later tonight.

 

[Kevin]

Thanks for you help,

I will give these a try & feedback later

Kevin