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

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

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!

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

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

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

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

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

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

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

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

512mb RAM

40GB free storage available on C: if that's what you mean.


Gord

On Thu, 4 Sep 2008 22:50:19 +0200, "Ron de Bruin"
wrote:

Hi Gord

How much memory do you have in your machine ?

I wouldn't do it, Gord. In fact, I'm not sure you can. You may need 512M for
just the virtual PC.

I had 1GB of RAM and when I set up VPC to use 512M for WinXP Pro and Vista Home
Premium, the both worked exceedingly slow.

I added 2GB (3GB total) and set up each of the VPCs to use 1.5M and they're not
too bad.

FYI, the WinXP Pro .vhd (virtual harddrive?) takes about 12GB. And the Vista
Home Premium is at 10GB.



Gord Dibben wrote:

512mb RAM

40GB free storage available on C: if that's what you mean.

Gord

On Thu, 4 Sep 2008 22:50:19 +0200, "Ron de Bruin"
wrote:

Hi Gord

How much memory do you have in your machine ?

--

Dave Peterson

Dave is correct Gord

Upgrade your machine

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Dave Peterson" wrote in message ...
I wouldn't do it, Gord. In fact, I'm not sure you can. You may need 512M for
just the virtual PC.

I had 1GB of RAM and when I set up VPC to use 512M for WinXP Pro and Vista Home
Premium, the both worked exceedingly slow.

I added 2GB (3GB total) and set up each of the VPCs to use 1.5M and they're not
too bad.

FYI, the WinXP Pro .vhd (virtual harddrive?) takes about 12GB. And the Vista
Home Premium is at 10GB.



Gord Dibben wrote:

512mb RAM

40GB free storage available on C: if that's what you mean.

Gord

On Thu, 4 Sep 2008 22:50:19 +0200, "Ron de Bruin"
wrote:

Hi Gord

How much memory do you have in your machine ?

--

Dave Peterson

Thanks Ron and Dave

That's the message I also get from lurking around the VirtualPC news group
for a while.


Gord

On Fri, 5 Sep 2008 05:23:44 +0200, "Ron de Bruin"
wrote:

Dave is correct Gord

Upgrade your machine

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

On Sep 4, 8:37*pm, Dave Peterson wrote:
I wouldn't do it, Gord. *In fact, I'm not sure you can. *You may need 512M for
just the virtual PC.

I had 1GB of RAM and when I set up VPC to use 512M for WinXP Pro and Vista Home
Premium, the both worked exceedingly slow.

I added 2GB (3GB total) and set up each of the VPCs to use 1.5M and they're not
too bad.

FYI, the WinXP Pro .vhd (virtual harddrive?) takes about 12GB. *And the Vista
Home Premium is at 10GB.

Gord Dibben wrote:

512mb RAM

40GB free storage available on C: *if that's what you mean.

Gord

On Thu, 4 Sep 2008 22:50:19 +0200, "Ron de Bruin"
wrote:

Hi Gord

How much memory do you have in your machine ?

--

Dave Peterson

Dave/Gord - does that mean you two are using Macs? Why else would you
be running VPC? I'm primarily a Mac user and would love to be able to
use Excel at home with VBA. Even the VBA that comes with 2004 is
limited and 2008 is non-existent!


Steven

I use a WinXP Home pc.

When xl2007 arrived, I didn't want to install it on my pc (just too chicken).
Same thing with Vista.

So instead of breaking something that works <vbg, I downloaded VPC from MS and
installed a couple of virtual pc's.

So I can experiment with xl2007 and with Vista knowing that there's nothing I
can do to really screw up my "real" pc.

I thought that there were a few of windows simulators that you could use with a
Mac.

A search of google came up with this list:
http://www.macwindows.com/emulator.html

wrote:

<<snipped
Dave/Gord - does that mean you two are using Macs? Why else would you
be running VPC? I'm primarily a Mac user and would love to be able to
use Excel at home with VBA. Even the VBA that comes with 2004 is
limited and 2008 is non-existent!

Steven

--

Dave Peterson

ps. I've read some posts that say that MS is going to add VBA to the next
version of MacOffice. (I have no idea when that is.)

Dave Peterson wrote:

I use a WinXP Home pc.

When xl2007 arrived, I didn't want to install it on my pc (just too chicken).
Same thing with Vista.

So instead of breaking something that works <vbg, I downloaded VPC from MS and
installed a couple of virtual pc's.

So I can experiment with xl2007 and with Vista knowing that there's nothing I
can do to really screw up my "real" pc.

I thought that there were a few of windows simulators that you could use with a
Mac.

A search of google came up with this list:
http://www.macwindows.com/emulator.html

wrote:

<<snipped
Dave/Gord - does that mean you two are using Macs? Why else would you
be running VPC? I'm primarily a Mac user and would love to be able to
use Excel at home with VBA. Even the VBA that comes with 2004 is
limited and 2008 is non-existent!

Steven

--

Dave Peterson

--

Dave Peterson

On Sep 5, 8:16*am, Dave Peterson wrote:
ps. *I've read some posts that say that MS is going to add VBA to the next
version of MacOffice. *(I have no idea when that is.)



Dave Peterson wrote:

I use a WinXP Home pc.

When xl2007 arrived, I didn't want to install it on my pc (just too chicken).
Same thing with Vista.

So instead of breaking something that works <vbg, I downloaded VPC from MS and
installed a couple of virtual pc's.

So I can experiment with xl2007 and with Vista knowing that there's nothing I
can do to really screw up my "real" pc.

I thought that there were a few of windows simulators that you could use with a
Mac.

A search of google came up with this list:
http://www.macwindows.com/emulator.html

wrote:

<<snipped
Dave/Gord - does that mean you two are using Macs? Why else would you
be running VPC? I'm primarily a Mac user and would love to be able to
use Excel at home with VBA. Even the VBA that comes with 2004 is
limited and 2008 is non-existent!

Steven

--

Dave Peterson

--

Dave Peterson

I'm hoping it's better than the last time. 2004 does run VBA but there
are enough limits to it that it isn't worth putting time into learning
how to convert PC macros for Mac 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.

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

Yep, one day you're soaring with Eagles, next day you're floundering with
Pterodactyls




On Fri, 05 Sep 2008 18:19:41 -0500, Dave Peterson
wrote:

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.