Databases
StackOverflow2013
Postsdbo
POChanging the location of an existing VBA Reference from C:\Windows\system32\ to a shared drive
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POChanging the location of an existing VBA Reference from C:\Windows\system32\ to a shared drive
    primarykey
    data
    text
    <p>I've been trying for a while now to get a reference file to be loaded externally to no avail.</p> <p>To be specific I am trying to load a "Microsoft Date and Time Picker Control 6.0(SP4)" which usually resides in C:\Windows\System32\MSCOMCT2.OCX</p> <p>However some people that run a macro containing this element don't have that "MSCOMCT2.OCX" file on their PCs so I thought I will move the MSCOMCT2.OCX to a shared location and reference the code to use the shared one instead (so everyone will have access to it)</p> <p>I tried doing that but when I was trying to load a reference with "Browse" from a different location it didn't load it - because I already had that in C:..</p> <p>So I thought OK... I will remove the file from C:\ so I can only reference the shared file. - so I deleted it. So I open the workbook again and look at references - I cant find "Microsotft Windows Common Controls-2.6.0(SP4)" - great! And I proceed to add it manually with Browse from the shared drive. When I do that however 2 references of "Microsotft Windows Common Controls-2.6.0(SP4)" are being added - 1 from C:\(which is not there) and 1 from the shared drive.</p> <p><img src="https://i.stack.imgur.com/u9GMa.jpg" alt="Reference automatically added from C:\"></p> <p><img src="https://i.stack.imgur.com/tY7fq.jpg" alt="Reference also added from Shared drive"></p> <p>The one from C:\ is always automatically selected. If I try to disable the one from C:\ and enable the one from the shared drive it automatically changes back to what it was when i press OK. If I try to enable both - it says duplicate References and keeps only the one from C:\</p> <p>So.. does anybody know how can I get rid of that C:\ reference from the list so it doesn't get loaded? Apparently deleting the files themselves did not work. Ultimately my goal is to enable people without C:\Windows\System32\MSCOMCT2.OCX file to be able to use my Date Picker Tool.</p> <p>Thanks a lot!</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USPotter Rafed
    plurals
    1. This table or related slice is empty.
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POChanging the location of an existing VBA Reference from C:\Windows\system32\ to a shared drive
      1. This table or related slice is empty.
      1. VTDownMod
    2. VO
      singulars
      1. POChanging the location of an existing VBA Reference from C:\Windows\system32\ to a shared drive
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POChanging the location of an existing VBA Reference from C:\Windows\system32\ to a shared drive
      1. This table or related slice is empty.
      1. VTUpMod
    1. COThey don't have the control because it is a licensed VB6 control library. You cannot legally share it for other people to use at design time - and generic Office editions only support design time operation. Office (and Excel) do not have a license to use this library except in the case of Developer Editions of Office (or the VSTO/VSTA add-on products).
      singulars
      1. POChanging the location of an existing VBA Reference from C:\Windows\system32\ to a shared drive
      1. USBob77
    2. COthanks for the additional info
      singulars
      1. POChanging the location of an existing VBA Reference from C:\Windows\system32\ to a shared drive
      1. USPotter Rafed
    3. COWell in case it isn't clear, what you are attempting is piracy. To make it legal you'd need to license one of the Office Developer packages. Which one you need depends on your Office version.
      singulars
      1. POChanging the location of an existing VBA Reference from C:\Windows\system32\ to a shared drive
      1. USBob77
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload