Search:

Type: Posts; User: westconn1

Page 1 of 13 1 2 3 4

Search: Search took 4.85 seconds.

  1. Replies
    4
    Views
    149

    Re: Word Template Not Found

    the path shown in the above should not cause an issue, but some other paths may do so if affected by virtualization
  2. Replies
    12
    Views
    5,271

    Re: *Resolved* Checkbox VBA Syntax?

    this is an old thread from 2004 and the people who were posting here may well no longer visit this forum, you should have started a new thread

    i do not have office 2019, but i guess you should...
  3. Re: Autofilter Criteria Array Parameters

    maybe

    strdate = "9/1/21"
    .Range("$A$1:$D$233").AutoFilter Field:=1, Operator:=xlFilterValues, Criteria2:=Array(2, Format(CDate(strdate), "mm/dd/yyyy")
    should fix issues, but i just hate...
  4. Replies
    11
    Views
    447

    Re: How to query an open ListObject?

    there is some difference in the ace connection strings for the different type of workbooks, to tell if it is macro enabled or binary type, if you need more on that you should be able to find at...
  5. Replies
    11
    Views
    447

    Re: How to query an open ListObject?

    but it could read from the open workbook without using sql, that is why i asked about the size of the data
  6. Replies
    4
    Views
    195

    Re: range testing

    there is no issue with using the same variable for 2 ranges, but not within a for each loop of the variable, as at that point the variable is locked

    you do not actually nee to use a variable to...
  7. Replies
    2
    Views
    183

    Re: Class not registered using Selenium

    i note in vbs you use selenium.chromedriver, whereas in vb, you use webdriver

    have you tried dumping the vbs code (createobject) into a sub, or adding a class to your vb6 project
  8. Re: How to open a macro given word document, like a docx the abilty to be viewed in R

    DOCX specifically can not contain any VBA macros, you would have to saveAs DOCM
  9. Replies
    4
    Views
    195

    Re: range testing

    i have no idea, from the description, what your end game is
  10. Replies
    11
    Views
    447

    Re: How to query an open ListObject?

    i can not answer this, but as it would not have to read the open workbook, it may not be causing the same issue

    i have used ADO against open workbooks many times for limited operations, without...
  11. Replies
    3
    Views
    126

    Re: Find -$####.#### or $####.###

    @ Zvoni, as he says it is a single column containing description first and value i would assume they would have to be a string, but without clarification (like a sample workbook) i can only guess
    ...
  12. Replies
    11
    Views
    447

    Re: How to query an open ListObject?

    options may be affected by the amount of data in the list object

    can you post a workbook with sample data?
    could you read the data into a disconnected recordset, then work from that?
  13. Replies
    3
    Views
    126

    Re: Find -$####.#### or $####.###

    i am not clear if you want all the values in a separate column from the description, the above comment indicates the description would still be in the same column


    this formula will put all the...
  14. Re: ftp upload,download by vb6,How many ways are there?

    i was using a shell object to read ftp directories exactly the same as on a local machine

    i posted a sample to read all subdirectories from an FTP site into a treeview, with almost no changes it...
  15. Re: Please how to know the number of items in a listview column?

    you can try like this to count all columns of subitems into an array

    Dim cnt() As Long, i As ListItem, s As Long
    With ListView1
    ReDim cnt(.ColumnHeaders.Count - 2)
    On Error Resume Next...
  16. Replies
    5
    Views
    250

    MsOf365 Re: Outlook forward item

    ?newitem.bodyformatreturns 1 for plain text and 2 for html
  17. Replies
    5
    Views
    250

    MsOf365 Re: Outlook forward item

    i noted the use of + instead the correct &, but did not think it was the cause of your problem

    for htmlbody you should use html code for break <B> instead of vbnewline, try like
    ...
  18. Replies
    5
    Views
    250

    MsOf365 Re: Outlook forward item

    you have an extra . in your message object and you need to use double quotes, should be more like

    Newitem.body =newitem.body & vbnewline & "text to add"

    or if it is an HTML email maybe
    ...
  19. Replies
    2
    Views
    2,282

    Re: Using XPath with ID, not a path

    derlee made 1 post in 2013, i doubt he will be watching this thread

    probably microsofthtml object library
  20. Re: String has quote by default. How to remove that quote from stringin VBA EXCEL?

    have you tried the parameters for find? lookAt should allow to specify xlPart that should find the value between the quotes
  21. Replies
    5
    Views
    362

    Re: Office 365 Pros and Cons

    personally i think your windows version is more of an issue than the office version
  22. Replies
    1
    Views
    380

    Re: Voice chat over lan in word environment

    i am sure there are some samples for chat programs in the codebank for vb6 and earlier
    while these are probably based for use on the internet, you should be able to limit any of them local area...
  23. Replies
    11
    Views
    516

    Re: BrowseForFolder

    i also prefered XP, and stayed with it for some time,
    i ended up giving up on XP when firefox kept falling over and some other problems, plus some of my VB programs did not work correctly for people...
  24. Replies
    11
    Views
    516

    Re: BrowseForFolder

    there are some threads in this forum detailing how to install vb6 onto w10, as long as you have install disks, maybe bout time you upgraded
  25. Replies
    4
    Views
    378

    Re: Updating formulas for future rows

    most code i write is just to add a missing functionality to someoneelses commercial program, very simple stuff mostly

    the above spreadsheet was created by a friend, i have been updating it...
  26. Replies
    4
    Views
    378

    Re: Updating formulas for future rows

    i think i have solved this with a vba code
    but now the whole problem has become irrelevant, as the spreadsheet will probably be obsolete in a short time, and only kept for history

    how things...
  27. Replies
    4
    Views
    378

    Updating formulas for future rows

    i have a formula that i may need to change the ranges within the formula on occasion, without affecting results for previous rows
    a simple example is

    =C5*P$3-F5+N4, where c5 is in the current...
  28. MsOf10 Re: What can cause Excel to think I have over a million rows

    i do not see where is the problem with the worksheet, but
    you can try some variation of this code to fix the workbook


    Sub dr()
    Dim r As Range, ns As Worksheet
    lr = Cells(Rows.Count,...
  29. MsOf10 Re: What can cause Excel to think I have over a million rows

    1,048,576 is the last row on a sheet, so it appears that the entire sheet is being used

    out of interest how many columns does it think you are using? 16384 is the number of columns on a sheet

    i...
  30. Re: Use special characters as a prefix for function or variable names

    i doubt if it would cause a problem as the ide does not allow such in an english version, must start with an alpha only
  31. Replies
    6
    Views
    401

    Re: Novice Macro Amendment Question

    try like

    lastrow = cells(rows.count, 3).end(xlup).row
    range("c2").resize(,lastrow -1).copyno need to select the cells to copy
  32. Re: Syntax Styles, Shortcuts and binding in VBA

    is that different than if the variable are fully dimensioned? i don't believe so, the bigger issue there is the possibly incorrect use of & or +, depending on the desired result
  33. Replies
    11
    Views
    803

    Re: Fast Ping (non-blocking)

    seems to be a far from perfect solution
  34. Re: Syntax Styles, Shortcuts and binding in VBA

    unlike some other languages where all variables on a line are defined by the last type
    vb6 /vba has to have every variable type defined individually, makes this shortcut style attractive

    i...
  35. Replies
    11
    Views
    803

    Re: Fast Ping (non-blocking)

    have a look at the code posted by olaf
    https://www.vbforums.com/showthread.php?729677-need-help-on-multi-thread-pinger&p=4476707&viewfull=1#post4476707

    i also have some similar code (no idea...
  36. Replies
    9
    Views
    674

    Re: PictureBox Question

    182219this is the project as downloaded from microsoft, you will have to adapt the code to your project
  37. Replies
    9
    Views
    674

    Re: PictureBox Question

    you can resize the the form to fit the desired size
    microsoft had an example for this (printing the form into the picturebox regardless of the size of the form, or whether it was all visible on the...
  38. Replies
    7
    Views
    462

    Re: [RESOLVED] crossword answer vb6

    oops an array of textboxes, glad you got it to work
  39. Re: VB6 exe doesnt work on Windows 10 as well as previous Windows systems.

    Many things

    probably not

    post the parts of the code that are causing issues, including variable and API declares
  40. Replies
    7
    Views
    462

    Re: crossword answer vb6

    you could try like

    For Count = 1 To 25
    oIE.document.All.Item("tasks[" & (Count + 5640) & "]").Value = me.controls("textbox" & count).text
    Next Countno need for double loops, which was...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width