Export Sheet to new Workbook

[adgjqetuo]

Hello,

I am looking for a VBA code that will look at sheet 2 and Sheet 3 and if there is data present to export them to a new workbooks. They need to be seperate workbooks - is this possible?

If there is no data, then the code should do nothing.

Thank you in advance.

[JBeaucaire]

Maybe something like this...this will prompt you asking for a filename:

Please Login or Register  to view this content.

[adgjqetuo]

I put in the VBA however it didn't do anything when I ran the code.

[JBeaucaire]

Let's make sure it's in the right place:

How/Where to install the macro:

1. Open up your workbook
2. Get into VB Editor (Press Alt+F11)
3. Insert a new module (Insert > Module)
4. Copy and Paste in your code (given above)
5. Get out of VBA (Press Alt+Q)
6. Save your sheet as a macro-enabled workbook.

The macro is installed and ready to use. Press Alt-F8 and select it from the macro list.

If it still does nothing at all, try restarting Excel and reloading the newly saved workbook.

[adgjqetuo]

Please see the attached - when you run it, it doesn't do anything.

[JBeaucaire]

Change this and try again:

Please Login or Register  to view this content.

[adgjqetuo]

Thanks! That worked however I do not like how it forces you to save - is there a way to change this? I was thinking if anything I'd like it to auto save as below:

Please Login or Register  to view this content.

"Seg" and "PONumber" are defined earlier in my code. This is an addition to an already existing code.

[JBeaucaire]

Looks like a plan.

If that takes care of your need, use the Thread Tools menu to mark the this thread as [SOLVED].


(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated. It is found across from the "time" in each of our posts.)