Search:

Type: Posts; User: lisagreen

Search: Search took 0.02 seconds.

  1. Replies
    51
    Views
    2,725

    Re: [RESOLVED] Getting hWnd from VBIDE.Window

    Thank you.
  2. Replies
    51
    Views
    2,725

    Re: [RESOLVED] Getting hWnd from VBIDE.Window

    Um.... please excuse me if I'm being dense but.. which caption/window?

    Lisa
  3. Replies
    3
    Views
    1,185

    Re: Access the excel statusbar

    Hi jdc,

    Weeeelllll.. not really. They both sort of depend on "padding" out the string to a certain length which isn't what I was looking for. There are multiple posts on the net about doing this...
  4. Replies
    3
    Views
    1,185

    Access the excel statusbar

    Hi,

    Apologies if this is in the wrong forum and if it is would appreciate a mod moving it. Thanks.

    Longish post warning!!

    This is a multipart sort of question from a newbie to vbforums. I've...
  5. Replies
    51
    Views
    2,725

    Re: [RESOLVED] Getting hWnd from VBIDE.Window

    Thank you ColinE!!!!!

    Unzipping it now!!!

    Regards
    Lisa
  6. Replies
    51
    Views
    2,725

    Re: [RESOLVED] Getting hWnd from VBIDE.Window

    Hi,

    I'm ***very*** interested in the addin and looking at the complete code.

    I also would like to go the other way and if there is a listbox "window" get the listbox so I can look at the...
  7. Thread: Back up

    by lisagreen
    Replies
    5
    Views
    1,651

    Re: Back up

    Thank you again!
  8. Thread: Back up

    by lisagreen
    Replies
    5
    Views
    1,651

    Re: Back up

    Thank you again!
  9. Thread: Back up

    by lisagreen
    Replies
    5
    Views
    1,651

    Re: Back up

    Thank you!!

    Lisa
  10. Thread: Back up

    by lisagreen
    Replies
    5
    Views
    1,651

    Back up

    Hi everyone,

    I was wondering how people back up their VBA code.

    Crossposted at http://www.eileenslounge.com/viewtopic.php?f=30&t=31562&p=244293#p244293

    TIA
    Lisa
  11. Replies
    0
    Views
    460

    Cross Reference

    Hi,

    I'm trying to create a procedure to cross reference procedures.

    So far I've identified the following that need to be taken into consideration.
    I'm sorry but I don't know how to indent the...
  12. Replies
    7
    Views
    1,015

    Re: What is an Operand/Operator in VBA?

    Heya....

    If we have a line...
    A = B + C
    for me B and C are operands.

    If there is A function...
    Result = function(A,B)
    that returns A + B
  13. Replies
    7
    Views
    1,015

    Re: What is an Operand/Operator in VBA?

    Hi Elroy!

    I have a sub and a class that do the same thing but I'll just talk about the class coz I'm going to get rid of the Sub. I instantiate it to return as much information as I can about...
  14. Replies
    7
    Views
    1,015

    Re: What is an Operand/Operator in VBA?

    Hi Elroy!!

    So far I've found counting the operators okay.... I think. Though whether a function is an operator is a mystery!! I've been on this for about a week now and have only just... in the...
  15. Replies
    7
    Views
    1,015

    What is an Operand/Operator in VBA?

    Hi,

    I'm trying to build code to calculate Halstead metrics.

    For this I need...
    A count of unique operators
    A total count of operators
    A count of unique operands
    A count of total operands
  16. Replies
    8
    Views
    849

    Re: To integer or not to integer

    Ok everyone... What I'm hearing is lots about the merits of Integer Vs Long and.

    I just wanted to know what actually happens.

    Thank you all for replying anyway.

    Lisa
  17. Replies
    8
    Views
    849

    Re: To integer or not to integer

    hmmmmmm.... ok

    As far as I can tell with my limited knowledge and restricting things to VBA not VB.... Integers do seem to be converted to longs... but... VBA remembers that they were originally...
  18. Replies
    8
    Views
    849

    To integer or not to integer

    Hello,

    Does anyone have definitive proof of what VBA does with integer type numbers please?

    Do they get converted internally to long or not?


    TIA
    Lisa
  19. Thread: VBA Compile

    by lisagreen
    Replies
    20
    Views
    1,696

    Re: VBA Compile

    Hi.... I'm posting this "as is" and expect criticism.

    Here is my current *VERY RAW* solution to compiling in VBA with no intervention.

    All files go into the same folder.

    Compile.txt is the...
  20. Replies
    56
    Views
    5,880

    Re: simple math string parser

    Hello,

    My two penneth on this... it's 5 yrs old though.

    Access has the Eval function.

    Open an instance of access, pass it the math... get the answer.

    May be slower than other methods but...
  21. Thread: VBA Compile

    by lisagreen
    Replies
    20
    Views
    1,696

    Re: VBA Compile

    Ok... Though I don't really like it... not sure why.. just feels uncomfortable... I'm using the registry to pass messages between the two asynchronous application instances.

    I'm getting another...
  22. Thread: VBA Compile

    by lisagreen
    Replies
    20
    Views
    1,696

    Re: VBA Compile

    Hello guys/gals,

    I'm happy to send the current code PM but I'm not happy about the code. I'd rather post a more stable solution. If you want what I've got just say though.

    At the moment I'm...
  23. Thread: VBA Compile

    by lisagreen
    Replies
    20
    Views
    1,696

    Re: VBA Compile

    Ok... done it. A bit rough at the edges but I think that can be smoothed out. I think it's probably timing issues.

    Attached is a txt file produced with no user intervention.

    Lisa
  24. Thread: VBA Compile

    by lisagreen
    Replies
    20
    Views
    1,696

    Re: VBA Compile

    Ummm ... not feature of VBA at all. All my own code.

    And nothing fancy either! so I'm sure it would work in VB. Positive in fact.

    Lisa
  25. Re: How to use CallByName in a Class to call methods or functions in modules?

    Hi gyhu,

    May I ask if you are familiar with using CallByName in a "normal" procedure? Not in a class?

    Lisa
  26. Thread: VBA Compile

    by lisagreen
    Replies
    20
    Views
    1,696

    Re: VBA Compile

    I'm sorry but I beg to differ.... Here is a raw list of errors generated...

    1134 mHolding Else

    1136 mHolding End If

    1140 mHolding If fncIsArrayAllocated(spParameters) Then

    1142...
  27. Re: How to use CallByName in a Class to call methods or functions in modules?

    Hi gyhu,

    May I ask if you are familiar with using CallByName in a "normal" procedure? Not in a class?

    Lisa
  28. Thread: VBA Compile

    by lisagreen
    Replies
    20
    Views
    1,696

    Re: VBA Compile

    Hi Elroy,

    I agree with everything you've said!

    It's likely that I'm not being to clear... apologies.

    I have "Require Variable Declaration" ticked in the VBE Options so every time I create a...
  29. Thread: VBA Compile

    by lisagreen
    Replies
    20
    Views
    1,696

    Re: VBA Compile

    Hi,

    Apologies for posting in the wrong place! Having said that it may be applicable to VB as well but I don't know that IDE. Does it have a debug option on the menu and does that have a compile...
  30. Thread: VBA Compile

    by lisagreen
    Replies
    20
    Views
    1,696

    VBA Compile

    HI,

    Newish to the forum....

    I'd like to intercept/catch the error message posted by debug/compile in VBA.

    Part of the problem is that it's not an error... debug.compile has been successful!...
Results 1 to 30 of 30



Click Here to Expand Forum to Full Width