Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default 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
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default 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

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default 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

  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default 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


  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 22,906
Default 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


  #7   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default 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
  #8   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default 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

  #9   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 22,906
Default 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


  #10   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6,582
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
global zero suppress Excel 2007 Big Al[_2_] Excel Discussion (Misc queries) 2 October 22nd 09 03:20 PM
Global find and replace in Excel 2007 Woodman Excel Discussion (Misc queries) 1 November 3rd 08 11:44 PM
Excel - global VB macros cs Excel Programming 4 April 27th 06 07:18 PM
How to put excel macros in a 'global' place. Peter van de Kerkhof Excel Programming 4 March 4th 04 12:05 AM
Creating Global excel macros Sebastian_var Excel Programming 3 February 10th 04 06:57 PM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"