tonywatsonhelp
Well-known Member
- Joined
- Feb 24, 2014
- Messages
- 3,194
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hi Everyone,
please excuse my ignorance but i don't know what the official name for these things would be, but if you use excel a lot I'm sure you can understand what I'm trying to do
I use cell D11 as the cell that holds the document name
I have a macro that works great, that takes this name and saves the document in it current location.
this is all fine,
the problem is sometimes someone will try save the document using a character excel cant include in the file name easily and we get an error
for example , it might be named "21/23 the street"
so what I'd like is a way to check if the cell contains any problem letters ?
if it does, the ideal would be to tell the person what is being used that cant be used in a message box?? eg "You can not use / in a document name, please change this!"
anyone able to help me? I don't know which chartreus are a problem but even if you could just do it to check the propular ones like "/" then this would be a huge help
thanks
Tony
please excuse my ignorance but i don't know what the official name for these things would be, but if you use excel a lot I'm sure you can understand what I'm trying to do
I use cell D11 as the cell that holds the document name
I have a macro that works great, that takes this name and saves the document in it current location.
this is all fine,
the problem is sometimes someone will try save the document using a character excel cant include in the file name easily and we get an error
for example , it might be named "21/23 the street"
so what I'd like is a way to check if the cell contains any problem letters ?
if it does, the ideal would be to tell the person what is being used that cant be used in a message box?? eg "You can not use / in a document name, please change this!"
anyone able to help me? I don't know which chartreus are a problem but even if you could just do it to check the propular ones like "/" then this would be a huge help
thanks
Tony