I have the following code

quotenumber = InputBox("Please enter QUOTE number to recall from your hard
drive. If recalling a quote from the server type in
\\server3\jobs\estimate1\quick quotes3\ and the estimate number ", "The
Company", "C:\Quick Quotes3\")
QUOTE = quotenumber & ".XLS"

As shown it highlites the quote number .xls. I want it to place the curcor
at the .xls

oldjay

Oljay,

If the quotes are stored in a specific directory then don't give the user
the chance to change the directory. You can just tie together the variables
as you did with Quotenumber and "xls". You would have an issue if the
directory "quick quotes 3" is not on the machine, however, you can run code
to test for it and/or create it. On the server you may want to have the user
type the word "server" and then the quote number. You can test your variable
for the word "server" then use the path '\\server3\jobs\estimate1\quick
quotes3\' + quotenumber to locate the file.


"Oldjay" wrote:

I have the following code

quotenumber = InputBox("Please enter QUOTE number to recall from your hard
drive. If recalling a quote from the server type in
\\server3\jobs\estimate1\quick quotes3\ and the estimate number ", "The
Company", "C:\Quick Quotes3\")
QUOTE = quotenumber & ".XLS"

As shown it highlites the quote number .xls. I want it to place the curcor
at the .xls

oldjay