Deleting characters assigned in the variable

Hi there,

My macro gets the name of the target file (eg. "100. Years of Legacy_12_09_2020_220845.xlsb"), and is assigned in the variable "fileName". This .xlsb file has number of links from different source files and the file name attaches the time stamp (report dumped time) in it.

The file is saved in a folder and I am looking to save it as a back up in a different folder on .xlsx format with the following requirements.

1. Delete numeric characters in the left,
2. Delete (".") after the numeric characters and trim " " (space character), and
3. Break links with other source files.

The output shall be "Years of Legacy_12_09_2020_220845.xlsx" with no links.

Can you please advise me appropriate code to do this?

Thank you,
Roshan Shakya

To update the file name, re-assign it to a string value, then manipulate the name and re-assign it. Something like this

Please Login or Register  to view this content.

Originally Posted by Roshan.Shakya

... file has number of links from different source files ...

What type of links are these (formulas, functions, defined names, hyperlinks, embedded ole, from charts, etc.) ?
Can you present their types ?

Originally Posted by Roshan.Shakya

... the file name attaches the time stamp (report dumped time) in it ...

What does this mean, can you explain ?