Copy Data to New Workbook with VBA Code without saving new Workbook

**SimonCampbell** · 10-19-2021, 05:45 AM

This should be easy but I can't seem to work it out. I have a worksheet, and want to copy (Range A1:O300) to a NEW Workbook and PASTESPECIAL Values and Formats
Google and YouTube are just not delivering anything this simple. I want the VBA Code to do this.

Hope someone can help

**AliGW** · 10-19-2021, 05:51 AM

Not sure how you are searching, but have a look at the two tutorials below:

https://www.excelcampus.com/vba/copy...ther-workbook/

https://excelchamps.com/vba/copy-cell-to-new-worksheet/

**SimonCampbell** · 10-19-2021, 06:39 AM

Yes I've seen these, BUT seeing as my project will be used on a number of different platforms amongst other TEAMS, I didn't want the NEW workbook to be saved with a name or location, I just want it to open and paste the data into it, giving the user option to save it to where he /she wants. The Code I am using now is

Please Login or Register  to view this content.

**AliGW** · 10-19-2021, 06:42 AM

OK - your thread title ought to reflect this as it's a pretty significant caveat and you didn't even mention it in your first post!

Update the title in your first post to this thread, please.

**SimonCampbell** · 10-19-2021, 06:52 AM

ooopss! wasn't aware it was such a significant caveat. Getting up the learning curve

**KOKOSEK** · 10-19-2021, 06:53 AM

Copy, create and paste.

Please Login or Register  to view this content.

Copy Data to New Workbook with VBA Code without saving new Workbook

LinkBack

Thread Tools

Rate This Thread

Display

Copy Data to New Workbook with VBA Code without saving new Workbook

Re: Copy Data to New Workbook with VBA Code

Re: Copy Data to New Workbook with VBA Code

Re: Copy Data to New Workbook with VBA Code

Re: Copy Data to New Workbook with VBA Code

Re: Copy Data to New Workbook with VBA Code without saving new Workbook

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] VB Code to copy certain data to another workbook

[SOLVED] Copy data workbook to another workbook vba code

VBA code to copy data from current workbook to another workbook and send email

[SOLVED] VBA code to copy data to new workbook

VBA code for copy data from closed workbook to "Data " sheet of current workbook

[SOLVED] Code to copy data from a closed workbook and paste in active workbook using named range.

VBA code to copy data from one workbook to another workbook if one criteria is met.

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions