Edit Excel cell from Access?

[JR2913]

Is it possible to change the content of a cell in an Excel spreadsheet from code within Access?

I have a number of spreadsheet files that need to be imported but the heading of one column is incorrect and needs changing to "SENStatus" before I use the Transferspreadsheet command to put the data into the table that exists in the back-end database. At the moment it is creating an error as the column heading doesn't match this existing field name, so I can't import the data.

Any advice on how to do this from within VB would be much appreciated.


John R

 

[vbajock]

You have to set up a reference to the Excel object model in code to do this. Can you work in VBA at that level?

 

[JR2913]

Yep....... must be brain dead this afternoon, as I have done this before. Just couldn't get my head round it to start with.

Thanks

John R