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
How to create a .XLS file instead of a .CSV file 5
XLS To CSV Macro 6
Saving XLS File as CSV 1
xls to csv 0
Need a tool to convert .csv to .xls 11
send reminder email through outlook based on info from a csv/excel file 0
how do I change a csv extension file to an xls file and use it? 1

Top