Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


How to make webservice call from excel securely.

Posted on 2009-12-30
Medium Priority
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
  • 2
LVL 81

Accepted Solution

zorvek (Kevin Jones) earned 500 total points
ID: 26148418
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, VB.net 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 (http://turboexcel.com) 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
ID: 26149591
I like the first idea using VB.net application to make the webservice connection call and return the result for excel spreadsheet.

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

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

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

LVL 81

Expert Comment

by:zorvek (Kevin Jones)
ID: 26159320
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 VB.net zone.


Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
This article covers the basics of data encryption, what it is, how it works, and why it's important. If you've ever wondered what goes on when you "encrypt" data, you can look here to build a good foundation for your personal learning.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…
Suggested Courses

580 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