Hey,
here is what I have so far. I know how to save a workbook, but I just want to loop thru and change the file names. I don't have to use excel, it just seemed easier:
Sub DirLoop()
Dim MyFile As String, Sep As String
' Sets up the variable "MyFile" to be each file in the directory...
I need to change multiple file names in a directory that contains almost 3000 files. I know how to change the names but I want to save the file and keep looping to the next file. I am using excel in a macro to loop thru the directory. Excel 2000.
Thanks
VBA on an Excel 2000 Worksheet
Using the following code I create a list box.
Set lstSubs = .Shapes.AddFormControl(xlListBox, 400, 700, 200, 200)
The next time someone opens this worksheet I want to make sure that this listbox is deleted so that when this code runs again it will not just keep...
Hey Paulwood,
Did you find the answer to this question?
I have the same problem with IE6 on just one of my systems running W2K Pro.
Your original question below:
I have been having a problem accessing the Mcafee site, and I think I may have found out why, but I'd appreciate some input, and if...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.