How to Cycle through open workbooks

[Buster]

How do I cycle through the open projects and perform a series of vba steps
on each sheet?

I want to be able to run my macro that exports timescaledata into excel on
each open project

Buster

 

[Rod Gill]

Hi,

Try:
Dim proj as Project
For each proj in application.Projects
'process schedule
next proj

--
For VBA posts, please use the public.project.developer group.
For any version of Project use public.project
For any version of Project Server use public. project.server

Rod Gill
Project MVP
For Microsoft Project companion projects, best practices and Project VBA
development services
visit www.project-systems.co.nz/
Email rodg AT project-systems DOT co DOT nz