hi
this is an issue that keeps happening
i created a linked set of payment workbooks
one is for the data entry (book 1) the other for the payments (book 2)
both are created of multiple sheets based on PQ
they share their info
book 1 gets info via index and match/update
book 2 gets the info via query
each of the pages has numerous macros all intertwined - it emails, prints statements, prints checks, add the check totals, creates labels
every so often either of the books just declares "cant find project or library"
in my previous book when i didnt make backups i lost all my data and all my codes
now i backup at every closedown (forced by macro) so when it fails i retrieve a backup
but i know something is wrong.
this shouldnt be happening.
can anyone help me figure out what and if we are doing something wrong?
this is an issue that keeps happening
i created a linked set of payment workbooks
one is for the data entry (book 1) the other for the payments (book 2)
both are created of multiple sheets based on PQ
they share their info
book 1 gets info via index and match/update
book 2 gets the info via query
each of the pages has numerous macros all intertwined - it emails, prints statements, prints checks, add the check totals, creates labels
every so often either of the books just declares "cant find project or library"
in my previous book when i didnt make backups i lost all my data and all my codes
now i backup at every closedown (forced by macro) so when it fails i retrieve a backup
but i know something is wrong.
this shouldnt be happening.
can anyone help me figure out what and if we are doing something wrong?