$$Excel-Macros$$ Need some help - VBA Cell reference n

2010-06-20 Thread Roshan Mathew
Hi All, Pls help me to modify the code with the following request *1. Active cell - I should accept the active cell reference from the user n the same varible will be very ever necessary.* *ActiveCell*.FormulaR1C1 = _ "=VLOOKUP(RC[-6],'[SAMPLE file.xls]PMSRegisterEC.rpt'!R11C2:R91C11,10,

Re: $$Excel-Macros$$ Re: E Book "Excel 2007 Macros Made Easy by Gail Parry"

2010-03-28 Thread Roshan Mathew
On Sat, Mar 27, 2010 at 3:57 PM, Harpreet Singh Gujral < harpreetguj...@gmail.com> wrote: > Hi Hemant, > > Thanks for providing the source > > But i am unable to download the file, the download stops in between. > Tried many times, would you be able to make available the file through > some other

Re: $$Excel-Macros$$ Re: vba code password protected pls help

2010-03-17 Thread Roshan Mathew
Pls forward us Hex Editor On Wed, Mar 17, 2010 at 12:45 PM, rf1234 rf1234 wrote: > Hello Dear > Please Have a look on attached doc file. > > > > > > > Hope it Will Help > Happy To Help > :) > Shyam > > > > > > On Tue, Mar 16, 2010 at 10:44 PM, Yogesh wrote: > >> H Yogesh, >> >> To crack the pas

Re: $$Excel-Macros$$ CONVERT

2010-03-16 Thread Roshan Mathew
Hi Jai, As I am aware, the following is possible during Mail Merge After Inserting the Merge Feild which is a numberic field, pls follow the following steps - Press Alt + F9, on doing so you will find {MERGEFIELD } - Mention \*Cardtext next to the field i.e. {MERGEFIELD \*Cardtext} -Pres Alt +

$$Excel-Macros$$ Help required

2008-12-26 Thread Roshan Mathew
Dear All, Hope you all had a good time during Christmas and Wish you all an Adv New Year Wishes... Pls help me... I need to convert Excel or Word sheets into PDF formart and email the same to different emails as per the list. -- Roshan --~--~-~--~~~---~--~~ Vi