View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Orion Cochrane Orion Cochrane is offline
external usenet poster
 
Posts: 119
Default Using SaveAs Dialog and Changing Location

I would like to call up the Save As dialog box, but get it to save in a
specific folder, as opposed to the current workbook's path. Eg. Instead of
the workbook's path of "C:\Test\Test.xls", I would like it to look in
"C:\Test2" and let you choose a filename.

TIA.
--
I am running on Office 2003, unless otherwise stated.