Detect the File path change state (excel)

[Ayoubas01]

Hello,
I need to know how I can detect the path change state of my excel file, to set my counter to zero, if the state changes, I was thinking of an event structure, but I don't know how to use it, is it that there are tracks or example for this kind of problem, thank you to all.

[GerdW]

Hi Ayoubas,

---

@Ayoubas01 wrote:

how I can detect the path change state of my excel file,

---

Which "excel file"?

What is a "path change state"?

Does the filepath change somehow somewhen in the middle of your file operations? (Why?)

What exactly do you want to achieve?

[Ayoubas01]

I want once the file path is changed by the user, at this time I have to detect this change to reset my register to zero, the change of path t is manually writing by the user during recording File,I hope you get the idea

[GerdW]

Hi Ayoubas,

---

@Ayoubas01 wrote:

I want once the file path is changed by the user, at this time I have to detect this change

---

Use an event structure with a ValueChange event for that filepath control...

[Ayoubas01]

I saw that, but I did not understand how, if you can give me an example I will be grateful thank you🙏

[GerdW]

Hi Ayoubas,

---

@Ayoubas01 wrote:

I did not understand how, if you can give me an example

---

Simple like this:

[Ayoubas01 · Accepted solution]

Using a simple path shift register I was able to solve the problem

thanks to all