Lavenderchan
Technical User
Hello,
I am looking to export data from an access query to an excel workbook. I can do it for cell ranges using the following code:
However, I need to export data into a column range and when I tried using the code below its not working right.
What am I doing wrong?
Thanks,
Lavender
I am looking to export data from an access query to an excel workbook. I can do it for cell ranges using the following code:
Code:
ExcelSheet.Range("H144").FormulaR1C1 = Me.[Parts Number]
However, I need to export data into a column range and when I tried using the code below its not working right.
Code:
ExcelSheet.Range("F17:F105").Columns.Value= Me.[Cost]
What am I doing wrong?
Thanks,
Lavender