Search Results - VBForums

Search:

Type: Posts; User: westconn1

Page 1 of 13 1 2 3 4

Search: Search took 0.26 seconds.

  1. MsOf07 Re: How to set column width of a listview report/table?

    1. you can set the width of columns at design time, in the property pages (custom > columnheaders), or at runtime when adding columns, as per your code snippet, or at any time, using...
  2. Re: Excel macros VBA (creating new workbook from existing one)

    you can try like

    thisworkbook.savecopyas thisworkbook.path & "\somenewfilename.xls"
    set newbk = workbook.open thisworkbook.path & "\somenewfilename.xls"
    set newsht = newbk.sheets.add "Summary...
  3. Re: Save Email Attachment from 2 Emails with Different Rules

    of course there is, but unlike excel or word where you can post a test workbook or document, in outlook you can not do that, so we can only help you to find the problem

    have you put a breakpoint...
  4. Re: Save Email Attachment from 2 Emails with Different Rules

    as your procedure have parameter, they can not be run from macros and would need to be started by their event, either from the rules dialog or by receiving appropriate new mail
    in either case the...
  5. Re: Save Email Attachment from 2 Emails with Different Rules

    put a break point at the first line of the procedure, the code will stop running at the break point, then you can step through the code to see what is happening

    if you are not sure about putting a...
  6. Thread: find error

    by westconn1
    Replies
    11
    Views
    254

    Re: find error

    sounds like a problem from using the change event
    the first matching result will fire the change event after each character is typed
    try using the exit event of the combobox, which would fire when...
  7. Re: Save Email Attachment from 2 Emails with Different Rules

    how do you know? does the procedure run but not save attachment or not run at all?

    what rule have you created? check messages when they arrive or what, i doubt this will run with already arrived...
  8. Re: code vb6 send email but can not sent text body thai language is Stars Language

    did you try sending the body as html rather than text?
  9. Replies
    4
    Views
    229

    Re: VBA Excel - Sort, Copy and Paste.

    i doubt that LIKE will compare the date /times well enough, LIKE is for comparing strings,
    try just compare to > A1

    also you are comparing a date to a string literal "A1", rather than a cell...
  10. MsOf13 Re: FormulaArray in Absolute RC formula keeps changing to relative

    in that case should be c3, c1 would be A:A


    as you can insert formulas by code in either style, .formula or .formular1c1, it does not really matter
  11. MsOf13 Re: FormulaArray in Absolute RC formula keeps changing to relative

    is realtive to cell with formula
    =sum(r1c3) is absolute "C1"

    not quite sure if that is what you are asking though
  12. Re: Runtime Error 1004 Sorting in Excel from VB6

    try using the SET keyword on the first line, as it is, temp is probably a 2d array rather than a range object
  13. Re: Save Email Attachment from 2 Emails with Different Rules

    just make another Sub in the same module, copy the code and edit as required, make sure to have different name for 2nd procedure
  14. Replies
    6
    Views
    191

    Re: Problems with exporting to excel

    probably have to change the filetype constant too
    you may have to research the available values for file types
    acFormatXLS
  15. Re: Save Email Attachment from 2 Emails with Different Rules

    you could use separate rules based on the subject, each rule can use different procedure

    else you can use the new mail event to process emails, just when they arrive,

    note also that datafile1...
  16. Re: Email attachments from form field with VB

    is the attachment actually in the database? or does the database contain a path to the attachment? if multiple attachments a loop would be required

    i am not sure how to add a database field to an...
  17. Replies
    2
    Views
    148

    Re: Nested if Issue in Excel

    do you have any idea how hard it is to read those images?

    i tested your formula, seems to work ok for me (as best as i could read it)

    post a sample workbook that demonstrates the problem,...
  18. Thread: find error

    by westconn1
    Replies
    11
    Views
    254

    Re: find error

    seems to indicate the job # is not found, so thesearch is nothing
  19. Replies
    10
    Views
    270

    Re: VB6 Listbox split shorten sentence

    as your criteria would never match for either sub, both will always do nothing
    is that correct?

    i suggest you post a list of before and after (what you want to add to listbox) strings, for us to...
  20. Re: Join listbox value into one string

    i do not see why you get the trailing , unless you have empty last list item
    to remove the initial , try like

    For i = 0 To .List10.ListCount()
    allstr = allstr & "," & .List10.ItemData(i)
    Next i...
  21. Replies
    2
    Views
    139

    MsOf10 Re: ListBox with Hiperlinked word

    if you use a multi column listbox, you could put the url in the 2nd column, the 2nd column could be hidden if desired, then easy to use the value of the 2nd column as the hyperlink
  22. Re: Ckick or get an area tag's href

    change to ele.outerhtml
  23. Re: USE range of cells instead db access - autolist during the typing in text box

    you can use ADO to access the worksheet data as a recordset, using SQL queries see http://support.microsoft.com/kb/257819
  24. Thread: find error

    by westconn1
    Replies
    11
    Views
    254

    Re: find error

    what error? when you select a customer of job number?

    as expected by the code posted, only finds the first job #

    can you post a test workbook, with the userform and some sample data, zip first
  25. Thread: find error

    by westconn1
    Replies
    11
    Views
    254

    Re: find error

    try moving the code to the click event of the combobox, rather than the change event, the code should then not fire when the combobox text is changed, only when a combobox item is clicked

    i...
  26. Thread: find error

    by westconn1
    Replies
    11
    Views
    254

    Re: find error

    to handle error if jobnumber is not found
    after the search

    if thesearch is nothing then msgbox thevalue & " was not found": exit sub

    if the job # exists, but is not found, then there must be...
  27. Re: Ckick or get an area tag's href

    try
    myvar = ele.href
  28. Thread: find error

    by westconn1
    Replies
    11
    Views
    254

    Re: find error

    i am sure there is
  29. Re: Error 2448 ("You can't assign a value to this object") cause?

    afaik you can only assign true or false (vbchecked) to a checkbox
    the content of the combo43 would not match that criteria

    that is not quite correct
    the constants for those values are
    vbchecked...
  30. Re: Excel VBA: Passing active sheet name to variable

    the worksheet name is a string, not a worksheet
    you can use like

    set ws = activesheet
    msgbox ws.name

    else use a string variable
  31. Re: Ckick or get an area tag's href

    try like

    for each ele in wb.document.getElementsByTagName("area")
    if instr(ele.innerhtml, "rel=""A B""") > 0 then ele.click: exit for
    nextnot tested
  32. Replies
    24
    Views
    377

    Re: How to find the weekday name from a date

    you could try like

    For i = 1 To 8
    If Me.Controls("text" & i) = "" Then
    MsgBox "Date is not complete, fill all boxes and try again"
    Exit Sub
    End If
    Next

    Label13...
  33. Replies
    24
    Views
    377

    Re: How to find the weekday name from a date

    maybe you need to check if any textboxes are empty first, prompt the user to make sure date is valid

    i would presume it should still work without error if text5 or text7 is empty, or even if text6...
  34. Replies
    24
    Views
    377

    Re: How to find the weekday name from a date

    wrong data type, will give overflow error when the numbers are assembled

    you should not use reserved words (in this case date) as variables, especially not global variables


    substituting the...
  35. Re: Excel VBA - calling a function located in a worksheet code module

    to call a function in an object module from code, you would address the function by modulename (or any sheet object name) .functionname
    i do not believe you can do this with worksheet functions as...
  36. Re: Printing a PDF to 'Microsoft XPS Document Writer' using VB6.5

    part 2, 1 is easy enough, just use shellexceute API, there will be many examples for this, in this forum and google, with the print verb, having first changed the windows default printer to xps...
  37. Replies
    4
    Views
    181

    Re: Runtime Error 3001 Invalid Arguement

    no line continuation on line 2?
  38. Replies
    4
    Views
    181

    Re: Runtime Error 3001 Invalid Arguement

    does the select part work, without the insert?

    probably just a typo on posting, but you are missing a quote at the start of the 3rd line
  39. Re: Email attachments from form field with VB

    i would believe this should be a string as it would be the name of the attachment, not the attachment object, which is later added to the mail item object
  40. Replies
    6
    Views
    264

    Re: Host on Web page

    you can try like
    change the function to

    Function UrlMsg$(ByVal tUrl$, myhost) ' pretend to be a browser

    'change this line to
    'Msg$ = Msg$ + "Host: ichart.yahoo.com" & vbCrLf
    Msg$ = Msg$ &...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.