Finding MDB or XLS files that contain macros

[Marvin G]

As part of our future conversion to XP and office 2003, we will be
converting thousands of mdb and XLS files. We want to first
identify/test those that contain macros. Is there a simple utility/app
out there that can do a directory search of files, and identify which
ones have macros?

 

[Amy Vargo]

Hi Marvin,

My name is Amy Vargo. Thank you for using the Microsoft Access Newsgroups.

We do not have such a tool available yet, however, we will soon have a
tool available that will aid in analyzing Access databases for upgrade and
conversion to Microsoft® Office Access 2003. The Microsoft Office Access
2003 Conversion Toolkit is planned to be available as a download from the
Microsoft Download Center and from this Web site concurrent with the
release of Microsoft Office 2003 Service Pack 1 later this year.

For more information, please see the page below:

http://www.microsoft.com/office/ork/2003/journ/accessconvert.htm

I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Amy Vargo
Microsoft Access Engineer


This posting is provided 'AS IS' with no warranties, and confers no rights.
You assume all risk for your use. © 2001 Microsoft Corporation. All rights
reserved.

 

[BAOBAO]

Hi Marvin,

My name is Amy Vargo. Thank you for using the Microsoft Access Newsgroups.

We do not have such a tool available yet, however, we will soon have a
tool available that will aid in analyzing Access databases for upgrade and
conversion to Microsoft?Office Access 2003. The Microsoft Office Access
2003 Conversion Toolkit is planned to be available as a download from the
Microsoft Download Center and from this Web site concurrent with the
release of Microsoft Office 2003 Service Pack 1 later this year.

For more information, please see the page below:

http://www.microsoft.com/office/ork/2003/journ/accessconvert.htm

I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Amy Vargo
Microsoft Access Engineer


This posting is provided 'AS IS' with no warranties, and confers no rights.
You assume all risk for your use. ?2001 Microsoft Corporation. All rights
reserved.