ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Retrieve a the date created date of an Access Table in Excel using VBA (https://www.excelbanter.com/excel-programming/379911-retrieve-date-created-date-access-table-excel-using-vba.html)

[email protected]

Retrieve a the date created date of an Access Table in Excel using VBA
 
Hi All
I'm trying to create a function in Excel, using VBA, where I can
determine if make tables are created in a number of Access databases
during nightly batch runs. Therefore by determining the pathway of the
access database and the specific table name does anyone have code that
would allow me to retrieve the date created timestamp of the newly
created make table, which I could then paste into predetermined cell in
Excel. Any help on this would be extremely appreciated.

Cheers

Neil



All times are GMT +1. The time now is 01:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com