Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format changed if we save our own (.xlt) file as (.csv) in Excel 2 | Excel Discussion (Misc queries) | |||
No prompt to save Excel file which has changed | Excel Discussion (Misc queries) | |||
Moved file, changed path, macros don't work | Excel Programming | |||
Excel XP: File name in Title Bar not changed after Save As... | Excel Discussion (Misc queries) | |||
Excel is not asking to save a changed file when the file is closed | Excel Discussion (Misc queries) |