Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() Follow-up on my last thread (which was answered, thus the new thread but same project...) At the beginning of my code, I use getopenfilename and then open workbook. I want a check (if/then?) between the getopenfilename an the open command, that will check to see if the filename entered i already open, if it is, skip the open command and continue with th rest of the code. Make sense? This is what I have: Sub get1degdata() Dim fname As Variant Dim Wkbk As Workbook Dim wksht As Worksheet fname = Application.GetOpenFilename("Excel files(*.xls),*.xls") Set Wkbk = Workbooks.Open(fname) Wkbk.Activate MsgBox fname |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Test to see if a workbook is open | Excel Discussion (Misc queries) | |||
Test if Lotus Notes open | Excel Programming | |||
Test that a workbook is open | Excel Programming | |||
test for workbook open | Excel Programming | |||
Test to see if a spreadsheet window is open | Excel Programming |