- Joined
- Jan 21, 2016
- Messages
- 4
- Reaction score
- 0
Hello,
I would like to ask you for a help. I have a special program for Word 2013 / Excel 2013 via DDE for merging to Contracts.
During merging files Word to Excel, Excel file closes. I use Word via DDE to Excel for first and second sheet which is moved to position one via Excel VBA as follow...
A) Word File: Contract_S > Excel File: SEZNAM, sheet Contract_S
B) Word File: Contract_P > Excel File: SEZNAM, sheet Contract_P
Before merging is sheet Contrac_S or P moved to position one....
Note: Word file is opened via Excel VBA
The problem is that Excel file is closed during merging to Word and Word use always sheet on first position which is not saved. I used "save" method after moving sheet and now is working. My question is: Is there any possibilities to disable closing Excel file during merging? It was ok in previous version like MS Office 2000, 2003, 2007 and 2010... now not :-(
Thanks for your help in advance.
Jerry
I would like to ask you for a help. I have a special program for Word 2013 / Excel 2013 via DDE for merging to Contracts.
During merging files Word to Excel, Excel file closes. I use Word via DDE to Excel for first and second sheet which is moved to position one via Excel VBA as follow...
A) Word File: Contract_S > Excel File: SEZNAM, sheet Contract_S
B) Word File: Contract_P > Excel File: SEZNAM, sheet Contract_P
Before merging is sheet Contrac_S or P moved to position one....
Note: Word file is opened via Excel VBA
The problem is that Excel file is closed during merging to Word and Word use always sheet on first position which is not saved. I used "save" method after moving sheet and now is working. My question is: Is there any possibilities to disable closing Excel file during merging? It was ok in previous version like MS Office 2000, 2003, 2007 and 2010... now not :-(
Thanks for your help in advance.
Jerry