I need VB code that will implement a macro in excel.
The url will be a link to a servlet that creates a csv file.
I want the csv data to appear starting in the cell specified.
The url will be an https:// link to a site that will need to get a session id from a cookie. The way the website works, if I manually login to the website, it gives me a session ID in a cookie such that if I later typed the url into the IE address bar, it would not require login (because it will check the cookie and notice that my session is still active), and it would popup the dialog box asking if I wanted to save the .csv file or open it using excel. Need the macro to somehow use the cookie rather than asking for a password.
Also, I want to avoid any dialog boxes popping up in front of the user. The macro should just "work" and blast the data into the sheet.
I also want a demo excel spreadsheet that implenents this function on one worksheet, with a "refresh" button on another sheet that will rerun the macro, get updated data from the server and overwrite the previous data (being sure to clear out all the old data).
I'll give the actual URL to the winning bidder.
Working VB conforming to the spec above that I can paste into Excel 2000 and up. Demo spreadsheet as specified above.
Solution must not require custom dll or nonstandard dll's that are not part of standard office2k and above installations.
Windows ME, 2000, XP