Link to Future Spreadsheet Tabs

[Butter]

It's easy enough to link to someone else's Excel spreadsheet and get their data into my Access database but I have to do it each month. They create a new tab each month (OCT-2007,NOV-2007,DEC-2007) for the month and the spreadsheets always have the same structure.

Is there anyway to tell my database to go out and look to see if the new spreadsheet has been created and if it has then import the data?

 

[DCrake]

Simple Software Solutions

Hi
If you are using VBA to import then you can enumerate throught the number of worksheets in the workbook. Or you can return the number of worksheets in the workbook.

If you know how many was there at the last point and that number has been exceeded then you will know another worksheet has ben created.

Then use the Worksheets(x).Name to base your import on

Code Master: