Pass Parameter from Excel to SharePoint

R

ryguy7272

I’m trying to open an Excel file from SharePoint. Here is a the scenario.
I’d like to be able to pass a parameter from excel to SharePoint, and have
SharePoint identify if the file exists on my SharePoint site. For instance,
here is the generic URL:
https://collaboration.net/sites/Documents/Forms/AllItems.asp

What I want to be able to do is pass a file name as a Parameter, and open
the appropriate Excel file with the same name, so it may be something like
this:
https://collaboration.net/sites/Documents/Forms/AllItems.asp?test=5262010.xls

It will always be the URL and the word ‘test’ and the file name, which is
unique because it is an AccountID.

I’ve imported from HTML sources, and aspx sources, many times, and even
exported from Excel to HTML, but I’m not an expert in this area, and I’m not
really sure how it will work with SharePoint. Any thoughts? I’d greatly
appreciate any input on this.

Thanks,
Ryan--
 
R

ryguy7272

Thanks ker! I don't think I really understand where you're going with this.
Can you please elaborate? I'm thinking of something like this:
http://finance.yahoo.com

Then pass a value to the URL, so I get something like this...
http://finance.yahoo.com/q?s=ibm
http://finance.yahoo.com/q?s=msft
http://finance.yahoo.com/q?s=ko

It's for my own site, though; not Yahoo!
Basically, I want to pass the parameter to the SharePoint site, and the
results are displayed, or even better, an Excel file that is already stored
on the site, is opened when a user enters an account number (the account
number should match the file that is stored on the SharePoint site).

Thanks so much!!
Ryan--
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top