View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Per[_2_] Per[_2_] is offline
external usenet poster
 
Posts: 10
Default Error 59 Bad record length


--
Per


"Joel" skrev:

I got the code to work by commented out the chdir. I did not get the same
error you had. I think the problem is with the permnissions of the directory
you are using. I would add the following code to help locate the problem


msgbox(Application.Path) <= find out which path you are using.
ChDir IndataKatalog


For some reason I don't understand it doesn't work on my computer. I have
modified the program code so that I can read the file from the same directory
as the workbook is stored in and also in the same directory as the
msgbox(Application.Path) shows but nothing seems to help.

Per