[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now


Setting Default Location for File/Save in Code for Excel

Posted on 2004-10-21
Medium Priority
Last Modified: 2010-04-17
I would like to set the File/Save path for a spreadsheet. I run several macros, then I prompt the user to save the modified version of the file. There are several iterations of this process, each compiles different data and needs to be saved with a slightly different name, but in a similar location. THe path is nested a bit deep. I don't want to change the general Excel default file location.

Can I present the user with an opened File/Save As dialog box, where the path has been set and they just need to modifiy the file name a bit then click save?

Thank you!
Question by:janderson131
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2

Accepted Solution

Ali_Jas earned 450 total points
ID: 12371196
I should change the name to a sequence in the save location, so each new file gets a new filename.
apart from that you can store the original entered filename of the user in a database or file. when the user later on wants to download the file, you can use this text file or database table to. identify the files again.

Author Comment

ID: 12604129
If I ask the user to enter the    filename in a control, can I then concatenate that as a part of the full file path and name, then automate the saving of the file like that?


Expert Comment

ID: 12612335
I think you can do that, but that's a little tricky, because you never know what your user will enter. this might cause unexpected errors. if you generate an automatic filename, you can ensure that the filename meets the standards for a filesystem.

Author Comment

ID: 12613622
OK, thanks!

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Q&A with Course Creator, Mark Lassoff, on the importance of HTML5 in the career of a modern-day developer.
The SignAloud Glove is capable of translating American Sign Language signs into text and audio.
In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

650 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question