Search results for query: *

I want to create an Excel Add-In that references the Access and ADO libraries. I'd like to avoid having the user manually add these references. From the Help documentation it looks like I can use the References collection to add references by GUID. I tried to play around with this by looping...

I have a macro that opens and closes a number of workbook files. The problem is that the files remain in my Project Explorer window even after closing Excel and rebooting. I've done similar things before and never had this happen. Here's the code I use to open the files: Set RegionBook =...

How do I get the row number of the last row in a range returned by the UsedRange property of a Worksheet? In other words, what is the last row used in the sheet? I have been using ActiveSheet.UsedRange.Rows.Count but just realized that this doesn't work if the worksheet does not use rows at the...

I am using CommandBarPopup & CommandBarControl to create custom menus. How do I create a separator bar to group menu items? I tried the VB technique of "-" as caption but that doesn't work.

I am trying to create an add-in with custom menus associated with macros I want to distribute. I tried to follow the instructions in the MS OFfice XP Developer's Guide. I did the following: - Created a new workbook - Created macros in a module in the workbook - Created a custom top level menu...

I have created a number of Excel macros written in Office XP and I need to distribute them to users of Office 97. The questions I have include: - Does Excel 97 also have Add-Ins in the same manner as Excel XP? Can I create custom Add-Ins and distribute them to other users? - If so, where should...

How do I retrieve the current page number in a document in Word? I've looked through the object model and see no objects, properties or methods that do this. Evidently, Word does not process pages as objects.