file name

K

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
 
K

kev carter

Frank
what macro?

Frank Kabel said:
Hi Kevin
you may pass the relevant code of this macro

--
Regards
Frank Kabel
Frankfurt, Germany


kev said:
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
Click to expand...
Click to expand...
 
F

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


kev said:
Frank
what macro?

Frank Kabel said:
Hi Kevin
you may pass the relevant code of this macro

--
Regards
Frank Kabel
Frankfurt, Germany


kev said:
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
Click to expand...
Click to expand...
Click to expand...
 
K

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
Frank Kabel said:
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


kev said:
Frank
what macro?

Frank Kabel said:
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
Click to expand...
Click to expand...
Click to expand...
 
Top