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

Workbooks.Open Filename:="C:\x.csv"

You will substitute your path and filename.
--
Gary's Student


"Prakash" wrote:

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

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:
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