Hi
I would appreciate some help with vba from access please. The following code works fine:
set objSheet = ObjExcel.Sheets("5TH 2004")
However, I want the user to provide the sheet name from a form. I have tried all sorts of variations using the form field name me.frmSheet such as
set objSheet = ObjExcel.Sheets("me.frmSheet") but no joy.
Please can anyone help me?
Sue (fairly new to VBA)