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

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

2017-07-24 Thread Secret Shot
Hi Experts, I have created a macro to automate my work. Its working fine on my laptop, but if i am using same file for same folder in my dasktop, its skip a action. its not giving any error but also not doing what it soupose to do. Below is the line of code which is not getting excuted, means th