Help with VBA

[saroo970]

I have 100 excel sheets all of them are identical with seven columns (Date, Open, High, Low, Close, Adj Close, Volume) what I need is to

1- delete all the columns in all 100 excel sheets inside the folder but keep only two columns (“Date”, and the “Close”)
2- I need to format all the 100 sheets the first column “Date” columns to be (dd-mmm-yyyy) and the “close” columns to be in this format 0.00000 which means the number should be like this 5.12345.

Thanks,
Sam

 

[My Aswer Is This]

Yes, definitely true. I hope someone can help. it can be done manually but as you can see it is very hard to do one by one. Appreciate your input and trying to help

Did you try my script in a open workbook? And did it do what you wanted?
It loops through all the sheets in the open workbook.

 

[saroo970]

I tried it but it deletes the last columns always, it might need some update to the code so it can delete the selected columns which in my case it is (B, C, D, F, and G). Attached is the final result of what I am looking for

 

[My Aswer Is This]

I tried it several times and it deletes column 2,3,4,6,7
In all sheets.
So not sure why it does not work for you

 

[saroo970]

Now it worked perfectly, no idea what did. Definitely, it was me (result attached after running your script - Wonderful results

 

[My Aswer Is This]

Now it worked perfectly, no idea what did. Definitely, it was me (result attached after running your script - Wonderful results

Glad to here that. Now just waiting for someone here to write a script to do this on all the workbooks you have in some particular folder.

 

[saroo970]

Hope the code you provided will be updated to include all the workbooks in the folder

 

[My Aswer Is This]

Hope the code you provided will be updated to include all the workbooks in the folder

Yes I was hoping someone else would help you with this post. I know how to do what you want with a Open book but not sure how to do what you want with all the Workbooks in a particular folder. Fluff made a few postings in this thread so I was hoping Fluff may be able to help you.

 

[saroo970]

i hope, he can help. thx