Re: $$Excel-Macros$$ is there option to run macro program to pull data from outlook mail

I think MS outlook has only one file (.pst) which has all its folders. Do you mean you saved your sent items in a folder? Can you attach 2-3 of your emails for testing purpose? On Tue, Apr 9, 2013 at 11:54 AM, Prabhu Pinky wrote: > Hi Abhishek, > > > It is MS Outlook mails, i just copied sent ma

Re: $$Excel-Macros$$ is there option to run macro program to pull data from outlook mail

Hi Abhishek, It is MS Outlook mails, i just copied sent mails from MS Outlook and copied in local folder. Thanks & regards, Prabhu R On 9 April 2013 11:49, Abhishek Jain wrote: > Is it MS Outlook (having .pst in your local folder) ? or Outlook > Express (having .dbx in your local folder) ? >

Re: $$Excel-Macros$$ is there option to run macro program to pull data from outlook mail

Is it MS Outlook (having .pst in your local folder) ? or Outlook Express (having .dbx in your local folder) ? On Tue, Apr 9, 2013 at 11:46 AM, Prabhu Pinky wrote: > Hi everyone, > > it will be so appreciated if anyone gimme a macro program for my > requirement. > > i have nearly 100 outlook mails

$$Excel-Macros$$ is there option to run macro program to pull data from outlook mail

Hi everyone, it will be so appreciated if anyone gimme a macro program for my requirement. i have nearly 100 outlook mails saved in my local folder. can i extract all mails sent time and subject in excel sheet one by one by using macro program? Please help because am doing this task manually on

$$Excel-Macros$$ Re: UDF to pull data from Remote Server

Application.Calculate=xlCalculationManual *'Your code* Application.Calculate=xlCalculationAutomatic regards Prince On Monday, April 8, 2013 6:45:31 PM UTC+5:30, Divaker Pandey wrote: > > Hi Expert, > > > I made a UDF function that pull data form server on the basis given > parameter. > > > When

$$Excel-Macros$$ Re: Excel 2003 compatibility issue

This worked: ActiveWorkbook.Worksheets("MyList").Range("B2:C37").Sort _ Key1:=Worksheets("MyList").Range("B2:B37") I had to put the .Range in the statement before the Sort method. -- 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

$$Excel-Macros$$ Re: Excel 2003 compatibility issue

Thank you for the attempt, but this did not work. If I use your code example, I get the same runtime error on this line: With ActiveWorkbook.Worksheets("MyList").Sort I don`t understand why this does not work! -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s

Re: $$Excel-Macros$$ DATE Conversion - Gregorian to Hijri

Hi Excel Beginner, Thank you for posting the conversion file from Gregorian into Hijri. Do you mind sharing the formula to make it the other way, i.e. from Hijri into Gregorian please?! Many thanks! Ziad On Tuesday, September 25, 2012 1:15:05 PM UTC-4, Excel Beginner wrote: > > Hi Ahmed, >

$$Excel-Macros$$ Need help in picking data and updating in new sheet via Macro

Hi Group... Would appreciate if someone can help me in creating a macro or any formulated template to pick data from one sheet and update in other sheet. Process:--- Input sheet has 3 tabs: '*IntraState-Inter InterLata SDN'*, '*International Outbound'* and '*Mobile Offshore'.* ** Output sheet ha

$$Excel-Macros$$ UDF to pull data from Remote Server

Hi Expert, I made a UDF function that pull data form server on the basis given parameter. When user put the multiple formula on sheet and when he press for calculate, it take s more time to download data. Is there any way to make it fast. like i send all formula parameter in one shot (using x

Re: $$Excel-Macros$$ Excel 2003 compatibility issue

Ignore the extra "Range" in second line. On Mon, Apr 8, 2013 at 6:03 PM, Abhishek Jain wrote: > You can give a try to: > > With ActiveWorkbook.Worksheets("*yoursheetname*").Sort > .SetRange Range("B2:C37") > .Header = xlGuess > .MatchCase = False > .Orientation = x

Re: $$Excel-Macros$$ Excel 2003 compatibility issue

You can give a try to: With ActiveWorkbook.Worksheets("*yoursheetname*").Sort .SetRange Range("B2:C37") .Header = xlGuess .MatchCase = False .Orientation = xlTopToBottom .SortMethod = xlPinYin .Apply End With On Mon, Apr 8, 2013 at 5:01 PM, wro

$$Excel-Macros$$ Excel 2003 compatibility issue

I have a VBA macro created in Excel 2010, where it works fine. However, I get the following error when I run it in Excel 2003 (file saved in 2003 format): Runtime error '438': Object doesn't support this property or method Range("B2:C37").Select Range("C2").Activate ActiveWindow.S

Re: $$Excel-Macros$$ PDF Text Copy paste Issue in Excel

Hi Amar, Check this one. Regards, Kuldeep Singh Info Edge India Limited (naukri.com) Phone.: +91-0120-4841100, Extn.: 2467, 9716615535 naukrikuld...@gmail.com || www.naukri.com *Please* *Consider the environment. Please don't print this e-mail unless you really need to.* * * On Mon, Apr 8, 2013 a

Re: $$Excel-Macros$$ Re: Extracting word and numbers

Result is same prince sir. * varResData(intCtr, 2) = Replace(strNum, "", " ", 1, , vbTextCompare)* With *varResData(intCtr, 2) = Replace(strNum, "", "", 1, , vbTextCompare)* * * *Please check* * * * * *Regards,* *Chaya* On Mon, Apr 8, 2013 at 12:39 PM, Prince wrote: > Hi Chaya, > > Just Re

Re: $$Excel-Macros$$ Re: Extracting word and numbers

Hi Chaya, Just Replace This Line * varResData(intCtr, 2) = Replace(strNum, "", " ", 1, , vbTextCompare)* With *varResData(intCtr, 2) = Replace(strNum, "", "", 1, , vbTextCompare)* * * *Enjoy. * * * *Regards * Prince On Monday, April 8, 2013 12:32:38 PM UTC+5:30, chaya moni wrote: > > Thank

Re: $$Excel-Macros$$ Re: Extracting word and numbers

Thank you so much prince sir, Its is perfectly working for Extracting words, Can it be done for Numbers too as per my requirement as earlier attached. Regards, Chaya On Mon, Apr 8, 2013 at 12:13 PM, Prince wrote: > Hi Chaya, > > I Hope This may Help you. > > Sub Test() > > Dim va