ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Updating or Changing VBA Reference (https://www.excelbanter.com/excel-programming/430858-updating-changing-vba-reference.html)

JeffTO

Updating or Changing VBA Reference
 
Hi All

I am having a problem that I think is around references in my VBA
project environment

I have my Adobe Distiller reference linked to:
C:\Program Files\Adobe\Acrobat 6.0 SDK\InterAppCommunicationSupport
\Headers\acrodistx.tlb
(trying to use this one hangs on me and does not work - I am not even
sure how this got referrenced)

When I think the reference should be linked to:
C:\Program Files\Adobe\Acrobat 6.0\Distillr\acrodist.exe

I can browse for what I think is the correct reference but it does not
attach the reference to my vba project.

Is there any way to:

A: Remove the first reference to the Adobe Distiller (the one to the
SDK file)
B. Add the correct reference (to the acrodist.exe file)
C. Or Change the reference to the correct one

If you need additional information please let me know

Thanks in advance for your assistance with this

Jeff

JLGWhiz[_2_]

Updating or Changing VBA Reference
 
Have you looked at Chip's site?

http://www.cpearson.com/excel/vbe.aspx



"JeffTO" wrote in message
...
Hi All

I am having a problem that I think is around references in my VBA
project environment

I have my Adobe Distiller reference linked to:
C:\Program Files\Adobe\Acrobat 6.0 SDK\InterAppCommunicationSupport
\Headers\acrodistx.tlb
(trying to use this one hangs on me and does not work - I am not even
sure how this got referrenced)

When I think the reference should be linked to:
C:\Program Files\Adobe\Acrobat 6.0\Distillr\acrodist.exe

I can browse for what I think is the correct reference but it does not
attach the reference to my vba project.

Is there any way to:

A: Remove the first reference to the Adobe Distiller (the one to the
SDK file)
B. Add the correct reference (to the acrodist.exe file)
C. Or Change the reference to the correct one

If you need additional information please let me know

Thanks in advance for your assistance with this

Jeff





All times are GMT +1. The time now is 01:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com