Hi Hector:
I suppose you could provide some input on a screen for the user to specify the path and file name. I wanted just the opposite, to have no user intervention and have Excel not visible. In this application sheets containing price lists are generated, saved, and emailed to customers with no user intervention other than saying "do it".
Scott
>Hi, Scott:
>
>I did the same you suggest but that's not what I want to get.
>
>As we say I want "la chancha y los veinte" (have a cake and eat it too) because
>
>I want...
>
>Create an Excel File. Assign it a name and open the "save as" window because I want the user is able to change that name if he wants to.
>
>Mainly if he wants to change the ubication instead of "My documents"
>
>Thank you very much.
>
> Héctor
Scott Ramey
BDS Software