Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 10-12-2012, 02:03 PM
Paul Cain Paul Cain is offline Incompatibility Excel VBA 2007/2010 Windows 7 64bit Incompatibility Excel VBA 2007/2010 Office 2007
Novice
 
Join Date: Oct 2012
Location: Australia
Posts: 6
Paul Cain is on a distinguished road
Default

Hi Colin

If I could give you an example as I am working with Matris on this:

Private Const gJAyzhMlkudo = "z0Ê®¥Å*Ÿ*éò„þ ©£¼²7GT@e¥B", mScMDpMZf = "+Õ¤qE¤b¥v.±t{»½åpÃî ¦W{~€ÐKrmM™ÊìòÓ©Y¿Éq*Ñ*çW’kØâcy°»Ê.¦±¢v‡kÏJ<Xûn$É, ¢iö5+îÒ¼¶Kï²þ", pSkjDhmMpelEEXIoGKcznvw = " ÉÐsRaß*N*œZ=D³G£¡“©Œ", KgMfEPYbo = "I½×*óâµw\Œ0'°ˆ}#UGÄ-A©Ž»t#ÕÐ_wÝ–*¸ H'ÃÍ£Ê}mŠ_„9åÕŒ¡ÙÅ3%Ä….CK)±cåö’ØJu1gÛÜ", BhHVaDeOhlhPQpRmlcYYWBUknI = "÷fÞÞx*Î&`zNΩŸ¤Ã)ÈÞ¹fL¨XØáºÅ¦ð6G$ùYõȵôPŠûîoÀÕG2ƒ ÊÖg1¿¬‹à~?‡c°‰âMëÈ û3‹Ëç(?áøCTƒC", kIkzUiqIdMzHXQs = "E¾ÈAŽ)HèÅÃM± ‘Z\sJ©xÞ.îâP–ÎÁˆ$ å*Ô(f:¤J_Qñ¥lÒ×u:SR´ªÏ-.ð", eKVeycLwtKRab = "J-¤€Ø8v¾ÈÑA`*/)~°¡2–+<¼¦5a²ó4oÕzÅ“…{", IDFY = "8`䜌5‚ŸC•ôëª88‚‚]{þr^‘Ó]!\*d ú", lpWG = "OýÒÖÂzƒn}…3yB¼}*I$¤ –CêÑËß%!Düõù.", yQleYRPIDsHmQYYYOPDoNngUlrT = "l7{^F;ÕhKµÒäñl¿ÓË®¢±H™ˆUe¼ìê¡‚#à*½!2Ôšõ…ìX^äºàÀ> M³§A ü³Š&=›VIç%¥ö", smbLlRNjeRsUGtwTtpA = "~0…W@—¤ÖL¼…ៗ2Çî:ܰNаF>˧FÁBGÒºš ô/?7qÒzÝj;Öñjšß*ºÄc®ié*µÁ»›<ïYë½=·<Û»×ü!K™,Âßç¨fEÖõò 0ùÙì›’”ÑÕýTL¾mDEU½rí¿7ˆÂð‹Q·U•σ*ö)ú#á{?k€„ë–šœíM‚ üý1¨IÉQòaæ£åÒÑ"

There are 907 characters (including spaces) in this particular line, which is typical, maximum was 935.
29 out of 56 modules have similar lines at the start.
Only 4 of these modules will not load, the same 4 whether I create the modules in 2007 and move the program to 2010 or in reverse order.

I have since done a test in which I split these lines in half to reduce their length and this makes no difference (tested with 1 module only, 2007 to 2010).

I have also remmed out the lines in another module and this made no difference (again tested with 1 module, 2007 to 2010).

In these most recent tests, all that appeared in these 4 modules that faulted was 1 remmed line, Option Explicit, then nothing or the first of the lines like the above example.

After these latest tests, it does not appear that these lines in themselves are the reason.

Earler tests tried to isolate a portion of the code which when moved or remmed allowed the module to load. In these tests, the offending code was moved to a new module and worked perfectly, but it appeared that a problem would then appear in a different module altogether!

At this stage, I am therefore at a loss to know what the problem is and don't know where to look next.

Any suggestion?

Thanks
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