View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Zedox Zedox is offline
external usenet poster
 
Posts: 1
Default Automate Excel URL Web Query

Synopsis:
I made this winforms application that automates a webpage from data the user
inputs. The webpage collects data and puts it into a database (it's a tab
delimited format). All I have to do is make a URL web query so that the
information is automatically inserted into the Excel file when the user opens
the excel file and click refresh.

What I want:
For the user to open the Excel File and press "Refresh" to get the
information from the webpage.

Question:
How do I set an Excel Object's URL Web Query?

What I know how to do:
Create an Excel Object, Workbook, and Worksheet.

Language of Choice:
C#

Thank you in advance. If I am not clear in what I want to do, please tell me
so I can elaborate.