How do I simply open Excel from Access using VBA (I would prefer early binding, but anything will do) and just change the color of a cell then save and Exit.

Well, you'll have to sift through some code, but this is a prototype I did for exporting data to Excel from Access. Because it was prototype code, I don't think it hides Excel when it launches. You'll have to dig around to find out how to do this, it's just one parameter though.

It doesn't exit, but I'm pretty sure that's just something like Application.Exit or Application.Quit.

Thank you!

Below are some tips on how to insert date and time in an excel cell for a specific purpose:-

To insert current date, press “CTRL”+ “;” in the chosen cell.

To insert current time, press “CTRL”+ “SHIFT”+ “;”.

To insert current date and time together, press “CTRL”+ “;” “SPACEBAR”+ “CTRL”+”SHIFT”+ “;"

Thanks for your reply