It sounds like no matter what, you're going to be relying on the remote user. To make things most simple, you could supply the remote user with a perl script that will extract the data needed, and then encrypt it to send to you. You'd be in control of the encryption algorithm used at both ends this way.

Another option is to have excel spew its data into a cvs, then encrypt that file using whatever method you wanted so long as it was reversable.

And finally, a bit of VBA like Taulmarill wrote above could be used to export the file in an encrypted way, but this is probably the most complicated and slowest option to code. (meaning getting the code working will take the longest, I'm not attempting to make predictions of which option is going to be the fastest once written).

-Scott

Update: The Email encryption eXile has suggested above is also a good option I hadn't thought of. It reminded me of yet another option: Is the remote user using VPN to connect back to you? If so, the network is already encrypted, and you wouldn't need to encrypt that file before transmitting.

In reply to Re: encrypt excel documents by 5mi11er
in thread encrypt excel documents by Win

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.