Pause between sheets
try this, just change test.xls to whatever the name of the file you're opening
is. this works if they're in the same folder
Option Explicit
Sub display_sheets()
Dim i As Long
Dim fpath As String
Dim wb1 As Workbook
Dim wb2 As Workbook
fpath = ThisWorkbook.Path
Set wb1 = ThisWorkbook
Set wb2 = Workbooks.Open(fpath & "\test.xls")
Dim ws As Worksheet
For i = 1 To 3
For Each ws In wb2.Worksheets
ws.Activate
Application.Wait (Now + TimeValue("0:00:03"))
Next
Next
wb2.Close savechanges:=False
End Sub
--
Gary
wrote in message
...
Not really
I think it is trying to work but I have two different spread sheets
open and it is trying to cycle through through the wrong one
|