Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code to save workbook without macros
Hello -
I am awfully rusty in Excel. I currently am working in 2007. I need to write code that will save an .xlsm workbook without the macros. I also need code to save it to a particular file name and always that particular file name, even though it's going to overwrite the file. Any help will be most appreciated! -- Sheldon |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code to save workbook without macros
Ummm, without macros? You would then need to move your mouse to the Save As
sub menu. -- Cheers, Ryan "Sheldon" wrote: Hello - I am awfully rusty in Excel. I currently am working in 2007. I need to write code that will save an .xlsm workbook without the macros. I also need code to save it to a particular file name and always that particular file name, even though it's going to overwrite the file. Any help will be most appreciated! -- Sheldon |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code to save workbook without macros
See Chip Pearson's site for module removal before saving.
http://www.cpearson.com/excel/vbe.aspx Gord Dibben MS Excel MVP On Wed, 3 Sep 2008 15:24:00 -0700, Sheldon wrote: Hello - I am awfully rusty in Excel. I currently am working in 2007. I need to write code that will save an .xlsm workbook without the macros. I also need code to save it to a particular file name and always that particular file name, even though it's going to overwrite the file. Any help will be most appreciated! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code to save workbook without macros
Save the workbook as xlsx and the macro's are gone
Application.DisplayAlerts = False 'Save code Application.DisplayAlerts = True -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Sheldon" wrote in message ... Hello - I am awfully rusty in Excel. I currently am working in 2007. I need to write code that will save an .xlsm workbook without the macros. I also need code to save it to a particular file name and always that particular file name, even though it's going to overwrite the file. Any help will be most appreciated! -- Sheldon |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code to save workbook without macros
Cool!!
I just gotta get me one of those Excel 2007's<g Gord On Thu, 4 Sep 2008 02:17:21 +0200, "Ron de Bruin" wrote: Save the workbook as xlsx and the macro's are gone Application.DisplayAlerts = False 'Save code Application.DisplayAlerts = True |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code to save workbook without macros
Hi Gord
Start downloading it now from MSDN -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Gord Dibben" <gorddibbATshawDOTca wrote in message ... Cool!! I just gotta get me one of those Excel 2007's<g Gord On Thu, 4 Sep 2008 02:17:21 +0200, "Ron de Bruin" wrote: Save the workbook as xlsx and the macro's are gone Application.DisplayAlerts = False 'Save code Application.DisplayAlerts = True |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code to save workbook without macros
I've already got several DVD's from MSDN subscriptions with 2007 so the
availability is not the roadblock. I'll have to get you to email me the full instructions for setting up Virtual PC with Windows XP and Office 2007<g Gord On Thu, 4 Sep 2008 14:51:30 +0200, "Ron de Bruin" wrote: Hi Gord Start downloading it now from MSDN |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code to save workbook without macros
Hi Gord
How much memory do you have in your machine ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Gord Dibben" <gorddibbATshawDOTca wrote in message ... I've already got several DVD's from MSDN subscriptions with 2007 so the availability is not the roadblock. I'll have to get you to email me the full instructions for setting up Virtual PC with Windows XP and Office 2007<g Gord On Thu, 4 Sep 2008 14:51:30 +0200, "Ron de Bruin" wrote: Hi Gord Start downloading it now from MSDN |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code to save workbook without macros
in my opinion, don't do it unless you need more than 65000 rows or 256 columns.
vba code runs slower, the interface sucks and some code isn't compatible. that's my opinion. -- Gary "Gord Dibben" <gorddibbATshawDOTca wrote in message ... Cool!! I just gotta get me one of those Excel 2007's<g Gord On Thu, 4 Sep 2008 02:17:21 +0200, "Ron de Bruin" wrote: Save the workbook as xlsx and the macro's are gone Application.DisplayAlerts = False 'Save code Application.DisplayAlerts = True |
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code to save workbook without macros
Gerry
I would install 2007 only because I feel left out in the discussions on 2007. Eventually I will become extinct and useless..........Mrs. D currently currently holds that opinion so I guess little will change<g Gord On Thu, 4 Sep 2008 23:43:20 -0400, "Gary Keramidas" <GKeramidasATmsn.com wrote: in my opinion, don't do it unless you need more than 65000 rows or 256 columns. vba code runs slower, the interface sucks and some code isn't compatible. that's my opinion. |
#11
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code to save workbook without macros
I feel the same way--well, about being left out of xl2007 discussions--not what
your wife feels <vbg. But with VPC, it's kind of a pain to suffer through the bootup process multiple times. Gord Dibben wrote: Gerry I would install 2007 only because I feel left out in the discussions on 2007. Eventually I will become extinct and useless..........Mrs. D currently currently holds that opinion so I guess little will change<g Gord On Thu, 4 Sep 2008 23:43:20 -0400, "Gary Keramidas" <GKeramidasATmsn.com wrote: in my opinion, don't do it unless you need more than 65000 rows or 256 columns. vba code runs slower, the interface sucks and some code isn't compatible. that's my opinion. -- Dave Peterson |
#12
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code to save workbook without macros
Thanks for your replies!
I tried using Ron's code and it works beautifully, however, I now have another problem. I am left in the xlsx document and my xlsm document has "disappeared." When I try to open the xlsm document, the macros just fire and I end up in the xlsx document, which would mean I would never be able to Edit the xlsm document. How can I fix this? -- Sheldon "Sheldon" wrote: Hello - I am awfully rusty in Excel. I currently am working in 2007. I need to write code that will save an .xlsm workbook without the macros. I also need code to save it to a particular file name and always that particular file name, even though it's going to overwrite the file. Any help will be most appreciated! -- Sheldon |
#13
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code to save workbook without macros
One way is set security to medium if you want to edit the code
Say No to use macro's -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Sheldon" wrote in message ... Thanks for your replies! I tried using Ron's code and it works beautifully, however, I now have another problem. I am left in the xlsx document and my xlsm document has "disappeared." When I try to open the xlsm document, the macros just fire and I end up in the xlsx document, which would mean I would never be able to Edit the xlsm document. How can I fix this? -- Sheldon "Sheldon" wrote: Hello - I am awfully rusty in Excel. I currently am working in 2007. I need to write code that will save an .xlsm workbook without the macros. I also need code to save it to a particular file name and always that particular file name, even though it's going to overwrite the file. Any help will be most appreciated! -- Sheldon |
#14
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code to save workbook without macros
Duh! Told you I was rusty.
Thanks so much! -- Sheldon "Ron de Bruin" wrote: One way is set security to medium if you want to edit the code Say No to use macro's -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Sheldon" wrote in message ... Thanks for your replies! I tried using Ron's code and it works beautifully, however, I now have another problem. I am left in the xlsx document and my xlsm document has "disappeared." When I try to open the xlsm document, the macros just fire and I end up in the xlsx document, which would mean I would never be able to Edit the xlsm document. How can I fix this? -- Sheldon "Sheldon" wrote: Hello - I am awfully rusty in Excel. I currently am working in 2007. I need to write code that will save an .xlsm workbook without the macros. I also need code to save it to a particular file name and always that particular file name, even though it's going to overwrite the file. Any help will be most appreciated! -- Sheldon |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
save workbook without code | Excel Programming | |||
How do I save a workbook as a new workbook by using macros? | Excel Discussion (Misc queries) | |||
Macros on workbook close and save | Excel Programming | |||
Save original workbook name, referenced by macros in other books? | Excel Programming | |||
Copy Macros and VB code from one workbook to another | Excel Programming |