Re: $$Excel-Macros$$ Re: how i convert pdf file to Excel using macro.

2014-01-25 Thread ashish koul
try this code http://www.myengineeringworld.net/2013/03/vba-macro-to-convert-pdf-files-into.html On Sun, Jan 26, 2014 at 8:31 AM, Frank Friedland wrote: > Hi I need someone to write macros for me, please email me. > Best > Frank > > On Saturday, February 19, 2011 2:17:51 AM UTC-5, rashid memon

$$Excel-Macros$$ copy data from attachment

2014-01-25 Thread Prabhu Pinky
Hi Experts, i need code to extract data from html file which is attached in mail.Mail i saved it in local folder. on a daily basis i receive many mails. am copying it in local folder. all mails will have html attachment. i need to copy the data from html to excel file. please help with code. i

Re: $$Excel-Macros$$ Extract data from mail attachment.

2014-01-25 Thread Prabhu Pinky
hi ravindar, since it is official file, i cant share it. assume any html file attached in mail and that mail is saved in local folder. ashis : on a daily basis i will receive around 30 mails with html attachment. i have macro to move all mails from outlook to local folder. but i need macro to che

$$Excel-Macros$$ Re: how i convert pdf file to Excel using macro.

2014-01-25 Thread Frank Friedland
Hi I need someone to write macros for me, please email me. Best Frank On Saturday, February 19, 2011 2:17:51 AM UTC-5, rashid memon wrote: > Dear Experts, > > i want to convert PDF file to Excel so plz provide me macro > > file is attached... > > > Looking forward to receive your kind attention.

$$Excel-Macros$$ input type = button onclick=top.frame will not click to open page. HTML web parsing

2014-01-25 Thread hgdev
Hi thanks for looking. I have followed a youtube video series on web scraping. So I am not as experienced as it may seem. The code is working to point where it logs in and then clicks to open another page. The below code is to go click on a second page to be opened for scraping. I tried belo

Re: $$Excel-Macros$$ Dairy 2012

2014-01-25 Thread Ahmed Siddique
Please Share Diary 2014. Best Regards, Ahmed Ali Siddique On Thu, Jan 23, 2014 at 9:41 AM, Ansar Ellahi wrote: > please send diary 2014 with great thanks > > > On Thu, Jan 26, 2012 at 5:39 AM, Mr excel wrote: > >> Very useful one.thanks a lot for sharing. >> >> >> On Wed, Jan 18, 2012 at

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

2014-01-25 Thread ashish koul
Sub test() Dim mailrng As Range Dim cl As Range Dim fl_path As String Set mailrng = Sheets("Master").Range("d4:d5") For Each cl In mailrng ThisWorkbook.Sheets(cl.Offset(0, -2).Value).Copy fl_path = "C:\Documents and Settings\Ashish Koul\Desktop\sample files\"

Re: $$Excel-Macros$$ Mail thru Excel

2014-01-25 Thread Mahesh
Dear, I got this sheet from this group only, so i don't know the password. On Tue, Jan 21, 2014 at 8:32 PM, pp kk wrote: > what's the vba password? > > > On Tue, Jan 21, 2014 at 1:49 PM, Mahesh wrote: > >> Dear, >> >> I need an excel sheet by which I can send the mail to around 100 ppls and

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

2014-01-25 Thread Abhishek Jain
Friends, A friend of mine needs to send attendance of employees to their email ids and he wants a worksheet automated to do that function as doing it manually for 400 employees is a bit exhausting task. A sample is attached herewith for understanding. What I need is: > A VBA to use Microsoft Outl

RE: $$Excel-Macros$$ Extract data from mail attachment.

2014-01-25 Thread Ravinder
Could you pls provide an example mail with HTML attachment. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ashish koul Sent: Saturday, January 25, 2014 12:39 PM To: excel-macros Subject: Re: $$Excel-Macros$$ Extract data from mail attachment. why you

Re: $$Excel-Macros$$ Reinitialising data sheets everytime data on sheet1 is processed in a loop.

2014-01-25 Thread ashish koul
or try to chnge last few lines of ur code ActiveCell.Offset(0, -10).Range("A1:D1").Select Selection.Cut Range("A1").Select ActiveSheet.Paste On Sat, Jan 25, 2014 at 2:02 PM, ashish koul wrote: > pls share ur workbook > > > On Sat, Jan 18, 2014 at 4:42 PM, Shailesh Tupe wrote: >

Re: $$Excel-Macros$$ Reinitialising data sheets everytime data on sheet1 is processed in a loop.

2014-01-25 Thread ashish koul
pls share ur workbook On Sat, Jan 18, 2014 at 4:42 PM, Shailesh Tupe wrote: > Hi Ashish, > > Thank you so much for your reply. In a loop, I want to copy filtered sheet > 2 and overwrite it on sheet3, similary sheet 4 to sheet 5 & sheet 6 to > sheet 7. If filter gives 0 records then I want to fi