I am the accountant for an insurance agency evaluating Office 2007 Small
Business Trial Version for upgrading our workstations. Our agency accounting
software has some old customized Excel macros that have worked seamlessly
with our Office 2000 Small Business installations. They now will not work
with Office 2007 as it has a "missing component". The Office Online Knowledge
Base informs me that a VBA Converter Pack must be installed and to do so I
must contact support. Why is this VBA Converter Pack not already readily
available for download? Why must I spend $49 on customer support just to be
told how I can get it? Why is Office 2007 Small Business less functional, or
not fully downward compatible, to the Office 2000 version?

I do not understand why Microsoft chooses not to give easily obtained and
free support on their trial versions. I certainly see no reason to upgrade
when the trail version is already letting me know that it will not work.

I am finding this whole exercise very frustrating.
--
Regards,

Ray

I agree with you. I have a regular (ie non-trial) version of Office 2007 and
can't use a boatload of spreadsheets because of the missing "VBA Converter
Pack". It's not available for download. This is completely ridiculous.

"Ray" wrote:

> I am the accountant for an insurance agency evaluating Office 2007 Small
> Business Trial Version for upgrading our workstations. Our agency accounting
> software has some old customized Excel macros that have worked seamlessly
> with our Office 2000 Small Business installations. They now will not work
> with Office 2007 as it has a "missing component". The Office Online Knowledge
> Base informs me that a VBA Converter Pack must be installed and to do so I
> must contact support. Why is this VBA Converter Pack not already readily
> available for download? Why must I spend $49 on customer support just to be
> told how I can get it? Why is Office 2007 Small Business less functional, or
> not fully downward compatible, to the Office 2000 version?
>
> I do not understand why Microsoft chooses not to give easily obtained and
> free support on their trial versions. I certainly see no reason to upgrade
> when the trail version is already letting me know that it will not work.
>
> I am finding this whole exercise very frustrating.
> --
> Regards,
>
> Ray

I agree with both of you. It is ridiculous.

What to do: if you have the chance to have access to the older version Excel
2003, VBA converter is already included, so you can do what you need to do,
and then back to version 2007.

It is a shame that version 2007 is less featured than older one!

Good luck.

"Ian" wrote:

> I agree with you. I have a regular (ie non-trial) version of Office 2007 and
> can't use a boatload of spreadsheets because of the missing "VBA Converter
> Pack". It's not available for download. This is completely ridiculous.
>
> "Ray" wrote:
>
> > I am the accountant for an insurance agency evaluating Office 2007 Small
> > Business Trial Version for upgrading our workstations. Our agency accounting
> > software has some old customized Excel macros that have worked seamlessly
> > with our Office 2000 Small Business installations. They now will not work
> > with Office 2007 as it has a "missing component". The Office Online Knowledge
> > Base informs me that a VBA Converter Pack must be installed and to do so I
> > must contact support. Why is this VBA Converter Pack not already readily
> > available for download? Why must I spend $49 on customer support just to be
> > told how I can get it? Why is Office 2007 Small Business less functional, or
> > not fully downward compatible, to the Office 2000 version?
> >
> > I do not understand why Microsoft chooses not to give easily obtained and
> > free support on their trial versions. I certainly see no reason to upgrade
> > when the trail version is already letting me know that it will not work.
> >
> > I am finding this whole exercise very frustrating.
> > --
> > Regards,
> >
> > Ray

Hi J.C.,

The VBA converter pack add-on, if it's the one I recall, is fairly dated and probably not extensively tested with Excel 2007. It
may be available from a prior version (or it could be a new version available through Product Support) but you may want to use the
link below to also post in the MS Excel discussion group on this. There may be other solutions. The converter pack may not actually
do what you would think from its name, but the folks in the Excel group would be more knowledgeable.

=============
<<"JC" <JC@discussions.microsoft.com> wrote in message news:158F1BFF-21D6-457C-B1D4-3947F1F32193@microsoft.com...
I agree with both of you. It is ridiculous.

What to do: if you have the chance to have access to the older version Excel
2003, VBA converter is already included, so you can do what you need to do,
and then back to version 2007.

It is a shame that version 2007 is less featured than older one!

Good luck. >>
--
Please let us know if this has helped,

Bob Buckland ?:-)
MS Office System Products MVP

>>*Courtesy is not expensive and can pay big dividends<<

LINKS
A. Specific newsgroup/discussion group mentioned in this message:
news://msnews.microsoft.com/microsoft.public.excel
or via browser:
http://microsoft.com/communities/new...t.public.excel

B. MS Office Community discussion/newsgroups via Web Browser
http://microsoft.com/office/communit...s/default.mspx
or
Microsoft hosted newsgroups via Outlook Express/newsreader
news://msnews.microsoft.com

Same problem here as far as being directed to VBA Converter Pack. However,
the file in question is an .XLA file. I can find a copy of excel 2003 as
directed below but don't see how to edit/update the .xla file since it works
fine in 2003 as an add-in. Is there an vba converter exe or something in
office 2003 i can force to update/revise the existing .XLA file that
apparently has vba code 2007 doesn't like?

Thanks!

"JC" wrote:

> I agree with both of you. It is ridiculous.
>
> What to do: if you have the chance to have access to the older version Excel
> 2003, VBA converter is already included, so you can do what you need to do,
> and then back to version 2007.
>
> It is a shame that version 2007 is less featured than older one!
>
> Good luck.
>
> "Ian" wrote:
>
> > I agree with you. I have a regular (ie non-trial) version of Office 2007 and
> > can't use a boatload of spreadsheets because of the missing "VBA Converter
> > Pack". It's not available for download. This is completely ridiculous.
> >
> > "Ray" wrote:
> >
> > > I am the accountant for an insurance agency evaluating Office 2007 Small
> > > Business Trial Version for upgrading our workstations. Our agency accounting
> > > software has some old customized Excel macros that have worked seamlessly
> > > with our Office 2000 Small Business installations. They now will not work
> > > with Office 2007 as it has a "missing component". The Office Online Knowledge
> > > Base informs me that a VBA Converter Pack must be installed and to do so I
> > > must contact support. Why is this VBA Converter Pack not already readily
> > > available for download? Why must I spend $49 on customer support just to be
> > > told how I can get it? Why is Office 2007 Small Business less functional, or
> > > not fully downward compatible, to the Office 2000 version?
> > >
> > > I do not understand why Microsoft chooses not to give easily obtained and
> > > free support on their trial versions. I certainly see no reason to upgrade
> > > when the trail version is already letting me know that it will not work.
> > >
> > > I am finding this whole exercise very frustrating.
> > > --
> > > Regards,
> > >
> > > Ray

Same problem here as far as being directed to VBA Converter Pack. However,
the file in question is an .XLA file. I can find a copy of excel 2003 as
directed below but don't see how to edit/update the .xla file since it works
fine in 2003 as an add-in. Is there an vba converter exe or something in
office 2003 i can force to update/revise the existing .XLA file that
apparently has vba code 2007 doesn't like?

Thanks!

"JC" wrote:

> I agree with both of you. It is ridiculous.
>
> What to do: if you have the chance to have access to the older version Excel
> 2003, VBA converter is already included, so you can do what you need to do,
> and then back to version 2007.
>
> It is a shame that version 2007 is less featured than older one!
>
> Good luck.
>
> "Ian" wrote:
>
> > I agree with you. I have a regular (ie non-trial) version of Office 2007 and
> > can't use a boatload of spreadsheets because of the missing "VBA Converter
> > Pack". It's not available for download. This is completely ridiculous.
> >
> > "Ray" wrote:
> >
> > > I am the accountant for an insurance agency evaluating Office 2007 Small
> > > Business Trial Version for upgrading our workstations. Our agency accounting
> > > software has some old customized Excel macros that have worked seamlessly
> > > with our Office 2000 Small Business installations. They now will not work
> > > with Office 2007 as it has a "missing component". The Office Online Knowledge
> > > Base informs me that a VBA Converter Pack must be installed and to do so I
> > > must contact support. Why is this VBA Converter Pack not already readily
> > > available for download? Why must I spend $49 on customer support just to be
> > > told how I can get it? Why is Office 2007 Small Business less functional, or
> > > not fully downward compatible, to the Office 2000 version?
> > >
> > > I do not understand why Microsoft chooses not to give easily obtained and
> > > free support on their trial versions. I certainly see no reason to upgrade
> > > when the trail version is already letting me know that it will not work.
> > >
> > > I am finding this whole exercise very frustrating.
> > > --
> > > Regards,
> > >
> > > Ray

I'm in a similar boat as most of you who have replied to this post. My
sistuation involves running software for me Masters Degree program - the VBA
macros won't open in Excel 2007. I get an error message telling me to searhc
online for "VBA Converters". When I do search all I find are posts about how
upset other people are... Next step for me is to write a letter to MS. Let's
see how that goes...
Xaviar

"Ray" wrote:

> I am the accountant for an insurance agency evaluating Office 2007 Small
> Business Trial Version for upgrading our workstations. Our agency accounting
> software has some old customized Excel macros that have worked seamlessly
> with our Office 2000 Small Business installations. They now will not work
> with Office 2007 as it has a "missing component". The Office Online Knowledge
> Base informs me that a VBA Converter Pack must be installed and to do so I
> must contact support. Why is this VBA Converter Pack not already readily
> available for download? Why must I spend $49 on customer support just to be
> told how I can get it? Why is Office 2007 Small Business less functional, or
> not fully downward compatible, to the Office 2000 version?
>
> I do not understand why Microsoft chooses not to give easily obtained and
> free support on their trial versions. I certainly see no reason to upgrade
> when the trail version is already letting me know that it will not work.
>
> I am finding this whole exercise very frustrating.
> --
> Regards,
>
> Ray

A letter will allmost certainly produce nothing
I've not used vba in excel, but have in Access, when upgrading from Office2k
to 2003 it was neccesary to edit the macros and vba as the later version
used different routines, took all of a few hours

"Xaviar" <Xaviar@discussions.microsoft.com> wrote in message
news:7088131B-C366-496C-95A3-6A9985159992@microsoft.com...
> I'm in a similar boat as most of you who have replied to this post. My
> sistuation involves running software for me Masters Degree program - the
> VBA
> macros won't open in Excel 2007. I get an error message telling me to
> searhc
> online for "VBA Converters". When I do search all I find are posts about
> how
> upset other people are... Next step for me is to write a letter to MS.
> Let's
> see how that goes...
> Xaviar
>
> "Ray" wrote:
>
>> I am the accountant for an insurance agency evaluating Office 2007 Small
>> Business Trial Version for upgrading our workstations. Our agency
>> accounting
>> software has some old customized Excel macros that have worked seamlessly
>> with our Office 2000 Small Business installations. They now will not
>> work
>> with Office 2007 as it has a "missing component". The Office Online
>> Knowledge
>> Base informs me that a VBA Converter Pack must be installed and to do so
>> I
>> must contact support. Why is this VBA Converter Pack not already readily
>> available for download? Why must I spend $49 on customer support just to
>> be
>> told how I can get it? Why is Office 2007 Small Business less functional,
>> or
>> not fully downward compatible, to the Office 2000 version?
>>
>> I do not understand why Microsoft chooses not to give easily obtained and
>> free support on their trial versions. I certainly see no reason to
>> upgrade
>> when the trail version is already letting me know that it will not work.
>>
>> I am finding this whole exercise very frustrating.
>> --
>> Regards,
>>
>> Ray

Ray et all -
Had the same problem. For those still having see the following link:
http://www.mrexcel.com/forum/showthread.php?t=280893
See instructions to download two DLL files and paste them accordingly. Works
like a charm.
Chris

"Ray" wrote:

> I am the accountant for an insurance agency evaluating Office 2007 Small
> Business Trial Version for upgrading our workstations. Our agency accounting
> software has some old customized Excel macros that have worked seamlessly
> with our Office 2000 Small Business installations. They now will not work
> with Office 2007 as it has a "missing component". The Office Online Knowledge
> Base informs me that a VBA Converter Pack must be installed and to do so I
> must contact support. Why is this VBA Converter Pack not already readily
> available for download? Why must I spend $49 on customer support just to be
> told how I can get it? Why is Office 2007 Small Business less functional, or
> not fully downward compatible, to the Office 2000 version?
>
> I do not understand why Microsoft chooses not to give easily obtained and
> free support on their trial versions. I certainly see no reason to upgrade
> when the trail version is already letting me know that it will not work.
>
> I am finding this whole exercise very frustrating.
> --
> Regards,
>
> Ray

Download this two DLL files (vbacv10.dll & vbacv10d.dll) from www.dlldump.com
and placed in \program files\common files\microsoft shared\vba\vba6 then
restart Excel.

It works !

Komi

--------------------------------------------------------------------------

"Chris" wrote:

> Ray et all -
> Had the same problem. For those still having see the following link:
> http://www.mrexcel.com/forum/showthread.php?t=280893
> See instructions to download two DLL files and paste them accordingly. Works
> like a charm.
> Chris
>
> "Ray" wrote:
>
> > I am the accountant for an insurance agency evaluating Office 2007 Small
> > Business Trial Version for upgrading our workstations. Our agency accounting
> > software has some old customized Excel macros that have worked seamlessly
> > with our Office 2000 Small Business installations. They now will not work
> > with Office 2007 as it has a "missing component". The Office Online Knowledge
> > Base informs me that a VBA Converter Pack must be installed and to do so I
> > must contact support. Why is this VBA Converter Pack not already readily
> > available for download? Why must I spend $49 on customer support just to be
> > told how I can get it? Why is Office 2007 Small Business less functional, or
> > not fully downward compatible, to the Office 2000 version?
> >
> > I do not understand why Microsoft chooses not to give easily obtained and
> > free support on their trial versions. I certainly see no reason to upgrade
> > when the trail version is already letting me know that it will not work.
> >
> > I am finding this whole exercise very frustrating.
> > --
> > Regards,
> >
> > Ray