Import/transfer data from worksheet to workbook in vba

Hi Everyone,

i;m not familiar using the vb application in excel, can someone here know how to do the importing file to excel using vba.

1. i have attached the "dummy file" with form on it. i don't know how to show it up when the workbook is open. and you will see the import button. once the user hit the Import button it will show another form that will prompt the user to locate the file. the file would be "import template" which i have also attached.

i don't know how to code this.

i don't know how to transfer the data from import template to the dummy file vba.

thanks,
Albert

AttachmentSize
dummy file vba.xls32 KB
Import template.xlsx7.39 KB
Nick's picture

import file

I'll start you off..

To obtain a file path, take a look at this tip:

excelexperts.com/VBA-Tips-Get-A-File-Path

Then, to complete the VBA, record a macro of the actions that you do once the file is open.