Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / January 2006

Tip: Looking for answers? Try searching our database.

Speed up Program Process

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
maperalia - 26 Jan 2006 17:32 GMT
I have a program (see program below) that sometimes takes several minutes to
run .
I wonder if there is any way to speed up the program.

Thanks in advance.
Maperalia

Option Explicit

Sub OpenReport()
Dim wordApp As Object
Dim fNameAndPath As String
Dim Filename As String
Dim sPath As String
Dim WO As String
Dim Progname As String
Dim myDateTime As String

Application.ScreenUpdating = False
WO = Worksheets("Template").Range("A1")
myDateTime = Format(Worksheets("Template").Range("A2").Value, "yyyymmdd")
Filename = "" & WO & "_M_" & myDateTime & ""

Dim sDocName As String
sDocName = Replace(sPath, ".xls", ".doc")

fNameAndPath = "S:\Test\" & Filename & ".doc"
Set wordApp = CreateObject("Word.Application")
wordApp.Documents.Open (fNameAndPath)
wordApp.Visible = True
wordApp.Activate

End Sub
Bill Martin - 26 Jan 2006 18:27 GMT
Although I can't see how it would help, when in doubt I always put in

 Application.Calculation = xlManual

I don't understand your code though.  For example why do you add null strings to
the front and back of Filename?

And what's up with the sPath variable?  You don't assign it, but use it to call
a Replace(...) function that doesn't seem to be part of VBA so I presume it's a
UDF of yours?  What's it do?

I'd start by just putting MsgBox breaks scattered into the code until you can
figure out which line (or lines) are taking minutes to execute.

Good luck...

Bill
----------------------
> I have a program (see program below) that sometimes takes several minutes to
> run .
[quoted text clipped - 29 lines]
>
> End Sub
maperalia - 26 Jan 2006 18:58 GMT
Bill;
Thanks very much!!!. I have tried it but I do not have any different than
before....
I will keep my program as is because I do not know is server or my computer..

Best regards.
Maperalia

> Although I can't see how it would help, when in doubt I always put in
>
[quoted text clipped - 47 lines]
> >
> > End Sub
Bill Martin - 26 Jan 2006 19:54 GMT
And have you tried using the MsgBox commands (or the debugger) to step through
the code to see where all the time is actually consumed?

Bill
------------------------
> Bill;
> Thanks very much!!!. I have tried it but I do not have any different than
[quoted text clipped - 56 lines]
>>>
>>>End Sub
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.