We have two price lists. One is our base price list and then we have +25%, +40%, etc for different buying levels. The base price list, let's call "Platinum Pricing" and the other price let's call "contractor pricing". Currently I have the documents residing on our server so all we have to do is update platinum pricing and it updates the other two automatically. We did this by using the =ROUND('E:\Price Lists\Order Form\[Platinum Order Form 6-2010.xls]CUSTOMER ORDER FORM'!J32*0.65,1)+'E:\Price Lists\Order Form\[Platinum Order Form 6-2010.xls]CUSTOMER ORDER FORM'!J32

We have an FTP or online folder that is password protected. I obviously don't want to give the password to our customers since there is other data in there they don't need to see, nor do we need someone at "Contractor Pricing" seeing what "Platinum Pricing" is. So if I substitute =ROUND(http://website.com/orderform/[Platinum Order Form 6-2010.xls]CUSTOMER ORDER FORM'!J32*0.65,1)+http://website.com/orderform/[Platinum Order Form 6-2010.xls]CUSTOMER ORDER FORM'!J32

It works however it is asking for a username and password to the online folder selected. How do I add a username and password to the file (vb script?? or other route) that will make this seamless for the user without giving them the username and password?

This will save us from having to email out a new order form when we update pricing or add new products.

Using excel 2003

THANK YOU, THANK YOU, THANK YOU.