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