How to make webservice call from excel securely.

Posted on 2009-12-30
Last Modified: 2012-05-08
I want to make a webservice call with some secure method from excel.

How can I prevent the for some one to hacked the excel macro code and copy the webservice url.

How can  incrypt the URL post to webservice and the result back from webservice to excel on client side.
Question by:Bharat Guru
    LVL 81

    Accepted Solution

    The short answer is that Excel VBA code cannot be securely protected without the use of third party tools. There are two basic approaches.

    The first approach is to extract the sensitive code into compiled external library files using any compilable language such as VB6, or C##. The advantage is that the sensitive code is converted to a compiled form and is much harder to view or reverse engineer. The disadvantage is that another development environment with suitable compiler is required. The estimated cost of a development environment such as Visual Studio is between $500 and $700. Another disadvantage is that an additional file is required to run the Excel workbook.

    The second approach is to purchase a third party tool ( that compiles the Excel workbook into a stand-alone application. The advantage is the compiled workbook will run without the Excel application. According to the Excel compiler author the compiled application runs much faster. The disadvantage is that the cost of the workbook compiler is $3,000.

    What is gained by protecting IP? Is it worth it? Most don't think so. Before pursuing one of the above paths consider what motivates people. Most people really don't care what's under the hood. Most of the few who do just want to see how the workbook was built - nothing malicious - just curiosity. The very few who would do something bad are going to do it no matter what is done to the workbook to protect the contents and that's what lawyers are for.


    Author Comment

    by:Bharat Guru
    I like the first idea using application to make the webservice connection call and return the result for excel spreadsheet.

    And from excel If I can call the application or component to grab the data and display in excel spreadsheet.

    Is there any way I can update the excel spreadsheet automatically from application?

    Is there any sample code for similar approach. In what format I should return the data from application which translate to excel.

    LVL 81

    Expert Comment

    by:zorvek (Kevin Jones)
    I'm sorry. I do not know how to do this. I was hoping someone in the other zones would respond.

    I suggest closing this question and asking a new question in the zone.


    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    Join & Write a Comment

    By default, Carbonite Server Backup manages your encryption key for you using Advanced Encryption Standard (AES) 128-bit encryption. If you choose to manage your private encryption key, your backups will be encrypted using AES 256-bit encryption.
    When the confidentiality and security of your data is a must, trust the highly encrypted cloud fax portfolio used by 12 million businesses worldwide, including nearly half of the Fortune 500.
    This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
    This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now