Search results for query: *

I have been searching for a way of somehow loading/registering a DLL file to the Excel VBA Reference Library through a VBA routine. Does anyone know of a way to do this? Somewhere out there is a Rocket Scientist who must have the answer. Much appreciated and thanks. Nigel

If I try to output the statement: ActiveWorkbook.ActiveSheet.Cells.SpecialCells(xlFormulas, 23).DirectPrecedents.Address ...to a range on a sheet; if there are a lot of formulas and precedents I only ever get the first 255 characters. Why is this and how can I get the whole lot with out...

Anyone know how to build a list of built-in number formats in a workbook and not just those that are being used? Thanks.

...that I see on the status bar when Excel is calculating and display it instead on a form via a progress bar that updates in real-time and then disappears once calculation is complete?

If I am in cell A10 in a sheet and move to an adjacent cell either by arrow keys, return key, tab key or by selecting another non-adjacent cell with my mouse; how do I pass the address of the cell I am leaving on to a variable. Many events seem to only look at the target cell but is there one I...

If I am in cell A10 in a sheet and move to an adjacent cell either by arrow keys, return key, tab key or by selecting another non-adjacent cell with my mouse; how do I pass the address of the cell I am leaving on to a variable. Many events seem to only look at the target cell but is there one I...

After any change to a sheet or a chart what VBA method may be used to determine if any change has been made to said sheet or chart in order to call a routine?

I have a folder that contains various file types. From Excel I want to be able to loop through the folder opening only txt files and importing their contents to a workbook. How do I do the looping through the folder looking for only the txt files bit?