Pass Parameter from Excel to SharePoint

  • Thread starter Thread starter ryguy7272
  • Start date Start date
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--
 
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--
 
Back
Top