Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Macro/VB Question DDE Question | Excel Worksheet Functions | |||
2007 Excel Tab Question | Excel Discussion (Misc queries) | |||
Two question about Excel 2007 | Excel Worksheet Functions | |||
Excel 2007 Question | Excel Discussion (Misc queries) | |||
Excel 2007 question? | Excel Worksheet Functions |