open & save

Hello Everyone I need your help to create a code for below action - Open workbook path mentioned in A1 D:\abc.xlsx - add four column in starting - Give heading to four column as A, B, C and D - in A4, concatenate F4 and G4.. and drag till the last row. . Same.and close workbook. Pls help

Dears, I am looking for macro command to open all worksheets in a specified folder and run certain commands save and close file.

I'm trying to save first column of the each sheet as a separate csv file who's name depends on name of each sheet in work book. Once i'm done saving those sheets i want to open those files one by one to align the data in them. below is my code can you please assist how can i open files from same...

I have 50+ workbooks, located in a single folder. Within that folder they are in subfolders (only one level deep). Each workbook has a macro set to run when the workbook is opened and it is after 11pm, then it saves and closes the workbook. What I need to have happen is a way to get the...

Hi I'm trying to write a VBA code in Excel that opens a folder (this folder will only contain Zip files) and from the zip archive open a xlsm file with same name as zip file, run some macros that are inside the xlsm file. Then save it as a xlsx file (removing the macros in the file) and saving...