dcsimg

Search:

Type: Posts; User: westconn1

Page 1 of 13 1 2 3 4

Search: Search took 0.79 seconds.

  1. Re: [RESOLVED] Default Excel User form Using VBA : Help on Unique Values.

    set a range of the 2 columns then add to the combobox using a collection as before


    lr = usedrange.rows.count
    set r = range("a1:b" & lr)
    for each cel in ryou would have to specify the worksheet...
  2. Re: looping all dir in sub dir and each files....

    there are many examples of alternatives in this forum and office development forum for recursively searching folders (folders with sub folders)
  3. Re: [RESOLVED] Default Excel User form Using VBA : Help on Unique Values.

    probably, but i do not understand what you want
  4. Re: Default Excel User form Using VBA : Help on Unique Values.

    try modifying like

    Dim c As Collection
    Set c = New Collection

    On Error Resume Next


    For i = i + 1 To lc
    tecAttrVal = Cells(1, i).Value
  5. Re: Default Excel User form Using VBA : Help on Unique Values.

    you always will be if you do not have a go for yourself
  6. Re: Read Text file and make changes to text by searching a string

    as far as i can tell this should not cause any error though the formatting of the output file may not be as desired
    you many need to do like

    avals(i) = format(avals(i) +pi,"##.000")formatting...
  7. Re: Default Excel User form Using VBA : Help on Unique Values.

    possibly the simplest method is to add the values to a collection, collections can not have duplicate values, then only add the value that can be added to the collection to be also added to the...
  8. Re: A program that searches within all files in a directory for a specific string

    i though chris' solution was quite sound, though has nothing to do with vb6, so is off topic here, it actually uses excel to search the files and returns a list of cells to inspect and edit if...
  9. Re: Read Text file and make changes to text by searching a string

    easy to do with code, but until testing is complete, need to keep old file

    kill fn
    name fn2 as fn


    do you want to edit the values before the -90.000?
    or if -90.000 is in the line, not to be...
  10. Re: A program that searches within all files in a directory for a specific string

    surly a dollar amount could have multiple instance of the same amount that are not related?
    especially as the data grows

    why would any customer or product have a unique amount to their record?
  11. Re: Read Text file and make changes to text by searching a string

    are you testing against the same sample file? what error are you getting?
    i had no error when i tested

    is the error happening at the beginning or end of the file
    you could add a counter to be...
  12. Re: Default Excel User Form using VBA : Help Needed

    i do not understand this

    i have tested on a later version, it works as intended, if it is not correct some other code must be interfering with it, or i have misunderstood what you want it to do...
  13. Re: How to share variables between two forms?

    declare the shared variables as public in a std module
    Not in either form code module


    public myvar as string, mynum as integer
  14. Re: Default Excel User Form using VBA : Help Needed

    works correctly on my testing

    the only issue had was where there were multiple spaces between words
  15. Re: Default Excel User Form using VBA : Help Needed

    this version will delete words till the last word then deletes characters
    Private Sub TextBox2_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)
    If KeyCode = vbKeyBack Then
    ...
  16. Re: Default Excel User Form using VBA : Help Needed

    try removing the trailing space

    TextBox2.Text = Left(TextBox2, InStrRev(TextBox2.Text, " ") - 1)
  17. Re: Default Excel User Form using VBA : Help Needed

    you should use & to concatenate strings

    you can test

    Private Sub TextBox2_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)
    If KeyCode = vbKeyBack Then
    ...
  18. Replies
    3
    Views
    146

    Re: scheduling a sending email

    if you are sending emails using outlook you can use DeferredDeliveryTime for the message to schedule when it is sent
  19. Re: A program that searches within all files in a directory for a specific string

    dilettante has posted examples to search files (or within files) using the windows shell search functionality
  20. Replies
    1
    Views
    101

    Re: creating separate tables in VBA word

    just need some minor changes

    Set oTable = odoc.Tables.Add(odoc.Range(0, 0), 6, 4)
    odoc.Paragraphs.Add
    Set arange = odoc.Paragraphs.Last.Range
    Set oTable2 = odoc.Tables.Add(arange, 5, 4)
  21. MsOf13 Re: remove colours by vba based on conditions in excel

    are the coloured (highlighted) cells as result of conditional formatting?

    you would need to post the 2 workbooks with some appropriate sample data
    zip first and attach to post
  22. MsOf13 Re: Outlook Macro to Copy Emails - Remove Carriage Return

    print puts a crlf, so try

    Print #1, writeLine;
  23. Re: Vba code:active ws copy paste special to new ws then email OUTLOOK

    this of course makes wb the same as wb2
    you need

    Set Wb = Application.ActiveWorkbook
    Set Wb2 = Appication.Workbooks.Add


    then you would need to copy the pivot table and paste to sheet 1...
  24. Re: Read Text file and make changes to text by searching a string

    initially i started with as slurp and split, but with the file size i changed to use line input

    Dim ec As Boolean, i As Integer
    Dim strln As String, avals() As String
    repval As String, fn As...
  25. Re: Accessing GMail (specifically) from VB6 - "not a secure app

    this is the only solution i know of, it has been in effect for some time
    my gmail account has that reduced security for several years, with no ill effects to date

    did you contact google regarding...
  26. Re: Set Outlook Out-of-office programatically

    i only posted the part of the code i though relevant to you, none of the scheduling part

    i agree your simple solution is probably much better, though you can call a vba macro from a rule if that...
  27. Re: Set Outlook Out-of-office programatically

    i did not see any reason to test the current state before changing, just set to the desired state anyway

    while it is useful to know how to test the current state, it did not seem to be required...
  28. Replies
    4
    Views
    78

    Re: Print Counter in Footer

    my misunderstanding

    you would need to store the last print # each time, the document is printed then place the number in the footer before printing
    the workbook open event would be a problem if...
  29. Re: Set Outlook Out-of-office programatically

    ' The name of the property whose value is to be returned.
    Const PR_OOF_STATE = "http://schemas.microsoft.com/mapi/proptag/0x661D000B"

    ' Set reference to the Stores...
  30. Replies
    4
    Views
    78

    Re: Print Counter in Footer

    try like

    sh.PageSetup.RightFooter = "&P"change sheet object to suit

    from help
  31. Re: [RESOLVED] VBA Excel 7.1. Issue when trying to write to text file.

    you should avoid using DIR (or other reserved words or functions) as a variable name
  32. Re: Set Outlook Out-of-office programatically

    are you running outlook connected to an exchange server?
  33. Re: Tips for updating a datasheet in a pivot table without corrupting it.

    i have done a little pivot table by vba, all tial and error methods, but not sure what your issue could be

    i would believe you must delete any pivot table before recreating
    can you post a sample...
  34. Re: Read Text file and make changes to text by searching a string

    so all the values in red should be changed to 0.5 (or whatever value is determined as the replacement value)?
    except the actual EC1
  35. MsOf10 Re: Copy a URL from a specific subject mail email body into excel worksheet

    you could try running the code from within outlook vba, see if the same problem occurs, just automate excel instead
  36. MsOf10 Re: Copy a URL from a specific subject mail email body into excel worksheet

    my rule here is never click any link in any email from anyone
  37. MsOf10 Re: Copy a URL from a specific subject mail email body into excel worksheet

    it would appear your company does not want you to do this and it would be wrong for anyone here to help you by-pass their security

    as you are getting paid to do it the slow way why should you...
  38. Replies
    8
    Views
    263

    Re: option boxes and general buttons

    unfortunately vba has no clipboard object, so is not straight forward, ranges and some other excel objects have a copy method, but that does not apply to a userform

    you can used a dataobject to...
  39. MsOf10 Re: Copy a URL from a specific subject mail email body into excel worksheet

    try like

    mylink = "http://mytkportal.si/sff/kp/sfsd="
    pos = instr(olMi.Body, mylink)
    if pos > 0 then
    Sheets("Sheet1").Range("A1") = mid(olMi.body, pos, len(mylink)+5)
    end ifif the length...
  40. MsOf10 Re: How to filter outlook emails for a specific date

    you must use a date range for the day
    >MailRcvdDate and < MailRcvdDate + 1
    should cover all times during MailRcvdDate

    formatting the value assigned to mailrcvddate is pointless as a date...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Featured


Click Here to Expand Forum to Full Width