Z
Zedox
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.
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.