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?