• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 481
  • Last Modified:

Use a web page to open an Excel spreadsheet and populate it

I have information displayed on an ASP page, and from this page I would like to open an existing Excel file and populate certain cells with data from the ASP page.

Is this possible and if so, what is the best way of doing it.  I don't want to create the Excel file using ASP, I want to use an existing Excel file and simply fill in the cells

Many thanks in advance
0
cjohnson300
Asked:
cjohnson300
  • 2
1 Solution
 
suvmitraCommented:
You need to use Excel --> Import Data -> New Web query. Provide the address / URL of your Asp Page -> Go--> Select the Table (->)-->Import.
 
0
 
cjohnson300Author Commented:
Sorry, I should have said that I want to initiate the copy over from the web page, not Excel
0
 
cjohnson300Author Commented:
I solved this one myself by using ASP to write to a vbscript file and then call the vbscript file to open the excel file and paste in the values
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now