Can I use the asterisk (*) wildcard to save file in multiple PATH ???

[tuongtu3]

Hello All,
Can I use the asterisk (*) wildcard to save the file in multiple PATH as long as it the file is in the master drive C:

ex: the file now is in "C:\Public\" then can I use "C:\Public\*" so user can save file at their desire sub-folder such as "C:\Public\Henry" as long as it has to be in drive C


Regards,
tt3

[Norie]

No.

To save a file you need to specify the full path and filename.

[shg]

No, SaveAs, Name As, FileCopy, ... will save the file only to a single folder.

[tuongtu3]

Thank you very much for yourr reponse. My question was wrong and sorry.

User can save, save as at any sub folder at user desire as long as it's in Drive C then user can open their file. If they try to save outside of Drive C then they can not open it.
I have code in WB open:

Please Login or Register  to view this content.

Is there a way to do this?
Regards,
tt3

[shg]

Please Login or Register  to view this content.

Of course, the user can disable macros and use the workbook anyway.

[tuongtu3]

Hi shg,
Thank you very much. This look like the one I'm looking for but I need to test it more.

Of course, the user can disable macros and use the workbook anyway. 

How user can disable macro?
I want user use it as long as user save it in the Drive C. Let say if user say it in Drive D then user can not open the wb.

Regards,
tt3

[shg]

Users must explicitly enable macros in order for them to run, unless they have their security settings set to enable all macros, which is an invitation to heartache and disaster.