I am trying to import data from 4 different Visual Fox tables and then insert each set of data into a new worksheet with the ws name added.
Right now, in a macro, I am creating the new ws and naming it, then just below that in the same subroutine, I am running the query to import the data. The new ws gets created and named, but the query imports the data and then just put it into a new ws, like Sheet5.
How can I get the query to add the data to the new ws.
Is it ok to add code to this message window?
Thanks,
Fred
Right now, in a macro, I am creating the new ws and naming it, then just below that in the same subroutine, I am running the query to import the data. The new ws gets created and named, but the query imports the data and then just put it into a new ws, like Sheet5.
How can I get the query to add the data to the new ws.
Is it ok to add code to this message window?
Thanks,
Fred
