S
Steve North
*New to VBA coding*
I've been trying to figure this out for a while to
minimise the amount of pieces of paper having to be
printed and a quicker way to complete set tasks in an
administrative setting.
Currently I have approximately 40 seperate calenders for
items that are booked throughout the department, in which
I monitor through out the day. Currently I'm going Open -
Other User's Folder - (Folder Name) - Print copy.
What I've been trying to find is a macro that will import
each appointment from the 40 calenders on a current day
and export it into excel to a specified template.
The template is used for a listing of vehicle bookings
made by other staff members, each vehicle has it's own
calender folder and I want to be able to open all
calenders and copy the appointments to excel without
having to do it manually.
Can someone tell me if this is possible and if so how?
I've been trying to figure this out for a while to
minimise the amount of pieces of paper having to be
printed and a quicker way to complete set tasks in an
administrative setting.
Currently I have approximately 40 seperate calenders for
items that are booked throughout the department, in which
I monitor through out the day. Currently I'm going Open -
Other User's Folder - (Folder Name) - Print copy.
What I've been trying to find is a macro that will import
each appointment from the 40 calenders on a current day
and export it into excel to a specified template.
The template is used for a listing of vehicle bookings
made by other staff members, each vehicle has it's own
calender folder and I want to be able to open all
calenders and copy the appointments to excel without
having to do it manually.
Can someone tell me if this is possible and if so how?