Problem updating references

Hi VanS,

> I am trying to make it compatible with earlier versions of Office-Office 97
> on a Win 98 platform at present-and after researching have decided to try
> late binding.

To use late binding, you do the following:

1. Remove any references to the object models, in Project > References
2. Declare all object variables that refer to the object models As Object
3. Replace any constants defined in those object models with their numeric
equivalents.
4. Use CreateObject("Appname") instead of 'New Appname' to create new
instances of the objects.

If you do that, you shouldn't have any references problems, as you won't have
any references!

Regards

Stephen Bullen
Microsoft MVP - Excel
www.oaltd.co.uk

Thanks for your helpful response, Stephen. God bless
Van

"Stephen Bullen" wrote:

> Hi VanS,
>
> > I am trying to make it compatible with earlier versions of Office-Office 97
> > on a Win 98 platform at present-and after researching have decided to try
> > late binding.
>
> To use late binding, you do the following:
>
> 1. Remove any references to the object models, in Project > References
> 2. Declare all object variables that refer to the object models As Object
> 3. Replace any constants defined in those object models with their numeric
> equivalents.
> 4. Use CreateObject("Appname") instead of 'New Appname' to create new
> instances of the objects.
>
> If you do that, you shouldn't have any references problems, as you won't have
> any references!
>
> Regards
>
> Stephen Bullen
> Microsoft MVP - Excel
> www.oaltd.co.uk
>
>
>

Stephen,
I tried to remove the Office references as you suggested which I was able to
do for those from Office specifically, except for the Excel 11.0 Library-it
gave an error message that the file was in use. My application runs in Excel.
So do you have any suggestions on how I can get around this to remove this
reference?
Thanks
Van

"VanS" wrote:

> Thanks for your helpful response, Stephen. God bless
> Van
>
> "Stephen Bullen" wrote:
>
> > Hi VanS,
> >
> > > I am trying to make it compatible with earlier versions of Office-Office 97
> > > on a Win 98 platform at present-and after researching have decided to try
> > > late binding.
> >
> > To use late binding, you do the following:
> >
> > 1. Remove any references to the object models, in Project > References
> > 2. Declare all object variables that refer to the object models As Object
> > 3. Replace any constants defined in those object models with their numeric
> > equivalents.
> > 4. Use CreateObject("Appname") instead of 'New Appname' to create new
> > instances of the objects.
> >
> > If you do that, you shouldn't have any references problems, as you won't have
> > any references!
> >
> > Regards
> >
> > Stephen Bullen
> > Microsoft MVP - Excel
> > www.oaltd.co.uk
> >
> >
> >

Hi VanS,

> I tried to remove the Office references as you suggested which I was able to
> do for those from Office specifically, except for the Excel 11.0 Library-it
> gave an error message that the file was in use. My application runs in Excel.
> So do you have any suggestions on how I can get around this to remove this
> reference?

Is this a VB project, or some VBA code in an Excel workbook. If the latter,
Excel will update its own references correctly. If the former, I've no idea why
you shouldn't be able to remove the reference, but you could try closing VB and
editing the .vbp file in Notepad to remove the Excel reference.

Regards

Stephen Bullen
Microsoft MVP - Excel
www.oaltd.co.uk

Stephen,
Thanks again for your reply. Yes, it is an Excel VBA project. One other
respondent suggested that I would only need to remove the Word references
which were the problem and shouldn't try to remove the Excel references. Do
you concur?
Thanks, God bless
Van

"Stephen Bullen" wrote:

> Hi VanS,
>
> > I tried to remove the Office references as you suggested which I was able to
> > do for those from Office specifically, except for the Excel 11.0 Library-it
> > gave an error message that the file was in use. My application runs in Excel.
> > So do you have any suggestions on how I can get around this to remove this
> > reference?
>
> Is this a VB project, or some VBA code in an Excel workbook. If the latter,
> Excel will update its own references correctly. If the former, I've no idea why
> you shouldn't be able to remove the reference, but you could try closing VB and
> editing the .vbp file in Notepad to remove the Excel reference.
>
> Regards
>
> Stephen Bullen
> Microsoft MVP - Excel
> www.oaltd.co.uk
>
>
>

Hi VanS,

> Yes, it is an Excel VBA project. One other
> respondent suggested that I would only need to remove the Word references
> which were the problem and shouldn't try to remove the Excel references. Do
> you concur?

Yes. From your original post - "I have a VB6/MS Office Excel/Word VBA app" - I
thought this was a VB6 app.

Regards

Stephen Bullen
Microsoft MVP - Excel
www.oaltd.co.uk