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
| Attachment | Size |
|---|---|
| dummy file vba.xls | 32 KB |
| Import template.xlsx | 7.39 KB |
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.