Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. smartbutdull

    Can you use vba to automate essbase retrieval?

    I want to write some vba scripts to run before I come into the office to open and update some spreadsheets which pull data from Essbase. Does anyone know if it's possible to connect to the essbase source using vba without popping up a log-in screen? I've found the following code to connect and...
  2. smartbutdull

    Schedule macro to run without setting macro security to low

    I have an excel report that uses a VBA macro to query an oracle database. I've created a second spreadsheet with an auto_open macro that opens the main report, runs the update macro, then saves and closes the report then closes itself. I've scheduled this second spreadsheet to run at 7:30am...
  3. smartbutdull

    How can I force an error?

    I know that there's a way to force a formula to return an error such as #N/A if it matches certain criteria. I want to do this so that I can plot graphs that miss a point out rather than shooting down to the x axis where there is no data. Does anyone know how to force an error or any other...

Part and Inventory Search

Back
Top