Search:

Type: Posts; User: Oorang; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.09 seconds.

  1. Thread: xlScript

    by Oorang
    Replies
    5
    Views
    1,635

    Re: xlScript

    I'm not really clear why you would want another scripting language when you have VBA already. :confused:
  2. Replies
    2
    Views
    714

    Re: Can you change the default paste settings?

    Sorry, but that isn't a built in option.
  3. Thread: Congrats Jonmo

    by Oorang
    Replies
    12
    Views
    1,109

    Re: Congrats Jonmo

    Woot:)
  4. Re: ***WINNERS ANNOUNCEMENT*** June/July 2008 Challenge of the Month

    lol Spoken like someone who didn't bother to read all 28 pages of the thread:biggrin: (Can't image why not.) It's been explained... Ad nauseum. :laugh:
  5. Thread: Hello World?

    by Oorang
    Replies
    4
    Views
    495

    Re: Hello World?

    Hahaha saw it coming.
  6. Replies
    3
    Views
    275

    Re: User-defined type not defined

    I doubt that has to do with MSQuery. Could be coming from code in the worksheets or workbooks. Check there. Also if you have any add-ins checks those. If you don't have the passwords and can't view...
  7. Replies
    2
    Views
    251

    Re: Like Operator Help

    If LCase$(rng.Value) Like "*myword*" Then
    'Do Something
    End If

    Although if you are just making a simple check for a Substring inside a string there is a trick you can do with InStr(). InStr...
  8. Thread: Brain Teasers

    by Oorang
    Replies
    300
    Views
    32,352

    Re: Brain Teasers

    CB, Did the Knight Puzzle put you in mind of that?
  9. Thread: Brain Teasers

    by Oorang
    Replies
    300
    Views
    32,352

    Re: Brain Teasers

    Is the grandson the son of the son?
  10. Thread: Brain Teasers

    by Oorang
    Replies
    300
    Views
    32,352

    Re: Brain Teasers

    8 is impossible and I'll prove it.
    To make the conversation easier, let's number the tiles:
    <table border="1"><tbody><tr><td bgcolor="cyan">1</td><td bgcolor="#33ff33">2</td><td...
  11. Replies
    1
    Views
    1,704

    Re: How do I create and register an XLL

    This may or may not get you started, I've not tried it personally: http://support.microsoft.com/kb/178474
  12. Thread: Brain Teasers

    by Oorang
    Replies
    300
    Views
    32,352

    Re: Brain Teasers

    Hmmm, there may be a more optimum solution but simple rotation yields the swap in 16 moves.
  13. Thread: VBA Error

    by Oorang
    Replies
    16
    Views
    1,597

    Re: VBA Error

    When the error message appears, do you have a debug button? If so please post the procedure that the error occurs in (and if possible which line).
  14. Thread: VBA Error

    by Oorang
    Replies
    16
    Views
    1,597

    Re: VBA Error

    Do you have any code called by workbook events?
  15. Thread: Brain Teasers

    by Oorang
    Replies
    300
    Views
    32,352

    Re: Brain Teasers

    My dog's mouse removes a thorn from the paw of your lion. Your lion now has the "loyalty" effect and must make a saving roll to attack.
  16. Thread: Brain Teasers

    by Oorang
    Replies
    300
    Views
    32,352

    Re: Brain Teasers

    What the dogs need is a mouse.
  17. Thread: Brain Teasers

    by Oorang
    Replies
    300
    Views
    32,352

    Re: Brain Teasers

    That is why it's in the order it is.
  18. Replies
    20
    Views
    18,675

    Re: What Changes can we expect in Excel 2010 VBA

    Some of the changes so far: http://www.vbaexpress.com/forum/announcement.php?f=43
  19. Re: VBA - Saving as "Read Only" then re-saving over it...

    It will if they have it open read only. There are two issue that could prevent deletion, first it being read-only, which we fix with setattr. The second is the user having the file locked by opening...
  20. Re: VBA - Saving as "Read Only" then re-saving over it...

    OIC, no worries. Use:

    SetAttr "C:\Test\MyFile.xls",vbNormalTo get rid of the read only attribute.
    Then you can either suppress the overwrite alert by doing this:

    Application.DisplayAlerts =...
  21. Thread: Brain Teasers

    by Oorang
    Replies
    300
    Views
    32,352

    Re: Brain Teasers

    lol I also object... On the grounds that 0 ≠ Null ;)
  22. Re: VBA - Saving as "Read Only" then re-saving over it...

    Public Sub Example()
    Const csPathOrg As String = "C:\Test\Test.xls"
    Const csPathNew As String = "C:\Test\Test2.xls"
    'Open file:
    With Workbooks.Open(csPathOrg, 3)
    'Do...
  23. Thread: Brain Teasers

    by Oorang
    Replies
    300
    Views
    32,352

    Re: Brain Teasers

    @PaddyD That's more in the spirit of the question (and I think the "Classical" answer). The funny thing is, the question lets you live but you never know who's lying. My way tells you whose lying,...
  24. Replies
    5
    Views
    4,274

    Re: Import Access Tables using VBA

    Yes it is:) But are you sure you need to copy the data? Why not just create a linked table to the other database? Here is how to do either:

    Import:

    DoCmd.TransferDatabase acImport, "Microsoft...
  25. Replies
    13
    Views
    1,481

    Re: Microsoft Can't sell Word anymore

    Word won't go off the market. They will pay a royalty or rush a fix into 2010 and release it. As long as this litigation has been going on, they almost certainly have a contingency plan. Letting...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4