Category: VBA

Dave writes: I found your excellent code to run a procedure on a target spreadsheet from an originating spreadsheet on VB Express Forum.  It works fine if both files are on the same jump drive but fails on our work

On Friday night, I began reading my way through PED 2nd Edition. After something weird happened with Excel, (I think because I have Excel 2003 and 2007 installed,) I got the bright idea to create a very simple Windows Forms

A little background My staff and spreadsheet users will tell you that any time I build a spreadsheet, there are always shaded cells on the grid. I preach that "Green means go", and make sure that any cell they enter

Macro Purpose: This code quickly replaces all external links in an Excel workbook with their values. It is something that can be very handy when you need to send a heavily linked workbook outside of your immediate network, to a

I had to do some real quick budgeting work today, and needed to build a template to work from.  The easiest way was to grab a heavily linked workbook we had, and convert all the links to values so that

I tripped on this in a forum today... The user wanted to create a message for all cells that did not have any cells dependent on their target.  The set about doing this by using the Trace Dependents tool through

Okay, I'll admit that you probably have to be a parent of a young child to agree with this, but here it is: [code]Application.Speech.Speak Target[/code] This all started when I showed my kid how fast the computer could count to

Introduction: This macro can be used to count how many files exist in a folder and, if passed the file extension, can also be used to count only files of a specific type. (For example "xls" files.) I've actually published