VBA Converter Pack-Office/Excel 2007

[Ray]

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.

 

[Ian]

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.

 

[JC]

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.

 

[Bob Buckland ?:-\)]

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.

=============
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

LINKS
A. Specific newsgroup/discussion group mentioned in this message:
news://msnews.microsoft.com/microsoft.public.excel
or via browser:
http://microsoft.com/communities/newsgroups/en-us/?dg=microsoft.public.excel

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

 

[Rich]

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!

 

[Xaviar]

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

 

[DL]

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

 

[Chris]

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

 

[Komi Ahiakpo]

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

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