Recent content by Burser

If that's all you want, why can't you go 'ForEach'ing through the Workbooks collection in Excel and getting workbook.Path?

That's nice :) I love simple solutions - that's probably not how I'd have done that. Have a star.

You've made life very difficult for us there, buddy. That paste isn't delimited in any way we can quickly format into Excel (commas, for example). And please stick code in tags. Keeps things fixed width and easyer to read. Can you go back and give is the data in CSV format? Though all I...

:) I've got to say - I'm not sure there is a solution. I think it's just a fundamental part of the Office 2007 Ribbon. The weird thing is, I can't find any other references to this behavior.

Step up your game, Mr Vaught. The code appears to be perfectTM. All my events are firing in order, when they are supposed to. The problem seems to occur in the line: Call RibbonReference.InvalidateControl("bLogInOut") As far as I can make out, this is the correct usage of the command...

Have a look at AdvancedFilter for filter/copy in one go. It has it's quriks too, but you'll get round them one way or another. It sounds like exactly what you want to do.

Are you looking for one macro that will allow you to print /any/ page with a calling button on it? So you've got six sheets, six buttons and each button should print the correct sheet?

This code comes with the caveat that I haven't tested it, haven't spell checked it, and wrote it in notepad. It may require debugging before it'll work. This is how I do Find loops. Public Sub Test() Dim sMyString As String: sMyString = InputBox("Enter the number you wish to find") Dim...

If your criteria are being driven by formula, then Advanced Filter won't count that criteria as a null criteria. I've had a play and I don't seem to be able to solve it - but then, I've not tried very hard.

SkipVought - TekTips legend ;) No one ever does read the post when there's acres of code around. I'm a sucker for posting way too much. Any hue, I don't understand the question. The procedures there all action the controls on the ribbon. The on-action callbacks are all managed through a...

Good afternoon everyone, If you can answer this question I promise to answer threads on this forum till I've solved ten peoples problems. Even if it takes me a decade. So - I have created a CustomUI.xml file which is working just great (I've stuck it at the end of the post, incase you want to...

Well - it's the standard ADO remote procedure call for calling stored procedures from the ADODB library in VBA (Command type adStoredProcedure). You'd think someone else would have come across this problem, wouldn't you. The reason I came here is because I'm seeing Oracle error messages -...

I should applogise here - I know my code compiles, and I know it runs successfully because I've executed it from OSD and it ran just fine. It even gave me the correct answer, which was nice :) The issues here only appear when I try to make the call via ADO. I'm thinking there is a problem...

Hello, Here is a selection of error messages thrown from the call to a stored procedure - I ran each one immediately after the last: [Oracle][ODBC][Ora]ORA-06550: line 1, column 197: PLS-00103: Encountered the symbol "Ì3" The symbol "Ì3" was ignored. [Oracle][ODBC][Ora]ORA-06550: line 1...

Both the command and connection timeouts are set to 60000 whilst I'm debugging - I'll put some more sensible timeouts in later. I've fallen for that one in the past :) The query is falling over nearly instantly (slight delay - presumably gathering crash information). -- Josh (also in Wales)