How to convert a Word macro to a VB program: Object Variable problem?? 1

[2781]

Hi there,

I wish to convert a macro which works fine to a stand-alone VB6 program.

The first line in the macro read: Set fs = Application.Search

In the stand-alone programme however, it returns an error: Application not defined as Variable. With some slight syntax variations, it says Object not defined.

I guess the problem is how to reference in visual Basic an object variable that comes from another programme.

Could the solution lie in using:

Private Statement WithEvents, or New - and how do you use this. Or should the solution be sought elsewhere.

Thanks

 

[JohnYingling]

In word, the application object is automatic and already defined. You will need.
Dim objWord As Object
Set objWord = CreateObject("Word.Application"

If you refer to Documents you will now need
objWord.Documents.

If you want to distribute this to people with different versions of Word from yours, you will need to use "late binding" i.e. "As Object" rather than "As Word.Apllication". The same goes for any other Word objects. You can still refer to a Word Object library to pick up constants (Enums).

http://www.VBResizer.com

Generate Forms/Controls Resizing/Tabbing Class

http://www.VBCompare.com

Compare Code (Text)

http://www.VBSortGen.com

Generate Sort Class in VB or VBScript

 

[JohnYingling]

Start here.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnoffdev/html/vsofficedev.asp

http://www.VBResizer.com

Generate Forms/Controls Resizing/Tabbing Class

http://www.VBCompare.com

Compare Code (Text)

http://www.VBSortGen.com

Generate Sort Class in VB or VBScript

 

[2781]

Many, many thanks.

as an amateur user, it is only since a few weeks that I am on this forum, and I find it really amazingly useful. It is amazing what people can do for each. For example, since a long time I was looking for a reference like one you just gave>

One more small question:

You taught how to create an object for one Word file. Which object does one need to create to search all Word type (*.doc) files in a particular directory.

Thanks