L
Lawson
Hello,
i have written a macro that saves the users file in the
appropriate file on the server when they type the job
name in a certain cell (if they type 23190, is saves to
\\EST-server-1\EST\Quotes\23000\23100\....
i would like to make this faster in the case that the
file already exists and the MS prompt comes up, 'File
found, would you like to save over it?'. i would like my
program to automatically enter yes rather than have user
click yes (or type y)
i know its picky, but it gets annoying after the 100th
time each day.
i have written a macro that saves the users file in the
appropriate file on the server when they type the job
name in a certain cell (if they type 23190, is saves to
\\EST-server-1\EST\Quotes\23000\23100\....
i would like to make this faster in the case that the
file already exists and the MS prompt comes up, 'File
found, would you like to save over it?'. i would like my
program to automatically enter yes rather than have user
click yes (or type y)
i know its picky, but it gets annoying after the 100th
time each day.