VB in Excel

Question

I've created a macro in excel in VBscript.  The macro migrates a portion of one excel spreadsheet and sends it to another workbook and then closes the workbook.  I want to change the default location that pops up everytime you save something.  I have changed the default save name text, but haven't figured out the path.  Any help is greatly appreciated! Thanks.

---

Control System Developer

Answer 1

 

Greetings,

This forum is for software developers who are using  the Open Protocol Specification documentation for Office to assist them in developing systems, services, and applications that are interoperable with Office. Since your post does not appear to be related to the Open Protocol Specification documentation set we would appreciate it if you could try http://www.microsoft.com/office/community/en-us/default.mspx?dg=microsoft.public.office.developer.officedev.other&lang=en&cr=US instead to find the information you are looking for. The folks that can best respond to your question do not monitor this forum.


Thanks,
Steve Smegner
Application Development Consulting Group