Heyall,
I have a VBA script that access a text file, extract information, do some manipulation and calculations, reexamine the files, extract some more information aso. And does that on several 1000s of files.
Each file take about one hour in average and I would like to use as many computers...
I have a task here that might be possible with VBA or VBScript. I did the first couple of steps with VBA but I am not sure how to proceed.
I am downloading annual reports from the SEC which I want to group in folders by their respective year and SIC code. I am doing this with the EDGAR package...
I have a VBA-code which runs a batch file (bat file). The code runs without error when I run the batch file directly, and I get the correct result:
<code style="margin: 0px; padding: 0px; border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono'...
Hello Excel Whizzes, another usual call for help.
my vba code below looks at my names list in a range e.g A:A, takes each value, copies a master template worksheet and renames it to the first value in the list range, hides the template and then moves on to the next name on the list till...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.