Accessing a proprietary toolbar in Excel 1

[jazminecat23]

Hi all - I've been working on a module in excel to run some procedures using an add-in we purchased for Excel called Spreadsheet Server. This program adds a toolbar to Excel. I need to figure out how to 'push' a button on that toolbar using VBA. Recording a macro of it doesn't work - I get an empty module. Same goes for recording a macro accessing the Spreadsheet Server Menu item on my main Excel menu.

Does anyone have any ideas? The menu item is two to the right of the Help menu item - after the Adobe PDF menu item.

crossing fingers!

 

[SkipVought]

Hi,

In Tools/References can you find a reference to Spreadsheet Server ANYTHING?

Skip,

_[red][/red]

 

[jazminecat23]

I actually contacted the manufacturer, and he said I can run that using this:

Application.Run ("ExpandDetailReports")

I haven't tested it yet. I'm stuck on the fact that Calculate is only calculating my one main sheet, and not all the sheets in the workbook.

For the record, it is listed as "SServer - for JDE". It was not checked. Is there something I need to do (check it for example) to make it available in VBA?

thank you so much. I could never do this without your guidance.

 

[SkipVought]

Yes, check it in the References. The open the Object Browser and browse ONLY that reference's objects to determine if they might include the toolbar objects or anything else that might be useful.

Skip,

_[red][/red]

 

[jazminecat23]

Cool. ExpandDetailReports is in there. So this is where I can go to access the other actions that this addin program can do. Thanks!