getting worksheetnames as links.

[OssieMac]

Hi again,

One more test and then I am out of ideas. The path on the network is a
mapped path and I wonder if Excel sees it that way or whether it sees the
fully qualified path because it does do some funny things sometimes.

Copy the small macro below into a new workbook.

Change back from the VBA editor to Sheet1.

Go into File Open as if you are going to open a file and change into the
network folder (D:\costs or whatever folder you use) but do not open any
files. Close the fileopen window.

Run the Test_File_Path macro and then check the filepath in cell A1 on
Sheet1 and see whether it is the same as you have been using as the filepath.
If it is different, then try it as your filepath in the code.

Sub Test_File_Path()
Sheets("Sheet1").Range("A1") = CurDir
End Sub

If this does not work, then I suggest that you start a new thread on this
forum and post the code on it and describe what happens. Include the
information that it runs on your home computer but not on the network and
request that the MVP's look at it and see if they can tell you what is wrong.

Your suggestion is worth a thought but if it won't write to the spreadsheet
then I doubt that it will write to a txt file either.

Regards,

OssieMac

 

[excel-tr]

Hi,

I understood what u mean. ı do not think there is a problem with the adress.
everytime I run I can see a different situation. for example it worked well
some time and added the adresses correctly but later it stopped.I think there
is a problem with the memory or something else. I will copy the path to my
home pc and try it at home, then send my question to the group.what is mvp ?
thanks again

 

[OssieMac]

This will be my sign off on this problem because I certainly do not know the
answer.
MVP's are Most Valuable Professionals. A lot of news/forum sites are shared
and people sign in to different web sites to view the info. If you sign in on
the Microsoft communities web site then at the bottom of the window where you
read the posted info you will see a qustion re whether the post was helpful.
Immediately below that there is a question-link 'Why should I rate a post?'.
if you open that link, there is quite a lot of info including an explanation
of MVP's.

Best of luck for the future and I hope you do find an answer to the problem.

Regards,

OssieMac

 

[Jay]

Hi SAHRAYICEDIT and OssieMac -

Thanks to both of you for pursuing this problem. I for one, will certainly
be wary of applications that require opening many workbooks because of your
efforts. I'll keep my eyes open for information on the subject, but I don't
have any fertile ideas to add to this thread. I'll post or email in the
future if I come across information that addresses this issue.

Thanks again for all your efforts; they were educational and resulted in an
application that produces a valuable result in my computing environment and
will benefit others I'm sure.