Search results for query: *

I am trying to run a macro located in Workbook B from some VBA in Workbook A within Excel 2007 I've tested this code in some test workbooks and it works great. However, when I try this from the actual workbooks, it does not work. I get an error:Cannot run the macro 'name of macro' The macro may...

I've got a listbox that gets its values from a range on an associated worksheet. The range size varies on a search result. The problem is this: if the results returns, say, 5 items the first time it is run, the box will display the 5 items just fine. If the next result is more than 5 items, it...

I know I read how to do this somewhere, but I can't remember where. Is there some way, I do remember it was through code, to change a VBA module in multiple workbooks. They are all in the same directory, if that helps. (Administrators have decided to add some functionality to spreadsheets after...

I'm trying to be able to generate a list of workbooks based on a range they contain called DateofChange. This is a simple date value. What I want to do is, from another workbook using VBA or VB proper in an independent program, to be able to "search" a number of workbooks and sort them based on...