Open a file on the desktop

**ammartino44** · 01-16-2014, 07:22 PM

How do you open a file on the desktop? I tried this

Please Login or Register  to view this content.

but it's not working.

Oh, I figured it out!! I used

Please Login or Register  to view this content.

but now it says excel cannot access days, the document may be read only or encrypted. How do I get around this?

Oh, now I got it to work, I had to add the name of the file (duh!!), but there was an error when I added ".xls" at the end. Why is this? Also, it came up minimized? Why would this be? Thanks.

**David A Coop** · 01-17-2014, 01:07 AM

The way my PC is set up, you need Workbooks.Open Filename:= _
"C:\Documents and Settings\user\Desktop\Monday.xls"

(But I am still using XP!)

Try recording the macro to get the correct syntax.

David

When you reply please make it clear WHO you are responding to by mentioning their name.
If this has been of assistance, please advise. A little thanks goes a long way.
- Please click on the *Add Reputation button at the bottom of helpful responses.
Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".

**cytop** · 01-17-2014, 02:26 AM

There is a post in your other thread showing 1 way to find the Desktop directory...

**Fotis1991** · 01-17-2014, 03:29 AM

Ok! So you start again the same issues...

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.