Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Open Existing Excel Workbooks from Access module
lube8 I am assuming you have create an object variable to hold your instance of Excel. I normally call mine objExcel. To open a particular workbook write: objexcel.workbooks.open pathname Once you have the workbook open you can access that workbook by using objExcel. Including formatting...- jnspres
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
