Merging a CSV and XLS file automatically

M

Maxwell2006

Hi,



I have a csv fles on the network derive that is being updated every night.



I need to automatically put the CSV data into the first worksheet of another
XLS file and make it available for users.



I can have a scheduled task runs and merge the CSV into the XLS file.



What would be the easiest/automated way to do that?



Thank you,

Max
 
M

mrice

Sounds like you need an auto_open macro in your workbook which you are
opening as a scheduled task.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merging a CSV and XLS file automatically 3
Macro to open CSV files 6
Excel CSV Files; Creating Of 3
Import Multiple CSV Files from Same Folder into Open Workbook 5
Convert a csv to xls prior to import 2
how do I change a csv extension file to an xls file and use it? 1
Convert csv to Excel files 1
Looping Open and Save as CSV 9

Top