Thread: Recall a file
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dennis Tucker Dennis Tucker is offline
external usenet poster
 
Posts: 140
Default Recall a file

What do you mean by

....if a Quote number has been selected ... ??



"oldjay" wrote in message
...
I have a file named MasterQuote. A salesman can open it and then insert
inputs to generate a quote. He then clicks a command button that saves the
inputs to a file named Quotes(varies with the quote). Also a record is
exported to a file Quotes Database.xls that has the quote number, date and
description.

I want a command button in Quotes Database that when clicked will check to
see if a Quote number has been selected and if so checks to see if
MasterQuote is open and if not opens it then executes the macro
RecallQuote.

oldjay