Search:

Type: Posts; User: nealb

Search: Search took 0.02 seconds.

  1. Re: Word automation started giving errors - Now have to close and re-create Word obje

    Thanks Elroy. Makes sense. I think I'll do the same.
    Neal
  2. Re: Word automation started giving errors - Now have to close and re-create Word obje

    Hey Elory, Your code came in very useful to check against when I modified my code to use document objects :) Thanks.

    Can I check something with you please?

    I notice that in your WordOpenDoc...
  3. Re: Word automation started giving errors - Now have to close and re-create Word obje

    Thanks very much Elroy. Hugely appreciated. I will have a go at changing my code to work with a document object......
  4. Re: Word automation started giving errors - Now have to close and re-create Word obje

    Would you be kind enough to show me the code for how you deal with find and replace when the document is set as an object?

    Also under .activedocument I was able to return a variable if the text...
  5. Re: Word automation started giving errors - Now have to close and re-create Word obje

    Thanks for the code example. I will look into declaring the document as it's own object rather than using .ActiveDocument. I presume it's better to handle it this way then?
  6. Re: Word automation started giving errors - Now have to close and re-create Word obje

    Thats what I thought and thats what I was doing for years, but this week I started having problems with it as described in my original post. I have no idea why.
  7. Re: Word automation started giving errors - Now have to close and re-create Word obje

    I was creating only one instance of Word at the start of the program and then closing it at the end (and setting to nothing), after all the documents had been processed. I wasn't creating a Word...
  8. Word automation started giving errors - Now have to close and re-create Word object

    Hi,

    I have a VB6 program that performs Word automation. It processes a batch of invoices. Each invoice's details are populated into an existing Word document using Word find & replace commands....
  9. Re: MS Word security notice when creating a Word object and Word is already running

    Ha ha, that brings back memories. I did just that to create my Normal.dotm macros many years ago.

    I've transferred all my macros now into my VB6 programs and so far so good, they are working.
    ...
  10. Re: MS Word security notice when creating a Word object and Word is already running

    Thanks. I didn't realise I could run the exact same macro code within my VB6 program. Off to Google to see how to do it........

    *Update*
    I've sussed out what to do.
    Now in process of testing it...
  11. Re: MS Word security notice when creating a Word object and Word is already running

    When the line 'Set MSWord = CreateObject("word.application","localhost")' is executed, the ~WRCxxxx.tmp file gets created and the Word Security Notice appears.

    I cleared all the ~WRCxxxx.tmp files...
  12. MS Word security notice when creating a Word object and Word is already running

    I have a VB6 app that creates a Word object. (Windows 11 PC)

    DIM MSWord as object
    Set MSWord = CreateObject("word.application","localhost")

    The app calls macros that exist in Word template...
  13. Re: VB6 + Access 2000 MDB + DAO on Windows 10 - Very slow SQL queries

    Yes, doing it within my VB6 App. I have tried it on another Windows 10 PC (fresh install) and I get the same delay problem.

    No, I haven't run the SQL query in Access 2000 as I don't have Access...
  14. Re: VB6 + Access 2000 MDB + DAO on Windows 10 - Very slow SQL queries

    I looked at the post you referenced and tried to add the code mentioned, i.e. the SetDaoRegistryOverrideOptions sub. but my app gave me Error 3028 "Cannot start your application. The workgroup...
  15. Re: VB6 + Access 2000 MDB + DAO on Windows 10 - Very slow SQL queries

    Thanks for the advice re using UNC instead of mapped network drive assignments.

    I can rule out wi-fi as this is a wired desktop.

    I tend to agree about adding an extra MDB on the local is...
  16. Re: VB6 + Access 2000 MDB + DAO on Windows 10 - Very slow SQL queries

    Thank you for all the replies and help. I will go through each.........



    I copied the MDB to a folder on my C drive to try and rule out the file server. I ran the same query with varying...
  17. Re: VB6 + Access 2000 MDB + DAO on Windows 10 - Very slow SQL queries

    Thank you for your reply.

    The MDB is located on a network drive, accessed through a network share, e.g. o:\database.mdb

    So you're saying that the delay is entirely normal, and is due to Windows...
  18. VB6 + Access 2000 MDB + DAO on Windows 10 - Very slow SQL queries

    I have a number of VB6 apps that connect to an Access 2000 MDB database using DAO.

    I have just discovered that some SQL query code takes forever to complete in Windows 10. In most cases the app...
  19. Re: Rounding a 4 decimal place number to 2 decimal places

    Thanks for your replies.

    I always thought that rounding started with the furthest digit then work left, so 14.5548 becomes 14.555, which becomes 14.556, which becomes 14.56. I use Sage 50 accounts...
  20. Rounding a 4 decimal place number to 2 decimal places

    I have the following problem:

    I have a 4 decimal place number e.g. 14.5548 that I want rounded up correctly to 2 decimal places. So the correct rounded number in this example should be 14.56
    ...
  21. Re: [RESOLVED] Blank vertical scroll bar after Windows 10 update

    :thumb:
  22. Re: Blank vertical scroll bar after Windows 10 update

    The 20H2 build update became available to me this morning so I have installed it and hey presto, the scroll bars are now working !

    So everyone experiencing this problem should find it gets fixed...
  23. Re: Blank vertical scroll bar after Windows 10 update

    My windows build which is effected is Windows 10 Pro 64 Bit - 1909 (OS Build 18363.1500)
  24. Re: Blank vertical scroll bar after Windows 10 update

    Create a new project, put a single VScrollbar control on it and make an EXE. Run it in Win 10 and it appears as a white block.

    (I am creating the VB6 project within a Win 7 VM.)
  25. Re: Blank vertical scroll bar after Windows 10 update

    Thanks for responding. Well it's good that it's not just me, but a pain that Microsoft have broken something with this update.

    The update is: April 13, 2021—KB5001337 (OS Build 18363.1500)
    ...
  26. Re: Blank vertical scroll bar after Windows 10 update

    Thanks for replying but it's not that unfortunately.
  27. [RESOLVED] Blank vertical scroll bar after Windows 10 update

    My Windows 10 PC updated itself last night and today my VB6 apps that use the vertical scroll bar control, now show the vertical scroll bar as blank. They don’t have the up or down arrows or the...
Results 1 to 27 of 27



Click Here to Expand Forum to Full Width