LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 258
Default Speed up Program Process

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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
WORD VBA program, can only process 50 documents at a time. bobk544 Excel Discussion (Misc queries) 0 February 9th 07 06:12 PM
Speed up the process Ali Baba Charts and Charting in Excel 2 October 3rd 05 06:40 PM
How to count process running time ( process not finished) miao jie Excel Programming 0 January 13th 05 09:23 AM
Question to speed up a process - Patrick[_5_] Excel Programming 0 April 6th 04 04:17 PM
program speed problem chris[_3_] Excel Programming 1 September 11th 03 02:05 AM


All times are GMT +1. The time now is 05:37 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"