Excel 2007 vba question

L.S.

The code:

vFileName = Application.GetOpenFilename("CSV Files (*.csv), *.csv", 1, "Select csv file.")
Sheets.Add Type:=vFileName

worked fine in excel 2003 vba but in excel 2007 vba it gives the error:

Run-time error '1004':
Method 'Add' of object 'Sheets' failed

The code line :

Sheets.Add Type:="D:\overview.csv"

worksfine in both versions.

Can someone help me with this....?

kaak

Kaak

Works fine for me in both versions (2003 and 2007)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
[email protected]HIS


"Kaak" <[email protected]> wrote in message
news:[email protected]...
>
> L.S.
>
> The code:
>
> vFileName = Application.GetOpenFilename("CSV Files (*.csv), *.csv", 1,
> "Select csv file.")
> Sheets.Add Type:=vFileName
>
> worked fine in excel 2003 vba but in excel 2007 vba it gives the
> error:
>
> Run-time error '1004':
> Method 'Add' of object 'Sheets' failed
>
> The code line :
>
> Sheets.Add Type:="D:\overview.csv"
>
> worksfine in both versions.
>
> Can someone help me with this....?
>
> kaak
>
>
> --
> Kaak
> ------------------------------------------------------------------------
> Kaak's Profile:
> http://www.excelforum.com/member.php...fo&userid=7513
> View this thread: http://www.excelforum.com/showthread...hreadid=556333
>