✅ Download the file | www.exceleinfo.com/macro-para-...
🏆 Subscribe | goo.gl/M5zNA8
The next macro that I share is based on a query I made in Blog. The question said:
The idea is this: I have "n" files and all of them contain in cell E6 a value that I want to modify. I have the new values in a list also in excel, which relates each file.
Is there a way to record a macro to automatically change all the files instead of opening them one by one?
It was then when I realized that I had seen before that users had that doubt, so I decided to make this article.
More examples | www.exceleinfo.com
More examples | blogs.itpro.es/exceleinfo
Facebook Page | / exceleinfo
Get notificacions on Telegram | t.me/EXCELeINFO
Twitter | @EXCELeINFO
Twitter | @SergioACamposH
Download EXCELeINFO addin:
addin.exceleinfo.com
Photo by Hope House Press - Leather Diary Studio on Unsplash
Impact Moderato by Kevin MacLeod is licensed under a Creative Commons Attribution license (creativecommons.org/licenses/...)
Source: incompetech.com/music/royalty-...
Artist: incompetech.com/
Негізгі бет Modify Excel files without open them using VBA and macros @EXCELeINFO
Пікірлер: 95