Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Moving from one Excel File to Another
I have an application I am working on that has a Menu which is contained in
an Excel Workbook with supporting VBA and no data. I open this workbook then select one of the following two options: 1. Choose to open a new workbook. - This option creates a new workbook based on a template I have created. 2. Choose to open an existing workbook. This works fine. The problem I am having is after I work in either a new workbook (and save it) or make changes in an existing wqorkbook (and save Changes) I may want to return to the menu. Toward this end I have a button on an input form to "Return to Menu". When I execute the code behind this button it opens the menu workbook again and then closes the workbook containing the data. The menu form appears, but the form from the data workbook does not disappear. The workboiok is closed so I suspect it is a problem with redrawing the screen. The only command I find in VBA which appears to address this issue applies to the Form object and does nothing to resolve this issue. Any ideas? Is the an API call that will do it and if so what would the code look like? Any help would be greatly appreciated! Kevin |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Moving from one Excel File to Another
Just a wild guess...
You unloaded the form, but screenupdating was set to false. Maybe change the screenupdating to true, unload the form, and then back to screenupdating = false. Kevin wrote: I have an application I am working on that has a Menu which is contained in an Excel Workbook with supporting VBA and no data. I open this workbook then select one of the following two options: 1. Choose to open a new workbook. - This option creates a new workbook based on a template I have created. 2. Choose to open an existing workbook. This works fine. The problem I am having is after I work in either a new workbook (and save it) or make changes in an existing wqorkbook (and save Changes) I may want to return to the menu. Toward this end I have a button on an input form to "Return to Menu". When I execute the code behind this button it opens the menu workbook again and then closes the workbook containing the data. The menu form appears, but the form from the data workbook does not disappear. The workboiok is closed so I suspect it is a problem with redrawing the screen. The only command I find in VBA which appears to address this issue applies to the Form object and does nothing to resolve this issue. Any ideas? Is the an API call that will do it and if so what would the code look like? Any help would be greatly appreciated! Kevin -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Moving from one Excel File to Another
Dave,
Thanks! I'll look at that! I will post back if that does not correct the problem. Thanks again! :-) "Dave Peterson" wrote: Just a wild guess... You unloaded the form, but screenupdating was set to false. Maybe change the screenupdating to true, unload the form, and then back to screenupdating = false. Kevin wrote: I have an application I am working on that has a Menu which is contained in an Excel Workbook with supporting VBA and no data. I open this workbook then select one of the following two options: 1. Choose to open a new workbook. - This option creates a new workbook based on a template I have created. 2. Choose to open an existing workbook. This works fine. The problem I am having is after I work in either a new workbook (and save it) or make changes in an existing wqorkbook (and save Changes) I may want to return to the menu. Toward this end I have a button on an input form to "Return to Menu". When I execute the code behind this button it opens the menu workbook again and then closes the workbook containing the data. The menu form appears, but the form from the data workbook does not disappear. The workboiok is closed so I suspect it is a problem with redrawing the screen. The only command I find in VBA which appears to address this issue applies to the Form object and does nothing to resolve this issue. Any ideas? Is the an API call that will do it and if so what would the code look like? Any help would be greatly appreciated! Kevin -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Moving from one Excel File to Another
Dave,
Thanks! I'll check that and post back if that does not correct the problem. I am at home now and will have to pull out the work laptop to try it! Thanks again! Kevin "Dave Peterson" wrote: Just a wild guess... You unloaded the form, but screenupdating was set to false. Maybe change the screenupdating to true, unload the form, and then back to screenupdating = false. Kevin wrote: I have an application I am working on that has a Menu which is contained in an Excel Workbook with supporting VBA and no data. I open this workbook then select one of the following two options: 1. Choose to open a new workbook. - This option creates a new workbook based on a template I have created. 2. Choose to open an existing workbook. This works fine. The problem I am having is after I work in either a new workbook (and save it) or make changes in an existing wqorkbook (and save Changes) I may want to return to the menu. Toward this end I have a button on an input form to "Return to Menu". When I execute the code behind this button it opens the menu workbook again and then closes the workbook containing the data. The menu form appears, but the form from the data workbook does not disappear. The workboiok is closed so I suspect it is a problem with redrawing the screen. The only command I find in VBA which appears to address this issue applies to the Form object and does nothing to resolve this issue. Any ideas? Is the an API call that will do it and if so what would the code look like? Any help would be greatly appreciated! Kevin -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Moving a sheet from one Excel file to another? | Excel Discussion (Misc queries) | |||
Problem with hyperlinks when moving destination file in excel | Excel Discussion (Misc queries) | |||
Moving data from one excel file to another | New Users to Excel | |||
How can I get a moving Clip art o move in my Excel file??? | Excel Discussion (Misc queries) | |||
moving file from excel to word | Excel Discussion (Misc queries) |