Search:

Type: Posts; User: westconn1

Page 1 of 13 1 2 3 4

Search: Search took 2.27 seconds.

  1. Re: [RESOLVED] Read Text file and make changes to text by searching a string

    i was able to make the large file sample to work with minor changes, but files larger than this are untested and may require recoding

    make change to these lines like

    Dim intI As Long
    ...
  2. Re: [RESOLVED] Read Text file and make changes to text by searching a string

    post a sample a larger data file to test with
    my test with larger data files errored when the HDD was full and had run overnight

    other possible issues could be memory hard drive free space
    post...
  3. Replies
    21
    Views
    2,463

    Re: [RESOLVED] Read Text file and make changes

    i am not sure that i have seen doogle here for some time

    this last post is the same as in your other thread, as both threads are from more than 2 years ago, you should have started a new thread...
  4. Re: [RESOLVED] Read Text file and make changes to text by searching a string

    please explain better, what should string 3 now be, and what is the criteria for the option of + or - and detail what the output line should look like with example including content of text1
    ...
  5. Replies
    4
    Views
    284

    MsOf365 Re: Delete blank columns with VB.NET

    also you do not need to loop all columns, just the columns within the usedrange

    if the usedrange contains a large number of columns it may well be much faster to add the empty columns to a non...
  6. Thread: Excel timer

    by westconn1
    Replies
    7
    Views
    392

    Re: Excel timer

    i am guessing that you want the message box when the time some initial value in d29 gets to 0 so the msg should be between testing the value of d9 and exit sub
    like
    If Range("D9").Value = 0 Then ...
  7. Re: How to save and read it back to last save (text file)

    it is a bit unclear what you want, but maybe :-

    in the text1.keypress event > open the file for append, > print the keyascii character

    use the Form_Unload event to save the content of the...
  8. Replies
    10
    Views
    1,483

    Re: VBA Macro gets slower with every execution

    if you want to post a workbook with the code and some sample data /workbook files i can try to see if the same problem exists here and if i can find a solution, but it might take a while as i only...
  9. Re: Problem with Automating Excel from VB6

    there was some thread in OD recently that was having similar problems with opening templates, i think a vb.net VSTO addin

    i think the work around was to open an empty workbook as per the template...
  10. Re: Fast Call Dll has a bug , how to fix it ?

    a bit more information may get you more assistance, rather than expecting people to open your project then try to find the bug
  11. Re: Setting Edge Default Download Folder via Registry

    this looks like a profile ID, but does it match your current profile ID?
  12. Re: References to Excel that worked in previous versions of VS not working in VS 2019

    have you tried fully qualifying the application and other objects?
  13. Replies
    2
    Views
    224

    Re: INTERCEPT the and of printout job

    why would you use the activesheet object when you already have a worksheet object of the sheet you want to print

    WS.PrintOut Copies:=1, Collate:=True
  14. Re: Runtime error 32813 - Method 'Name' of object '_VBComponent' failed

    i would believe that to complete the removal of the module the code must finish or break, for testing, you could try a stop statement after the removemodulefromaddin

    one work around maybe to...
  15. Re: How to change the computer date format to the following format???

    in most cases you should not change the users settings for date format, make your program work with their settings
  16. Re: Need little help to save my form settings

    probably need to find the correct ID for each record before editing
  17. Re: Macros run slower and slower every time I run them.

    there was a fairly recent thread in this forum that had similar problems, may be worth looking back at that to see if they reached any solution there
  18. Replies
    2
    Views
    350

    Re: Nuance PDF VB

    without ever having heard of nuance before, looks like you specify to insert 2 pages after the first page, though that does not indicate why the document should be truncated by 1 page

    maybe...
  19. Replies
    5
    Views
    386

    Re: Possible help for someone with no clue!

    i thought i had taken out all the single quotes as it appeared they are not actually in the email, but i see they are still included and would need to be removed in 3 lines
  20. Replies
    5
    Views
    386

    Re: Possible help for someone with no clue!

    yes and maybe

    assuming that the email body is html this code would do part of what you want
    With msg
    .HTMLBody = "Hi" & "<br>" & .HTMLBody
    .HTMLBody = Replace(.HTMLBody, "'Location'",...
  21. Replies
    6
    Views
    532

    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
  22. Replies
    12
    Views
    5,542

    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...
  23. 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...
  24. Replies
    11
    Views
    810

    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...
  25. Replies
    11
    Views
    810

    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
  26. Replies
    4
    Views
    422

    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...
  27. Replies
    2
    Views
    270

    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
  28. 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
  29. Replies
    4
    Views
    422

    Re: range testing

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

    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...
  31. Replies
    3
    Views
    318

    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
    ...
  32. Replies
    11
    Views
    810

    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?
  33. Replies
    3
    Views
    318

    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...
  34. 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...
  35. 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...
  36. Replies
    5
    Views
    483

    MsOf365 Re: Outlook forward item

    ?newitem.bodyformatreturns 1 for plain text and 2 for html
  37. Replies
    5
    Views
    483

    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
    ...
  38. Replies
    5
    Views
    483

    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
    ...
  39. Replies
    2
    Views
    2,425

    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
  40. 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
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width