ofso

Hey guys, I would like to create a simple tool in Excel that can list a few files in the specified folder together with the modified date in Excel. Now i have 2 pieces of code that should do this, but i noticed that their approach seems different. The first one will not work for me (it gives...

Dear all, I need to modify the below code in order to assign the particular cell number in sequential order to all the worksheets exists in the workbook. However, the name and no. of worksheets in each workbook are different. Hence, i cannot define the worksheet name. Please help me...

Dear all, I am naive to excel macros. I am trying to build a macro in order to select and print all the sheets in the workbook to PDF. And then do the same for the rest of the files in the folder. However, I am getting error on the below line. Please help to fix the same. Thanks a lot in...

Dear all. I am getting error for the following macro for copying and pasting data to multiple sheets in the folder. It seems after saving the file, clipboard gets clear and the copy text from the file gets unselected. Hence, the copy/paste function works for the first file and gives error for...

Hi Friends, I am using below FSO object because of my requirements. Because of this every time I run the code , I have to go to Menu Bar , select Tools --> References --> Microsoft Scripting Runtime and check it. But it stays checked till the VB Editor is open .Once the editor is closed , I...