Search:

Type: Posts; User: Webtest

Page 1 of 13 1 2 3 4

Search: Search took 0.16 seconds.

  1. Re: Excel VBA: How To: Set Hyperlink to Sheet With Special Chars in Name !!!

    Glad you got some mileage out of this! I always try to share my "aha" moments. You never know when a little knowledge will come in handy.
  2. Re: [RESOLVED] ACCESS SQL problem - MAX() selection of newest 'Update' from Transacti

    The working FINAL SOLUTION many thanks to si_the_geek !!!
    SELECT Updates.TransDate, Updates.Balance, Accounts.OrgName, Updates.AcctID,
    Accounts.Owner
    FROM (Accounts
    INNER JOIN Updates ON...
  3. Re: ACCESS SQL problem - MAX() selection of newest 'Update' from Transaction list

    Si ...
    Thank you very much for your interest and your assistance. Your solution works PERFECTLY! Sorry about my error in my initial posting ... it is very understandable that you would copy it and...
  4. Re: ACCESS SQL problem - MAX() selection of newest 'Update' from Transaction list

    I actually got this working, thanks to the "Design View" (as opposed to the SQL view), but I had to create 2 queries to do it.

    The first query just builds the (virtual) table of Date/Account pairs...
  5. Re: ACCESS SQL problem - MAX() selection of newest 'Update' from Transaction list

    Thanks for the detailed explanations Si. I think I'm beginning to see the process ...

    Create something like a virtual temporary table aliased UpdateAmount that contains only the records from the...
  6. [RESOLVED] ACCESS SQL problem - MAX() selection of newest 'Update' from Transaction list

    Esteemed Forum Participants and Lurkers:
    ================================
    Microsoft Access 2000 (9.0.3821 SR-1)

    I am trying hard to understand and use Access, but it is eluding me. I have...
  7. Re: EXCEL VBA: How To: Copy Hyperlink while Preserving Target Format [RESOLVED]

    Robbo ... (Is that an "Old Tanglefoot" in your personal icon?)

    It's been awhile since I have had VBA open, and I have no experience with auto generating e-mails ... but ... and I'm just guessing...
  8. Re: EXCEL VBA: How To: Developers Open Webpage "Read Only" ???

    Thanks westconn1 ...

    I sort of figured that was going to be the approach. I can't mess with the folder ... it isn't mine. My VBA program writes the file to the shared drive before the user can...
  9. Re: EXCEL VBA: How To: Developers Open Webpage "Read Only" ???

    It is a simple HTML page file .... myTableFile.htm
  10. EXCEL VBA: How To: Developers Open Webpage "Read Only" ???

    Esteemed Forum Participants and Lurkers:
    ===============================
    Excel 2003 VBA

    We have a few low-level web (intRAnet) document publishers in this group, and I would like to add a macro...
  11. Re: Excel VBA: How To: Pass Array to nested function ???

    Thanks everyone ...

    If I had spent as much time trying to hack through the problem as I did writing the letter to the Forum, I would have solved it. I was in a hurry to leave to go home. Here is...
  12. Excel VBA: How To: Pass Array to nested function ???

    Esteemed Forum Participants and Lurkers:
    ===============================
    Excel 2003 VBA

    I can't remember how to pass an array to a nested function. This is a snippet ... I can do everything...
  13. Re: EXCEL VBA: How To: Force Long Macro to Background Task ???

    Legacy File operations vs. File System Objects (Microsoft Scripting Runtime)
    ========================================================

    Scan 4 directories ... 150 files in each directory.
    Fetch...
  14. Re: EXCEL VBA: How To: Force Long Macro to Background Task ???

    Thanks All ...

    Most of the time is spent deleting and copying files on a networked drive. I have 150 files ... about 1.7 megs each ... to manipulate. That takes around 10 minutes no matter how...
  15. [RESOLVED] EXCEL VBA: How To: Force Long Macro to Background Task ???

    Esteemed Forum Participants and Lurkers:
    ===============================
    Excel 2003 VBA

    I have a lengthy Excel macro (VBA program) that takes 10 to 15 minutes to run to completion. While it is...
  16. Re: Excel VBA: HowTo: Update 1 Series of several on a Chart ???

    Thanks for your help koolsid. It is all working now. One of these days I'll investigate all the nuances of ".SetSourceData" and see what it really can do.
  17. Re: Excel VBA: HowTo: Update 1 Series of several on a Chart ???

    Thanks CoolSid ... I did use the Macro Recorder and I came up with a workable solution ... but it sure does complicate the code a LOT!

    The old single line:
    'Update the HISTORY chart
    ...
  18. [RESOLVED] Excel VBA: HowTo: Update 1 Series of several on a Chart ???

    Esteemed Forum Participants and Lurkers:
    ===============================
    Excel 2003 VBA

    I have a workbook with 2 chart pages that I have been keeping for a few months. Basically, the 2 charts...
  19. Replies
    4
    Views
    12,563

    Re: Excel VBA: How To: Copy a Dictionary ???

    Yes, SET just creates 2 names for the SAME dictionary ... not 2 separate dictionaries. If I change one of the items in "junk", it changes the same item in "aSmart_List". I know I can equate ranges...
  20. Replies
    4
    Views
    12,563

    Re: Excel VBA: How To: Copy a Dictionary ???

    Doesn't the "Set" directive just point the "junk" directory to the other one? I need 2 separate dictionaries, but 98% of the keys are the same.

    Thanks ... I'll try it and post the results.
  21. Replies
    4
    Views
    2,679

    Re: IsNumeric in Excel

    Try naming your subroutine "MyIsNumeric" ... just a quick guess.
  22. Replies
    4
    Views
    12,563

    Excel VBA: How To: Copy a Dictionary ???

    Esteemed Forum Participants and Lurkers:
    ===============================
    Excel 2003 VBA
    Is there a quick and dirty way to copy all of the contents of one dictionary into a different dictionary? ...
  23. Replies
    6
    Views
    700

    Re: Edit and Refresh of cells in VB

    This is a simple example ... you can put your PARAMETER and New Value in the Global constants ... If you change "Integer" to "Variant" you can put anything in PARAMETER and NEW_VALUE. This will...
  24. Replies
    6
    Views
    700

    Re: Edit and Refresh of cells in VB

    How do you intend to specify the particular value(s) for the particular parameter(s) that you want to change? There is no problem scanning any number of rows to change the value matched to...
  25. Replies
    6
    Views
    700

    Re: Edit and Refresh of cells in VB

    The easiest way to get started is to Record a Macro or two to do some simple things.

    Menu/Tool Bar: Tools > Macro > Record New Macro
    then
    Tools > Macro > Stop Recording

    Now, you...
  26. Replies
    6
    Views
    700

    Re: Edit and Refresh of cells in VB

    VERY basically ...

    Refresh:

    ActiveSheet.Calculate

    Edit:

    Range("B5").Value = Range("B5").Value + 27
  27. Re: Excel: How To: Switch between control Edit & Operate modes ???

    THE SHEET WAS PROTECTED !!! When I unlocked the sheet it works FINE. Thanks for the help, Hack!
  28. Re: Excel: How To: Switch between control Edit & Operate modes ???

    Thanks Hack ...

    That's close. It certainly de-activates the "operate" function. When in the "Design" mode, I still can't click on a button to select it for editing the properties, such as...
  29. [RESOLVED] Excel: How To: Switch between control Edit & Operate modes ???

    Esteemed Forum Participants and Lurkers:
    ===============================
    Excel 2003

    Does anyone remember the shortcut to switch modes in Excel from Editing controls (standard VBA buttons and...
  30. Replies
    37
    Views
    18,972

    Re: Print Macro Information Needed

    JayCR:

    The following post will show you a loop to find all network printers. Start around post #6 in this thread.

    http://www.vbforums.com/showthread.php?t=385944&highlight=printer
  31. Re: VBA or VB6 or VB.NET what do i have/can I use

    darbid:

    The Visual Basic systems available in the MS Office applications are extremely powerful and comprehensive programming languages. I personally use Excel VBA extensively. There are some...
  32. Replies
    2
    Views
    423

    Re: Deleting Duplicate Rows based on

    You have shown a 'duplicate' row that is adjacent to its match. Is that always the case, or do you have to use the universal situation where the 'match' can be anywhere in the list? Can you sort...
  33. Replies
    5
    Views
    650

    Re: Open program with parameters from Outlook

    Excel: How to: Pass Command Line Parameter [DKenny is KING!]
  34. Replies
    5
    Views
    650

    Re: Open program with parameters from Outlook

    Watermeloene:

    I believe you have to use an API call to the OS to pass command line parameters to a VBA program. I was able to us this successfully to pass command line parameters to an Excel VBA...
  35. Replies
    4
    Views
    50,816

    Re: Split one cell into two cells in Excel

    What is the typical contents of the cell that you want to split? is it Text?
  36. Replies
    10
    Views
    14,466

    Re: [EXCEL 2003] =HEX2DEC equivalent

    Do you have an "Option Explicit" line before the first Sub/Function in your module? The functions you show are actually String functions operating on DECIMAL numbers. Even though the "Binary"...
  37. Replies
    10
    Views
    14,466

    Re: [EXCEL 2003] =HEX2DEC equivalent

    Are you looking for something like this?
    Function HexaNum(aNum As Variant) As String
    HexaNum = Hex(aNum)
    End Function
    Variant allows the function to be passed a Long or an Integer ... I don't...
  38. Replies
    6
    Views
    2,305

    Re: [EXCEL 2003] Circular Shifting

    The numbers are identical internally ... it's just a matter of how you display them. I've got to head for home now, but I'll look at it again tomorrow.
  39. Replies
    6
    Views
    2,305

    Re: [EXCEL 2003] Circular Shifting

    There are no native bit shifts or rotates in VBA (that I know of).

    This can be optimized, but here is a quick and dirty solution ... signs may get in your way.
    '16 bit Logical Rotate Left...
  40. Replies
    6
    Views
    2,305

    Re: [EXCEL 2003] Circular Shifting

    What datatype are you using / how many bits in your bitfield??? Do you need sign-extension or not???
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width