Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi guys,
A snip of code to open a workbook or create one if it does not exist. On Error GoTo CreateNewWorkbook Application.ScreenUpdating = False Workbooks.Open directory & filetext Why does Excel keep poppin'up saying ".....cannot be found. Check your spelling, or try a different path. It does open my workbook if it exists, or it does go to "Create Workbook" and creates my workbook if not. Works fine. The only bug is the pop-screen. Well, you guys are the different path I'm trying. Thanks in advance Marc |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
File Path Too Long? Not Anymore! Check out Long Path Tool | Excel Discussion (Misc queries) | |||
Formula too long - new file path is shorter than old file path - Excel 2003 | Excel Worksheet Functions | |||
hyperlink navigation path path wrong in Excel 2003 | Excel Discussion (Misc queries) | |||
how to change absolute path to relative path | Excel Worksheet Functions | |||
Current path to Qualified Path | Excel Programming |