Thread: VBA Converter
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default VBA Converter

Microsoft doesn't even seem to know anything about the converters. There is
one download page for VBA converters, for Excel 5/95 VBA macros that need to
run on a Mac.
http://www.microsoft.com/downloadS/d...displaylang=en

The KB article you've cited seems to be for converting Excel 5/05 macros to
any "modern" version of Excel. Which I never knew to be a problem. And the
article says to search the Microsoft site, when there should be links right
on that page.

I would suggest opening the file in an intermediate version of Excel, 2003
if possible, and saving it in .xls Excel 97-2003 format (not in Excel 5/95
format).

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


"Angelina" wrote in message
...
I have seeing the same error message microsoft posted on this page

http://support.microsoft.com/kb/926430

And cannot find "VBA Converter Pack for Microsoft Office Excel 2007"

online concierge cannot help either.

Anybody get it from microsoft?

Angelina

"Jon Peltier" wrote:

Never heard of such a thing. I frequently use old code without needing a
converter; at worst sometimes an old command needs its parameters
adjusted.
Was there an error message? Had you tried running any of the old code? Or
is
a little gremlin causing you grief?

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


"Wiz" wrote in message
...
Hi All
I was called in to an old workplace this week to do some data gathering
from
old excel worksheets (I think 97) and the VBA I had written to gather
the
data originally was going to be of great benefit!! When I opened the
first
spreadsheet in Excel 2007, to my horror there was an error message
saying
I
had to get a VBA converter and all VBA code would be lost. I went
looking
for such a converter and couldn't find one. Geez, can't Microsoft read
or
convert their own stuff. I am seriously annoyed, one of 65,565 other
times
I've been really annoyed with these people over the last 20 years.

Can anyone please help, I need this code, I don't want to write it all
over
again!
I have a deadline to meet.

Thanks in anticipation.
Wiz