A
aaronjosephward
OK lets see if i can explain what I am trying to do.
Every day at midnight a .csv file is generated at midnight containing
values of power consumption for the day with the date being the
filename (ie 2007 1 11.csv.)
Every week on wednesday a .xls file is generated containing values
predicting the power consumption for each day for the next week.
i need to compare the data between the two files and save this file
either weekly or daily.
i have some ideas how to do this but i'm not familar with VBA at all.
i've googled some things and i've found code for renaming and copying
files but most of it doesn't work or i'm probably doing stuff wrong.
any ideas?
Thanks,
Aaron Ward
Every day at midnight a .csv file is generated at midnight containing
values of power consumption for the day with the date being the
filename (ie 2007 1 11.csv.)
Every week on wednesday a .xls file is generated containing values
predicting the power consumption for each day for the next week.
i need to compare the data between the two files and save this file
either weekly or daily.
i have some ideas how to do this but i'm not familar with VBA at all.
i've googled some things and i've found code for renaming and copying
files but most of it doesn't work or i'm probably doing stuff wrong.
any ideas?
Thanks,
Aaron Ward