Abbreviate the string...
vSaveFileFilter = "Lotus 1-2-3 rel 1 (*.wks), *.wks, " & _
"Lotus 1-2-3 rel 2 (*.wk1), *.wk1, " & _
"Lotus 1-2-3 rel 3 (*.wk3), *.wk3, " & _
"Excel (*.xls), *.xls, " & _
"Excel 2007 (*.xlsx), *.xlsx, " & _
"Access (*.mdb), *.mdb, " & _
"Paradox (*.db), *.db, " & _
"Web (*.htm;*.html), *.htm;*.html, " & _
"PDF (*.pdf), *.pdf"
--
Jim Cone
Portland, Oregon USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)




"Kruncher"
wrote in message
Thanks Jim. yeah, the string that works OK is 252, so if I add
anything... boom.
Of course, there's no mention of a limit in the help (that I could find).
So any ideas on where am I going next to do this?




On Jun 7, 7:56 pm, "Jim Cone"
wrote:
My guess is that you are up against a limit on the string length.
If the length of vSaveFileFilter is under 255 the dialog is displayed.
Add the line "MsgBox Len(vSaveFileFilter)" and see what you get.
--
Jim Cone
Portland, Oregon USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)