Execute code in a loop - Question

[Les]

Hello all, i am not a programmer so forgive the type of questions. Is it
possible to run code to manipulate a document if it is opened within a loop
and once finished the loop continues ?

 

[Sam Wilson]

Hi Les, yes it is:

sub demo()

dim wb as work book
dim s as string
dim i as integer

s= "C:\Filepath\File.xls"

for i = 1 to 10
Set wb = Workbooks.Open(s, False)

'Write your code in here

wb.Close
next i

end sub

 

[Les]

Thanks Sam, much appreciated
--
Les

Hi Les, yes it is:

sub demo()

dim wb as work book
dim s as string
dim i as integer

s= "C:\Filepath\File.xls"

for i = 1 to 10
Set wb = Workbooks.Open(s, False)

'Write your code in here

wb.Close
next i

end sub