Hi
i need a vba code that inserts the already opened workbook name in a variable. i.e. if workbook named "data" is opened. i need the code to enter the name "data" into a variable when it is opened. The workbook name will change from time to time, so i can not put data = name = variable. i need the code to read what workbook name i just opened, and put it into the variable because the name may change from data to tuesday, to apples, to whatever ad infinitum. thanks for all the help
i need a vba code that inserts the already opened workbook name in a variable. i.e. if workbook named "data" is opened. i need the code to enter the name "data" into a variable when it is opened. The workbook name will change from time to time, so i can not put data = name = variable. i need the code to read what workbook name i just opened, and put it into the variable because the name may change from data to tuesday, to apples, to whatever ad infinitum. thanks for all the help