Export from access to specific worksheet and specific cell in exce

  • Thread starter Thread starter Kevin
  • Start date Start date
K

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.
 
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---
 
Back
Top