I have tried and tried but no success
I have this macro code
Wb = workbook.Open(C:/workfiles/expenses/week9.xls")
I would like the end bit the file name e.g. week9.xls to be value from worksheet cell A3 how do I rewrite code to be able to take value from cell A3 to be in code.
E.g if A3 value is week10 the line will be
Wb = workbook.open(C:/workfiles:expenses/week10.xls")
Anyone help please
Thanks
I have this macro code
Wb = workbook.Open(C:/workfiles/expenses/week9.xls")
I would like the end bit the file name e.g. week9.xls to be value from worksheet cell A3 how do I rewrite code to be able to take value from cell A3 to be in code.
E.g if A3 value is week10 the line will be
Wb = workbook.open(C:/workfiles:expenses/week10.xls")
Anyone help please
Thanks