Data from CSV to Excel Prakash 21.09.2006 12:35:02 Hi Experts, 1. User has a product, which has feature to export data only into CSV. 2. In Excel, I have written a VB Macro to format the data/generate certain reports. 3. Is there away out to Import/Copy data Programatically using VBMacro from CSV to Excel so my VB Macro will work and generate reports. Thanks in advance

RE: Data from CSV to Excel Gary''s Student 21.09.2006 12:54:01 Workbooks.Open Filename:="C:\x.csv" You will substitute your path and filename. -- Gary's Student "Prakash" wrote: [Quoted Text] > Hi Experts, > > 1. User has a product, which has feature to export data only into CSV. > 2. In Excel, I have written a VB Macro to format the data/generate certain > reports. > 3. Is there away out to Import/Copy data Programatically using VBMacro from > CSV to Excel so my VB Macro will work and generate reports. > > Thanks in advance

Re: Data from CSV to Excel "Pete_UK" <pashurst[ at ]auditel.net> 21.09.2006 12:56:25 The easiest way to get to know the syntax is to go through the exercise once with the Marcro Recorder turned on and to manually select the file for import (or just File | Open). After you have finished recording, you can view the recorded code to see how it would need to be amended to suit a more general situation (like specifying a different filename each time you run it) and calling your existing macro. Hope this helps. Pete Prakash wrote: [Quoted Text] > Hi Experts, > > 1. User has a product, which has feature to export data only into CSV. > 2. In Excel, I have written a VB Macro to format the data/generate certain > reports. > 3. Is there away out to Import/Copy data Programatically using VBMacro from > CSV to Excel so my VB Macro will work and generate reports. > > Thanks in advance