Hi
I'm currently exporting a query result into an excel workbook. However, I now need to export the workbook & save it with a different save name every time (the week number needs to change).
I created a form with an unbound text field for the user to enter the week number in, but i'm really struggling to get the entry carried over into the save name.
Hope that makes sense....any help???!!
I'm currently exporting a query result into an excel workbook. However, I now need to export the workbook & save it with a different save name every time (the week number needs to change).
I created a form with an unbound text field for the user to enter the week number in, but i'm really struggling to get the entry carried over into the save name.
Hope that makes sense....any help???!!