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...
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.