Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #9  
Old 10-15-2012, 12:54 AM
Volker Frank Volker Frank is offline Incompatibility Excel VBA 2007/2010 Windows 7 64bit Incompatibility Excel VBA 2007/2010 Office 2010 32bit
Novice
 
Join Date: Oct 2012
Posts: 1
Volker Frank is on a distinguished road
Default same problem encountered in PowerPoint 2007 / 2010, both 32 bit

Hi all,

not sure whether 32/64 bit is the right direction to go. I had the same problem with PowerPoint and it seemed to have been a problem with const not being declared private (where possible). I do have (public) const in my project and they work. Only additional constants that were added later and used only in the respective modules seem to have caused the trouble. Maybe 64 bit is only aggravating a different cause?

Quite weird: you test, compile and save the project in either version (2007/2010) and you cannot open it with the other without code being dismissed. Always the same module(s), different starting lines though. And the other modules had constants added later, too. So why do some modules fault while others don't? And why consistently the same modules? (Though I have to admit having had variations such that two modules faulted at the beginning. After I had restructured the project to isolate code only one module faulted. However after implementing test results (only minor changes), another module started to fault, too. Ever since it had been these two modules and after declaring constants private whereever possible, I was able to open the project in both PowerPoint versions crosswise. Luckily! I hope this is a stable solution ;-)

As the code is working fine in both versions of PowerPoint, I would not have expected any incompatibility if that's the right word to use for this trouble. So how does PowerPoint 2010 save (or open) VBA projects differently from 2007? Does anyone have technical information on that? Or has a suggestion where to search? (In case I am encountering the problem again.)
Reply With Quote
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to create microsoft Excel 2007 and 2010 File in .xlsx format ipacesetters Excel 1 12-16-2019 05:13 PM
Excel 2007 custom ribbon not showing in Excel 2010 Paulzak Excel 2 02-17-2012 06:35 PM
Incompatibility Excel VBA 2007/2010 VBA code from Excel 2007 in Excel 2010 csam63 Excel Programming 1 10-07-2011 10:46 AM
Excel 2010 Ribbon look like 2007's Ribbon esotop Excel 0 03-22-2011 07:05 PM
Incompatibility Excel VBA 2007/2010 Word Basic 2003 to Word Basic 2007 Incompatibility Mark1110 Word VBA 1 12-29-2010 11:04 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:13 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft