centralmike
asked on
access 2007/excel 2007
I have process in access 2007 that opens up multiple excel files and reads a sheet called "test". Loads some data into a access table. I am trying to add code to my function, if the sheet "test" does not exist in the workbook close down the function an go to the next workbook. I receive an error if the sheet does not exist in the workbook. I have attached my function below.
excel.txt
excel.txt
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER