hi guys...
macros what i am using takes lot of time.
to reduce time i m using application.screenupdating=false at the begin
and made it true at the end..
it is working in some macros.
but in some macros it is nt working... i am nt able to find the reason..
any one can help to sort this issue.
29.10.2010
I am using two input data files like SALES and PURCHASES and the third file
COMBINED is having cell references to SALES and PURCHASES.
SALES and PURCHASES are having month names. Condition is to insert a new column
and add the next month and enter the data.
In the COMBINED file, in
*Thanks A lot dear
*
On Fri, Oct 29, 2010 at 4:53 PM, anil panchal wrote:
> Dear Rakesh,
>
> As per Discus please find the attached file.
>
> hope this is want you :-)
>
> Thanks & Regards
> Anil Kumar
> 113784
>
>
> On Fri, Oct 29, 2010 at 3:41 PM, anil panchal wrote:
>
>> Dear Rakesh,
>>
already give solution
On Fri, Oct 29, 2010 at 3:16 PM, Born to Win wrote:
> Hello,
>
> Please Use COUNTA() Function or check Attached File.
>
> Thanks,
> Chandrabhan Singh
>
>
>
> On Fri, Oct 29, 2010 at 2:43 PM, Rakesh Sharma wrote:
>
>> *Dear All,
>>
>>
>> Please find the attachment and let me
Very good
Very thanks
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On
Behalf Of Ashish Jain
Sent: Friday, October 29, 2010 10:13 AM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Re:
Hi Omar,
-5004 is equivalent to VB constant xlRT
Hi all,
I managed to get some code (almost) working, as below.
It uses FileSearch to find CSV files saved within Outlook and imports
them to the current Excel Workbook.
It worked fine the first time (although for some reason didn't find
and import every single file) but after that the .lookin pa
Hi Omar,
-5004 is equivalent to VB constant xlRTL (means Right to Left)
Difference between 2 lines is:
1st Line - Turn the Excel Sheet direction for all sheets and new
workbooks that will be opened in the Application. So, basically it
will change the default settings of the Excel Application.
2n
