Search results for query: *

Skip, Everything seems to be working. Thanks for your quick replies and knowledge. It made my day go a little smoother with this help.

Just the one QT will be run per data source page. Steps for the macro -User selects data source -Macro fills the template with the appropriate columns of data -Will then prompt for a location to SaveAs

Thanks for your help Skip! I see what you mean by defining the active sheet... But I can't hardcode in BENNINGTON_9 because that name will change depending upon the data file that the user selects at the beginning in fopen. The above code you posted doesn't specify the destination of the data...

The difference is me just running the marco recorder real quick and not clicking the identical column widths as previous. The intention is to fill the blank template with the portion of data that we need.

Yes, I can run it manually and record it no problem but then it hard codes a source for the data file. We use over 50 different data files so the user needs to be able to select the file which is why I added in that portion to the begining of the code. Below is a copy of the code from...

VB isn't my area... I'm having trouble trying to get the QueryTable to actually populate the data into the active worksheet in Excel. It works in that it prompts me to navigate and select my data source file. The problem is once I select the data file source I get a "Run-Time error 1004" with...