VBA to Import Sheet - Excel VBA to Import Sheet from Closed Workbook (Code Included) | Excel VBA
VBA to Import Sheet - Excel VBA to Import Sheet from Closed Workbook
#CTTUTORIAL
This example explains how to import sheet from other workbook with VBA Code. We can copy specific sheet from a closed workbook and paste into active workbook or transfer to any other workbook.
Follow me on :
Facebook: / arka09
Email:[email protected]
Telegram Channel:t.me/ct_tutorial
Subscribe:https://bit.ly/32hPbjd
Code:
Private Sub CommandButton1_Click()
Dim directory As String, fileName As String, sheet As Worksheet, total As Integer
'to avoid screen fliking
Application.ScreenUpdating = False
Application.DisplayAlerts = False
'
directory = "E:\Youtube\Test\"
fileName = Dir(directory & "*.xl??")
Do While fileName != ""
Workbooks.Open (directory & fileName)
For Each sheet In Workbooks(fileName).Worksheets
total = Workbooks("import-sheets.xlsm").Worksheets.count
Workbooks(fileName).Worksheets(sheet.Name).Copy _
after:=Workbooks("import-sheets.xlsm").Worksheets(total)
Next sheet
Workbooks(fileName).Close
fileName = Dir()
Loop
Application.ScreenUpdating = True
Application.DisplayAlerts = True
End Sub
copy,sheet,move,transfer,import,copy sheet,move sheet,transfer sheet,import sheet,vba,macro,vba to copyy sheet,vba to move sheet,vba to import sheet,vba to export sheet,macro to copy sheet,copy sheet to another workbook,copy sheet from different workbook,vba tutorial,best vba tutorial,top vba tutotial
