Hi,
Im designing a system that will update and create a report on a 4 month cycle using Excel.
What I would like to know is, is it possible that access before updating checks whether the excel file already exists, and same for the worksheets within excel.
This will be to prevent and alert for the following cases.
1. When user logs onto access system, the system will do a status check to see what needs updating, ie if the excel report does not exist access will report that you need to create it.
2. If a new user is created, access will recognise that the specific worksheet for that user within the excel file does not exist there fore alerts the user to create it.
3. Access will check whether all the columns are filled up and if so will alert the user that the 4 month cycle is up and therefore a need to create a new report.
any help will be much apprieciated thx
Im designing a system that will update and create a report on a 4 month cycle using Excel.
What I would like to know is, is it possible that access before updating checks whether the excel file already exists, and same for the worksheets within excel.
This will be to prevent and alert for the following cases.
1. When user logs onto access system, the system will do a status check to see what needs updating, ie if the excel report does not exist access will report that you need to create it.
2. If a new user is created, access will recognise that the specific worksheet for that user within the excel file does not exist there fore alerts the user to create it.
3. Access will check whether all the columns are filled up and if so will alert the user that the 4 month cycle is up and therefore a need to create a new report.
any help will be much apprieciated thx