Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
ac ac is offline
external usenet poster
 
Posts: 18
Default Windows 7 Corrupting Excel 2007 Files with VB Code?

Situation:

One developer is using Windows XP (64 bit) and provides a copy of his Excel
2007 macro enabled workbook utilizing a substantial amount of VB code to a
second developer who in running Windows 7 (64 bit) and the same version of
Excel 2007 as the first developer.

VB code modifications were made by developer two and the file saved, then
given back to developer one. When developer one opened the modified file,
many of the macros in the workbook ceased to function properly for various
reasons that seemed like they were related to unexplanable, incorrect
workbook references

The exact same code modifications made by developer two and manually entered
into the VB code of the original file residing on developer one's computer
resulted in a completely error free, working program.

Even if the original file is left completely unmodified, if the second
developer clicks to save the file and sends it back to the first developer,
the same issues occur. Multiple file transfer attempts included ftp, e-mail,
and flash drives to ensure it wasn't the method that was causing the problem.
The second developer also attempted to run in a variety of compatability
modes before saving the file to see if that changed the results-- it did not.

Any insight as to what could be causing this would be much appreciated.
Thank you in advance.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
I cannot open Office 2007 Excel files From Windows Explorer David Excel Discussion (Misc queries) 6 October 10th 09 09:42 PM
Cannot Open Excel 2007 Files From Windows Explorer David Excel Discussion (Misc queries) 0 October 10th 09 12:36 AM
Excel 2007 corrupting shared formulae in worksheet richardf Excel Programming 0 June 23rd 09 11:26 AM
Excel 2007 on Windows XP computer will not open .xlsx files. Gotoknow Excel Discussion (Misc queries) 0 June 4th 09 01:08 AM
Bug with pivot tables corrupting in Excel 2007 Mike Croom Excel Discussion (Misc queries) 1 May 10th 07 09:02 AM


All times are GMT +1. The time now is 07:34 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"