ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Saving Add-in in Excel 2007 (Global Macros) (https://www.excelbanter.com/excel-programming/405400-saving-add-excel-2007-global-macros.html)

JackRazz

Saving Add-in in Excel 2007 (Global Macros)
 
Hey everyone,
I'm trying to create a file for my global macros and would like to use an
Add-in instead of the more classic Personal.xlsm method. I don't see how to
save a worksheet with my macros as an addin or xlam file. How do I do this?

Also where is the save as cvs file format?

Thanks - JackRazz

Dave Peterson

Saving Add-in in Excel 2007 (Global Macros)
 
When you do a saveas, don't you see options in the "save as type" dropdown?

JackRazz wrote:

Hey everyone,
I'm trying to create a file for my global macros and would like to use an
Add-in instead of the more classic Personal.xlsm method. I don't see how to
save a worksheet with my macros as an addin or xlam file. How do I do this?

Also where is the save as cvs file format?

Thanks - JackRazz


--

Dave Peterson

JackRazz

Saving Add-in in Excel 2007 (Global Macros)
 
Dave, All I have in my 'Save as type' is

*.xlsx
*.xlsm
*.xlsb
*.xls
*.xml
*.mht

So I must be missing something. Could I have missed it in my install?

Thanks - JackRazz




"Dave Peterson" wrote:

When you do a saveas, don't you see options in the "save as type" dropdown?

JackRazz wrote:

Hey everyone,
I'm trying to create a file for my global macros and would like to use an
Add-in instead of the more classic Personal.xlsm method. I don't see how to
save a worksheet with my macros as an addin or xlam file. How do I do this?

Also where is the save as cvs file format?

Thanks - JackRazz


--

Dave Peterson


JackRazz

Saving Add-in in Excel 2007 (Global Macros)
 

Okay,
I went back through my install and checked to see if I missed anything and I
didn't see anything related save as filters or anything that might have
caused me not to get this during my install.

Any ideas anyone?

Thanks - JackRazz

"JackRazz" wrote:

Dave, All I have in my 'Save as type' is

*.xlsx
*.xlsm
*.xlsb
*.xls
*.xml
*.mht

So I must be missing something. Could I have missed it in my install?

Thanks - JackRazz




"Dave Peterson" wrote:

When you do a saveas, don't you see options in the "save as type" dropdown?

JackRazz wrote:

Hey everyone,
I'm trying to create a file for my global macros and would like to use an
Add-in instead of the more classic Personal.xlsm method. I don't see how to
save a worksheet with my macros as an addin or xlam file. How do I do this?

Also where is the save as cvs file format?

Thanks - JackRazz


--

Dave Peterson


Dave Peterson

Saving Add-in in Excel 2007 (Global Macros)
 
When I installed xl2007, I installed everything and get a lot more extensions
that what you show.

Sorry, I don't know enough about xl2007 to help.

JackRazz wrote:

Okay,
I went back through my install and checked to see if I missed anything and I
didn't see anything related save as filters or anything that might have
caused me not to get this during my install.

Any ideas anyone?

Thanks - JackRazz

"JackRazz" wrote:

Dave, All I have in my 'Save as type' is

*.xlsx
*.xlsm
*.xlsb
*.xls
*.xml
*.mht

So I must be missing something. Could I have missed it in my install?

Thanks - JackRazz




"Dave Peterson" wrote:

When you do a saveas, don't you see options in the "save as type" dropdown?

JackRazz wrote:

Hey everyone,
I'm trying to create a file for my global macros and would like to use an
Add-in instead of the more classic Personal.xlsm method. I don't see how to
save a worksheet with my macros as an addin or xlam file. How do I do this?

Also where is the save as cvs file format?

Thanks - JackRazz

--

Dave Peterson


--

Dave Peterson

Gord Dibben

Saving Add-in in Excel 2007 (Global Macros)
 
Dave

When did you bite the bullet?

My Office Ultimate 2007 is still sitting in its plastic envelope.


Gord

On Thu, 31 Jan 2008 18:52:40 -0600, Dave Peterson
wrote:

When I installed xl2007, I installed everything and get a lot more extensions
that what you show.

Sorry, I don't know enough about xl2007 to help.

JackRazz wrote:

Okay,
I went back through my install and checked to see if I missed anything and I
didn't see anything related save as filters or anything that might have
caused me not to get this during my install.

Any ideas anyone?

Thanks - JackRazz

"JackRazz" wrote:

Dave, All I have in my 'Save as type' is

*.xlsx
*.xlsm
*.xlsb
*.xls
*.xml
*.mht

So I must be missing something. Could I have missed it in my install?

Thanks - JackRazz




"Dave Peterson" wrote:

When you do a saveas, don't you see options in the "save as type" dropdown?

JackRazz wrote:

Hey everyone,
I'm trying to create a file for my global macros and would like to use an
Add-in instead of the more classic Personal.xlsm method. I don't see how to
save a worksheet with my macros as an addin or xlam file. How do I do this?

Also where is the save as cvs file format?

Thanks - JackRazz

--

Dave Peterson



Dave Peterson

Saving Add-in in Excel 2007 (Global Macros)
 
I installed VPC a few months ago and installed winxp pro on a virtual disk. I
installed xl2007 on that VHD. But the bad news is I only had 1GB on my pc. So
I used 512MB for the real pc and 512 for the VPC.

I would start winxp pro on the VPC and it was just excruciatingly slow.

Last week, I upgraded to 3GB and I allocate 1.5GB for the VPC and it seems to be
responsive enough to actually use!

But I still have to load VPC to get to office 2007 (and I don't always do that).

ps. The extra 2GB cost about 45USD from newegg.com. I used Crucial.com to find
what kind of memory I needed and then looked for cheaper <vbg prices.

Gord Dibben wrote:

Dave

When did you bite the bullet?

My Office Ultimate 2007 is still sitting in its plastic envelope.

Gord

On Thu, 31 Jan 2008 18:52:40 -0600, Dave Peterson
wrote:

When I installed xl2007, I installed everything and get a lot more extensions
that what you show.

Sorry, I don't know enough about xl2007 to help.

JackRazz wrote:

Okay,
I went back through my install and checked to see if I missed anything and I
didn't see anything related save as filters or anything that might have
caused me not to get this during my install.

Any ideas anyone?

Thanks - JackRazz

"JackRazz" wrote:

Dave, All I have in my 'Save as type' is

*.xlsx
*.xlsm
*.xlsb
*.xls
*.xml
*.mht

So I must be missing something. Could I have missed it in my install?

Thanks - JackRazz




"Dave Peterson" wrote:

When you do a saveas, don't you see options in the "save as type" dropdown?

JackRazz wrote:

Hey everyone,
I'm trying to create a file for my global macros and would like to use an
Add-in instead of the more classic Personal.xlsm method. I don't see how to
save a worksheet with my macros as an addin or xlam file. How do I do this?

Also where is the save as cvs file format?

Thanks - JackRazz

--

Dave Peterson


--

Dave Peterson

JackRazz

Saving Add-in in Excel 2007 (Global Macros)
 
Thanks everyone for the help. I have a version of Office 2007 I got from a
Microsoft Fair/Seminar last spring. It called Launch 2007 Resource Kit with
an product key for office and groove.

The CD apparently contains a Trial Version and the key activates it into a
full version. Althought fuller than the trial version, it appears not to be
a little hungry compared to the retail version.

I'm going to try posting to the setup group and see if anyone knows there.


See Ya - JackRazz

"Dave Peterson" wrote:

I installed VPC a few months ago and installed winxp pro on a virtual disk. I
installed xl2007 on that VHD. But the bad news is I only had 1GB on my pc. So
I used 512MB for the real pc and 512 for the VPC.

I would start winxp pro on the VPC and it was just excruciatingly slow.

Last week, I upgraded to 3GB and I allocate 1.5GB for the VPC and it seems to be
responsive enough to actually use!

But I still have to load VPC to get to office 2007 (and I don't always do that).

ps. The extra 2GB cost about 45USD from newegg.com. I used Crucial.com to find
what kind of memory I needed and then looked for cheaper <vbg prices.

Gord Dibben wrote:

Dave

When did you bite the bullet?

My Office Ultimate 2007 is still sitting in its plastic envelope.

Gord

On Thu, 31 Jan 2008 18:52:40 -0600, Dave Peterson
wrote:

When I installed xl2007, I installed everything and get a lot more extensions
that what you show.

Sorry, I don't know enough about xl2007 to help.

JackRazz wrote:

Okay,
I went back through my install and checked to see if I missed anything and I
didn't see anything related save as filters or anything that might have
caused me not to get this during my install.

Any ideas anyone?

Thanks - JackRazz

"JackRazz" wrote:

Dave, All I have in my 'Save as type' is

*.xlsx
*.xlsm
*.xlsb
*.xls
*.xml
*.mht

So I must be missing something. Could I have missed it in my install?

Thanks - JackRazz




"Dave Peterson" wrote:

When you do a saveas, don't you see options in the "save as type" dropdown?

JackRazz wrote:

Hey everyone,
I'm trying to create a file for my global macros and would like to use an
Add-in instead of the more classic Personal.xlsm method. I don't see how to
save a worksheet with my macros as an addin or xlam file. How do I do this?

Also where is the save as cvs file format?

Thanks - JackRazz

--

Dave Peterson


--

Dave Peterson


Gord Dibben

Saving Add-in in Excel 2007 (Global Macros)
 
I have been thinking of VPC just to have a look at Office 2007.

I have 2.6 GB so should get good response.

Good weekend project maybe<g


Gord

On Thu, 31 Jan 2008 20:02:25 -0600, Dave Peterson
wrote:

I installed VPC a few months ago and installed winxp pro on a virtual disk. I
installed xl2007 on that VHD. But the bad news is I only had 1GB on my pc. So
I used 512MB for the real pc and 512 for the VPC.

I would start winxp pro on the VPC and it was just excruciatingly slow.

Last week, I upgraded to 3GB and I allocate 1.5GB for the VPC and it seems to be
responsive enough to actually use!

But I still have to load VPC to get to office 2007 (and I don't always do that).

ps. The extra 2GB cost about 45USD from newegg.com. I used Crucial.com to find
what kind of memory I needed and then looked for cheaper <vbg prices.

Gord Dibben wrote:

Dave

When did you bite the bullet?

My Office Ultimate 2007 is still sitting in its plastic envelope.

Gord

On Thu, 31 Jan 2008 18:52:40 -0600, Dave Peterson
wrote:

When I installed xl2007, I installed everything and get a lot more extensions
that what you show.

Sorry, I don't know enough about xl2007 to help.

JackRazz wrote:

Okay,
I went back through my install and checked to see if I missed anything and I
didn't see anything related save as filters or anything that might have
caused me not to get this during my install.

Any ideas anyone?

Thanks - JackRazz

"JackRazz" wrote:

Dave, All I have in my 'Save as type' is

*.xlsx
*.xlsm
*.xlsb
*.xls
*.xml
*.mht

So I must be missing something. Could I have missed it in my install?

Thanks - JackRazz




"Dave Peterson" wrote:

When you do a saveas, don't you see options in the "save as type" dropdown?

JackRazz wrote:

Hey everyone,
I'm trying to create a file for my global macros and would like to use an
Add-in instead of the more classic Personal.xlsm method. I don't see how to
save a worksheet with my macros as an addin or xlam file. How do I do this?

Also where is the save as cvs file format?

Thanks - JackRazz

--

Dave Peterson



Jon Peltier

Saving Add-in in Excel 2007 (Global Macros)
 
I installed VPC on a 2GB laptop, and the VHD has Windows XP Pro and Office
2007. It's not remarkably slower than Office 2007 running normally on
another older laptop. And it makes checking things in 2007 easier, just fire
up the VPC, and save its state when I finish.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Dave Peterson" wrote in message
...
I installed VPC a few months ago and installed winxp pro on a virtual disk.
I
installed xl2007 on that VHD. But the bad news is I only had 1GB on my
pc. So
I used 512MB for the real pc and 512 for the VPC.

I would start winxp pro on the VPC and it was just excruciatingly slow.

Last week, I upgraded to 3GB and I allocate 1.5GB for the VPC and it seems
to be
responsive enough to actually use!

But I still have to load VPC to get to office 2007 (and I don't always do
that).

ps. The extra 2GB cost about 45USD from newegg.com. I used Crucial.com
to find
what kind of memory I needed and then looked for cheaper <vbg prices.

Gord Dibben wrote:

Dave

When did you bite the bullet?

My Office Ultimate 2007 is still sitting in its plastic envelope.

Gord

On Thu, 31 Jan 2008 18:52:40 -0600, Dave Peterson

wrote:

When I installed xl2007, I installed everything and get a lot more
extensions
that what you show.

Sorry, I don't know enough about xl2007 to help.

JackRazz wrote:

Okay,
I went back through my install and checked to see if I missed anything
and I
didn't see anything related save as filters or anything that might
have
caused me not to get this during my install.

Any ideas anyone?

Thanks - JackRazz

"JackRazz" wrote:

Dave, All I have in my 'Save as type' is

*.xlsx
*.xlsm
*.xlsb
*.xls
*.xml
*.mht

So I must be missing something. Could I have missed it in my
install?

Thanks - JackRazz




"Dave Peterson" wrote:

When you do a saveas, don't you see options in the "save as type"
dropdown?

JackRazz wrote:

Hey everyone,
I'm trying to create a file for my global macros and would like
to use an
Add-in instead of the more classic Personal.xlsm method. I don't
see how to
save a worksheet with my macros as an addin or xlam file. How do
I do this?

Also where is the save as cvs file format?

Thanks - JackRazz

--

Dave Peterson


--

Dave Peterson





All times are GMT +1. The time now is 12:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com