Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error 1004 when I open a file
Hi!
When I want to open a .xls file with VBA command: Set bk2 = Workbooks.Open(name) where bk2 is defined as: Dim bk2 As Workbook I get: 'run time error '1004': Method 'Range' of object '_Worksheet' failed and when I look in Excel, the file is opened! Please anybody who can help me on the right track? What is wrong? Regards, Mike |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Open Excel file get error with file names that have spaces in the | Setting up and Configuration of Excel | |||
EXCEL:Can't open any file without error saying it's ALREADY open??? | Excel Worksheet Functions | |||
Runtime error '1004' General ODBC error | New Users to Excel | |||
Excel 2003 Macro Error - Runtime error 1004 | Excel Discussion (Misc queries) | |||
runtime error 1004 when opening excel file via VBA in a browser | Excel Programming |