Open a text file from the desktop (Multiple users)

**WasWodge** · 02-17-2011, 06:43 PM

Hi there, does anyone know any code for opening a text file(.txt) from the desktop so that multiple users can open the text file (Our IT dept is restricting some peoples access to their C/ drive) from a macro.
Ideally I would like to put the text file in a folder on the desktop first.
Any suggestions welcome

**TMS** · 02-17-2011, 06:53 PM

The desktop is just a folder:

C:\Users\... user name ...\Desktop

Regards

**WasWodge** · 02-17-2011, 07:07 PM

The username is the problem. There are various macro's that we use that are used by as many as 10 different users. Obviously we want to avoid if possible creating/copying and amending 10 different macro's each time if at all if possible.
I believe we can't just put in C:\.Desktop\"TEXT FILE NAME".txt or something similar like we can in the C:\ drive.
Please let me know if I am mistaken

**TMS** · 02-17-2011, 07:22 PM

The desktop is unique to the user. That said, the "All Users" shared area also has a desktop.

You could try putting the files there: C:\Users\All Users\Desktop

How are you planning on distributing these files?

Regards

**WasWodge** · 02-17-2011, 07:31 PM

The text files are created by the user from the companies mainframe which is based on "Reflection" and so they print to the desktop and are not the problem. The problem is any new macro we use needs to be able to access these files. One of us writes and e-mails out the macro's to the others.

**TMS** · 02-17-2011, 07:35 PM

There are various functions to get the user's Windows Logon ID and their "application name".

Google Excel VBA Get User Name

One example:

http://www.exceltip.com/st/Function_...Excel/452.html

Regards

**WasWodge** · 02-17-2011, 08:04 PM

Getting the username isn't the problem as they are std across the group.
The problem is getting a generic path to go in the macro, but before we go any further I will try to get into the all users folder on one of the restricted peoples logins tomorrow and see what happens, but I suspect that they won't gain access as I know can't put anything new in the main C drive folder but we'll see.what happens