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, it didn't work pr

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

$$Excel-Macros$$ Macro for Copy Paste

2017-07-24 Thread Shrinivas Shevde
Dear All I have a work book which contain many daywise sheet in which I maintain machinewise data. I have 20 machines all machines are not running daily so if machine is not running I hide that rows and machine running will be visible. There is down time for a machine having many reasons which are