Run Time 1004 - App Defined or Object defined error with String defined path structure

Hi Folks,

I have a scenario where I print reports for management based upon job task, these reports are weekly under most cases and range across different staff levels. To counteract this and minimise code I have the following basic code

Please Login or Register  to view this content.

This code works but requires manual change every week for the report name and also it has too many fixed variables for my liking.

Changing the code to the include variables causes issues when using ReportWeek inside the path name, changing this to a separate variable also does not change the result, hard coding this into the code which works as above will not provide the required result due to the changes needed to be made each week.

Please Login or Register  to view this content.

Does anyone have any ideas on how to rectify this issue? to allow correction of my actual code base as below

Please Login or Register  to view this content.

Thanks in advance

Leith,

After annonmising the book and shrinking it as much as I could it's down to just over 2mb here

Thanks

Iain

Problem resolved

This code

Please Login or Register  to view this content.

Should have been this

Please Login or Register  to view this content.

What's the old saying - Garbage In - Garbage Out
or was it
User Error - Replace User and press any key to continue