Save As dialog, Tools option missing

[gustaf111]

Hello all! I have the code below which open a SaveAs dialog, it works BUT, the Tools Options at the bottom only allows tou to look at mapping the drive ... ? I'm using excel 2007

What do I need to add to see the Tools options ?


Set fileSaveName = Application.FileDialog(msoFileDialogSaveAs)
fileSaveName.FilterIndex = 2 'select to save with a ".xlsm" extension
fileSaveName.Show
fileSaveName.Execute

 

[UnsolvedCoding]

My experience with msofile anything is that the full features are not available, it gives only a skeleton set of controls.

 

[gustaf111]

Okay, Thanks! I have been seraching a few hours