Good day
I'm Peter and have a query regarding a VBA function I want to implement in an Excel 2003 file. I've some Matlab programming background, but no VBA experience, so assistance would be greatly appreciated.
I've got a file template sitting on a server. A user pulls this file and creates a new file with the filename and path in the form Z:\Facility\Admin\Order\BxxxxYYY.xls
What I want to happen is that cell F6 should automatically contain the filename, ie BxxxxYYY when the file is opened. Furthermore, in cell H10 the date should automatically be entered when the file is opened, but should from then on stay static. With =today(), I can obtain the date the file has been accessed for the first time, but this changes everytime the file is opened on a different date.
I've tried my luck on forums and by myself, to no avail. Hence I contact the experts.
Bookmarks