file name

[kev carter]

hi
i have a workbook that allows the user to save a copy of the workbook by
entering the name as text
the problem is if the user enter a character such as [],:,/,* it crashes
the program
is there anyway i can trap this and stop the spreadsheet crashing

thanks in advance

kevin

 

[Frank Kabel]

Hi Kevin
you may pass the relevant code of this macro

 

[kev carter]

Frank
what macro?

Hi Kevin
you may pass the relevant code of this macro

--
Regards
Frank Kabel
Frankfurt, Germany

hi
i have a workbook that allows the user to save a copy of the workbook
by entering the name as text
the problem is if the user enter a character such as [],:,/,* it
crashes the program
is there anyway i can trap this and stop the spreadsheet crashing

thanks in advance

kevin

 

[Frank Kabel]

Hi
I thought you had a macro for saving the workbook. So the user enteres
these characters in the build-in dialog?
If yes what crashes exactly?

--
Regards
Frank Kabel
Frankfurt, Germany

Frank
what macro?

Hi Kevin
you may pass the relevant code of this macro

--
Regards
Frank Kabel
Frankfurt, Germany

hi
i have a workbook that allows the user to save a copy of the
workbook by entering the name as text
the problem is if the user enter a character such as [],:,/,* it
crashes the program
is there anyway i can trap this and stop the spreadsheet crashing

thanks in advance

kevin

 

[kev carter]

Frank
the user can type a name into a cell, the value of the cell is the name the
file will be saved as.
if the name contains any of the chars previously mensioned windows reads it
as a path or command

Hi
I thought you had a macro for saving the workbook. So the user enteres
these characters in the build-in dialog?
If yes what crashes exactly?

--
Regards
Frank Kabel
Frankfurt, Germany

Frank
what macro?

Hi Kevin
you may pass the relevant code of this macro

--
Regards
Frank Kabel
Frankfurt, Germany


kev carter wrote:
hi
i have a workbook that allows the user to save a copy of the
workbook by entering the name as text
the problem is if the user enter a character such as [],:,/,* it
crashes the program
is there anyway i can trap this and stop the spreadsheet crashing

thanks in advance

kevin