We have a system that creates files that are imported into Oracle. The files have the naming convention...
Filename.0000
... where the numbers are incremented with each export. So one file might be filename.4357 and the next file will be filename.4358 and so on.
Ive managed to import the file...
Changes were made this weekend to speed up the forum. If you notice any unusual slowness (usual would be queries, unusual would be posting or opening a thread) or errors, please post here, with as much error information as possible. For speed issues, please note, if possible, the number of users...
Hi Guys,
Last year some time I wrote a macro to sum specific quantities.
Here's how it works:
the data contains song names, composers, prices and quantities sold.
It could have multiples of the same song, the average file is about 50,000 lines.
the macro sorts the file by song name, then...
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.