hello,
I'm trying to use a macro button to import a CSV from a browse location dialog box, then name the current worksheet the imported file name with the spaces and dashes replaced with underscores. So when I export the sheet it saves as a new file name with the spaces and dashes replaced with underscores.
Every thing works as it should until I get to replacing the spaces and dashes with underscores.
This is my current import code
and the code for my export button is
Any advice would be appreciated.
Bookmarks