Search:

Type: Posts; User: westconn1

Page 1 of 13 1 2 3 4

Search: Search took 3.60 seconds.

  1. Replies
    27
    Views
    570

    Re: CDO.Message Problem

    yes i am using those


    here is the code, pretty basic

    Set objmessage = CreateObject("CDO.Message")
    objmessage.Subject = "Example CDO Message"
    objmessage.From = fr
    ...
  2. Replies
    27
    Views
    570

    Re: CDO.Message Problem

    the code i wrote around 10 years ago, before i started editing to use with windows 10
    i have never used gmail server to send outgoing emails i only ever had this code for testing purposes, sending...
  3. Replies
    27
    Views
    570

    Re: CDO.Message Problem

    after a couple of changes to code, i now have the gmail server accepting cdo emails in windows 10, i will test with xp later

    BUT i was initially locked out by gmail and had to set use less secure...
  4. Replies
    27
    Views
    570

    Re: CDO.Message Problem

    there was a thread here about a year ago, i will see if i can find it for you,...
  5. Replies
    27
    Views
    570

    Re: CDO.Message Problem

    in my case i have my own mail server for incoming mail, but security and other issues deter me from having a smtp server on the same box

    i either use my isp outgoing mail server, which may have...
  6. Replies
    3
    Views
    131

    Re: Getting the active mailbox

    this code is copied from a recent thread, where the poster was accessing multiple inboxes, but all mailboxes are still within the same namespace, so i believe there would only be one collection of...
  7. Replies
    27
    Views
    570

    Re: CDO.Message Problem

    i was using cdo from xp sp3 until recently, when i upgraded the last of the computers here, too many issues with xp to continue
    i had modified the code for the program to run on windows 10

    have...
  8. Replies
    27
    Views
    570

    Re: CDO.Message Problem

    you do not provide enough information to readily provide a solution

    the issue may not be the age of the code or any external changes to smtp, but a change of operating system, which you do not...
  9. Replies
    13
    Views
    549

    Re: Copy Worksheet & formatting

    there is 2 choices to work with a workbook that is not currently open, OPENan existing workbook, specifying the full path and filename, or ADDto open a new blank workbook

    if you say so!!
    you...
  10. Replies
    13
    Views
    549

    Re: Copy Worksheet & formatting

    because between post #7 an post #8 you changed the line Set b = Workbooks.Add

    of course it would you do not specify which workbook contains that sheet, if it is in the new workbook there is no...
  11. Replies
    13
    Views
    549

    Re: Copy Worksheet & formatting

    you have missed the line

    b.saveas myfile
    looks like you should have a \ between mypath and the file name

    to specify the sheet FM, you need to change the name of the default sheet in the new...
  12. Replies
    2
    Views
    172

    Re: Difficut assignment

    you do not mention how marty is prioritized with other staff when allocating shifts, or how many staff per shift per cafeteria
  13. Re: Excel not formatting when creating new row

    insert constants are different from paste constants
    xlshiftdown should b the constant used, but for an entire row insert it is irrelevant as an entirerow can only go down

    i had done a simple test...
  14. Re: Excel not formatting when creating new row

    i am not sure that -4122 is a correct value for a valid constant
    other than that it appears to work as desired, though it also copies any cell values as well as formatting
  15. Replies
    13
    Views
    549

    Re: Copy Worksheet & formatting

    isn't that what the other macro did with out emailing the workbook? just change the path and filename and remove the emailing part
  16. Replies
    9
    Views
    340

    Re: Turn On and Off the printer spooler

    shellexecute with runas
  17. Replies
    13
    Views
    549

    Re: Copy Worksheet & formatting

    so you want an additional copy of the same workbook in another folder?


    b.SaveAs myfile
    b.saveas "W:\.Team Documents\Freehold Team\Freehold Managers\Reporting\FM Report builder.xlsx"
    where the...
  18. Replies
    13
    Views
    549

    Re: Copy Worksheet & formatting

    to change the file name you need to edit this line
    but i am still not sure what result you want the code should create a file named
    FEB PM Template.xlsx please specify the exact file name you want...
  19. Replies
    5
    Views
    304

    Re: Weird sequential file access problem

    as a test, i would try clearing the value of text for each iteration
  20. Thread: VBA CountIf

    by westconn1
    Replies
    2
    Views
    194

    Re: VBA CountIf

    several of the worksheet functions do not work with non contiguous ranges

    a workaound is to copy the non contiguous range to a temporary worksheet then perform the countif on the usedrange of that...
  21. Replies
    31
    Views
    1,394

    Re: Paste value special

    as you have not told us what the actual file name being saved it is a bit hard to know the solution, but it may be

    myfile = mypath & "\" & Format(Date, "MMM") & " PM Template.xlsx"or do you just...
  22. Re: Simple VB code for date comparison and formatting

    thank you for sharing, but
    invalid attachment
  23. Re: Open Outlook Mailbox in current window.

    you can try like
    Set Application.ActiveExplorer.CurrentFolder = myfolder
  24. Replies
    14
    Views
    460

    Re: comma value in csv file

    if you want to keep .csv then enclose fields that could contain commas in quotes
    if you decide to use some other field separator, then the file is no longer .csv (comma separated values)
  25. Replies
    4
    Views
    342

    Re: CRONOMETER in label

    use a timer control to update the label every second
  26. Re: How to call a certain vba Form from vb6 ?

    i would believe the only way you can do this is to write a vba sub in some module (or add a module) in the same workbook (can all be done in code), to hide the userform, then run the sub from vb6...
  27. Re: VB6 - Change PRIVATE TYPE dynamically

    shouldn't that be

    ReDim WAVEBLOCK.wavinfo(1 To 960)or some variable of the type, do you have option explicit at the top of the module?
    as we can not see the entire code, a bit hard to guess
  28. Replies
    31
    Views
    1,394

    Re: Paste value special

    i have no idea why that should give a syntax error, i know i tested all the code in post #19 before i posted, it all ran without error
    that line is the same as other line in the excerpt you posted...
  29. Re: How to call a certain vba Form from vb6 ?

    p.Designer.Caption = "xxxzzc"not sure if this does what you actually want
  30. Re: How to call a certain vba Form from vb6 ?

    that would need to be fixed in excel, macro security
  31. Re: Looking for Microsoft's ExcelADO Sample Files

    if you are using any ADO on workbook that is later than .xls, you should check your connection string is up to date (connectionstrings.com), without checking, i would assume the sample file is a bit...
  32. Re: How to call a certain vba Form from vb6 ?

    in its simplest form

    Set p = ThisWorkbook.VBProject
    For Each m In p.vbcomponents
    Debug.Print m.Name
    Nextchange the workbook object to your vb6 variable object

    to access a control on an...
  33. Re: Looking for Microsoft's ExcelADO Sample Files

    searching in this and office development forums should produce many examples

    workbooks are the database and worksheets are the tables
  34. Replies
    31
    Views
    1,394

    Re: Paste value special

    what error are you getting?

    i did not save the sample book or code so i can not test at this time
  35. Re: Simple VB code for date comparison and formatting

    you could apply conditional formatting to every even row in the worksheet, or the same could apply to changing the cell colours by code, the initial sample limited to the cells within a specific...
  36. Re: Simple VB code for date comparison and formatting

    as you only want to colour rows in the second row for each project, you only put the conditional formatting for those even rows, editing either row will change the colour if the comparative values...
  37. Re: Simple VB code for date comparison and formatting

    i can open the attachment from the link above, but i will do it again180093
  38. Replies
    10
    Views
    391

    Re: VB6 selenium how to submit this form

    a lot of web designers try very hard to prevent automated logins like this
    there may be some javascript or similar, somewhere in the page, looking for a keyup or other event to allow the login by...
  39. Replies
    10
    Views
    391

    Re: VB6 selenium how to submit this form

    i do not see any error, you could try loginform.submit
  40. Re: Simple VB code for date comparison and formatting

    180082

    you may need an additional criteria to remove color for any cell that has n/a, nil or equal values
    the conditional formatting should apply to all cells in second row of each project
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width