You are welcome!

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

you can use additional code to activate specific sheet

Welcome

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.

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

I have already uploaded one example for this task. you can check kzfaq.info/get/bejne/aZ59is2mrq2RZ4k.html

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 : kzfaq.info/get/bejne/d9Jza8RosN-uoWQ.html

Yes! you can watch another tutorial for that at below given link : kzfaq.info/get/bejne/f7ppa7OBypa7oIU.html

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?

yes, that can be done.

How

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

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