open different spreadsheets dependant on one field

[themastertaylor]

Is there some code that will enable me to open a different excel
spreadsheet dependant on the value shown in a form? I've got a number
of projects and i want a button on the projects form that will call up
a related spreadsheet. each project has its own buying spreadsheet
detailing the quotes we've received for that site, i want to be able
to view a site in a form, click one button and open the sheet for that
specific site.

Thanks

[fredg]

On Fri, 17 Aug 2007 09:43:33 -0000, th*************@hotmail.com wrote:

Is there some code that will enable me to open a different excel
spreadsheet dependant on the value shown in a form? I've got a number
of projects and i want a button on the projects form that will call up
a related spreadsheet. each project has its own buying spreadsheet
detailing the quotes we've received for that site, i want to be able
to view a site in a form, click one button and open the sheet for that
specific site.

Thanks

Does the control on the form contain the full name of the spreadsheet,
i.e. "MedicalCenter"?

Application.FollowHyperlink "C:/PathToFolder\" & [FieldName] & ".xls"
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail