VBA to Open a File on ANY Desktop

**hutch@edge.net** · 10-16-2009, 02:33 PM

Greetings, Gurus.

I am sending this workbook out for several buyers to use. Part of the macro opens a workbook on their desktop named "Backorder List.xls" and copied data to it. The problem is, the way it is written, I have to go around to each buyers computer and edit it so the vba is looking in the right directory for the file. Is there any way to modify this so that it will open the file "Backorder List.xls" no matter who's desktop it is on?

Please Login or Register  to view this content.

Thanks in advance for any help you can offer.

**royUK** · 10-16-2009, 02:38 PM

Try this Function to find the Desktop

Please Login or Register  to view this content.

**Rick_Stanich** · 10-16-2009, 02:41 PM

Try changing:

Please Login or Register  to view this content.

to:

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

to:

Please Login or Register  to view this content.

A simple test to show current user:

Please Login or Register  to view this content.

**hutch@edge.net** · 10-19-2009, 08:33 AM

Thanks, guys. I will be testing on multiple computers/configurations today, and wil let you know after troubleshooting.

Have a good one.

**hutch@edge.net** · 10-20-2009, 09:24 AM

Morning, Guys.

I tried Rick's suggestion first, because I knew how to incorporate it, but it didn't work on any of the 3 systems I tested it on.

Roy, I don't know how to use your suggestion. Would I just replace the name, "jerry.hutcheson", with the variable "GetDesktop" in the VBA? Would it have quotes around it, or not?

Thanks for the help.

**royUK** · 10-20-2009, 09:38 AM

No, just place the code into a Standard Module, then run the test macro. It will return the desktop path.

Try changing your code

Please Login or Register  to view this content.

To

Please Login or Register  to view this content.

**hutch@edge.net** · 10-20-2009, 10:22 AM

Thanks, Roy. That seems to work on the machines I've tested it on. After adding the function at the top of a standard module, I had make edit the code a bit. Here's what I came up with:

Please Login or Register  to view this content.

Thanks, guys. Have a good one.

**royUK** · 10-20-2009, 10:25 AM

Glad it helped

VBA to Open a File on ANY Desktop

LinkBack

Thread Tools

Rate This Thread

Display

VBA to Open a File on ANY Desktop

Re: VBA to Open a File on ANY Desktop

Re: VBA to Open a File on ANY Desktop

Re: VBA to Open a File on ANY Desktop

Re: VBA to Open a File on ANY Desktop

Re: VBA to Open a File on ANY Desktop

Re: VBA to Open a File on ANY Desktop

Re: VBA to Open a File on ANY Desktop

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions