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

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?

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

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.

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?

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,