QUOTE (Cosmichighway @ Jan 12 2012, 07:14 PM)
Gerry, did that work for you?
Only back at the sheet this morning. Ientereed the following code as my function:
Dim ApXL As Object
Dim xlWBk As Object
Dim xlWsh As Object
Set ApXL = CreateObject("Excel.Application")
Set xlWBk = ApXL.Workbooks.Open("S:\?????\019 - ???\Focused Improvement\Charts\Focused Improvement Chart Data 2.xls")
ApXL.Visible = False
Set xlWsh = xlWBk.Worksheets("Chart_Data")
I changed the visibiity to "False" so that the user will not see the excel spreedsheet opening. Other than that it worked perfectly. Thank you for you help.
This site is an absolute cracker for anyone learning access. This help is excellent.