| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving a spreadsheet without saving the Macro
I have a spreadsheet that I use as a template. When a user opens the
spreadsheet it runs a macro (using Auto_Open). This macro does its thing with the data and then saves the spreadsheet. The problem is that the macro is saved with the spreadsheet. Because of the Auto_Open, the user has to dispable macros when they open the saved spreadsheet. Is there a way, using VBA, to save the spreadsheet without the macro? Thank you. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Saving a spreadsheet without saving the Macro
Is it a real template ? xlt
-- Regards Ron de Bruin http://www.rondebruin.nl "tedd13" wrote in message ... I have a spreadsheet that I use as a template. When a user opens the spreadsheet it runs a macro (using Auto_Open). This macro does its thing with the data and then saves the spreadsheet. The problem is that the macro is saved with the spreadsheet. Because of the Auto_Open, the user has to dispable macros when they open the saved spreadsheet. Is there a way, using VBA, to save the spreadsheet without the macro? Thank you. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Saving a spreadsheet without saving the Macro
Sorry, no it's just a spreadsheet. I guess I shouldn't call it that. Would
it make a difference if I saved it as a template? Thanks "Ron de Bruin" wrote: Is it a real template ? xlt -- Regards Ron de Bruin http://www.rondebruin.nl "tedd13" wrote in message ... I have a spreadsheet that I use as a template. When a user opens the spreadsheet it runs a macro (using Auto_Open). This macro does its thing with the data and then saves the spreadsheet. The problem is that the macro is saved with the spreadsheet. Because of the Auto_Open, the user has to dispable macros when they open the saved spreadsheet. Is there a way, using VBA, to save the spreadsheet without the macro? Thank you. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Saving a spreadsheet without saving the Macro
If you save it as a real template you can test the path
You can test the ThisWorkbook path A real template have no path Sub Auto_Open() If Len(ThisWorkbook.Path) = 0 Then MsgBox "run the code it is a template" Else MsgBox "The file is a xls do nothing" End If End Sub -- Regards Ron de Bruin http://www.rondebruin.nl "tedd13" wrote in message ... Sorry, no it's just a spreadsheet. I guess I shouldn't call it that. Would it make a difference if I saved it as a template? Thanks "Ron de Bruin" wrote: Is it a real template ? xlt -- Regards Ron de Bruin http://www.rondebruin.nl "tedd13" wrote in message ... I have a spreadsheet that I use as a template. When a user opens the spreadsheet it runs a macro (using Auto_Open). This macro does its thing with the data and then saves the spreadsheet. The problem is that the macro is saved with the spreadsheet. Because of the Auto_Open, the user has to dispable macros when they open the saved spreadsheet. Is there a way, using VBA, to save the spreadsheet without the macro? Thank you. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Saving a spreadsheet without saving the Macro
Another way is to delete the VBA
See Chip Pearson's site http://www.cpearson.com/excel/vbe.htm -- Regards Ron de Bruin http://www.rondebruin.nl "tedd13" wrote in message ... Sorry, no it's just a spreadsheet. I guess I shouldn't call it that. Would it make a difference if I saved it as a template? Thanks "Ron de Bruin" wrote: Is it a real template ? xlt -- Regards Ron de Bruin http://www.rondebruin.nl "tedd13" wrote in message ... I have a spreadsheet that I use as a template. When a user opens the spreadsheet it runs a macro (using Auto_Open). This macro does its thing with the data and then saves the spreadsheet. The problem is that the macro is saved with the spreadsheet. Because of the Auto_Open, the user has to dispable macros when they open the saved spreadsheet. Is there a way, using VBA, to save the spreadsheet without the macro? Thank you. |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Saving a spreadsheet without saving the Macro
Thanks I will check that out.
Maybe I am going about this the wrong way. When the user opens my spreadsheet it opens a text file, does lots of formating and totalling, and then saves the spreadsheet in a folder with a different name. I thought that there might be something I could add to the code that saves the spreadsheet so that it no longer has the macro. I tried saving it as a template but it still runs the macro. The user can always disable macros but I would rather they didn't have to do that. Thanks "Ron de Bruin" wrote: Another way is to delete the VBA See Chip Pearson's site http://www.cpearson.com/excel/vbe.htm -- Regards Ron de Bruin http://www.rondebruin.nl "tedd13" wrote in message ... Sorry, no it's just a spreadsheet. I guess I shouldn't call it that. Would it make a difference if I saved it as a template? Thanks "Ron de Bruin" wrote: Is it a real template ? xlt -- Regards Ron de Bruin http://www.rondebruin.nl "tedd13" wrote in message ... I have a spreadsheet that I use as a template. When a user opens the spreadsheet it runs a macro (using Auto_Open). This macro does its thing with the data and then saves the spreadsheet. The problem is that the macro is saved with the spreadsheet. Because of the Auto_Open, the user has to dispable macros when they open the saved spreadsheet. Is there a way, using VBA, to save the spreadsheet without the macro? Thank you. |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Saving a spreadsheet without saving the Macro
Working OK for me in the template
The macro will run but now you can do what you want Sub Auto_Open() If Len(ThisWorkbook.Path) = 0 Then MsgBox "run the code it is a template" Else MsgBox "The file is a xls do nothing" End If End Sub when you open the template you will see the first msgbox and when you save it as a xls and open the file you see the second one(you can delete this line) This way the code will only run if the file is a xlt and not ais it is xls -- Regards Ron de Bruin http://www.rondebruin.nl "tedd13" wrote in message ... Thanks I will check that out. Maybe I am going about this the wrong way. When the user opens my spreadsheet it opens a text file, does lots of formating and totalling, and then saves the spreadsheet in a folder with a different name. I thought that there might be something I could add to the code that saves the spreadsheet so that it no longer has the macro. I tried saving it as a template but it still runs the macro. The user can always disable macros but I would rather they didn't have to do that. Thanks "Ron de Bruin" wrote: Another way is to delete the VBA See Chip Pearson's site http://www.cpearson.com/excel/vbe.htm -- Regards Ron de Bruin http://www.rondebruin.nl "tedd13" wrote in message ... Sorry, no it's just a spreadsheet. I guess I shouldn't call it that. Would it make a difference if I saved it as a template? Thanks "Ron de Bruin" wrote: Is it a real template ? xlt -- Regards Ron de Bruin http://www.rondebruin.nl "tedd13" wrote in message ... I have a spreadsheet that I use as a template. When a user opens the spreadsheet it runs a macro (using Auto_Open). This macro does its thing with the data and then saves the spreadsheet. The problem is that the macro is saved with the spreadsheet. Because of the Auto_Open, the user has to dispable macros when they open the saved spreadsheet. Is there a way, using VBA, to save the spreadsheet without the macro? Thank you. |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Saving a spreadsheet without saving the Macro
I tried that out and it works!
Thanks for your help! "Ron de Bruin" wrote: Working OK for me in the template The macro will run but now you can do what you want Sub Auto_Open() If Len(ThisWorkbook.Path) = 0 Then MsgBox "run the code it is a template" Else MsgBox "The file is a xls do nothing" End If End Sub when you open the template you will see the first msgbox and when you save it as a xls and open the file you see the second one(you can delete this line) This way the code will only run if the file is a xlt and not ais it is xls -- Regards Ron de Bruin http://www.rondebruin.nl "tedd13" wrote in message ... Thanks I will check that out. Maybe I am going about this the wrong way. When the user opens my spreadsheet it opens a text file, does lots of formating and totalling, and then saves the spreadsheet in a folder with a different name. I thought that there might be something I could add to the code that saves the spreadsheet so that it no longer has the macro. I tried saving it as a template but it still runs the macro. The user can always disable macros but I would rather they didn't have to do that. Thanks "Ron de Bruin" wrote: Another way is to delete the VBA See Chip Pearson's site http://www.cpearson.com/excel/vbe.htm -- Regards Ron de Bruin http://www.rondebruin.nl "tedd13" wrote in message ... Sorry, no it's just a spreadsheet. I guess I shouldn't call it that. Would it make a difference if I saved it as a template? Thanks "Ron de Bruin" wrote: Is it a real template ? xlt -- Regards Ron de Bruin http://www.rondebruin.nl "tedd13" wrote in message ... I have a spreadsheet that I use as a template. When a user opens the spreadsheet it runs a macro (using Auto_Open). This macro does its thing with the data and then saves the spreadsheet. The problem is that the macro is saved with the spreadsheet. Because of the Auto_Open, the user has to dispable macros when they open the saved spreadsheet. Is there a way, using VBA, to save the spreadsheet without the macro? Thank you. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automaticly saving formula's to values when saving | Excel Discussion (Misc queries) | |||
| Saving spreadsheet | Excel Worksheet Functions | |||
| Saving or not a spreadsheet | Excel Programming | |||
| Saving a Workbook: Forcing User to Rename before Saving | Excel Programming | |||
| Writing a macro so that when saving a spreadsheet the data cannot be changed | Excel Programming | |||
Linear Mode
