Excel VBA to Save Data to Another Workbook

200+ Video Tutorials - 200+ Downloadable Excel Reference Files - 50+ Hours of Content

Downloadable File: Available in the VBA course.

I walk you through every step required to seamlessly use VBA/Macros to save data into a separate workbook and then close and save that workbook.

In this tutorial, I show you a setup that is easy to follow, manage, and apply to your situation.

The main things that you will learn in this tutorial include:
- Referencing workbooks using variables.
- Opening workbooks using VBA.
- Moving data between multiple workbooks in VBA.
- Closing workbooks using VBA.
- Saving workbooks using VBA.

Excel Courses:

#excel #vba #tutorial

[timparke]

Exactly what I was looking for... Thank You!!!!

[darrylmorgan]

Really Nice Simple Bit Of VBA Code Thumbs Up...Thank You Sir :)

[wayneedmondson]

Fun one! I hacked out my own solution before watching the video. Picked up some good tips from your detailed lesson. Thanks for sharing. Thumbs up!!

[shaiquenasir]

Very useful for me. Thanks
I have macro based excel sheet but how to share for multiple user entry. Please suggest.

[AzharyRahim]

thank you, with little adjustment i'm able to finish my work

[wishboneattack]

If you want to be sure it saved instead of just a msgbox that is basically telling you the macro has ended, you can add an IF statement using the two lines he already gave you to do a simple verification check. Put this right above wbMaster.Close True

IF wbMaster.Worksheets("Data".Cells(masterNextRow, 1).Value = Value And wbMaster.Worksheets("Data").Cells(masterNextRow, 2).Value = Then
MsgBox "Part Saved"
Else
MsgBox "Part not saved correctly"
End IF

[murattulek]

AB AN ERROR: thank you so much for your share and contribution us. i want to ask a question: normally this code run well but when i open another workbook i receive "RUN TIME ERROR NO 9", how can i fix this? (when i close the other workbook code starts well again) thanks a lot in advance!

[tomgebka]

Great video - the one piece that I am looking for is how to assign a path name for a file on Onedrive that I want to update, not a local workbook. Is there more to it than just the correct path name? When I look at the file path for the Onedrive it shows me a link.

Thanks in advance

[hirunimarasinghe]

Thank you for sharing. But I found an error in the line of masterNextRow- subscript error.

[ryanallen]

How can I run this same code, but with the feature of keeping the vbMaster open while using the input source? I would like to see the data entry happen side by side and not have the master file automatically close each time an input is "saved". Thanks!

[suzannejoshua]

Hi, may I know how I can save the data without opening the excel workbook using only the vba excel form.

[shriharibhat]

Thank You for the informative video.
I would just like to know how we can transfer range of values. I tried inserting the range in the inverted commas, but it is taking only value of the 1'st mentioned cell. If anyone could please help me with it would be great help.
Thanks Anyways :)

[maheshkhursale]

Thanks. It's very useful. But can we have multiple copy of the input worksheet at clients side and data can be inputed at a time from multiple worksheets?

[vinothsathiyavan]

Hiii.. if my closed workbook stored in online how to mention the file path?

[Couchsleepr]

I need to do this but copy a full table over what changes do I need

[TeachExcel]

200+ Video Tutorials - 200+ Downloadable Excel Reference Files - 50+ Hours of Content

[thebetalearner]

Is there a way to keep the values entered in the form instead of them disappearing when you hit save?

[curtismorris]

Why won’t my workbook file location work?

[travisbenge]

alright, what if I don't want to make duplicate entries but update an existing entry with additional/different information

[moesadr]

Is there a way that one can globally print all the codes ( Modules, Macros, ....) in a an Excel file ( Workbook) to review, cross over, .... to be able to alter some without creating a catastrophe?