MsgBox to start macro for other spreadsheet (OK) or cancel

[Nicooo]

Hi,

I am working on a VBA to switch to another active worksheet (other file) and start or cancel a macro.

With a MsgBox the user can validate if he would like to run the macro on the spreadsheet (name is showed) or not. The cancel part is working, the OK part as well, however, the macro runs in the spreadsheet with the command buttons and not in the intended spreadsheet.

Please Login or Register  to view this content.

So I would like to run the macro's from one spreadsheet with command buttons on different spreadsheets.

Looking forward to receive tips.

Kind regards,

Nicooo

[Kaper]

Hope x variabe used in

Please Login or Register  to view this content.

has value of this other workbook name
In the code you've shown this is the most probable prroblem cause. The other possibel problem source is: where the code is placed - is it in standard module or in worksheet code?

[Nicooo]

Hi Kaper,

Thank you for your quick response.

The workbook names are different each time because they show the date and time of when the export is created/downloaded. This macro is listed in 'Module 1'.

Please find the file which I would like to use as dashboard with command buttons attached (EDIT: I cannot attach the file to the post).

Kind regards,

Nicooo

[Kaper]

Unfortunately the attachment icon doesn't work at the moment. So, to attach an Excel file you have to do the following: Just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

[Nicooo]

Hi Kaper,

Thank you, attached now.

Hope you can help me out.

Kinds regards,

Nicooo

[Kaper]

In Kitting procedure (you shown, and the one in attached workbook) all te code for displaying the other workbook name, show msgbox, etc. is disabled, because the
'
at the beginning of the line converts given line to a comment (not excecuted part).

As I already suspected ;-), after removing apostroph signs, variable x (a file to open) is not assigned (and not defined).

Try something like:

Please Login or Register  to view this content.

BTW. I'm a bit worried by "creëren" in msgbox - do you plan to create new file or to use (second) one which is open?

[Nicooo]

Hi Kaper,

That's working. Thanks a lot!

It has to use the second file open.

Kind regards,

Nicooo

[Kaper]

Hi,

Glad to hear that

It would be also lovely if you could marke thread SOLVED (use "thread tools" above your first post, and "add me some reputation" by clicking a small star icon in lowerleft corner of my post(s). (and confirming in pop-up that "you agree").
As opposite to many other sites, you can grant reputation to several posts of one/many users and not only in threads started by you.

Best Regards,