ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Custom SaveAs dialog - need list of supported filetypes (https://www.excelbanter.com/excel-programming/450411-custom-saveas-dialog-need-list-supported-filetypes.html)

nikeeg

Custom SaveAs dialog - need list of supported filetypes
 
I'm working on a project where we do not want to show the file name and directory browsing portion of the Save As dialog. Our code is automatically saving and naming the file. However, we want the user to select the file format/type.

So essentially, I want to create a custom dialog where we replicate the Save As Type dropdown but do not show the directory browsing section.

Any ideas?

GS[_2_]

Custom SaveAs dialog - need list of supported filetypes
 
I'm working on a project where we do not want to show the file name
and directory browsing portion of the Save As dialog. Our code is
automatically saving and naming the file. However, we want the user
to select the file format/type.

So essentially, I want to create a custom dialog where we replicate
the Save As Type dropdown but do not show the directory browsing
section.

Any ideas?


A ComboBox perhaps?

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion



isabelle

Custom SaveAs dialog - need list of supported filetypes
 
hi,

You can use the next list to feed a ComboBox

http://msdn.microsoft.com/en-us/libr...ffice.15).aspx

http://www.rondebruin.nl/win/s5/win001.htm

'Save the file in the format you choose in the "Save as type" dropdown
NewWb.SaveAs fname, FileFormat:= _
FileFormatValue, CreateBackup:=False

isabelle

Le 2014-11-03 21:21, nikeeg a écrit :
I'm working on a project where we do not want to show the file name and
directory browsing portion of the Save As dialog. Our code is
automatically saving and naming the file. However, we want the user to
select the file format/type.

So essentially, I want to create a custom dialog where we replicate the
Save As Type dropdown but do not show the directory browsing section.

Any ideas?





GS[_2_]

Custom SaveAs dialog - need list of supported filetypes
 
http://msdn.microsoft.com/en-us/libr...ffice.15).aspx

Lots of good stuff here! Thanks for sharing...

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion



isabelle

Custom SaveAs dialog - need list of supported filetypes
 
glad that this info was helpful.

isabelle

Le 2014-11-04 12:46, GS a écrit :
http://msdn.microsoft.com/en-us/libr...ffice.15).aspx


Lots of good stuff here! Thanks for sharing...



All times are GMT +1. The time now is 02:49 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com