Source for learning Excel Manipulation in Access VBA

[certifydgangsta]

I've done some googling, but haven't had much luck finding an in-depth guide on manipulating excel workbooks using MS Access VBA. Does anyone have any recommendations? Thanks for any input!

 

[namliam]

Well if you know how to do it in Excel itself, then all you do is make an excel reference
Dim xlApp as Excel.Application

Then prefix all your normal code from excel with this xlApp or xlWkb, xlSheet, xlRange, etc...

 

[certifydgangsta]

Thanks namliam, that helped me fix the code in my other post!