How to automate a web query login to download data in Microsoft Excel 2007?

Question

Hi, Have anyone can sharing with me the info on which is how to automate a web query login to download data in Ms.Excel 2007? Problem is existing that i need to manually login through a web query each time.... Thanks in advance for any help you can provide!

Answer 1

USE C# COM INTERFACE FOR EXCEL THROUGH WHICH U CAN INJECT ANY DATA INTO EXCEL...... hit google with following search keywords and u will get 100's of result for it

using Excel = Microsoft.Office.Interop.Excel;

now the above is basically possible in ASP.NET ONLY. OTHERWISE get an interface for excel with your corresponding programming language.

http://stackoverflow.com/questions/2413682/change-in-behaviour-generation-of-nullreference-exception

see this u will get some idea..