VBA to Browse File and Open File in Excel

This Example explains how to Browse a file, Capture the path of selected file in a cell or variable. How to use File Dialog Box to get the file path and open the selected file using simple VBA Code in Excel.

[@aliyasir4104]

Thanks for sharing i have one question if we want to browse data from any of the location from the system for complier so how we can give the coding for that?

[@mohammedameerahmed2250]

Thank you so much. Really helped alot.

[@ExcelDestination]

Welcome

[@pratik9217]

the pop-up doesn't come in front when calling this macro from vbs--why?,how to resolve it?

[@anhnhatnguyet4628]

Convert multi file excel, all sheet with cell formula to value, how work with vba ?

[@ExcelDestination]

you need to loop through sheets and then use pastespecial as value method using vba code. to loop through sheets, you can watch tutorial at :
ruclips.net/video/AlC8a7KyJq0/видео.html

[@nitawinidiantari4867]

I made vba coding to open file excel 2000 with path xls, but it doesnt running, could you help me to fix it ?

[@johnvodopija]

This is exactly what I was looking for. Thank you for the clear tutorial 👍😎🇦🇺

[@ExcelDestination]

thanks!

[@acexzavier897]

dunno if anyone gives a shit but if you guys are stoned like me atm then you can stream pretty much all of the new movies on InstaFlixxer. Have been watching with my brother for the last few weeks :)

[@jadenconrad8882]

@Ace Xzavier Yea, I've been using instaflixxer for months myself :D

[@rostislavslavov2993]

Nice one!
Can you please show how I can add a pdf file in each row and open it in a viewer inside excel?

[@aakashpanchal8686]

I want to browse and open the excel file in the same excel file from where I have clicked on browse , copy the data of the browsed excel file and paste it to my existing excel file. Is there a way I could do it?

[@SuperHanme]

This is exactly what I was looking for. Thank you for the clear tutorial

[@ExcelDestination]

You are welcome!

[@pandharinathjoshi6565]

Nice video sir.
If some body copy and paste file to another PC... it will work Path in that system
Bcoz I want fix that path only one pc, if somebody copied file it could not work or open... pls sir help us

[@fmathsfun7397]

Sir how it is automatically opening desktop only can we specify which drive it has to open

[@ExcelDestination]

a small modification would be required to do this task in the given example

[@veebee3969]

Thank you for the video. If the file opened (using GetOpenFileName) has multiple sheets, how to make the user select a particular sheet with a mouse click?

[@ExcelDestination]

you can use additional code to activate specific sheet

[@anicetojoaocostacassama2826]

Very useful code 😁
Is there any way out we can close the opened file using VBA. thanks

[@ExcelDestination]

Yes! you can watch another tutorial for that at below given link :
ruclips.net/video/IT98PPe0WpQ/видео.html

[@mohitiagrawal9752]

how to add an image with a browser and fit in a fixed column

[@tharanya]

Very helpful info thanks a lot

[@premkumart3315]

Good one

[@Time_utilize]

Where to get the file for reading coding clearly...

[@nitawinidiantari4867]

Sir may i ask you, how open a file with greatest size in one folder thanks

[@ExcelDestination]

There is a VBA function named FILELEN. This function chek the file size in bytes. Syntax is : FileLen( file_path ). You can loop through files and then store file sizes in array and then decide about biggest size file. Try at your end. If you can not you can share your VBA requirement at [e-mail]. I have a small team that works upon excel vba projects.

[@ramsaple9986]

hello sir
I want one select file button. to select multiple file at different cells

[@ExcelDestination]

yes, that can be done.

[@foodvlogs3049]

How

[@anicetojoaocostacassama2826]

Very useful code 😁
Is there any way out we can close the opened file? thanks

[@johnpaulbadajos633]

will this open a pdf format file?

[@code4all870]

Video is nice and useful. Just make video how send this file mail

[@aodieuhoaquatgioazuki]

hey, can you tell me how to make a chart after select file
thank u so much :x

[@ExcelDestination]

You need to write code for certain things like first select and open file then referencing range and the code for creating chart. It is very much doable.

[@aodieuhoaquatgioazuki]

@@ExcelDestination I finished writing the reference code and opened the file. Can you teach me to write code to draw a chart from the newly opened file?

[@davemir1435]

Is it possible to select more than one file? For example to get a list of all files in a folder. Can we rename one or multiple files in a specific folder using this approach?
Thank you for your videos. Way to go!

[@ExcelDestination]

I have already uploaded one example for this task. you can check ruclips.net/video/38MWjuIG-7U/видео.html

[@TheNeighborhoodCat]

this is clickbait

[@AshikKhan-er4up]

How to paste data in visible columns (when I have hidden some columns in excel) now I need to paste data in visible columns I need your help Dear sir resolve it. I'm waiting for answer.

[@ExcelDestination]

Hello Ashik, I think it can not be done. You can copy only from visible cells in this situation.......by using Alt + ; key and then copy data....it will copy data only from visible cells.......there is no way to paste, if some rows are hidden or filtered......only way is sorting data by using logic.......and then pasting.

[@AshikKhan-er4up]

@@ExcelDestination there is no any way for pasting data in visible columns

[@aliakbarmohammad2316]

Sir, How To open PDF file in Excel Sheet

[@ExcelDestination]

let me help you
you can create one function and then call that function using vba code. I am pasting here sample function and calling of function :
Function Open_AnyFile(strPath As String)
Set objShell = CreateObject("Shell.Application")
objShell.Open(strPath)
End Function
Sub Test()
Dim pdfPath as String
pdfPath = "C:\example.pdf"
Call Open_AnyFile(pdfPath)
End Sub

[@pandharinathjoshi6565]

Sir pls make this video, can i paste in excel and open pdf where it is select