Corruption from Excel Mac to Win

shadowq

New Member
Joined
Jun 25, 2011
Messages
2
Hello!

I've got a unique problem. I'll provide a little bit of background first- I've created a platform for users to download a number of excel workbooks. Once they download the workbook, they are actually unable to save the workbook locally, but upon trying to save, I have a number of macros that force the save to happen remotely, and with their particular username and password. That all works fine, and works accross Office 2003 - 2010 for Windows.

Excel 2011 for Mac didn't like this though. So using AppleScript, I pass the excel workbook to Curl to upload it to the FTP server. Again, all is fine.

But occasionally (I have not figured out the trigger yet), when saving in Mac, and then opening on Windows- all the text in every single button in the workbook has become unrecognisable text. For example- "P cK [ £{ «£C+s£K £+ PkË *à +c šƒ“+ #›C++£ 2Kc+ s{»q" is what it says in one box. Once it becomes corrupt for Windows, there is no way to go back! (Although, it still appears fine on Mac).

Now, I have no idea why this is happening?! Can anyone please shed some light? I first thought maybe it's something to do with the way it was being uploaded? But then- wouldn't it affect all text, not just text in buttons?

Any help, or even any ideas or suggestions would be much appreciated!

Thank you in advance!
 

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.
Macs use Unicode based text for their operating system.
Excel uses Ascii, sometimes the two might come into confusion.

Are you using any special fonts?
 
Upvote 0
Thanks for the quick reply Mike.

Would it help if I was to change the way I'm using CURL- upload it via HTTP and set the data type to ASCII?

As for any special fonts- Nope. Just the Excel default - Calibri / Arial.
 
Upvote 0
I'm not familiar with UNIX commands. I was just shooting in the dark for an explaination of strange characters.

Does the number of characters change or only their value?

If you have an issue with scripting Mac Unix, you might try
http://macscripter.net/index.php
 
Upvote 0

Forum statistics

Threads
1,224,506
Messages
6,179,159
Members
452,892
Latest member
yadavagiri

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top