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?
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 :)
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?
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?
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!
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 exceldestination@gmail.com. I have a small team that works upon excel vba projects.
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
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.
@@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?
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 : th-cam.com/video/AlC8a7KyJq0/w-d-xo.html
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.
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.
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
This is exactly what I was looking for. Thank you for the clear tutorial
You are welcome!
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?
This is exactly what I was looking for. Thank you for the clear tutorial 👍😎🇦🇺
thanks!
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 :)
@Ace Xzavier Yea, I've been using instaflixxer for months myself :D
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?
you can use additional code to activate specific sheet
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?
Nice one!
Can you please show how I can add a pdf file in each row and open it in a viewer inside excel?
will this open a pdf format file?
I made vba coding to open file excel 2000 with path xls, but it doesnt running, could you help me to fix it ?
the pop-up doesn't come in front when calling this macro from vbs--why?,how to resolve it?
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!
I have already uploaded one example for this task. you can check th-cam.com/video/38MWjuIG-7U/w-d-xo.html
Thank you so much. Really helped alot.
Welcome
Sir how it is automatically opening desktop only can we specify which drive it has to open
a small modification would be required to do this task in the given example
Where to get the file for reading coding clearly...
Very useful code 😁
Is there any way out we can close the opened file using VBA. thanks
Yes! you can watch another tutorial for that at below given link :
th-cam.com/video/IT98PPe0WpQ/w-d-xo.html
Sir may i ask you, how open a file with greatest size in one folder thanks
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 exceldestination@gmail.com. I have a small team that works upon excel vba projects.
hello sir
I want one select file button. to select multiple file at different cells
yes, that can be done.
How
Very useful code 😁
Is there any way out we can close the opened file? thanks
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
hey, can you tell me how to make a chart after select file
thank u so much :x
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.
@@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?
Convert multi file excel, all sheet with cell formula to value, how work with vba ?
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 :
th-cam.com/video/AlC8a7KyJq0/w-d-xo.html
how to add an image with a browser and fit in a fixed column
Very helpful info thanks a lot
Video is nice and useful. Just make video how send this file mail
Good one
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.
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.
@@ExcelDestination there is no any way for pasting data in visible columns
Sir, How To open PDF file in Excel Sheet
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
Sir pls make this video, can i paste in excel and open pdf where it is select
this is clickbait