Hi all, I would like to delete any special characters of a filename before saving, however, it seems I have missed something.....
Can anyone please help?
Thanks!
TT77
..VBA Newbie[ATTACH]801073
Hi all, I would like to delete any special characters of a filename before saving, however, it seems I have missed something.....
Can anyone please help?
Thanks!
TT77
..VBA Newbie[ATTACH]801073
Last edited by TT77; 10-18-2022 at 12:36 AM. Reason: Add information
Just need a simple code to delete all special characters in the filenames before saving.
Any other suggestions also welcome.
Thank you
Last edited by TT77; 10-18-2022 at 12:39 AM.
Attached the code in txt format Thanks
Last edited by TT77; 10-18-2022 at 12:37 AM.
I think I missed a save function.
Thanks Alan, you already made 20,000 posts!!
Last edited by TT77; 10-18-2022 at 12:40 AM.
Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Please Login or Register to view this content.
Hi, jindon, thank you so much for the code!
I want to make it as part of a process before Activeworkbook.SaveAs I tried to paste the function but it does not work.
Will something like the attached work?
ThanksReplace special characters before save.txt
Function should remain intact.
then call it like
Please Login or Register to view this content.
Thank you very much. How will you make an independent macro to loop all files in a folder, remove all special characters in the filenames?
Thanks!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks