Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
For some extra functions I created a second workbook (wb2.xls). In Sheet1!A1
(wb1.xls) is the filename (created with a formula). This works fine: Sub Test1() Workbooks.Open Filename:= _ Range("Sheet1!A1").Value End Sub But this doesn't work: Sub Test2() Option Explicit Dim mywkbk As Workbook Dim myfile As String myfile = Range("sheet1!A1").Value If Dir(myfile) = "" Then MsgBox "that doesn't exist!" Exit Sub Else Set mywkbk = Workbooks.Open(myfile) End If End Sub Can someone help?? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Check if file exists | Excel Discussion (Misc queries) | |||
How do I check if a sheetname exists in a file? | Excel Programming | |||
How to check if a file exists in an ftp folder | Excel Discussion (Misc queries) | |||
check if file exists | Excel Programming | |||
check if a file exists / is open | Excel Programming |