View Single Post
  #1 (permalink)  
Old August 19th, 2003, 03:59 PM
bourgeois02 bourgeois02 is offline
Registered User
Join Date: Aug 2003
Location: , , .
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Access XP VBA compatibility issues w/ Access 2000

I created an application for formatting Excel spreadsheets and uploading them all with the click of a single button within Access. The application works fine in Access XP, but my users with Access 2000 receive the error "Compile error: User-defined type not defined" Clicking on the "Debug" button highlights the following:

Dim fd As FileDialog

The user has selected the reference to the Excel 9.0 Object library, but still receives this error. Anybody know what the problem might be?

Brett Burgess
Internet Consulting, PHP, MySQL, VBA