Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
open word from excel & then back again
i need to open word from excel and then close word & open excel again. i have
a form that opens in excel without showing excel, only the form is visibe on start up with command buttons to open different documents. i can open word but it does not make it the active item. It sits at the bottom of the screen, not visible for use. Second question; when i open another excel workbook and then try to close and return to the original form the original form will not display, can anyone help me? code i am using below for first problem and also second problem. Private Sub CommandButton1_Click() Unload Me Dim Word As New Word.Application Dim WordDoc As New Word.Document Set WordDoc = Word.Documents.Open("D:\NSS BULK\KUSTOM CONCRETE\Kustom Working Documents\Safety\document register") Word.Visible = True End Sub Private Sub CommandButton2_Click() 'saves and closes this workbook while opening the Switchboard workbook Workbooks("Permit Register.XLS").Close SaveChanges:=True Workbooks.Open ("D:\NSS BULK\KUSTOM CONCRETE\Kustom Working Documents\SWITCHBOARD") End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
open word from excel & then back again
I would advise not to use object words as names of variables for a start.
e.g. Use Dim WordApp As New Word.Application If you do not close Excel, you do not need to open it again. Maybe use Me.Hide instead of Unload Me I think the problem is that you are closing the WB containing the running code. Use a single WB (or add-in) to contain all the code that manipulates the other Word docs and Excel WBs. NickHK "new_to_vba" wrote in message ... i need to open word from excel and then close word & open excel again. i have a form that opens in excel without showing excel, only the form is visibe on start up with command buttons to open different documents. i can open word but it does not make it the active item. It sits at the bottom of the screen, not visible for use. Second question; when i open another excel workbook and then try to close and return to the original form the original form will not display, can anyone help me? code i am using below for first problem and also second problem. Private Sub CommandButton1_Click() Unload Me Dim Word As New Word.Application Dim WordDoc As New Word.Document Set WordDoc = Word.Documents.Open("D:\NSS BULK\KUSTOM CONCRETE\Kustom Working Documents\Safety\document register") Word.Visible = True End Sub Private Sub CommandButton2_Click() 'saves and closes this workbook while opening the Switchboard workbook Workbooks("Permit Register.XLS").Close SaveChanges:=True Workbooks.Open ("D:\NSS BULK\KUSTOM CONCRETE\Kustom Working Documents\SWITCHBOARD") End Sub |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
open word from excel & then back again
hit wrong button and posted as a question. Thanks NickHK, i will try that .
"NickHK" wrote: I would advise not to use object words as names of variables for a start. e.g. Use Dim WordApp As New Word.Application If you do not close Excel, you do not need to open it again. Maybe use Me.Hide instead of Unload Me I think the problem is that you are closing the WB containing the running code. Use a single WB (or add-in) to contain all the code that manipulates the other Word docs and Excel WBs. NickHK "new_to_vba" wrote in message ... i need to open word from excel and then close word & open excel again. i have a form that opens in excel without showing excel, only the form is visibe on start up with command buttons to open different documents. i can open word but it does not make it the active item. It sits at the bottom of the screen, not visible for use. Second question; when i open another excel workbook and then try to close and return to the original form the original form will not display, can anyone help me? code i am using below for first problem and also second problem. Private Sub CommandButton1_Click() Unload Me Dim Word As New Word.Application Dim WordDoc As New Word.Document Set WordDoc = Word.Documents.Open("D:\NSS BULK\KUSTOM CONCRETE\Kustom Working Documents\Safety\document register") Word.Visible = True End Sub Private Sub CommandButton2_Click() 'saves and closes this workbook while opening the Switchboard workbook Workbooks("Permit Register.XLS").Close SaveChanges:=True Workbooks.Open ("D:\NSS BULK\KUSTOM CONCRETE\Kustom Working Documents\SWITCHBOARD") End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007-send Word Art text to back | Excel Discussion (Misc queries) | |||
Long text, Excel to Word, then back again | Excel Discussion (Misc queries) | |||
Excel document was saved to word in error how do I get it back | Excel Discussion (Misc queries) | |||
Excel to Word and back again | Excel Programming | |||
Embedded word doc changed to image-need to change back to word. | Excel Discussion (Misc queries) |