Calling an excel file via a macro

Question

I want to create a macro that pulls a file by allowing the user to browse and locate the file from his/her local and then perform some functions on the pulled file.

I am not sure how to incorporate the browsing file feature in the macro.

Sounds like you want to use [`Application.FileDialog`](https://msdn.microsoft.com/VBA/Excel-VBA/articles/application-filedialog-property-excel) — YowE3K, Jul 05 '17 at 10:23
yes ... but it wont be a "xlsm" type it will be an "xlsx" extension — prerna arora, Jul 05 '17 at 10:24

score 0 · Answer 1 · answered Jul 05 '17 at 10:23

0

Use Application.FileDialog, there are lot's of examples in SO and elsewhere on the internet, for example here

answered Jul 05 '17 at 10:23

FunThomas

23,043
3
18
34

score 0 · Answer 2 · answered Jul 05 '17 at 10:26

The below will open and set wkbFileToOpen, you will then be able to use this as your workbook to manipulate.

Dim vFileToOpen As Variant
Dim wkbFileToOpen As Workbook

'Ask the user to select the file, you can change your desired file extensions and file types
vFileToOpen = Application.GetOpenFilename("Excel Files (*.xls),*.xls,", 1, "Select the workbook", , False)

'if the user cancels, then vFileToOpen will be false, so we need to check there's a value
If Not vFileToOpen Then

    Workbooks.Open vFileToOpen
    Set wkbFileToOpen = ActiveWorkbook

End If

Calling an excel file via a macro

2 Answers2