Check out this thread in this forum: thread705-283848 for the solution. http://support.microsoft.com/default.aspx?scid=kb;EN-US;q304548 is also referenced in that thread.
I started getting the error with a form that wouldn't appear on the form list yet I had a code module in the project list...
Here's my code for solving this problem. It edits out spreadsheet files that are not part of the group I'm looking for based on the name format. Make sure that the Excel 9.0 Library is in the list of references.
Function GetData(intMonth As Integer) As Boolean
Dim XLFile As Excel.Workbook...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.