View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
BOSS BOSS is offline
external usenet poster
 
Posts: 123
Default screen updating file open

I will pull my hairs off if it does not solve..

screenupdating not getting disabled. pleas ehelp




Sub Main_Steady()

Dim sfile As String, spath As String
Dim intflfound As Integer
Dim fundgrp As String
Application.ScreenUpdating = False
sfile = "Steady"

i = 6

For sht = 55 To Sheets.Count 'sheets count

fundgrp = Sheets(sht).Name

spath = "G:\US_IS\Cash_Project\Metrics\Year 2008\" & fundgrp & "\New"

With Application.FileSearch
.NewSearch
.LookIn = spath
.Filename = sfile
.SearchSubFolders = True
.MatchTextExactly = False
'.MatchAllWordForms = True
.Execute

If .FoundFiles.Count = 0 Then

ThisWorkbook.Sheets("Reports").Range("b" & i).Value = spath
ThisWorkbook.Sheets("Reports").Range("a" & i).Value = fundgrp

i = i + 1

Else

For intflfound = 1 To .FoundFiles.Count ' found file



Workbooks.Open Filename:=(.FoundFiles(intflfound)),
UpdateLinks:=0

x = ActiveWorkbook.Name
Sheets("Cash Availability").Activate

If Run("'" & ActiveWorkbook.Name &
"'!Cash_Availability.cash_availability") Then

ThisWorkbook.Sheets("Reports").Range("b" & i).Value
= spath
ThisWorkbook.Sheets("Reports").Range("a" & i).Value
= fundgrp

i = i + 1

Else

For co = 2 To 24 'for all count
For ro = 6 To 28 Step 2 'for all count

On Error Resume Next

ThisWorkbook.Sheets(fundgrp).Cells(ro, co).Value =
ThisWorkbook.Sheets(fundgrp).Cells(ro, co).Value + _
ActiveWorkbook.Sheets("Cash Availability").Cells(ro, co).Value

Next 'for all count

Next 'for all count


For ro = 11 To 29 Step 6 'quater count
For co = 2 To 24 'quarter count


ThisWorkbook.Sheets(fundgrp).Cells(ro, co).Value =
ThisWorkbook.Sheets(fundgrp).Cells(ro, co).Value + _
ActiveWorkbook.Sheets("Cash Availability").Cells(ro, co).Value


Next 'quarter count
Next 'quarter count


For ro = 31 To 31 'year count
For co = 2 To 24 'year count

ThisWorkbook.Sheets(fundgrp).Cells(ro, co).Value =
ThisWorkbook.Sheets(fundgrp).Cells(ro, co).Value + _
ActiveWorkbook.Sheets("Cash Availability").Cells(ro,
co).Value

Next 'yr count
Next 'yr count


End If

Workbooks(x).Close SaveChanges = "No"




Next
End If
End With


Next

Sheets("reports").Activate

End Sub