Search results for query: *

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)

Dear TekTips - I would like to be able to edit my posts. If I already can, I am too stupid to work out how - this may explain why I'm banging my head against my PC crying out to any god that will hear me to strike down the person who wrote ADO and all that sail in it. Yours, Josh. Update: I...

Dim iChar as Integer For iChar = 65 To 90 Debug.Print Chr(iChar) Next iChar ASCII and you shall recieve. (Fnah fnah)

Update on the problem: I just enabled tracing on the local ODBC drivers. No ODBC trace is genarated for that /entire/ method. Not for creating the connection - not for opening it - running Refresh on the parameters - nada. My ExecuteScalar, ExecuteNonQuery and ExecuteQuery methods all trace...

Howdy, I tried to fit all the gubbins I'm using in the title. I am trying to execute a stored procedure on an Oracle 10g database. To do this I use the following code: Public Function ExecuteStoredProcedure(sStoredProcedure As String, ByRef vParameters() As Variant) As ADODB.Parameters On...

I've used MAX for quite some time now - we've grown to like each other. I know very little about the technical side of 3DS, so I was wondering if someone could clear something up for me. When I render a scene, does the 3DS MAX renderer use my Graphics hardware to hel pit, or does it do all the...