sitewolf
Active Member
- Joined
- May 4, 2012
- Messages
- 304
Code:
For lead = 1 To 20
CurrentFile = ActiveCell
Workbooks.Open Filename:=CurrentFile
ActiveWindow.Caption = "Graboid"
I have a file I use to grab information off a website I subscribe to.
I get daily emails containing a list, then I use that list to extract additional information for each item in the list.
But I never know how many will be in the list. Now, when it's me running the macro, I just edit the numbers to suit me, but I'm looking to set this up so someone can run this w/o having to deal with editing VB.................which means I should also add in some log in script now that I think about it.
Anyway, this is just a snippet...