Demosthenes&Locke
Board Regular
- Joined
- May 11, 2010
- Messages
- 93
I have a workbook that is named based on the entry in a cell when the person selects save as. These workbooks are always in the same place and will always be the same formatting of the date:
08-02-10-to-08-08-10.xls
08-09-10-to-08-15-10.xls
Now because the workbook is based on a variable set within itself, I can also calculate the previous workbook's name using that same variable.
I want to be able to link to my previous workbook without having to manually put in each link. I've tried using indirect also, and both ways an extra pair of " quote marks show up, and I presume that is what is screwing the proverbial pooch. Anyone know another way to calculate the name of a workbook and have it work?
I'm thinking of next trying to add in vb the calculation and the setting of a cell to the formula I need to pull up the closed workbook, I just wanted to be able to make it in a cell.
08-02-10-to-08-08-10.xls
08-09-10-to-08-15-10.xls
Now because the workbook is based on a variable set within itself, I can also calculate the previous workbook's name using that same variable.
I want to be able to link to my previous workbook without having to manually put in each link. I've tried using indirect also, and both ways an extra pair of " quote marks show up, and I presume that is what is screwing the proverbial pooch. Anyone know another way to calculate the name of a workbook and have it work?
I'm thinking of next trying to add in vb the calculation and the setting of a cell to the formula I need to pull up the closed workbook, I just wanted to be able to make it in a cell.