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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
multiple for each loops within vba
I hope someone can help me. I have a vba script that combines equipment from multiple excel files. The problem I have is trying to compare 2 files for similar worksheet names. If names are similar then I need to add a worksheet in the new workbook after the matching sheeet. I have attached...- pburke11
- Thread
- Replies: 7
- Forum: Microsoft: Office
-
double click and intersection
I am not having much success. I have part of it working. so far I have: Set Target = ActiveCell Set a = Range("e12") Set b = Range("f12") Set aa = Range("o29") Set ab = Range("p29") If aa = 3 And Intersect(Target, a) Is Nothing Then Exit Sub Cancel = True...- pburke11
- Thread
- Replies: 2
- Forum: VBA Visual Basic for Applications (Microsoft)
-
populate text box with file open dialog box
Hi, I have been trying to get the right combinations to pass the user selected files from a file open dialog box to a text box in a user form. I think I have the right dialog to put each file on a separate line, but running the routine either doesn't pass the variable or only passes 1 name...- pburke11
- Thread
- Replies: 4
- Forum: Microsoft: Access Modules (VBA Coding)
