Search:

Type: Posts; User: westconn1

Page 1 of 13 1 2 3 4

Search: Search took 3.29 seconds.

  1. Replies
    4
    Views
    137

    Re: [Powerpoint]Working with group shape

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

    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
  3. Replies
    21
    Views
    403

    Re: OUT of memory in VB&

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

    Re: Moderators please delete

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

    yes i picked that in post #2
  6. 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...
  7. 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
  8. Replies
    16
    Views
    474

    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
  9. Re: Error 35600 ListView Index Problem

    post a sample of your workbook, zip first
  10. Replies
    16
    Views
    474

    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)
  11. 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?
  12. 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...
  13. 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
  14. 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
    ...
  15. 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
  16. 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
  17. 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...
  18. 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...
  19. 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
  20. Replies
    4
    Views
    593

    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...
  21. Re: [RESOLVED] Change "Resolved" back to an open thread?

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

    well it was working long before the double posting issue started
  23. 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
  24. Replies
    5
    Views
    320

    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...
  25. 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?
  26. Re: [RESOLVED] Change "Resolved" back to an open thread?

    if they are the thread starter?
  27. Replies
    5
    Views
    320

    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...
  28. Replies
    6
    Views
    469

    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...
  29. Thread: Monitor

    by westconn1
    Replies
    15
    Views
    1,083

    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...
  30. 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...
  31. 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...
  32. 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 >...
  33. Replies
    13
    Views
    676

    Re: save as comma delimited csv file

    if you can post a sample of the text file that is saved and make a matching sample csv as desired, to compare, someone may be able to do the conversion, for you

    but running the project or...
  34. Replies
    13
    Views
    676

    Re: save as comma delimited csv file

    the above codes only save the content of the textbox to file, i very much doubt anyone here can help without knowing exactly what the content of the textbox would be, like where commas have to be...
  35. Re: Copy & Paste if condition met with add & subtract

    have you tried doing any of this yourself?
    in these forums wee try to help people with code they are having problems with, we are not a free code writing service
    you have had several examples of...
  36. Re: If column C has blank cell then delete that entire row in two files(macro correct

    that was not specified anywhere i saw in the thread, i only answered the question in this thread about empty sheet or no data, i presumed the existing code (do your other stuff) must do whatever else...
  37. Re: Cut & paste the data to new sheet if condition matches

    i must have missed the last line when i copy and pasted, after the last end if
  38. Re: If column C has blank cell then delete that entire row in two files(macro correct

    just add refference to the worksheet object

    Set wb = Workbooks.Open(Stear)
    Set ws = wb.Worksheets(1)
    ' test this first
    If IsEmpty(ws.UsedRange) Or...
  39. Re: Cut & paste the data to new sheet if condition matches

    you can test this to see if it does what you require
    Dim wb As Workbook, output As Worksheet, rng As Range, rw As Long
    Set wb = Workbooks("1.xls") ' if already open
    ' OR
    Set wb =...
  40. Replies
    2
    Views
    333

    Re: Close.xls file by a macro

    if the macro will be in the workbook you want to close

    thisworkbook.close, false ' true if you want to save it
    if that is the only workbook open and you want to close excel as well, add
    ...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width