PC Review


Reply
Thread Tools Rate Thread

Merging a CSV and XLS file automatically

 
 
Maxwell2006
Guest
Posts: n/a
 
      12th May 2006
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




 
Reply With Quote
 
 
 
 
mrice
Guest
Posts: n/a
 
      13th May 2006

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


--
mrice

Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=541719

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Merging info from Wkbk 1 to Wkbk2 automatically avinity Microsoft Excel Setup 0 13th Jan 2010 04:41 PM
Automatically merging 2 data sets that share some values srsammsiam Microsoft Excel Programming 5 8th Sep 2009 03:16 AM
merging of data automatically ah Microsoft Excel Misc 2 29th Nov 2007 01:44 PM
Merging a CSV and XLS file automatically Maxwell2006 Microsoft Excel Programming 3 16th May 2006 04:20 AM
Help needed in merging csv files into one Automatically. TD Microsoft Access 1 19th Oct 2004 01:39 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:44 PM.