In a cell D4 in my worksheet, I have the filepath and name of a file I wish to open, e.g, C:\Mike1\abc.xlsm
Could anyone give me VBA for a user defined function that I could use in say, cell E4, that would return TRUE if the file is already open in the current instance of Excel?
Thanks,
Mike
Could anyone give me VBA for a user defined function that I could use in say, cell E4, that would return TRUE if the file is already open in the current instance of Excel?
Thanks,
Mike