Maybe the problem is not in Excel, but in the location of the csv file. It
is possible that it can only be accessed with administrator rights, even from
outside Excel.
Check also the path in the script, it may be refering to the "My documents"
folder of the logged user, so it will change for each user, leading to wrong
paths.

Hope this helps,
Miguel.

"Free Agent99" wrote:

Greetings,

As the subject says, I have a working macro (auto_open) that works fine when
i am testing. It simply opens a CSV file and copies cells to the different
sheets in the spreadsheet. However, if someone who is not an administrator
runs it it stops on the first "sheets" command and give an error "invalid
subscript". I tested for a long time before I figured out the problem, but I
have set the security levels at the lowest and changed the security on the
workbook and CSV files to allow "everyone" but it still won't work. What is
the problem? More important, what is the fix?

thanks for looking,

Tod Brannen