VBA - Spreadsheet Server - Drilldown Prompt RRS feed

  • Question

  • I'm using Spreadsheet Server in Excel and trying to create a macro for the Drilldown function. Excel pops out a prompt screen to select which ad hoc query to be used. I'm having difficulties writing this into my VBA so the user doesn't have to select the prompt every time. When I try to record the steps, it doesn't recognize them and nothing is recorded. 

    This is where I'm stuck:

    Application.Run "GLJournalsToSheet"

    This will prompt the user to select which ad hoc query to use before a drilldown will occur. Anyone know or have experience with this?

    Thursday, April 9, 2020 11:52 PM

All replies

  • To:  TabT3
    re:  question about SpreadSheet Server

    Your best bet will be to contact vendor support.
    My guess is that interaction with custom VBA code is probably limited.

    An informed user of Spreadsheet Server may stumble across your post at some point.
    But you will probably be retired before that happens.

    The free Excel workbook "Professional_Compare" compares every cell Or
    each row in two worksheets - choice of compare type.
    Includes utilities:  "Clean Data, Quick Uniques".
    Download (no ads) from:  http://www.mediafire.com/folder/lto3hbhyq0hcf/Documents

    Friday, April 10, 2020 6:39 PM