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