Can I edit Excel file in Access VBA?

[sharonng]

My task: export an Excel file that is one column different compared to the Access table (e.g. change the data in one Access column to another).
Is it possible to write an Access VBA program that manipulates the exported Excel file, or can I only change that in the Excel VBA?

 

[welshgasman]

You can run VBA on the excel workbook after exporting?
Is that what you mean?
You could change the column on the fly with a query/program and just export that.?

 

[Micron]

I think this is the go-to place for automation to or from Excel and Access.

EXCEL Import And Export