Search results for query: *

I've worked it out - if anyone else uses Hyperion Essbase and is interested the following code seems to do the trick: Declare Function EssMenuVRetrieve Lib "ESSEXCLN.XLL" () As Long Declare Function EssVConnect Lib "ESSEXCLN.XLL" (ByVal sheetName As Variant, ByVal username...

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...

Don't know about an array VLOOKUP, but try this: Suppose you have up to three old departments in one new department (this will work for any number though). Enter the new departments in column A. In column B start at 1 against the first new department and 2 against the second etc Enter all of...

Thanks both of you - still struggling though. Skip Opening the main report is fine (I'm already using Application.DisplayAlerts = False). It's opening the workbook with the auto_open macro in the first place that gives me a problem. Jean-Paul Thanks for the tip, but I'm using NT4 so that's not...

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...

Couldn't be simpler could it? Thanks Geoff for your very prompt response. Rgds, Phil

By the way - I'm talking about Excel here - forgot to mention that

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...