$$Excel-Macros$$ Re: Continuous-Selection and transpose

2010-03-28 Thread uojemeni
See attached Ojemeni Uzoma I Radio Network Planning & Optimization Engineer. HUAWEI TECHNOLOGIES 8th floor, Plot 98, Adeola Odeku Str. South Atlantic Petroleum Towers, Victoria Island, Lagos. Tel: 0806 070 0717, 0702 857 7421 Email: u...@huawei.com www.huawei.com >From :uojemeni Date :2010-

$$Excel-Macros$$ Re: Code or Formula Required

2010-03-28 Thread paulwillekens
Hi Puttu, Here it comes... Remark how I "unmerge" "merged fields" before grabbing the content... and then I "remerge" it... Let me know if this helped you out... Greetings Paul Willekens '=== Sub Normalize() Dim cAddress Dim c

$$Excel-Macros$$ Continuous-Selection and transpose

2010-03-28 Thread uojemeni
Hello All, Pls I need your help. I would like to find "ADD NBRCDMACH"(see attached) and then select the found cell and two subsequent cells in the same column and then transpose the selection in a different column. This procedure will be repeated over and over until the find "ADD NBRCDMACH" i

$$Excel-Macros$$ Re: type mismatch at "End Function"

2010-03-28 Thread paulwillekens
Hi ScubaGirl A Function returns a value by assigning a value to its name in one or more statements of the procedure. The return type of a Function is always a Variant, unless you specified the type e.g. Public Function CalcResourceUtilization() as Boolean If you had some statement within your fun

$$Excel-Macros$$ Re: Macro

2010-03-28 Thread paulwillekens
Hi Sreejith, Here is your macro. It should be stored and run from another Workbook, of course... Just change the number of countries and enter them in the macro... (arrays start at 0, so 9 countries should make aCountry(8)) Sub Sreejith() Dim aCountry(2) Dim cPeriod Dim cSet1 Dim cSet2 Dim cSh

$$Excel-Macros$$ Re: Macro to move file from one folder to another

2010-03-28 Thread paulwillekens
OK, Amit, create your excel with from row 2 the files, from-paths and to-paths as specified... If you save that workbook as "c:\xls \MoveIt.xls" then the following "MoveIt.vbs" will do what you expect... just run it under windows... Let me know if you are satisfied... Greetings Paul Willekens '=

Re: $$Excel-Macros$$ Help In access

2010-03-28 Thread Mahesh parab
Dear Vikas Please find required info on below mention link http://www.techonthenet.com/top10/access.php On Sun, Mar 28, 2010 at 2:35 PM, Vikas Chouhan wrote: > > Dear All, >> >> >> Please help me in *access* please provide access queries and how to put >> queries,,, >> >> *and how to vlook

Re: $$Excel-Macros$$ Outlook and excel integration

2010-03-28 Thread Mahesh parab
Hi Putta F column contain passport expiry date, Formula in E column is F column date minus today's date in sheet1 code you will find below mention criteria, if column E value (No of days)more then 30 then email will get drafted. 'Above the MyLimit value it will run the macro MyLimit = 30 ch

$$Excel-Macros$$ Help In access

2010-03-28 Thread Vikas Chouhan
> Dear All, > > > Please help me in *access* please provide access queries and how to put > queries,,, > > *and how to vlookup,concatenate in access * > > > -- > One Team One Dream One Goal > > Warm Regards, > Vikas Chauhan > E-Mail :- vikask...@gmail.com,vikask...@rediffmail.com, > 9911868518, >

Re: $$Excel-Macros$$ Inserting new Sheet condition based

2010-03-28 Thread Vikas Chouhan
Dear All, Please help me in *access* please provide access queries and how to put queries,,, *and how to vlookup,concatenate in access * -- One Team One Dream One Goal Warm Regards, Vikas Chauhan E-Mail :- vikask...@gmail.com,vikask...@rediffmail.com, 9911868518, "We can't Spell S_ccess wit

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

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

2010-03-28 Thread Harpreet Singh Gujral
Hemant, You can try uploading the file on Sendspace.com, its easy to use website and allows you to upload files and share it with other people Let me know when you upload the files on an alternate source, i will be happy to download them. Harry On Mar 26, 5:21 pm, Hemant K wrote: > Hi All, > >

Re: $$Excel-Macros$$ Outlook and excel integration

2010-03-28 Thread Puttaswamy
Can you please tell me how to work out this? I am bit confused. It would be great if you provide me the instruction. On Sat, Mar 27, 2010 at 1:29 PM, ~ Z A H E E R ~ wrote: > Thank you very much Mahesh. This is what i want. > > > On Wed, Mar 24, 2010 at 7:58 PM, Mahesh parab wrote: > >> Dear Za

$$Excel-Macros$$ excel file accessing

2010-03-28 Thread Rajesh D
Hi please advice me is there any way that excel file in the server can be accessed thru web -- Thanks Rajesh -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://