Re: $$Excel-Macros$$ Macro Error in line. .

2017-07-24 Thread 'Storey Thomas' via MS EXCEL AND VBA MACROS
On Mon, 7/24/17, Paul Schreiner wrote: Subject: Re: $$Excel-Macros$$ Macro Error in line. . To: "excel-macros@googlegroups.com" Date: Monday, July 24, 2017, 5:48 PM I took a quick look, but since I don't have any .CDS files,

Re: $$Excel-Macros$$ Macro Error in line. .

2017-07-24 Thread Paul Schreiner
I took a quick look, but since I don't have any .CDS files, it didn't work properly. But a couple of observations:#1) I'd add Option Explicit to the start of the module, to ensure all variables are declared.#2) It's curious that your  editors aren't showing a compile error on "Dim Dirpath as Str