Search results for query: *

I will have a look at this VBScroll. thank you for helping.

It has always been enabled. I just went once into the Control Panel/Mouse app to set the minimum nb of lines /wheel step.

Office 97

When I split a vba code window, the mouse scroll works only in the lower window. how to mouse scroll in the upper part of the window as well?

my code did contain a comma in the Diff function, I was just absentminded when I put a minus sign in my text

I 'll take your code, which is nicer/neater than mine. This said, it doesn't work either, ..... just because when I re installed Windows etc.., I forgot ....to modify the Regional Settings (environment is in French, but I use Excel & VB, VBA in English UK). It's all right now, both my code &...

I have been using the code below to substract 2 given dates to get days: nbDays = DateDiff("d",date2 - date1) date1 example : "2009-03-06" ( 06 march ) date2 example : "02Feb09" I have date2 = Left(date2, 2) & "-" & Mid(date2, 3, 3) & "-" & Right(date2,2) then date2= Format(date2...

Alt-enter is a manual operation, I want it to be done by program, when the cell is filled with the string. Also, I DON'T WANT the wrap, just a single text line. ................ ok, I found the problem : I did use the right property .WrapText = False but it must be applied to the cell AFTER it...

I want a text string put into a cell to be displayed in a single line, that is extended to the right, without the cell width being modified. Currently, the width remains unchanged but the cell height is increased to contains the whole text. Which format must be applied to this cell to have this...

Yes, my code checks the format is 2 3 2 (ddmmmyy)

Your solution is the one I finally reached too (I used "-" instead of " "). Thank you

I have the string date "23Mar08" . Can it be easily translated into a formated one (for arithmetic operations)

Capito, the problem was the (ambiguous)Destination.

Ok, fine now, I'll try not to forget the advice. It's a subtelty I haven't seen documented yet... Thank you !

In a piece of code using web queries I normally use the F1 sheet But when I started a similar code using another F2 sheet I have an error I do not understand: Please explain why the first set works and the second one doesn't, I get "argument or procedure call incorrect (error 5)" Both sheets...

I am using the code below to retrieve data from a web site: With ActiveSheet.QueryTables.Add(Connection:=destinationURL, Destination:=Range("a1")) .WebTables = "10,11,12,13,14,15,16,17" .BackgroundQuery = True .TablesOnlyFromHTML = True .Refresh BackgroundQuery:=False...

Can a DDE command read the current URL from the Internet Explorer window ? I found that Chan = DDEInitiate("IExplore", "WWW_OpenUrl") can make IE ready to display a specified site with tmp = DDERequest(Chan, "www.specifiedsite"), but are there any other topics WWW_....

navigate thru the QueryTable connection" ? It supposes an (already done)connection, right? but precisely, to have this connection, I need an URL and it is located in the address bar of the IE/Firefox browser window. How to retrieve it first? Otherwise would you mind specifying what you mean...

So, nobody knows how to retrieve from Excel vba the URL of the current Firefox or IE browser address bar ?

My code is not yet written, only a part of it. What I want to do is this : Go to the RacingPost site and retrieve into an Excel sheet for further parsing some specific data(tables) about each race of the day. the code is grossly as follows: For i = 0 To n PremCell = (i * 8) + 1...