Search:

Type: Posts; User: westconn1

Page 1 of 13 1 2 3 4

Search: Search took 0.11 seconds.

  1. Replies
    2
    Views
    175

    Re: VB6 chat client over internet

    i am sure there is a chat client server example in codebank vb6
  2. MsOf10 Re: Speed up the copying of data from one worksheet to another

    copy the complete ranges into arrays change all the data in the array and rewrite to cells, will be much faster
  3. Re: Increase number of undos in VBIDE for VBA7.dll

    feed it
  4. Replies
    6
    Views
    262

    Re: Urgent need this done simple code

    you can try like

    Set sh = CreateObject("shell.application")
    Set n = sh.Namespace(Text11.Text & "downloaded\kof95.zip")
    Set nn = sh.Namespace(Text11.Text & "downloaded\")
    dest = nn.self.Path &...
  5. Replies
    7
    Views
    352

    Re: Handling Non-Existent Printer Error

    test for each p in printers then set one that is known can work without error, may need to test if printer is online
  6. Replies
    6
    Views
    262

    Re: Urgent need this done simple code

    that looks like a slow way to do it
    just loop through the files in the zip and use dir (or the shell equivalent) to check if each already exists in the destination, if not then extract, no need to...
  7. Replies
    6
    Views
    341

    Re: Combing Macros For Copying Ranges

    i thought you might need to move down a row, if not offset(0) can be omitted

    Range(aa).Select

    i would, as far as possible, avoid working with active anything, also avoid selecting ranges or...
  8. Replies
    6
    Views
    341

    Re: Combing Macros For Copying Ranges

    looks like what i was suggesting, does it work as desired?
  9. Replies
    6
    Views
    341

    Re: Combing Macros For Copying Ranges

    you can use the address of the activecell to return to it like


    Sub Macro1()

    Dim ws As Worksheet

    Set ws = Sheets("INTERNAL")

    If ActiveCell.Column = 2 Then
  10. Replies
    3
    Views
    274

    MsOf365 Re: Create macro to censor documents

    are the parts to be replaced always like Name : some Name
    and Address : 22 some AddreSS ?

    do i assume this is to be done in Word?
  11. Re: [VBA]: Regular Expression Pattern: Replace & ignore line feeds

    if there are multiple different characters you could create a loop to replace each one
  12. Re: [VBA]: Regular Expression Pattern: Replace & ignore line feeds

    perhaps, if this is an isolated case, you could replace chr(160) with chr(32) before the regex
  13. Re: Application.ScreenUpdating = false does not work

    i guess the question here is- do the document images update in the document when compressed during the iteration of the loop? the flickering of a command bar may not necessarily be considered a...
  14. Replies
    2
    Views
    357

    Re: Open vba excel form from vb6

    create a public sub in excel std module (workbook with user form)


    Sub ufshow()
    TanSuat.Show
    End Sub


    call it from vb
  15. Replies
    11
    Views
    617

    Re: Weird error

    but the recordset /data source has been closed already
  16. Replies
    9
    Views
    445

    Re: Running Macro Based On Checkbox

    the code will probably work if the code is on the codepane of the MAIN worksheet, else you would need to address the checkbox as an object of a shape object

    if you want to post a sample workbook...
  17. Re: need help to automate a copy to clipboard function

    you can easily copy all the fields in the email into a string, by appending each field, then copy the entire string into the clipboard

    where msg is a mailitem object that you have already assigned...
  18. Re: Access Print to pdf and lock pdf after printing

    there are pdf utilities that can secure files from commandline, which can be shelled from vba
    search on pdftools
  19. Replies
    5
    Views
    413

    Re: vb6 get multiple ip ping speed?

    there are some posts here using icmp

    try https://www.vbforums.com/showthread.php?893205-RESOLVED-Fast-Ping-(non-blocking)&highlight=multi+ping
  20. Replies
    4
    Views
    538

    Re: New to VBA and need help!

    possibly words built in autotext may be able to do what you want
  21. Replies
    2
    Views
    450

    Re: DAO Object invalid or no longer set

    if you movefirst after editing the record, does the loop work?
  22. Re: Help with vb code in Outlook 365 app

    you have some of your end if in the wrong place, code tested and working as below
    Private Sub m_Inspector_Activate()

    Dim Item As MailItem
    Dim Value As String
    If TypeOf...
  23. Re: Help with vb code in Outlook 365 app

    the problem you are having initially is an html format character within your string [TICKET] in the email
    so instr always returned 0 and the string to replace also not found, that is why it would...
  24. Re: Help with vb code in Outlook 365 app

    not really, if nothing is put in the name box it should just skip and go to the ticket box

    only thing i can think of is if the inspector is activated again, casing an endless loop
    it would be...
  25. Re: Help with vb code in Outlook 365 app

    how does the code progress? do you get any error? is the name actually replaced with the desired name value?
    if you leave the first inputbox blank, does the second inputbox show?

    can you post a...
  26. Re: Get list of files and folders that changed after certain moment

    you can monitor a folder and subfolders for files that are changed created or deleted, i use this just to monitor for files that are created, but plenty more options, you would have to find some...
  27. Replies
    1
    Views
    578

    Re: [Excel] Find Value and Paste X Below It

    something like

    set fnd = sheets("sheet2").range("optionsrange").find(sheets("sheet1").range("a2"))
    fnd.offset(1) = "X"
  28. Replies
    22
    Views
    1,370

    Re: [RESOLVED] LibreOffice

    thanks for posting your solutions
  29. Replies
    8
    Views
    627

    Re: Error while adapting VBA code

    that is exactly what i was talking about

    even if they work in vba, you should try to avoid working with active anything, or the selection object, even in vba, they can lead to errors
    and in vb6...
  30. Re: VBA script to hide/unhide rows not unhiding... but no errors

    i am not sure why you are iterating all the checkboxes as you do nothing with any result from the loop and the chk object goes out of scope at the end of the procedure
    also you do not specify which...
  31. Replies
    8
    Views
    627

    Re: Error while adapting VBA code

    if you develop your code using early bindings it may be a lot easier, then change to late binding before deploying

    ie. add a reference to word and declare strongly typed variable while writing the...
  32. Replies
    8
    Views
    627

    Re: Error while adapting VBA code

    Wdoc is a document object, i doubt that you should refer to the activedocument of a document
  33. Replies
    9
    Views
    875

    MsOf365 Re: Add second sheet to Workbook in Code

    yes, only one at a time but they are separate, as your code always creates a new instance of excel
    when append = false a new workbook is added
    when append = true, no workbook is added and no...
  34. Re: Show available workbooks in date descending order

    i believe you can subclass the dialog to change the sort order or the sort by
    but as this is a much later version of office i have no idea if it will work for you
  35. Replies
    1
    Views
    351

    Re: Extract text from HTML

    what code have you tried so far?
    we are not here to do it all for you, more to help you to do it yourself
    there would be several methods to achieve the desired result

    here is an example of one...
  36. Replies
    9
    Views
    613

    Re: sendmessage/postmessage Outlook

    outlook main window has many child windows, so you may be trying to send the messages to wrong window, try using spy+ or similar to see if you are in the correct window
  37. Replies
    9
    Views
    875

    MsOf365 Re: Add second sheet to Workbook in Code

    one problem is that the xlapp you have created is a new instance of excel which will have no existing workbooks, probably you need to use getobject to return an already open workbook, or if known,...
  38. Re: Microsoft Visual Basic for Applications- Compile error: Invalid use of property

    should be sheets.count
  39. Re: how to read registry all valus or keys?RegEnumKeyEx,RegEnumValue

    i did some of this a while ago, see https://www.vbforums.com/showthread.php?567903-list-all-keys-subkeys-and-values-in-registry-hive&p=3687866&viewfull=1#post3687866
  40. Re: [Outlook] Macro to change proofing language of selected text

    if outlook is using word as its email editor, then it should just work, if outlook is the default editor then i doubt there is any way to make it work in outlook

    it may be possible to copy the...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width