Don Dufau
Last Activity: Jun 22 '11, 07:58 PM
Joined: Jun 22 '11
Location:
-
That's unusual, I'm not recieving any errors at that point. If all of the data on your worksheets is the same size you could just remove that code and set the size of the range in the DoCmd line. -
I just used this code to Import a mutli page spreadsheet of my own. The two things I had to do to get it to run were: Added a Reference to Microsoft Excel 12.0 Object Library and then I also added the extension to the File name in the variable strFilePath (.xls)Leave a comment:
-
You need to put the code into a subroutine or function. Add Public Sub ImportData before the first Dim statement, and End Sub to the end of the code block.Leave a comment:
No activity results to display
Leave a comment: