$$Excel-Macros$$ Fwd: Require A Macro To Compile Data From Different Files

Hey Noone is interested to solve this query..!! :-( -- Forwarded message -- From: Deepak Pal Singh deepaktheind...@gmail.com Date: Tue, Aug 10, 2010 at 2:18 PM Subject: Require A Macro To Compile Data From Different Files To: excel-macros@googlegroups.com Hi All, I'm looking

$$Excel-Macros$$ Re: Help needed in changing this code

Just Try this code. Dim CELL As Variant Range(B2:B105).Select For Each CELL In Selection If IsEmpty(CELL) Then With CELL.Offset(0, -1).Interior .ColorIndex = 3 .Pattern = xlSolid .PatternColorIndex = xlAutomatic End With Else With

$$Excel-Macros$$ Re: How to open WK1 formated file with Excel 2007

Just save it as (using save as) excel file. Then you can open it in Excel 2007. Regards, Kishan Reddy, K On Aug 13, 1:48 pm, harris a harris...@gmail.com wrote: Hello, I am not able to open lotus formatted files (with extension WK1) using Excel 2007. However, I am able to open it with Excel

Re: $$Excel-Macros$$ Re: How to open WK1 formated file with Excel 2007

I think what you're saying is that he should find a machine that still has Excel2003 and open all of his WK1 files and save them as XLS... If he needs help writing a macro to find all of his WK1 files, open them and save them as WKS, he should let us know. Paul

RE: $$Excel-Macros$$ Re: Help needed in changing this code

Absolutely perfect mate :P may thanks Alex cargill -Original Message- From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Kishan Reddy, K Sent: 16 August 2010 08:13 To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Re: Help needed in changing this

$$Excel-Macros$$ macro or similar

How i cam make some macro for using example 60 days one excel page? thank you -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join

Re: REMINDER !! $$Excel-Macros$$ Problem in Macro

It could be because you're not following good group etiquette? #1) your title should describe your problem. Otherwise all of the problem in macro, help required, urgent please help questions all look the same. I get over 100 emails a day, if 20 of them say Problem in Macro, I assume that it is

Re: $$Excel-Macros$$ Fwd: Require A Macro To Compile Data From Different Files

If you check in the archives for this group, there are several previous examples of doing PART of what you ask. However,  your question is missing WAY too much for us to be very helpful. What version of Excel are you using? Do you know anything about VBA programming? what does your data look

RE: $$Excel-Macros$$ Help needed in changing this code

Hi Alex, Have a look at the attached. I have assumed by the syntax of your original code that you are useing XL2007, so I've used that too. One sheet does what you want by macro, while the second sheet does it with coditional formatting. The second sheet has the advantage of being active, in

Re: Fwd: $$Excel-Macros$$ help required

I've made a couple of modifications. This actually should work for both files. Please note that I created a new variable: Col_Data also changed the range that is replaced to: Columns(B:C).Select '== Please keep in mind that many of the members of

$$Excel-Macros$$ Fwd: Urgent Requirement: Excel VBA with Mini Tab

Hi, Reply to Mr. Lalit Sharma (lalit.sha...@xentaqsys.com) for all information. Will be better if you send your resume. Thanks Regards Sandeep -- Forwarded message -- From: Lalit Sharma lalit.sha...@xentaqsys.com Date: Mon, Aug 16, 2010 at 11:41 AM Subject: Urgent Requirement:

$$Excel-Macros$$ Combine NETWORKDAYS and IF functions

I currently use an IF formula (see below) to track total time to resolve an issue. Sometimes, the issues are placed in a Pending status so there is a need to use the IF function. I need the current formula below to use NETWORKDAYS to calculate issues between 7AM and 6PM Monday-Friday. Please help

Re: $$Excel-Macros$$ macro or similar

Hey, Dont post vague queries and clog our mail box, BE specific and attach a sample file... Please read the mail sent by Paul regarding Good Group Etiquettes.. Thanks Vinod On Mon, Aug 16, 2010 at 3:47 AM, caffe Trieste coffeetrie...@gmail.comwrote: How i cam make some macro for

$$Excel-Macros$$ Macro for Mail check

Hello All , First request and bit urgent. Request : When I send a mail , Outlook should search list of words which are stored in backend. If found , it gives me popup with list of words which are identified in Mail , once I confirm than mail is sent to recipient. Macro should not only search

$$Excel-Macros$$ VBA is disabled in a Shared Workbook in Excel 2010

Hi there. I have a shared work book which contains VBA. We have always run it in 2003. Recently, we leapfrogged 2007 and went to 2010. It seems that in shared mode, the VBA is disabled. When I remove shared mode, the VBA comes alive again. Is there a setting to correct this behaviour or is this