I have a missing reference listed in my References list (in the VBA Code view). It\'s a reference to 开发者_StackOverflow中文版an OCX for a product that we no longer use.
Is there a way in an Excel VBA macro to get the current datetime in UTC format? I can call Now() to get the current time in the local timezone; is there a generic way to then convert开发者_运维问答
Using VBA in MS Project 2003 I create an Excel sh开发者_如何转开发eet and write data to it. After that I want to change SetPrintArea and Orientation of the sheet I created so I wrote
I am new to excel add-in prgramming and I am having a existing excel add-in project need to modify. The plug-in has 2 parts, one is programmed in VB and compiled into a ActiveX DLL file, the other pa
I am new to Active Directory. I have a VBA Excel Add-In that should run if, and only if, the computer that it is running on is currently logged into the Active Directory, whether locally or through a
I have a document with sections that are protected and unprot开发者_运维问答ected. With Word 2003 the sections that were unprotected had formatting enabled - specifically the bullets and numbering. No
I am a pilot who flies multiple legs in a day.The software I use to log flights spits out a csv file and lists every leg separately.I import the csv file into table 1 in ms access.I would like to merg
I would like to hide the current page that the user is looking at when they click a hyperlink within excel that takes them to a different worksheet within the same workbook. 开发者_如何学运维 I tried
I have an excel worksheet with 2 comboboxes, and 3 scrollbars. I want to protect all the sheet except this form objects (and one cell). When i try to protect the sheet开发者_StackOverflow中文版, i can
I have Template made in Word 2003 which is sometimes updated (add开发者_如何转开发ing text, bookmarks, formfields ...) and its located on intranet and has the same name all the time (for example \"Mas
加载中,请稍侯......