Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I don't have any access to MS Office, but SkyDrive for personal use is proving great for my basic edits, but as soon as somebody sends me a workbook containing macros, which I don't need, I can't upload it to Skydrive, even with macros disabled. Is there anything I can use to strip macros from the workbook? I'm even willing to write some code and share it if necessary, but surely someone has done this already.

share|improve this question
add comment

3 Answers

up vote 2 down vote accepted

You might be able to use Microsoft's free Excel Viewer as an intermediate step. Open the worksheet in the viewer, then copy and paste the contents into a document on Skydrive. I haven't tried this myself, but I have used the copy/paste trick to get rid of macros in Excel worksheets so it may work.

share|improve this answer
    
Very nice suggestion, thanks! Have to wait to tomorrow to get the viewer, but it looks like this can work. –  ProfK Jul 31 '11 at 17:29
add comment

What version of Excel are you using?

If you are using Excel 2007 or 2010 then you have the option to save the workboox as a "Macro-free" (.xlsx) workbook. To do that simply open the workbook, then go to File -> Save as and change the workbook type to .xlsx.

If you are using an older version of Office then there is a macro here that you can paste into your personal "default" workbook that claims to be able to strip all the macros out of any workbooks you open. Note that macros in your personal workbook do not get copied to new workbooks so that will not be a problem.

share|improve this answer
    
I'm not using any version of Excel, hence the need for me to use SkyDrive. I've added that morsel of info to my question. –  ProfK Jul 31 '11 at 12:26
add comment

A macro enabled Excel workbook can be saved to SkyDrive by first making a copy of all (or a subset) of the sheets as a standard XLSX. Additionally, some cleaning can then be executed on the copy such as the removing of external link references and other features not supported on web apps. There is a VBA sub routine that accomplishes this at http://www.business-spreadsheets.com/forum.asp?t=1085.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.