Hi
I have created a simple template in excel that contains a freeze pane for the first row. I want to export a queries results to this template so that the first row of DATA (not the headings) of the query fills the second row of my template.
at the moment i am using the "output to" macro which outputs the whole query result (including headings) to a blank worksheet but it will not export to my template and will not export just the data.
What am i doing wrong?
hope someone can help, Thank you for you time
Jed
I have created a simple template in excel that contains a freeze pane for the first row. I want to export a queries results to this template so that the first row of DATA (not the headings) of the query fills the second row of my template.
at the moment i am using the "output to" macro which outputs the whole query result (including headings) to a blank worksheet but it will not export to my template and will not export just the data.
What am i doing wrong?
hope someone can help, Thank you for you time
Jed
