Error In macro that checks if the file is already open

[Launchnet]

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.

[rylo]

Hi

Here's another approach. You only need to enter the file name, not the path

Please Login or Register  to view this content.

called like

Please Login or Register  to view this content.

rylo

[Launchnet]

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 ????

[Charlize]

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

[Launchnet]

Hi Charlize . . .

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

Have a great one.

I'll post as solved.