Em Andamento

VB / Excel / OLE project

I need VB code that will implement a macro in excel.

GETWEBDATA(url,cell)

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.

## Deliverables

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.

## Platform

Windows ME, 2000, XP

Habilidades: PHP

Ver mais: works need excel, starting with visual basic, excel macro to get data from website, vb in excel, xp project, vb excel, save to excel, need to get excel, excel password, excel function, file dialog custom, ole excel, save session data, php excel csv, refresh excel spreadsheet, excel macro csv, refresh spreadsheet macro excel, excel can open file, sheet excel visual basic, excel spreadsheet check check, dialog box dll project, project macro, blast website, excel cell, excel refresh

Acerca do Empregador:
( 2 comentários ) United States

ID do Projeto: #2960419

Premiar a:

derektpvw

See private message.

$102 USD em 2 dias
(109 Avaliações)
6.5

2 freelancers estão ofertando em média $94 para este trabalho

timk98

See private message.

$85 USD in 2 dias
(54 Comentários)
4.7