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 dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Application.Match issue in Access VBA Module
The code below works fine in a XL VBA module but when I add it to my Access VBA module it produces an error. I suspect it needs to be modified but am unsure what to change. Can someone point me in the right direction? x = objWorkbook.Worksheets(lngCount).Application.Match("[All Markets]"...- BigFish69
- Thread
- Replies: 5
- Forum: Microsoft: Access Modules (VBA Coding)
-
Import Multiple Workbooks & Worksheets based on Worksheets Name
I am trying to modify the following code from "Ken's Examples for Importing from EXCEL Workbook Files" in an Access 2007 database. I need to cycle thru all the workbooks in c:\temp , open them and determine if any worksheets are name *child* "look for the word child which will have chars before...- BigFish69
- Thread
- Replies: 11
- Forum: Microsoft: Access Modules (VBA Coding)
