View Single Post
  #12   Report Post  
Posted to microsoft.public.excel.programming
Kruncher Kruncher is offline
external usenet poster
 
Posts: 18
Default GetSaveAsFilename Troubles

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 *USAhttp://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)