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: 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
 
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
why would a excel file sent with data open as grey screen Lynne Excel Discussion (Misc queries) 1 August 25th 08 01:15 PM
use hyperlink to open file as front screen Kerry Excel Discussion (Misc queries) 0 October 30th 07 04:28 AM
Print multiple files from File Open screen MarvInBoise Excel Programming 0 August 28th 07 02:26 PM
File Open dialog box is full-screen...???? Tiscali Excel Discussion (Misc queries) 3 May 11th 07 10:34 AM
Screen Updating on Open Workbook PaulZ Excel Programming 1 June 29th 06 08:13 AM


All times are GMT +1. The time now is 03:01 PM.

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

About Us

"It's about Microsoft Excel"