Excel stops working!!!

[ktwclark]

I have a macro that links from Ecel to Acces and back again. During testing an Access form wasn't closed, the system halted, after a restart I couldn't open Excel. I've narrowed down the line of code that's causing the problem but am stuck. The line of code is for reading in data from a text file in to an Access database:

DoCmd.TransferText acImportDelim, "EDW Import Specification", "GO", txtLocation.Value

txtlocation.Value hold the location of the text file.

I corrected the error to hide the form (after uninstalling and reinstalling Office to get it working) and now get the error message "Couldn't find installable ISAM."

Help!

 

[Hasit]

Take a look at these which may help:

http://support.microsoft.com/directory/article.asp?ID=KB;EN-US;Q155666&

http://support.microsoft.com/directory/article.asp?ID=KB;EN-US;Q107672&