$$Excel-Macros$$ VBA Macro Code - for spell of Numbers into Words

2014-01-28 Thread Camukesh2015
Hi EverReady, I have downloaded a macro code for spell numbers in Indian Rupees, in Lakhs and Crore notation. But I am facing a problem in the code. Code is working fine upto 200 crore conversion into words but when I tried to convert above 200 crore formula showing #Value! errror.. I have t

Re: $$Excel-Macros$$ Need help in converting table format data to pivot format in excel

2014-01-28 Thread Umesh Kumar
Hi, My apologies, i uploaded the wrong work book second time around. Attached is the actual book.* (File Name: Request.xlsx)* On Tuesday, 28 January 2014 00:26:27 UTC+5:30, bé trần văn wrote: > > You see File, with PivotTable VBA. > > 2014-01-27 Umesh Kumar > > >> Hi Ashish, >> I had pasted the

$$Excel-Macros$$ Copy/paste loop with VBA

2014-01-28 Thread pp kk
Dear All, i was stuck in a situation in Excel. When i am downloading a file from SAP it it exporting in .xls but in different format. PFA -- Thanks Pankaj Kumar 9910075248 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook

$$Excel-Macros$$ Convert Pdf to xls using VBA

2014-01-28 Thread Akul Rastogi
Hi All, I was stuck in a situation when I got 300 Pdf files and I have to analyze the data of all PDF files. Now I need VBA code to get the data from PDF into excel. Please help me? -- ~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~* Thanks and regards Akul 91-99115-52543 ~*~*~*~*~*

RE: $$Excel-Macros$$ Convert Pdf to xls using VBA

2014-01-28 Thread Ravinder
All pdfs are in same format and give an example pdf From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Akul Rastogi Sent: Tuesday, January 28, 2014 4:21 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Convert Pdf to xls using VBA Hi All,

RE: $$Excel-Macros$$ Convert Pdf to xls using VBA

2014-01-28 Thread Ravinder
Increase the seconds 3 to 10 in the given code. may be Application.Wait Now + TimeValue("00:00:10") ' wait 10 seconds From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Akul Rastogi Sent: Tuesday, January 28, 2014 4:32 PM To: excel-macros@googlegroups.

Re: $$Excel-Macros$$ Convert Pdf to xls using VBA

2014-01-28 Thread Akul Rastogi
No It Doesn't work Thanks Akul Rastogi On Tue, Jan 28, 2014 at 4:32 PM, Akul Rastogi wrote: > Hi, > > Due to some reason I can't post actual sheets. > > But one sample pdf is attached with this mail. > > I tried the VBA code on given below link > http://quickvba.blogspot.in/2010/12/import-pdf-

Re: $$Excel-Macros$$ Send Email from Excel attaching a sheet

2014-01-28 Thread Abhishek Jain
Dear Ashish, Sorry for late response. It works very well. Thank you so much :) Regards, Abhishek On Sat, Jan 25, 2014 at 6:59 PM, ashish koul wrote: > Sub test() > > Dim mailrng As Range > Dim cl As Range > Dim fl_path As String > > > > Set mailrng = Sheets("Master").Range("d

$$Excel-Macros$$ Need Ethernet Card MAC Address VBA Code

2014-01-28 Thread HeMan
Dear All, I need MAC Address of Ethernet whether it is Enabled Or Disabled to Create License Excel File. I got many vba script but its shows only Enabled Card MAC Addresses. *I want Disabled Or Enabled **Ethernet Card **MAC Address VBA Code..?* Please Help Thanks in Advance. -- Are you =EXP(