1

Topic: Links on Excel and Word in Office 13

On Win10x64 there are different offices - 7, 10, 13 32 bit.
For switching of links it is used
strFileExcel = "C:\Program Files (x86) \Microsoft Office\Office15\EXCEL.EXE"
Set refExcel = References. AddFromFile (strFileExcel)
On a new computer in configuration W10x64 Of13x32  switching ceased to work.
We check links
Excel Path: C:\Program Files\Microsoft Office 15\Root\Office15\EXCEL.EXE
Word Path: C:\Program Files\Microsoft Office 15\Root\Office15\MSWORD.OLB
Question: why on 13 in one case of the link "standard", in other - through Root&

2

Re: Links on Excel and Word in Office 13

vgrafin not to depend on layout of files instead of AddFromFile it is possible to use AddFromGUID.
And is better to pass to late binding, and to forget about this problem.

3

Re: Links on Excel and Word in Office 13

C late binding - to rewrite it is lazy, when all works for a long time.
With GUID - both identical, it is possible also them.
It is possible to go round, is amazing, why in the same version different ways, and only for files Word and Excel.
The question can at all to a forum, and to BG. But who can faced it? Any  should be. I in searchers  - something somehow anything. Who can the link?

4

Re: Links on Excel and Word in Office 13

vgrafin;
Early binding
=========================================
Dim exApp As Excel. Application
Dim exBooks As Excel. Workbooks
Dim exBook As Excel. Workbook
Set exApp = New Excel. Application
exApp. Visible = True
Set exBooks = exApp. Workbooks
Set exBook = exBooks. Add ()
Late binding
=========================================
Dim exApp As Object
Dim exBooks As Object
Dim exBook As Object
Set exApp = CreateObject ("Excel. Application")
exApp. Visible = True
Set exBooks = exApp. Workbooks
Set exBook = exBooks. Add ()

5

Re: Links on Excel and Word in Office 13

vgrafin wrote:

why in the same version different ways, and only for files Word and Excel.

I think, it is necessary what to ask the one who put office or delivered (rearranged) separate components.
Generally to be anchored to standard ways it is incorrect. In one network I saw that on a C: the software, and offices were put only system and other user a software was put on D:. It is natural that program files was 2 (on a C and on D).
It is possible to tighten a way from the register.

6

Re: Links on Excel and Word in Office 13

To alter under late binding it is very easy, much easier, than to struggle with hemorrhoids at switching of libraries. Time and again altered huge programs, it is possible to manage generally autochangeover

7

Re: Links on Excel and Word in Office 13

Thanks. Intimidated. Convinced. Really, in such situation the binding to a way became .
About the identical version - it is not absolutely exact.
One 15.0.4569.1506
Another 15.0.5007.1000
I put not, but hardly I imagine, to whom and what for could it is required to overtake a part of files in the office with unpredictable consequences.