SpearC1993
New Member
- Joined
- Jan 22, 2016
- Messages
- 5
Hello all,
Back again for another question!
Can I use a cell value in VBA to open a file for example:
Set January = Workbooks.Open("C:\Users\"CELL A1 HERE".xls") <- this is a guess
In my work sheet have a cell like such
<tbody>
</tbody>
The result would then be that the macro would open an excel in the location "C:\Users\January_3047.xls". At the moment I have statically written these in but I dont want to write over this code every month.
Back again for another question!
Can I use a cell value in VBA to open a file for example:
Set January = Workbooks.Open("C:\Users\"CELL A1 HERE".xls") <- this is a guess
In my work sheet have a cell like such
A | ||
1 | January_3047 |
<tbody>
</tbody>
The result would then be that the macro would open an excel in the location "C:\Users\January_3047.xls". At the moment I have statically written these in but I dont want to write over this code every month.