I have a folder with lot of workbooks in which there is only one sheet per workbook.
Am looking a macro that renames all worksheets (excel) similar to their workbooknames within a folder (loop).
The files are found c:\TESTA\
ANNEXED a copy of the directory
found a similar thread but did not work
https://stackoverflow.com/questions/...es-in-a-folder
Can someone assist
When you say that the example that you got from the similar thread did not work....
Which one of the examples were you trying?
What error message (if any) did you get.
It would help if you posted the actual code that you tried to run and the error description.
Martin
I got compile error variable not defined at i = 1
Please Login or Register to view this content.
OK - Try
Please Login or Register to view this content.
Have a try indeed nothing happens.
I have changed path to testa1 as a test for 2 files .
Nothing happens
However ,I have a new code, it works but issue each time give message
Be careful of your documents may include personal information that can;t be removed by document inspector.Please Login or Register to view this content.
Since I have 300 files . It is boring to click ok each time.
Any way to get rid of that message.
Last edited by JEAN1972; 01-06-2019 at 04:14 PM. Reason: new code
How about this.
Please Login or Register to view this content.
Last edited by bakerman2; 01-08-2019 at 03:31 AM. Reason: Fixed error in code
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
tried but unsucessful getting compile error message
for each control variable must be variant or object.
Please Login or Register to view this content.
My apologies...only now had a look at bakerman2's code which works with this variable declaration...
Please Login or Register to view this content.
Last edited by sintek; 01-07-2019 at 02:44 PM.
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks