I have an Access 2000 mdb file which opens MS Word docs using automation.
Our WAN is somewhat slow, and it takes about six seconds to open Word and
the specified document (20 KB) from within Access using automation. I also
noticed that if I use Shell to open Winword and the document, or if I just
enter the document name from a Command window, it also takes 6 seconds.
However, if I double-click on the file from Windows Explorer to open Word
and the file, it only takes 4 seconds.
Any ideas as to why opening the file from Windows Explorer is faster than
any of the other above-mentioned methods?
Thanks. 2 2335
It may have to do with Caching. Once a file has been opened once, it will
open quicker the next time. There may also be something in Explorer that
pre-caches some aspect of opening the file when it sees it as you browse the
folder (such as already having the connection to the network folder open),
but this has to be done without warning when you call the file from within
code.
--
Wayne Morgan
MS Access MVP
"Neil" <no****@nospam. net> wrote in message
news:T8******** *********@newsr ead1.news.pas.e arthlink.net... I have an Access 2000 mdb file which opens MS Word docs using automation. Our WAN is somewhat slow, and it takes about six seconds to open Word and the specified document (20 KB) from within Access using automation. I also noticed that if I use Shell to open Winword and the document, or if I just enter the document name from a Command window, it also takes 6 seconds. However, if I double-click on the file from Windows Explorer to open Word and the file, it only takes 4 seconds.
Any ideas as to why opening the file from Windows Explorer is faster than any of the other above-mentioned methods?
Thanks.
You're actually using three different methods to open the file
Automation
Command line
DDE
Having said that, entering the document path alone in the run box or double
clicking on the file should both be using DDE. teh difference in results
could be doe to cacheing or some other network glitch of which we are
unaware.
In order to get a statistically sound group of tests I would try all the
methods at least 10 times each and take the average time before comparing.
--
Terry Kreft
"Neil" <no****@nospam. net> wrote in message
news:T8******** *********@newsr ead1.news.pas.e arthlink.net... I have an Access 2000 mdb file which opens MS Word docs using automation. Our WAN is somewhat slow, and it takes about six seconds to open Word and the specified document (20 KB) from within Access using automation. I also noticed that if I use Shell to open Winword and the document, or if I just enter the document name from a Command window, it also takes 6 seconds. However, if I double-click on the file from Windows Explorer to open Word and the file, it only takes 4 seconds.
Any ideas as to why opening the file from Windows Explorer is faster than any of the other above-mentioned methods?
Thanks. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: mic |
last post by:
I'm currently trying to write an MSIE automation software and have run into
such problem - have no idea how to take control of external popup windows -
I use WebBrowser COM object and am able to catch the NewWindow2 event, but
don't know how to change 'focus' to other than main explorer window. I tried
to use winguiauto package and am able to get the HWND of the 'Internet
Explorer Server' control located in that new window, but I don't know...
|
by: asadhussain |
last post by:
I wrote a plugin to internet explorer that requires internet explorer
to be shutdown and restarted. I figured out a way to shut down IE using
the MSI and to start it back up using VBScript.
I was wondering if there was a way to remember what webpage each
internet explorer process was on and then open up internet explorer
windows that open up to the URLs that the user was visiting previously.
Any insights?
|
by: Robert |
last post by:
---EN---
This message has been crossposted in a french speaking newsgroup,
english version is at the end. Thanks a lot for your help...
--/EN---
Bonjour,
Je développe une application intranet qui "tourne" maintenant depuis
plusieurs années auprès de 2500 personnes environ, mais depuis 1 mois,
|
by: qwweeeit |
last post by:
Hi all,
Elliot Temple on the 1 June wrote:
> How do I make Python press a button on a webpage? I looked at
> urllib, but I only see how to open a URL with that. I searched
> google but no luck.
> For example, google has a button <input type=submit value="Google
> Search" name=btnG> how would i make a script to press that button?
I have a similar target: web automation, which
|
by: TR |
last post by:
Hi,
We have some code that uses automation to create/manipulate word
documents. This runs in a batch mode, generating dozens of documents in
sequence. The code works great, but while the automation code is working
in word, care must be taken not to "interrupt" it with a keystroke or
mouse-click, otherwise the current selection gets put somewhere its not
supposed to be, and subsequent code will fail. This means that while it
is running,...
| |
by: scorpion53061 |
last post by:
My boss is more and more asking me to get into areas of report formatting
and such with the primarily database apps that I write.
I am not pleased with Crystal and some of the pitfalls I have seen with this
particualar report tool.
I would like to delve into Word automation ( I believe you can control page
breaks and such with this). Can someone point me to a good how to with the
various methods available there?
|
by: RJB |
last post by:
I'm working on a VB application that must run 24x7 for a LONG time,
think 60 days of so. As part of what it does it must automate an
instance of IE and navigate to many different URLs, think many
thousands.
Issue 1: Most of the time, these navigations succeed. All is well.
But, based on early runs, from time to time, say once or twice every
24 hrs IE inexplicably hangs and the automation object hangs, gets
stuck, becomes...
|
by: HS1 |
last post by:
Hello
Could you please help a code so I can open a folder in windows explorer when
I click a button, (e.g explorer automation)
Thank you
SH
|
by: Nitin Mittal |
last post by:
Dear Sir
I have a created a Web Service that uses ShDocVw.Dll and
Microsoft.mshtml.dll for IE automation. For the development I am using VS
2005 installed on Windows 2000 Professional System. In my application, I use
IE instance to navigate to certain site. This application runs fine on the VS
Development server but when I deploy it on Windows 2003 server, my IE
instance is unable to navigate to the specified page. However if I specify...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |