Excel (VBA) opened in IE is having pathproblems...

[bertjetek]

Dear all,

I recently took over a Excel(VBA) - internet project over from an (ex) collegue and I am encountering a bizar problem.
It will probably a long description, but I prefer to explain it as good as possible...

An Excel sheet containing VBA code is opened from an ASP page. On open there is a form asking for username and password. This data is checked with allowed users in the sheet; So far no problem.
After the users clicks "logon" a piece of coding compares a value in the sheet with a value in a txt file on the same directory. If the values are the same the sheet opens.
Here comes up the problem... the above works fine for users on the "local" domain,i.e users in the same domain as the webserver.
When users abroad try to "downlmoad" and execute this Excel sheet, an error occurs saying that he can not find the txt file. The path is not existing...
When the same user open the excel sheet directly from its desktop; everything works fine. The additional internet - step is killing the whole thing.

Could anybody give me possible leads to the cause of the problem?? Or alternatives ???

Thanks in advance,

Kind regards,

Bert

 

[SteveBausch]

Four Guys From Rolla

http://www.4guysfromrolla.com/

Is the file dynamic? If it isn't, why not a hidden worksheet with your data?

 

[bertjetek]

Steve,

thanks for the interest in my problem and your reply.

The filename is not dsynamic.
he did already use a hidden sheet in which the value of the path is stored.

Sorry I should of added this info in my original message.

Kind regards,

Bert