Import Data Into a Different Workbook Using VBA

Import Data Into a Different Workbook Using VBA

VBA Code Explained in the video:

Sub ImportTab()

Dim i As Integer
Dim T As Integer
Dim fName As String
Application.DisplayAlerts = False
Application.ScreenUpdating = False
For i = 1 To 1
fName = "C:\Temp\Sales\Sales"
ActiveWorkbook.Worksheets(i).SaveAs Filename:=fName
Next i

'Message box
MsgBox "Data Imported Successfully"

End Sub

*****************************************
*****************************************
*****************************************

Check out my Previous video on "How to Import Data Into a Different Tab Using VBA" :

#Excel
#ExcelTips
#ExcelTutorials