Did you digest this part of my previous post -
> > I don't think the location of the dll is not the issue, is it actually
> > registered on the target machine.
What's the answer to this question.
Regards,
Peter T
"vqthomf" <(E-Mail Removed)> wrote in message
news:318AD18D-67A8-44B3-BE72-(E-Mail Removed)...
> I tried the code you gaive me but I still get an error, their location is
in
> Trukish and that why it can't fine the dll's and when there is a problem
or
> they want an upgrade they send it back and we have to manaualy change it.
>
> "Peter T" wrote:
>
> > > I wanted to have the programme know where it is and
> > > change the location.
> >
> > I don't think the location of the dll is not the issue, is it actually
> > registered on the target machine.
> >
> > If it is registered it might be an older version (along the lines I
> > mentioned previously), have you checked. If so removing (as per example
> > posted previously) and re-adding the reference might work.
> >
> > Regards,
> > Peter T
> >
> > "vqthomf" <(E-Mail Removed)> wrote in message
> > news:8BDF541D-1946-4261-B429-(E-Mail Removed)...
> > > we are supporting a sister company in Turkey and the report programmes
> > that
> > > we build and test here work fine but when we send it you them it wont
work
> > > due to references!, I wanted to have the programme know where it is
and
> > > change the location.
> > > TIA
> > > Charles
> > >
> > > "Peter T" wrote:
> > >
> > > > > I think my Idea of a reference is wrong?
> > > >
> > > > Is that a question?
> > > >
> > > > Difficult to understand what you are doing and why you want to
change
> > file
> > > > location of the dll. However if that's what you are doing, and the
dll
> > is an
> > > > ActiveX, you will need to re-register the dll. Having done that,
> > providing
> > > > the dll is the same version or later as that to which a reference
was
> > set in
> > > > your project, you shouldn't need to remove and re-add the reference
to
> > your
> > > > project.
> > > >
> > > > Regards,
> > > > Peter T
> > > >
> > > > "vqthomf" <(E-Mail Removed)> wrote in message
> > > > news:3F61C059-33E6-450B-BAEA-(E-Mail Removed)...
> > > > > I think my Idea of a reference is wrong?
> > > > > I am trying to change the location of this file Y:\Quality\GALC
> > system\HTR
> > > > > support\Turkey\Data Files\msadox.dll to another location can this
be
> > done
> > > > as
> > > > > nothing I have tried works.
> > > > > TIA
> > > > > Charles
> > > > >
> > > > > "Peter T" wrote:
> > > > >
> > > > > > Hi Charles,
> > > > > >
> > > > > > Without seeing your code its not possible to know if it fails
> > because
> > > > the
> > > > > > code is wrong or fails for some other reason, eg the reference
> > doesn't
> > > > > > exist. Try something like this -
> > > > > >
> > > > > > Dim rf As Reference
> > > > > >
> > > > > > 'With ThisWorkbook.VBProject.References
> > > > > > With Application.VBE.ActiveVBProject.References
> > > > > > On Error Resume Next
> > > > > > Set rf = .Item("ref name to be removed")
> > > > > > If Not rf Is Nothing Then
> > > > > > .Remove rf
> > > > > > Else
> > > > > > ' ref doesn't exist
> > > > > > End If
> > > > > > End With
> > > > > >
> > > > > > Regards,
> > > > > > Peter T
> > > > > >
> > > > > > "vqthomf" <(E-Mail Removed)> wrote in message
> > > > > > news:57D9ED2C-D729-40B0-8113-(E-Mail Removed)...
> > > > > > > Hi all I was wondering if Reference location be changed using
vba
> > code
> > > > I
> > > > > > have
> > > > > > > tried using
Application.VBE.ActiveVBProject.References.AddFromFile
> > but
> > > > I
> > > > > > need
> > > > > > > to remove the reference before adding a new one when I try to
> > remove
> > > > the
> > > > > > it I
> > > > > > > get an error has one done this before if so can you please
help?.
> > > > > > > TIA
> > > > > > > Charles
> > > > > >
> > > > > >
> > > > > >
> > > >
> > > >
> > > >
> >
> >
> >
|
Similar Threads
