vb.net - Changing the location of an existing VBA Reference from C:\Windows\system32\ to a shared drive -


i've been trying while reference file loaded externally no avail.

to specific trying load "microsoft date , time picker control 6.0(sp4)" resides in c:\windows\system32\mscomct2.ocx

however people run macro containing element don't have "mscomct2.ocx" file on pcs thought move mscomct2.ocx shared location , reference code use shared 1 instead (so have access it)

i tried doing when trying load reference "browse" different location didn't load - because had in c:..

so thought ok... remove file c:\ can reference shared file. - deleted it. open workbook again , @ references - cant find "microsotft windows common controls-2.6.0(sp4)" - great! , proceed add manually browse shared drive. when 2 references of "microsotft windows common controls-2.6.0(sp4)" being added - 1 c:\(which not there) , 1 shared drive.

reference automatically added c:\

activex control rereferences always guid-based. vb ide shows current location of file listed in registry on computer, courtesy, doesn't matter says. control loaded wherever registered on user's computer.

that's key: control must registered on user's computer.

i must discourage doing you're trying do. might able concoct method load dll network location, presents no advantage on doing right thing(tm), , plenty of problems. right thing if need control, must distribute , register application, else does. , should install in recommended location (system32); not on network.

here's quick example of can go wrong: provide user app, , works control on network want it. user installs application happens need same control. app's installer sees control registered on user's computer, doesn't try add again. except particular app intended used when user not connected network. broke else's program.

the vb/vba architecture never intended support xcopy deployment. i'm know it's pain , these steps extremely inconvenient when you're trying deploy "macro". sadly, it's nature of beast. i'm sorry


Comments

Post a Comment

Popular posts from this blog

monitor web browser programmatically in Android? -

i've got tricky question here. need users make payment bank (namely barclaycard) in uk. so, have https url , add parameters (such amount pay, order reference, etc) url, start http connection intent.actionview, redirect user browser can enter credit card details on bank's webpage , make payment our account successfully. far ? the code use below (i changed values privacy reasons) problem is, need app when user has completed/failed/cancelled payment. barclaycardautomatically redirects particular url when payment has succeeded, 1 if failed. there no way of knowing when barclaycard payment has succeeded go android app somehow ? button cardbutton = (button) findviewbyid(r.id.card_button); cardbutton.setonclicklistener(new view.onclicklistener() { @override public void onclick(view arg0) { string prehashstring = new string(); string prohashstring = new string(); string shapassphrase = new string(); shapassphrase = "gsvth£h70zkh...
Read more

Shrink a YouTube video to responsive width -

i have youtube video embedded on our website , when shrink screen tablet or phone sizes stops shrinking @ around 560px in width. standard youtube videos or there can add code make go smaller? you can make youtube videos responsive css. wrap iframe in div class of "videowrapper" , apply following styles: .videowrapper { float: none; clear: both; width: 100%; position: relative; padding-bottom: 56.25%; padding-top: 25px; height: 0; } .videowrapper iframe { position: absolute; top: 0; left: 0; width: 100%; height: 100%; } the .videowrapper div should inside responsive element. padding on .videowrapper necessary keep video collapsing. may have tweak numbers depending upon layout.
Read more

wpf - PdfWriter.GetInstance throws System.NullReferenceException -

i'm trying create pdf document using itextsharp 5.3.4 using following document document = new document(); filestream stm = new filestream(filename, filemode.create); pdfwriter writer = pdfwriter.getinstance(document, stm); i'm getting system.nullreferenceexception following stack trace: system.nullreferenceexception occurred hresult=-2147467261 message=la référence d'objet n'est pas définie à une instance d'un objet. source=itextsharp stacktrace: à itextsharp.text.version.getinstance() innerexception: i've verified neither document nor stm null, , if select "continue" in vs12 document created - exception thrown. updated itextsharp 5.4.0 , it's still occurring. can't find information on anywhere - got ideas? make sure not catching exceptions. nullreferenceexception can 1 caught , handled inside itextsharp, don't care it. fact can continue supports theory. change following setting verify: debug -> exceptions ...
Read more