if i save as the excel file, macros path changed
 

hi,
i use public excel file( plan.xls). i run macro on plan.xls and save as the
file for copy-paste, change color vs. because i don't want to change public
excel files properties but i save as the file, changed public.xls macros path.

example
plan.xls have "olustur" macros but i save as plan.xls to plan-yedek.xls and
i open the plan.xls, plan.xls macros adress changed. plan-yedek!olustur.

How can i secure default settings. thanks

if i save as the excel file, macros path changed
 

have your macro use the filecopy command to make the copy of plan.xls without
opening it excel.

--
Regards,
Tom Ogilvy


"Selim Ozbas" wrote:

hi,
i use public excel file( plan.xls). i run macro on plan.xls and save as the
file for copy-paste, change color vs. because i don't want to change public
excel files properties but i save as the file, changed public.xls macros path.

example
plan.xls have "olustur" macros but i save as plan.xls to plan-yedek.xls and
i open the plan.xls, plan.xls macros adress changed. plan-yedek!olustur.

How can i secure default settings. thanks

if i save as the excel file, macros path changed
 

hi,
thanks for answer

i tried your request to use filecopy command but filecopy command not run
because plan.xls was opened.
The user work on plan.xls and save as other filename when worik is finished.
i say please save as other filename to the user because i don't want the
user destroy the macro unknowingly


"Tom Ogilvy" wrote:

have your macro use the filecopy command to make the copy of plan.xls without
opening it excel.

--
Regards,
Tom Ogilvy


"Selim Ozbas" wrote:

hi,
i use public excel file( plan.xls). i run macro on plan.xls and save as the
file for copy-paste, change color vs. because i don't want to change public
excel files properties but i save as the file, changed public.xls macros path.

example
plan.xls have "olustur" macros but i save as plan.xls to plan-yedek.xls and
i open the plan.xls, plan.xls macros adress changed. plan-yedek!olustur.

How can i secure default settings. thanks

if i save as the excel file, macros path changed
 

In the beforeSave event,

put up the Application.getSaveAsFilename dialog

set cancel to true (to cancel the users initiated save)

Application.EnableEvents = False
save the file use SaveCopy as and specify the selected file name
Application.EnableEvents = True

Open the copied file and close Plan.xls

--
Regards,
Tom Ogilvy


"Selim Ozbas" wrote:

hi,
thanks for answer

i tried your request to use filecopy command but filecopy command not run
because plan.xls was opened.
The user work on plan.xls and save as other filename when worik is finished.
i say please save as other filename to the user because i don't want the
user destroy the macro unknowingly


"Tom Ogilvy" wrote:

have your macro use the filecopy command to make the copy of plan.xls without
opening it excel.

--
Regards,
Tom Ogilvy


"Selim Ozbas" wrote:

hi,
i use public excel file( plan.xls). i run macro on plan.xls and save as the
file for copy-paste, change color vs. because i don't want to change public
excel files properties but i save as the file, changed public.xls macros path.

example
plan.xls have "olustur" macros but i save as plan.xls to plan-yedek.xls and
i open the plan.xls, plan.xls macros adress changed. plan-yedek!olustur.

How can i secure default settings. thanks