Search:

Type: Posts; User: westconn1

Page 1 of 13 1 2 3 4

Search: Search took 3.66 seconds.

  1. Replies
    2
    Views
    137

    Re: clear the data by vba macro

    i am currently unable to open your samples, but based on your description

    p1 = "c:\temp\"
    p2 = "C:\temp\"
    Set wb1 = Workbooks.Open(p1 & "book1.xlsx")
    Set wb2 = Workbooks.Open(p2 & "book2.xlsx")...
  2. Re: Excel to HTML Text File - Formatting/Highlighting

    first go back and edit your posts to wrap all the code in code tags, so it is more readable
    highlight the code and press the # button in the toolbar

    your code can be abbreviated by creating loops...
  3. Re: Getting a compile error : stub or function not defined error in VB6

    option explicit at the top of all modules, will help to prevent those type of errors
  4. Replies
    5
    Views
    157

    Re: VLookup of date and time

    i assume that a396 contains 25.09.2020, so the returned lookup is correct closest value below the lookup time, what do you want it to find in this case?
    the values here are all text, no dates,...
  5. Re: Runtime error 424 when referring to class method

    as my is dimensioned within the form load event, it is out of scope for the timer procedure, you should dimension it at module level or globally for all modules

    you should move the Dim My As...
  6. Re: Getting a compile error : stub or function not defined error in VB6

    do you have a sub or function addlog?
    i am guessing that is the one it is not finding, test if it will run if you comment out that line
  7. Replies
    5
    Views
    157

    Re: VLookup of date and time

    this seems to work correctly, it will pick up the one before the time looked up, not one after the time, so while 2pm would be closer to 14:08, vlookup would find the 13:08, if you need to find the...
  8. Re: Looking to make this macro Faster

    depending how many rows are involved, i am sure it would be faster to to read the values into an array, do the calculation, then write the array back to the range

    or probably even faster, use an...
  9. Replies
    4
    Views
    225

    Re: [Powerpoint]Working with group shape

    i am not sure that you can do a pickup of the group, maybe only the individual shapes
  10. Replies
    2
    Views
    232

    Re: Changing Object Fill Color

    you can try like

    With Worksheets(Sheet2.Name).Shapes("Oval 52")
    .Visible = msoTrue
    .Fill.ForeColor.RGB = RGB(112, 48, 160)
    .Shadow.Transparency = 0
    End With
  11. Replies
    21
    Views
    434

    Re: OUT of memory in VB&

    why use a text file at all? seems like a database would be more appropriate
  12. Replies
    5
    Views
    285

    Re: Moderators please delete

    why delete? just mark resolved, it may help someone searching the same problem
  13. Re: [RESOLVED] Error 35600 ListView Index Problem

    yes i picked that in post #2
  14. Re: Email Sheet Range With Images/Formatting as Email Body

    you could try writing your own html table, that way you can set the widths of columns etc as well as the text, font properties etc, i have done this before in a more limited way

    as the images are...
  15. Re: Error 35600 ListView Index Problem

    when in ran the code qlv had a value of 0 so it would try to loop from 0 to -1, anyhow listitems.items(0) will give index out of bounds as it is 1 based, so try

    For i = 1 To QLV
  16. Replies
    16
    Views
    533

    Re: How to use vb6 for fill the html form

    using the link supplied, i tested variations of the code i posted previously they work ok with small changes

    this is more difficult as code will not run until after the dialog is closed
  17. Re: Error 35600 ListView Index Problem

    post a sample of your workbook, zip first
  18. Replies
    16
    Views
    533

    Re: How to use vb6 for fill the html form

    you could try like

    WebBrowser1.Document.all("_CD_BIRTH")(0).Value = Text2.Text

    WebBrowser1.Document.all("_CD_IDNO")(0).Value = Text3.Text



    WaitTime (0.5)
  19. Re: Run-time error 91 Object variable or With block variable not set

    is emppay variable diimensioned globally? the error indicates not, possibly in some other procedure?
  20. Re: Error 35600 ListView Index Problem

    looks like this should be within the loop else every row from the listview will be written (overwritten) to the same row in the worksheet, else use the value of i to increase the offset from the...
  21. Re: old vb6 and visual studio community edition

    i did have some conflict that when i loaded vb6 it started the vb.net installer for some reason, but i think that just went away in the end
  22. Re: Email Sheet Range With Images/Formatting as Email Body

    the function is in the post, publishes a temp workbook as html, returns the html string from the saved file

    looks like the problem is not to do with the outlook object

    you could test
    ...
  23. Re: How to find the country code using an email messaged link to an inbox???

    a lot of people just use web based mail now
  24. Re: Email Sheet Range With Images/Formatting as Email Body

    each of these paste operations overwrite the previous one, as posted above, you probably need to combine the paste operations
  25. Re: old vb6 and visual studio community edition

    the community edition is VB.net, nothing to do with VB6
    all VB6 is old, but if you want to support old programs you probably need to install it anyway
    if you wish, you can install vb.net along side...
  26. Re: Parsing string, counting commas and removing text

    while you first example with 4 groups from 15 numbers is relatively straight forward, how about 7 groups from the same numbers?
    what should the result look like?
    3 numbers to a row would only take...
  27. Re: Parsing string, counting commas and removing text

    by having a trailing comma in your text box, you actually have an array of 16 elements (0 to 15)
    the last being empty, but still part of the calculations
  28. Replies
    4
    Views
    633

    Re: Automate some steps in IE, with VBA

    that is a call to an API, you would need to declare the API function, which would then go at the top of the code module in the general section, or as public in a module, you can search on the...
  29. Re: [RESOLVED] Change "Resolved" back to an open thread?

    ok done that
  30. Re: editing posts in quick reply title changed

    well it was working long before the double posting issue started
  31. Re: Conditionally Run & move the .bat file shortcut(i.e .lnk file) by vba macro

    which part is not working?
    is it finding the shortcut?, is it moving the shortcut if found? are there any errors?

    try changing to

    If not strFileExists = "" Then
  32. Replies
    5
    Views
    329

    Re: Excel file remains opne

    if the user has not closed either the file or excel, you will get the error
    you should use a template file with .xltx extention, then open a new file each time based on that template, as each time...
  33. editing posts in quick reply title changed

    previously could click to edit post, would be like a quick reply, now it always like go advanced

    any chance they will bring back this feature?
  34. Re: [RESOLVED] Change "Resolved" back to an open thread?

    if they are the thread starter?
  35. Replies
    5
    Views
    329

    Re: Excel file remains opne

    of course you are not closing the workbook or the excel appication
    also you are not saving any updated data from the recordset to the workbook
    with the current code the data will always wholly or...
  36. Replies
    6
    Views
    523

    Re: Loop not working

    you try to list all errors to find if any specific ones are causing a problem

    if not err.number = 0 then msgbox err.description & vbnewline & "No. " & err.number
    Application.DisplayAlerts...
  37. Thread: Monitor

    by westconn1
    Replies
    15
    Views
    1,110

    Re: Monitor

    on previous testing, the line that is failing is a method in an activex, to set the orientation of the printer
    i tried several workarounds using the printer object and other things that came to mind...
  38. Re: [RESOLVED] "Reset" a With/End With structure?

    you could also use a second with block within the first


    Set ws = ActiveSheet
    With ws
    ' stuff
    Set newsht = Sheets.Add
    With newsht
    .Name = "my new sheet"
    ' other...
  39. Re: How to generate an alphanumeric tree changes with criteria?

    you can test like

    Dim cel As Range, sfirst As String, cnt3 As Integer, cnt4 As Integer
    sfirst = "ABCD.01.01."
    cnt3 = 0
    For Each cel In Range("c:c") ' i just looped column till first empty...
  40. Re: "Reset" a With/End With structure?

    the for line is only executed once on entering the loop, so changing lnglastrow will have no effect during the loop, whereas changing lngrow wold affect the output, if it is changed to a value >...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width