Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 483
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

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