Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Working with the forms in different workbooks...
Hello all,
I think its bit difficult to explain, but let me try..... I have two xls files - Main.xls & Feature_Compare.xls In each file I have a Public Function (in Module) named "showform" which will initiate the Showing of the respective form. My code is as follows.... This code is in the Form of Main.xls '************************************************* ****** ' IsFileOpen checks if the file is open or not.... If IsFileOpen(BaseFolder & "Feature_Compare.xls") Then Workbooks("Feature_Compare.xls").Close False End If Me.Hide Workbooks.Open BaseFolder & "Feature_Compare.xls" ActiveWorkbook.Worksheets("Blank").Activate Application.Run "Feature_Compare.xls!showform" ThisWorkbook.Close False '************************************************* ****** OBSERVATION: the code, Application.Run "Feature_Compare.xls!showform", will show the Form. But until that form is not closed, the last line, "ThisWorkbook.Close False", will not get executed. When I close that Form, the Main.xls gets closed. MY PROBLEM: I have a similar code in the "Feature_Compare.xls" also. So when I switch from "Feature_Compare.xls" to the "Main.xls", it will make the form in the Main.xls to show. But the "Feature_Compare.xls" is still open because it will be closed only when I close the form. Because of this, When I try to go back to the form in "Feature_Compare.xls", since the previous code was not fully complete, this above code is not working properly. If my explanation may not be fully understandable, please let me know.. Any help will be really be appreciated.... Thanks Joe |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup not working (active) - 2 workbooks | Excel Discussion (Misc queries) | |||
Formuals not working in existing workbooks | Excel Worksheet Functions | |||
Working on Multiple Workbooks | Excel Discussion (Misc queries) | |||
Working with Different workbooks | Excel Discussion (Misc queries) | |||
Working with Different workbooks | Excel Discussion (Misc queries) |