shieldsco
asked on
Rename excel sheet from Access
I need to rename an Excel sheet from a button in Access. Any thoughts. Thanks
Name filepath\filename as newfilename
ASKER
I need to rename the sheet not the file
Ah, missed that.
OK. All worksheets? Just the 1st (2nd, 3rd,) etc? Do they already have names other than default?
OK. All worksheets? Just the 1st (2nd, 3rd,) etc? Do they already have names other than default?
ASKER
Just the first sheet from a button in access
Access and excel versions?
ASKER
2010
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Good Job -- Thanks
You are welcome!
/gustav
/gustav