I am trying to register a type library programatically from VBA code, using two variants of a technique found using Google (Subs RegisterTypeLibrary and RegisterTypeLibrary2 below).
does anybody hav开发者_高级运维e any idea what\'s does this mean: onLoad=\"MyOnLoad\"? thanks OnLoad is an event that occurs when a control has been created. The MyOnLoad method will be called when t
In Excel VBA (or if you could in C#, I\'m using the Excels Object Library from .NET), how to copy a worksheet from one workbook to another sheet in another workbook. Basically, what I\'m doing is copy
Given the Image... If I know that there is some data starting at Range(\"B3\"). How can I find the cells with contiguous data that is till cell E3? Since F3 is blank G3 onwards should not be consid
I know how to loop through all the worksheets in a workbook, and how to exit once I reach an \'end-flag\' worksheet:
I\'ve g开发者_StackOverflow社区ot a macro to copy a summary row from each of a series of worksheets. The summary row is specially formatted with font/font color/bg color, but when pasted into the \'su
being in need to 开发者_Go百科export a DOC file to TXT and then reimport it without losing bold and underline formatting I\'d need a macro to do that.
Is there a way to watch a file in VBA (which is essentially VB6), so that I know when the file has been mo开发者_开发技巧dified? -- similar to this only I don\'t want to know when a file is unused, ju
I have a bunch of sheets with detailed data sets and pivot tables. On a summary sheet, I want to display just the pivot tables. (Of course, I\'d rather stay DRY and not create a who开发者_运维知识库le
I have data of this form: CategorySourceAmount DuesFTW$100 DonationsODP$20 DonationsIOI$33 DuesMMK$124 There is no sort order. The categories are unknown at compile time. I want a VBA macro to cycl
加载中,请稍侯......