Operations on files and folders

par Taisho
Portfolio

Change authors in files following *.xls* pattern within specified directory. Macro works on all levels of subfolders.

image of username Taisho Flag of Poland Góra, Poland

Me concernant

My main areas of expertise are VBA macros (Excel, web scraping) and WordPress speed optimization, where I regularly achieve 95+ score in Google PageSpeed Insights / GTmetrix. I also develop WordPress plugins, mostly WooCommerce-related. In Excel VBA I like to work on big data sets, for example, stock market and Forex data, where code performance matters. I'm proficient in standard Excel tools: formulas, charts, graphs, pivot tables, conditional formatting, Solver, etc. VBA: - over 8 years of experience - Excel automation - web scraping - passing data between Excel, Word, text files, etc. - rearranging data structure - sending e-mails based on Excel data - operations on files and folders - UserForms - custom formulas - macro speed optimization WordPress (PHP, jQuery, JavaScript, HTML, CSS) - over 3 years of experience - website speed optimization (Google PageSpeed Insights, GTmetrix) - fixing websites, small customizations - plugin development, mostly for WooCommerce

$15 $ US / h

69 évaluations
5.4

Étiquettes