Automatic a Data Import routine in Excel

[safarijoe2000]

Hello,

I have a data import routine that I have to do manually every day, converting a CSV file into Excel.

Is there any way, I can automate the process?

Your help will be much appreciate it.

Regards

 

[SkipVought]

Hi,


Use Data/Get External Data/IMPORT Data.

As long as the FILENAME does not change, all you have to do, once you add this QueryTable, is Data/Refresh to get a new set of data that replaces the original data.

If the FILENAME changes, there are some things we can do that might take a little VBA Code.

Skip,
[sub]
[red][/red]
[/sub]