I have a macro that imports a simple Excel spreadsheet. Yet when it runs I receive a "File not in required format" error. However if I open the file in Excel and then run the Access macro it works!!

Why?, what?, how? help!!

Peter