Open and paste a .txt file to a pre-defined table

Hi all,

1. I have a pre-formatted spreadsheet. Would it be possible using a macro to open a text file (note I have files for everyday of the month) to a pre-defined table in a spreadsheet.

This macro would be taking place of selecting my table and using Get External Data> Import Text File.

This needs to be connected to a command button that is located on the spreadsheet.

2. I have a command button that clears all the data from the pre-defined data table.

3. This is to simplify everything for my employees (about 6) to be able to view data but to be able to look at certian variable that are in formulas like averages and simple addition to determine data from that day.

I can also supply a copy of my spreadsheet and a couple days of data if it will help.



Also here is what I have for code on it right now.

Please Login or Register  to view this content.

Where Im not sure where to go is how to take the file I opened from the dialog and paste it to my table.

I have included my template, 3 days of data and 2 macros

If anyone can help Thanks



Tim

Try this. It requires your template to be in the same folder as the workbook.

Please Login or Register  to view this content.