Is my logic correct? I have a macro running in a workbook that asks the
user for the account number. On Click, I want the macro to create and
save a new workbook with the account number as file name, then excecute
a query to pull data from a database.

The macro ran fine when taking the account number and pasting it on a
new sheet in the same workbook. Its failing now that I am trying to
get the data onto a new xls. Am I trying something not possible?


--
luke99s
------------------------------------------------------------------------
luke99s's Profile: http://www.excelforum.com/member.php...o&userid=28016
View this thread: http://www.excelforum.com/showthread...hreadid=475224