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 Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Working with Excel named ranges
Folks... I didn't receive a reply, so I've re-worded my question, opening it up for other solutions, besides what I was attempting. I have a series of Excel files (path/filename stored in a table - tblOutlines) that I need to step through. Each file has several worksheets, and each worksheet...- gpseymour
- Thread
- Replies: 0
- Forum: Microsoft: Access Modules (VBA Coding)
-
Find comma in string & split string
Yes, you can do this. Let's assume your string will contain the following: 110,234, and that it is stored in a variable called strStringTest (from parent code or as a public variable, so not declared here) You can use InStr to return the position of the comma, as follows: Sub...- gpseymour
- Post #2
- Forum: Microsoft: Access Modules (VBA Coding)
-
Problem accessing Excel named range from Access VBA
Folks... I'm having trouble using the .GoTo method of an Excel object. Can someone advise me? I've tried several methods, and all receive the following error: "Error 1004: Method 'Goto' of object '_Application' failed." Here are two of the attempts: EXAMPLE 1: Dim xl As...- gpseymour
- Thread
- Replies: 0
- Forum: Microsoft: Access Modules (VBA Coding)
