get excel 2010 to use word 10.0 object library

[cromby]

G'day all,

I found a similar thread named "Re: help with object library", but I didn't know if I could reply there. Effectively the thread ended just before the information that I needed was imparted. Essentially the last two comments were

- "If you go down the reference list the missing files will have:

MISSING:reference name"


- "If it's marked as MISSING it isn't available, so it won't be possible to add it (except by installing it from the application disk). "

I have written some vba in excel for a mate and it works seamlessly on my version of excel, but he has since upgraded to the latest 2010 office, which lacks a reference the "microsoft word 10.0 object library", (it uses 14.0).

I am trying to find out how to install it into the "reference list" so that he can select it, and I won't have to change the software to match the 'upgrade'.


Thanks.

 

[Glory]

Is it a .dll file? Can you just copy and paste it somewhere?

 

[xenou]

Try referencing the Microsoft Word 14.0 Library and cross your fingers. You can search for posts on late binding to avoid these crashes when users change to a new version - most VBA code is backward compatible for at least a few generations. It's best to develop your code with early binding during development, but convert to late binding if you are installing the finished code for other users who may be upgrading later on.

 

[cromby]

Thanks for the replies. I don't think? its a dll. I did select the reference to word 14 but that did not work.

I had read that changing to late binding would be likely to require rewrites, something I am trying to avoid.

I am just at loss as too why excel would stop interacting with the previous versions vba? I 'was' hoping that there would be someway of downloading the specific object library and then calling it through GUID?

Does this mean that the "reference list" is set and limited to whatever is there upon installation of exel? What about the browse function on the "reference list" box, is there no way to know what the GUID is and find it and select it?

Ever hopeful, thanks for your help.

 

[xenou]

What is listed as missing? I assumed it was the Word 10.0 Object library.

 

[cromby]

Run-time error '445':
Object does not support this action.

Then I hit the debug button and it highlights

With Application.FileSearch


The program runs fine with my computer. I have previously written a different program that works on both his and my machine but, it does not utilise word, so it seems likely that has some relevance?

It just seems that if there is a "reference list" with heaps of boxes to tick, and this area being the specific domain of programmers, that you could add another box option if you wanted?

 

[xenou]

FileSearch was apparently removed from Office 2007 VBA. I'd thought it was "coming back" but maybe it's also not in Office 2010 either.

I guess you must assume you don't have this anymore (not on the machine in question). I'm not quite up to speed on all of this as I have never used FileSearch - but you'll probably find some information googling Word VBA FileSearch (and throw in some other search terms like missing or removed or doesn't work).

 

[cromby]

Okay mate, no dramas. I have now seen how they have discontinued the use of filesearch, which makes sense as that was part of the 'Word' component of the program.

I have come across a potential solution if you google "HarleyQuinn filesearch posted", its there. Its some kind of work around, attempting to duplicate the filesearch method. I will have to try it out.

My question remains though. Is there NO way to add a reference to the reference list box? Doesn't the 'browse' bit on it mean you could reference something somewhere else, as long as you knew its name and location?

Can't I just call it (like a library?) with vba?

 

[xenou]

My question remains though. Is there NO way to add a reference to the reference list box? Doesn't the 'browse' bit on it mean you could reference something somewhere else, as long as you knew its name and location?

Yes.
But ... I think that FileSearch is part of the Office Library (probably) which you do have referenced. Except this particular part of it no longer exists within that library. That's my guess, anyway.

 

[cromby]

alright, thanks everyone for your advice. I guess I will work around it.