leak

  1. I

    Filtering from more than 1 sheets

    I have a series of worklist written in sheet 1 and sheet 2 as indicated below. What I want to happen is that at Sheet 3, I will have an input cell which is designated at A1 which when I type any word from column F of sheet 1 and 2, it will filter out that word and all information on the worlist...
  2. S

    memory leak open/save/close

    Pretty simple code. I have daily files (dy and mo) for multiple years (yr) for different areas (ucode) that are in .txt format. I want them in excel so that I can use them later for other vba macros. So there are four "For" loops, then I declare the file name and the path name. When the...
  3. D

    Out of memory : or Just quits

    I have a workbook, #13. It has a module called “Mass” I made some small modifications to other modules, renamed the workbook #14. I test the module “Mass” the same way, in both. It works fine in #13. It gives memory error in #14 or just plain quits. -I generate a tempform -I show it and...
  4. W

    How to deallocate memory in Excel 2007?

    I have some macros that I have setup to continuously run under Excel 2007. Among other things, the macros connect to a webpage and import data from there, also import data from local HTML files and from other workbooks. The macros run 24/7, unattended, on a dedicated machine. Now everything...
  5. G

    limited # calls to 3rd party DLL allowed

    I am using a 3rd party hydraulic modeling program that provides its computational engine in a DLL and associated VBA module that provides the desired functions from the DLL to VBA. I have a macro that I wrote that iterates on rows of a spreadsheet. Each row contains some inputs. At each row...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

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.
Go back
Top