Re: $$Excel-Macros$$ Fwd: Plz help me

2011-04-29 Thread sanjay maurya
On Fri, Apr 29, 2011 at 8:42 PM, rajan verma wrote: > Hi Sanjay > Hope it will help you.. > > > On Fri, Apr 29, 2011 at 9:45 AM, sanjay maurya wrote: > >> >> All Friends >> >> I have some solution. I have problem to create the report look in attached >> Excel Sheet. >> >> -- >> ***Thanks & Best Re

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

2011-04-29 Thread GoldenLance
Hanumant, Download the COM Add-in from http://www.microsoft.com/downloads/en/details.aspx?FamilyId=4D951911-3E7E-4AE6-B059-A2E79ED87041&displaylang=en and install. You should now be able to convert the range to PDF using the vba ActiveSheet.UsedRange.ExportAsFixedFormat Type:=xlTypePDF,

Re: $$Excel-Macros$$ How to include new Rs font in Excel Currency format (option in format cell)

2011-04-29 Thread vaibhav joshi
Hi Rajan I have dwnld the file ,but unable use the font.It is not coming Regards Vaibhav Joshi 91-9869069433 On Fri, Apr 29, 2011 at 1:05 PM, rajan verma wrote: > Add the attached Font File and use ' for Rs Font.. > > > On Fri, Apr 29, 2011 at 12:27 PM, vaibhav joshi wrote: > >> Hello everybo

$$Excel-Macros$$ Fwd: Available consultant's for your requirement.

2011-04-29 Thread Akshay Korgaonkar
-- Forwarded message -- From: Akshay Korgaonkar Date: Fri, Apr 29, 2011 at 11:55 PM Subject: Fwd: Available consultant's for your requirement. To: Akshay Korgaonkar HI, Mentioned below are the list of candidates available for your requirement. Kindly let me know if you have

$$Excel-Macros$$ Excel pulling data from Crystal report

2011-04-29 Thread Hall
I know I can export a Crystal report to Excel format from the Crystal Viewer. But is it possible to have my Excel file initiate the export from Crystal into the same Excel file or a different Excel file? -- -- Some i

Re: $$Excel-Macros$$ How do I transfer subtotal account Nr. alongwith its balance?

2011-04-29 Thread celadol_a
Rajan, Please, kindly send again the sample file as I did not get the attached file referenced. Thanks. Sent from my BlackBerry® wireless handheld from Glo Mobile. -Original Message- From: rajan verma Sender: excel-macros@googlegroups.com Date: Fri, 29 Apr 2011 21:03:21 To: Reply-To: e

Re: $$Excel-Macros$$ How do I transfer subtotal account Nr. along with its balance?

2011-04-29 Thread rajan verma
Please attach a Sample File.. On Fri, Apr 29, 2011 at 2:56 PM, wrote: > Hello Guys, > > Please, I have generated a subtotal spreadsheet with over 150 accounting > numbers with their balances that need to be transfered to another sheet to > generate Trial Balance figures and Balance Sheet. Kindly

Re: $$Excel-Macros$$ help macro commands need -reg

2011-04-29 Thread rajan verma
http://www.ozgrid.com/ http://www.excel-vba.com/excel-vba-contents.htm http://www.webandmacros.net/excel-macros-vba.htm On Fri, Apr 29, 2011 at 7:55 PM, jmothilal wrote: > Dear any one > > i want to learn macro commands ,

Re: $$Excel-Macros$$ Fwd: Plz help me

2011-04-29 Thread rajan verma
Hi Sanjay Hope it will help you.. On Fri, Apr 29, 2011 at 9:45 AM, sanjay maurya wrote: > > All Friends > > I have some solution. I have problem to create the report look in attached > Excel Sheet. > > -- > ***Thanks & Best Regards** > Sanjay Kumar Maurya* > > * > Life is Very beautiful !!! > *

$$Excel-Macros$$ help macro commands need -reg

2011-04-29 Thread jmothilal
Dear any one i want to learn macro commands , can u help me send the macro commands -- J.Mohilal Universal Computer Systems # 16, Brindavan Complex Otteri, Vellore-2 -- -- Some important links for excel users: 1.

$$Excel-Macros$$ How do I transfer subtotal account Nr. along with its balance?

2011-04-29 Thread celadol_a
Hello Guys, Please, I have generated a subtotal spreadsheet with over 150 accounting numbers with their balances that need to be transfered to another sheet to generate Trial Balance figures and Balance Sheet. Kindly tell me on how to do it. Thank you and Best Regards. Reginald Ok Sent from my

Re: $$Excel-Macros$$ Fwd: Plz help me

2011-04-29 Thread Yogesh Gohil
Check this might be it help On Fri, Apr 29, 2011 at 9:45 AM, sanjay maurya wrote: > > All Friends > > I have some solution. I have problem to create the report look in attached > Excel Sheet. > > -- > ***Thanks & Best Regards** > Sanjay Kumar Maurya* > > * > Life is Very beautiful !!! > * > * >

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

2011-04-29 Thread rajan verma
Download DoPDF from Internet.. Select the Range and Print seletion by this doPDF Printer... On Thu, Apr 28, 2011 at 6:09 PM, Anil Bhange < anil.bha...@tatacommunications.com> wrote: > Hi Expert, > > > > I am having one excel file which contains many report, I wanted to convert > the same in PDF

Re: $$Excel-Macros$$ Help Required!

2011-04-29 Thread ashish koul
try this macro Sub t() Dim i, j, k As Long For ww = 1 To Worksheets.Count Sheets(ww).Activate For j = 2 To Sheets(ww).Range("a1").End(xlDown).Row If Sheets(ww).Cells(j, 4).Value - DateSerial(Year(Now), Month(Now), Day(Now)) >= 1 Then MsgBox Sheets(ww).Cells(j, 1).Value & " Will Expire in "

$$Excel-Macros$$ How to include new Rs font in Excel Currency format (option in format cell)

2011-04-29 Thread vaibhav joshi
Hello everybody Can any one tell me how to insert New Rs font in currency format in excel. So that when ever i type any amt that should reflect & also to ensure that i can use that cell for formula also Regards Vaibhav --

$$Excel-Macros$$ Fwd: Plz help me

2011-04-29 Thread sanjay maurya
All Friends I have some solution. I have problem to create the report look in attached Excel Sheet. -- ***Thanks & Best Regards** Sanjay Kumar Maurya* * Life is Very beautiful !!! * * ¨`•.•´¨) Always `•.¸(¨`•.•´¨) Keep (¨`•.•´¨)¸.•´ Smiling! `•.¸.•´. * --

Re: $$Excel-Macros$$ Help Required!

2011-04-29 Thread syed aliya raza hashim
Hi Andred, see for example in sheet1 UPS 28-Apr-12 Battery 28-Jul-11 SMPS 2-Jan-11 then i want the meassage box should display message when we open the file --like "ur UPS product will expire in 1 year 0r 365 da