MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Open Excel files


Posted by Dee on October 26, 2001 9:57 AM

Sorry, I don't see my 1st post listed so here goes again.

Is there a way to automate Excel so that it when I ask to open a file it automatically opens my new folder "Excel Files" that I've added to my desktop without having to click Desktop first? I'm trying to save a step. Thank you.


Posted by Barrie Davidson on October 26, 2001 10:06 AM

Under Tools|Options, select the General tab. In the box "Default file location" enter the path to your Desktop.

BarrieBarrie Davidson

Posted by Dee on October 26, 2001 10:39 AM

Thank you for that prompt & informative answer. I'm a new Excel user & very lucky to have found this wonderful site. I hope you're all getting paid for your time and expertise.

Posted by Barrie Davidson on October 26, 2001 10:44 AM

No payment in $ for this, but the experience gained in helping others is enough for me (and I suspect this is the same for everyone else who provides answers).

Barrie :-)Barrie Davidson