Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Update WorkBooks in Folder
Actually, I just realized. In all the work books, only these two cells have
the number value of 1.40. So a Find and replace for all work books for this value of 1.40 to 1.3352 might be easier to do, but how without opening the work books. Or can a macro be done to open up all work books in a folder, then shoot off and find and replace this in all work books then close them up? "JavyD" wrote: Hey guys, Lets see if this possible with a VBA. I have over 100 work books in a folder. There's two specific cells in each work book that I need to change. Currently the cell is multiplying a figure times 1.40, I need a VBA if possible to take each work book in that folder, and replace 1.40 with 1.3325 in those two cells. Those two cells being D17 and C25. Is this possible. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Update WorkBooks in Folder
You have received two possible answers to your question.
No, a find and replace can not be done to all workbooks in a folder. You would need a macro to open the workbooks and execute the command, but that puts us back to where you already have two proposed answers. -- Regards, Tom Ogilvy "JavyD" wrote in message ... Actually, I just realized. In all the work books, only these two cells have the number value of 1.40. So a Find and replace for all work books for this value of 1.40 to 1.3352 might be easier to do, but how without opening the work books. Or can a macro be done to open up all work books in a folder, then shoot off and find and replace this in all work books then close them up? "JavyD" wrote: Hey guys, Lets see if this possible with a VBA. I have over 100 work books in a folder. There's two specific cells in each work book that I need to change. Currently the cell is multiplying a figure times 1.40, I need a VBA if possible to take each work book in that folder, and replace 1.40 with 1.3325 in those two cells. Those two cells being D17 and C25. Is this possible. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
linking cells from workbooks in a folder | Excel Worksheet Functions | |||
Copy a cell to all workbooks within a folder. | Excel Discussion (Misc queries) | |||
Update WorkBooks in Folder | Excel Programming | |||
Update WorkBooks in Folder | Excel Programming | |||
list Workbooks in Current Folder | Excel Programming |