Excel VBA Backup Process Backing up non targeted workbooks

[wherdzik]

I have a backup process that backs up an important workbook when it is opened, ever 15 minutes and when closed. It works great but the problem is that when I am working in multiple workbooks once the timer hits 15 minutes..whatever file I have opened gets backed up not the file that the code is in. I have attached a file for your refernce so you can see what the process looks like. What do I need to change so that it always backs up this file and not the excel file that is currently being worked on. Hopefully that makes sense...

If I can proivder more information please let me know..
thanks!

[Greg M]

Hi there,

Knee-jerk and untested, but you could try the following modification to your code:

Please Login or Register  to view this content.

Hope this helps.

Regards,

Greg M

[wherdzik]

Thank you Greg I will try it and monitor. That is probably spot on. Much appreciate your time for reply.

[wherdzik]

Greg, sorry I just noticed something Do I need to also change the following:

Please Login or Register  to view this content.

See right after the file path it says ActiveWorkbook.Name...Should I change it to ThisWorkbook.Name?

[Greg M]

Hi again,

Good catch! I should have spotted that one

Yes indeed, change it to ThisWorkbook - "ThisWorkbook" will always refer to the workbook which contains the code, whereas "ActiveWorkbook" refers to whichever workbook happens to be active when the code is executed.

Regards,

Greg M

[wherdzik]

No worries at all, I am just thankful you were able to guide me in the right directions. Much-much appreciated.
Without this forum , my excel life would be misearable So thank you.

[Greg M]

Hi again,

Many thanks for your very prompt feedback.

You're welcome - glad I was able to help.

Regards,

Greg M

[wherdzik]

Greg, I got a chance to play with this today and it still does not work unfortunately. Here is the complete code.

Before Close

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Do you think I can change anything else?

[Greg M]

Hi again,

Here's how I would write those routines:

Please Login or Register  to view this content.

Hope this helps as before, - please let me know how you get on.

Regards,

Greg M

[wherdzik]

Works like a dream! Thank you!

[Greg M]

Hi again,

Many thanks for your feedback and also for the Reputation increase - much appreciated!

You're welcome - glad I was able to help.

Best regards,

Greg M