<div>
I like the first idea using VB.net application to make the webservice connection call and return the result for excel spreadsheet.<br />
<br />
And from excel If I can call the vb.net application or component to grab the data and display in excel spreadsheet.<br />
<br />
Is there any way I can update the excel spreadsheet automatically from VB.net application?<br />
<br />
Is there any sample code for similar approach. In what format I should return the data from vb.net application which translate to excel. <br />
<br />
<br />

</div>


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.




<div>
I'm sorry. I do not know how to do this. I was hoping someone in the other zones would respond.<br />
<br />
I suggest closing this question and asking a new question in the VB.net zone.<br />
<br />
Kevin
</div>


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.

Kevin

<div>
<div class="content wysiwyg-content">
I want to make a webservice call with some secure method from excel. <br />
<br />
How can I prevent the for some one to hacked the excel macro code and copy the webservice url. <br />
<br />
How can &nbsp;incrypt the URL post to webservice and the result back from webservice to excel on client side.
</div>
</div>


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.

How to make webservice call from excel securely.

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications

ASP.NET

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Encryption is the process of encoding messages or information in such a way that only authorized parties can read it. In an encryption scheme, the intended communication information or message, referred to as plaintext, is encrypted using an encryption algorithm, generating ciphertext that can only be read if decrypted. For technical reasons, an encryption scheme usually uses a pseudo-random encryption key generated by an algorithm. An authorized recipient can easily decrypt the message with the key provided by the originator to recipients, but not to unauthorized interceptors.