Search:
Type: Posts; User: nealb
Search:
Search took 0.02 seconds.
-
Thanks Elroy. Makes sense. I think I'll do the same.
Neal
-
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...
-
Thanks very much Elroy. Hugely appreciated. I will have a go at changing my code to work with a document object......
-
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...
-
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?
-
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.
-
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...
-
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....
-
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.
...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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
...
-
-
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...
-
My windows build which is effected is Windows 10 Pro 64 Bit - 1909 (OS Build 18363.1500)
-
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.)
-
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)
...
-
Thanks for replying but it's not that unfortunately.
-
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...
|
Click Here to Expand Forum to Full Width
|