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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by sandoztek

  1. sandoztek

    wrong mouse scroll in split window

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

    wrong mouse scroll in split window

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

    wrong mouse scroll in split window

    Office 97
  4. sandoztek

    wrong mouse scroll in split window

    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?
  5. sandoztek

    Date Format difficulty

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

    Date Format difficulty

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

    Date Format difficulty

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

    cell text displayed in a single line

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

    cell text displayed in a single line

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

    convert a string Date into a formated one

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

    convert a string Date into a formated one

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

    convert a string Date into a formated one

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

    Adding a webquery table

    Capito, the problem was the (ambiguous)Destination.
  14. sandoztek

    Adding a webquery table

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

    Adding a webquery table

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

Part and Inventory Search

Back
Top