$$Excel-Macros$$ Re: How to break the vba project password

2009-03-22 Thread madhu
hi all, Pls send the VBA books to me Regards Madhu 09743130534 On Fri, Mar 20, 2009 at 10:19 AM, hari prekkeh...@gmail.com wrote: Hi Harmeet, Enclosed please find the file. Regards Hari Kumar -- *From:* excel-macros@googlegroups.com [mailto:

$$Excel-Macros$$ Embed a flash into Excel

2009-03-22 Thread mahesh parab
Dear All Any one knw the way how to embed a flash project into Excel ? --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text),

$$Excel-Macros$$ My VBA Macros Collection 01

2009-03-22 Thread Ashish Jain
*Worksheets* 1. Sort all sheetshttp://www.excelitems.com/2009/03/sort-all-worksheets-on-basis-of-sheet.html 2. Remove blank worksheets from Current workbookhttp://www.excelitems.com/2009/02/deleteremove-blankempty-worksheets.html 3. Color all Sheet

$$Excel-Macros$$ A NEWS FOR ALL MEMBERS

2009-03-22 Thread Ashish Jain
Hi All, Effective from March 22, 2009 following members posts won't be moderated, we found each of them constantly and consistently active in the community and always helping the other members. This means that their posts/replies will be emailed to all of you directly. 92 Ayush 88

$$Excel-Macros$$ Re: Embed a flash into Excel

2009-03-22 Thread Ashish Jain
Hi Mahesh, Here is your solution - How to embed Flash Project in MS Excel: http://www.excelitems.com/2009/03/how-to-embed-flash-in-excel-office.html . . . . . For more tips, tricks, downloads and problem solutions: visit -- http://www.excelitems.com

$$Excel-Macros$$ Re: Sort Table as per the order of records in another Table

2009-03-22 Thread Maddy
I found no solution for sorting the names in Valuation tab as per PV tab. ??? On Mar 22, 5:45 pm, Harmeet Singh harmeet.hew...@gmail.com wrote: Hi, Due to time constraint couldn't write VBA macro. Sending you updated file, it has formulas and giving required results. As per me for this

$$Excel-Macros$$ Re: Sort Table as per the order of records in another Table

2009-03-22 Thread Mathan Kumar
Hello Harmeet, The issue here is to sort the data in valuation tab as per the data in PV tab. I think formulae can not be helpful in sorting the data. Therefore, could anyone write a macro for this??? Please refer to For Your Information tab in my first post below: Here is the points for your

$$Excel-Macros$$ Re: A NEWS FOR ALL MEMBERS

2009-03-22 Thread Aindril De
Thanks for the priviledge Ashish and thanks everyone for the support to keep such a nice community active. Regards, Andy On Sun, Mar 22, 2009 at 8:51 PM, Ashish Jain 26may.1...@gmail.com wrote: Hi All, Effective from March 22, 2009 following members posts won't be moderated, we found each

$$Excel-Macros$$ Re: Convert PDF to Excel

2009-03-22 Thread prabhakar jain
Use below mentioned link : http://www.convertpdftoword.net/Default.aspx On Sat, Mar 21, 2009 at 3:42 PM, Pranav nadkarni pranav81.2...@gmail.comwrote: Hi kamal Do u have the application for converting pdf into MS word..? if yes, i would be obliged to recieve the software from u... regds

$$Excel-Macros$$ Reg. Output to be more viewable

2009-03-22 Thread raafi barey
Hello Team, Can anyone please help me to make my output more systamatic and viewable, I have attached an excel sheet which has two tabs 1.output, which shows the output format which i pull it from DB. 2. Required Output, is the output which I wanted so that it is more presentable, Can anyone

$$Excel-Macros$$ Getting Run-time error 13 Type Mismatch by VBA Macro

2009-03-22 Thread xmux
Hi Everyone, I am just checking a Cell with If Selection.Cells(x, 8) _ AD Or AE Or AF Or AG Or AI Or AL Or AM Or AN Or AO Or AQ Or AR Or AS Or AT Or AU Or _ AW Or AX Or AZ Or BA Or BB Or BD Or BE Or BF Or BG Or BH Or BI Or BJ Or BM Or BN Or _ BO Or BR Or BS Or BT Or BV Or BW Or BY Or BZ Or CA

$$Excel-Macros$$ Re: Reg. Output to be more viewable

2009-03-22 Thread Ashish Jain
Hi Raafi Barey, You need to use Pivot Tables. The output you required is perfectly obtainable through them even for 10 lac rows of data(not just 5000 rows). I've seen your file and only after that I've made this view for solution. Please reply, if you need assistance on Pivot Tables. . . . . .

$$Excel-Macros$$ Macros connecting any software

2009-03-22 Thread karthinatraj
Hi, Can anybody help me in creating a macro connecting Excel with any other software (except MS family) Mainframe, SAP Regards Karthik --~--~-~--~~~---~--~~ - Some important

$$Excel-Macros$$ Re: Convert pdf to excel

2009-03-22 Thread Tanzeem Ahmad
Dear Manoj, Can u send the PIN Regards, Tanzeem On Mon, Mar 23, 2009 at 9:59 AM, nehal sejpal nehal_c...@rediffmail.comwrote: Dear Manoj, I already download the software kindly provide me the PIN No.Thanks in advance. With Regards, Nehal A.Sejpal On Sun, 22 Mar 2009 Manoj S Negi