Message Box givig an Option to Create a new file

[MHamid]

Hello,

I created a code that does excalty what I need with the exception of a message box when openinga file that does not exits.

What I need is a message box to appear somewhere after the code below alerting the user that the file it attempted to open does not exists and giving the user the option to create the file so that the code could continue and finish. This message box will need to appear for each sheet in the code (944300, 937698, 937839, 976601, and 644597445).

Please Login or Register  to view this content.

Would this be possible? If so, how can I accomplish this?


Thank you,
Miriam

[HaHoBe]

Hi, Miriam,

what about

Please Login or Register  to view this content.

And maybe you could use an array or an area on any sheet to lay down the names of the sheets involved and work with them in a loop instead of hard-coding the individual names.

a code that does excalty what I need

I doubt that copying the whole worksheet is necessary.

CIao,
Holger

[MHamid]

Looping would be my next project to work on with this after I get it to work. I will post that problem in a new post later. Thanks!!

As for my issue, your code worked, but what it did was created a new sheet within the workbook I am using, but i would actually like another message box after waht you gave me asking the user if they want to create a new workbook, copy the data as normal, and save it as the filename (not the path) per cell I1.

Is that possible?

Thank you,
~Miriam

[HaHoBe]

Hi, Miriam,

maybe like this:

Please Login or Register  to view this content.

Ciao,
Holger