Error In macro that checks if the file is already open

Hi everyone - - - I thought that I had this working completely, but the test to see if the "file is already open" isn't working.

Something is wrong with my example.

I have marked in the code where the problem is. Everything else works.
It's marked as such:

HERE IS MY PROBLEM - - - - - - - - - - - - - - - - - - - - - - - - - - -
Can someone please tell me what I'm doing wrong ?

Please Login or Register  to view this content.

Please take note: The path and file name constantly change.



The following Function IS CALLED to check if the File Is Open - or Not

'It all works if the Path & File Name are hard coded. I have to have it working with changing Paths & File names.

Please Login or Register  to view this content.

Hi rylo . . .
Good to hear from you again.

As I see it, the function isn't my problem. The function works properly, it simply isn't getting the Path and File name from the 1st macro.

I should also have mentioned, that each file name is in a separate instance of Excel.

I also want, if possible, that this should also work from a macro that opens a word document, checking to see if document is already open. Maybe I may have to use a second function when opening a word document which would be OK ????

You aren't passing the value of a variable to your function but the value cl. Maybe try this :

Please Login or Register  to view this content.

A little example to show the difference in passing the contents of a variable (declared as string) or a string

Please Login or Register  to view this content.

Charlize

Hi Charlize . . .

You Charlized it. Works perfect for both Excel and Word.

Have a great one.

I'll post as solved.