Go Back   TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



VBA converter

MS Office Support


Reply
 
Thread Tools Search this Thread
  #1  
Old 01-08-2008
Member
 
Join Date: Apr 2004
Posts: 64
VBA converter

Hi, Iím using Windows Vista with Office 2007. I have a very old Excel sheet which needs to add the ODBC addin in order to run. But as you all might be knowing ODBC addin does not work without VBA converter. So I tried to download VBA converter pack for Office 2007 but dint found it anywhere. I request you guys to please let me know where can I get the same?

Reply With Quote
  #2  
Old 01-08-2008
Member
 
Join Date: Sep 2004
Posts: 148
Re: VBA converter

Iím bit confused with your post because as far as I know Office 2007 still uses VBA. So Iím not sure whether you are referring VBA or something else. Can you just clarify whether it is VBA or xlodbc.xla ?

Apart from this I would also like to know how old your Excel file is ?
Reply With Quote
  #3  
Old 01-08-2008
Member
 
Join Date: Apr 2004
Posts: 64
Re: VBA converter

I appreciate your reply friend. Actually we are using that Excel file on Office 2003. When I tried to addin the ODBC, Excel 2007 tells me that I need the "VBA converter". Later i installed Office 2007 Enterprise edition using MSDN development set and I had looked at the Shared options in the Office install that the VBA application was installed. Furthermore i installed Office Compatibility pack for 2007 but still getting the same problem.
Reply With Quote
  #4  
Old 01-08-2008
Member
 
Join Date: Sep 2004
Posts: 127
Re: VBA converter

As per my experience I donít think the problem is with VBA but its Excel itself. Is it Excel 5 or Excel 97? Anyways just try out this. Make a copy of that excel file and open it in Office 2003 or 2007. Click the office button at top left corner and select Save As option. If it's not Excel 97-2003 then first try saving it as Excel 97-2003 and see if that works. If not then if you have access to Excel 2003 you might want to try opening the file in that version and upgrading the file to Excel 2003.
Reply With Quote
Reply

  TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Tags: ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "VBA converter"
Thread Thread Starter Forum Replies Last Post
VOB converter? Dharitree Media Player 2 23-08-2011 08:27 AM
Best Flv to mp3 converter wirelessprom Windows Software 6 29-12-2009 02:58 PM
VHS to PC DVD Converter neonxgenesis Windows Software 5 06-11-2009 09:45 AM
looking for a DTT-900 converter box dyoungen Portable Devices 2 24-08-2009 06:55 PM
Vob to avi converter B e B o Windows Software 2 24-08-2009 10:52 AM


All times are GMT +5.5. The time now is 10:50 PM.