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!
-
Excel File Search Problem
Thanks for the help but I'm a little slow... What do you mean by quallifying the path? I've tried the \\ approach and the e:\ approach and both of them work with only one folder on the drive. I think the .FileName = "*.dwg" might be causing a problem. One other thing, the...- jbhill001
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Excel File Search Problem
I'm new to most of this so can anyone tell me what I am doing wrong? I get a Invalid Procedure Call or Argument when I change the .LookIn directory to something other than e:\drew Thanks! Jason Private Sub CommandButton1_Click() Range("A2:C40000").Clear r = 2 TheDate = Format(Now()...- jbhill001
- Thread
- Replies: 2
- Forum: VBA Visual Basic for Applications (Microsoft)
-
File Search Directory Problem
I'm new to most of this so can anyone tell me what I am doing wrong? I get a Invalid Procedure Call or Argument when I change the .LookIn directory to something other than e:\drew Thanks! Jason Private Sub CommandButton1_Click() Range("A2:C40000").Clear r = 2 TheDate = Format(Now()...- jbhill001
- Thread
- Replies: 1
- Forum: Visual Basic (Classic)
