ExcelBanter - Save As

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Save As (https://www.excelbanter.com/excel-programming/296989-save.html)

Orf Bartrop

Save As

I am a newby at programming Excel.
How do you program to bring up the "Save As" box?

Orf Bartrop

yogendra joshi

Save As

This should help:

Code:

Sub sv_as()

fileSaveName = Application.GetSaveAsFilename( _

     fileFilter:="Excel File (*.xls), *.xls")

ActiveWorkbook.saveas (fileSaveName)

End Sub

Orf Bartrop wrote:

I am a newby at programming Excel.
How do you program to bring up the "Save As" box?

Orf Bartrop

Orf Bartrop

Save As

Thank you, works well. However, at present it selects My Documents
folder and I would like it to select a particulat folder. How do I
nominate that folder rather than have to select it from the dialog box?

Orf

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Bob Phillips[_6_]

Save As

Use

chdrive "d:\Development"
chdir "d:\Development"

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Orf Bartrop" wrote in message
...

Thank you, works well. However, at present it selects My Documents
folder and I would like it to select a particulat folder. How do I
nominate that folder rather than have to select it from the dialog box?

Orf

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

All times are GMT +1. The time now is 03:35 AM.