Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Converter
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Converter
Hello.
Have a look here : http://www.eggheadcafe.com/software/...ck-for-ex.aspx Regards. Daniel "Wiz" a écrit dans le message de news: ... 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Converter
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Converter
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA Converter | Excel Discussion (Misc queries) | |||
VBA Converter ADD in | Excel Discussion (Misc queries) | |||
converter | New Users to Excel | |||
PDF Converter | Excel Discussion (Misc queries) | |||
PDF converter to xls | Excel Programming |