Excel 2007 macro works differently on different systems.

**marty_r** · 12-08-2011, 01:44 PM

I have an Excel 2007 workbook with a macro that takes the data from one worksheet and makes a seperate TXT file. It works fine on two on my computers. On the third, the macro runs and gives no indication of an error, but not all of the data is transfered to the TXT file. All the systems have Excel 2007, all updates with the same SP , updates, ect..
Any help is appreciated.

**TMS** · 12-08-2011, 02:20 PM

Does it matter how much data? How many records?

If it can be repeated with a relatively small number of records, I'd step through the code on each machine and monitor the variables and output.

You could post a sample workbook and someone could see what output they get.

Regards

**marty_r** · 12-08-2011, 03:27 PM

I stepped through and at each step everything was correct, but the txt file still was wrong. Here is the excel file itself, a good txt and bad txt file. The difference in the two is the column with the "E" 's in it. The excel sheet is set to output the txt file to c:\test If you create a test folder at c:\ , you shouldn't need to make any other changes for it to work..

Thx

Marty

**TMS** · 12-08-2011, 05:11 PM

On my laptop, I end up with a file which is identical to the "good" output.

I guess the answer is to step through the code on the bad machine and watch as each cell is filled in. Clearly something is different on the "other" machine.

Unfortunately, using single alpha character variable names isn't overly conducive to diagnosis, but there doesn't appear to be any calculation.

Confusing

Regards, TMS