MACRO Crash after moving workbook to share drive

Excel is just getting crashed... restarting

HI Dave.

DO you think you will be able to help me on this ?

Thanks

is F: the letter of the shared drive is mapped to on every users PC?

Hardcoded file locations can be problamatic if you do not change them.

The crashing is a bit odd but can have many causes.. nowdays sometimes firewall software or simular servermanagement tools may detect VBA script running to the shared drive and block that attempt causing excel crash.

Good evening Roel.

Yes, F: letter for all.
Do you want to say that it will be very difficult for VBA sheet to work on Share drive ?
I Will check with our IT Director tomorrow about possible issues regards to the VBA and Firewall ect.

Thank you

Originally Posted by Chu3

Yes, F: letter for all.
Do you want to say that it will be very difficult for VBA sheet to work on Share drive ?
Thank you

In general more difficult that a the harddrive on your own laptop over which you have full control / full rights.
But how much more difficult it is really all depends on how the shared drive is setup and how tight security is and the willingness to accomodate you in setting up additional rights so it runs without interuption

Good evening Roel.

Question, if i would like macro below to do save reports in PDF Format what exactly i should be changing in below code ?

Please Login or Register  to view this content.

Thank you