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
------------------------------------------------------------------------
Kaak's Profile: http://www.excelforum.com/member.php...fo&userid=7513
View this thread: http://www.excelforum.com/showthread...hreadid=556333

Excel 2007 vba question
 

Kaak

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

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


"Kaak" wrote in message
...

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