$$Excel-Macros$$ Re: PDF to txt by vba code

2013-09-04 Thread Basole
Will save in the same folder. This problem can occur due to application "DOS" PDFtoText.exe, only read files with up to eight (8) digits. Try to rename your PDF file with 8 digits (eg "myfile1.pdf"), to see if it works. Bsl. Em terça-feira, 3 de setembro de 2013 10h22min31s UTC-3, Priti_Verma e

Re: $$Excel-Macros$$ Opening only file in folder

2013-09-04 Thread Anoop K Sharma
Replace your code with below one openFile = Application.GetOpenFilename Workbooks.Open (openFile) On Wed, Sep 4, 2013 at 9:39 PM, ashish koul wrote: > are thr multiple files in the folder > > > On Wed, Sep 4, 2013 at 1:39 PM, Jorge Marques wrote: > >> Hi guys, >> >> I have this macro to open a

Re: $$Excel-Macros$$ Re: PDF to txt by vba code

2013-09-04 Thread Prabhu Pinky
Hi Basole, i copied one file into the folder and tried converting. i received the success msg. but i dont find the file in that folder. will it saved in same folder or any other folder..? Thanks & Regards, Prabhu R On 4 September 2013 00:07, Basole wrote: > Hi, I adapted this code to use ut

$$Excel-Macros$$ Re: PDF to txt by vba code

2013-09-04 Thread Basole
hi sorry, password is: 1234 Bsl Em terça-feira, 3 de setembro de 2013 10h22min31s UTC-3, Priti_Verma escreveu: > > Please ignore previous mail and consider on this. > > i want to convert PDFs file to .txt file. through vba code. > i have been search it on Google ,but not get any solution. > Can

$$Excel-Macros$$ Re: Opening only file in folder

2013-09-04 Thread Basole
Not sure I understand, but see if this is what you need? rsg. Bsl Em quarta-feira, 4 de setembro de 2013 05h09min50s UTC-3, Jorge Leote escreveu: > > Hi guys, > > I have this macro to open a excel file in a specific folder, I now want to > do the same in another folder, but the problem is th

Re: $$Excel-Macros$$ Opening only file in folder

2013-09-04 Thread ashish koul
are thr multiple files in the folder On Wed, Sep 4, 2013 at 1:39 PM, Jorge Marques wrote: > Hi guys, > > I have this macro to open a excel file in a specific folder, I now want to > do the same in another folder, but the problem is that the file is always > changing name. > > Set oWSHShell = Cr

Re: $$Excel-Macros$$ Re: PDF to txt by vba code

2013-09-04 Thread Ricardo®
Ok the Password is: 1234 On Wed, 4 Sep 2013 07:48:52 -0300, excel-macros@googlegroups.com wrote: > Hi Basole > > Thanks for the code ,Could You Pls tell me the Password that is in Your > code. > > > On Tue, Sep 3, 2013 at 12:37 PM, Basole wrote: > > > Hi, I adapted this code to use utilit

Re: $$Excel-Macros$$ PDF to txt by vba code

2013-09-04 Thread priti verma
Thanks ashish Sir, On Tue, Sep 3, 2013 at 9:43 AM, ashish koul wrote: > > http://www.myengineeringworld.net/2013/03/vba-macro-to-convert-pdf-files-into.html > > see if it helps > > > > On Tue, Sep 3, 2013 at 6:52 PM, priti verma wrote: > >> Please ignore previous mail and consider on this. >>

Re: $$Excel-Macros$$ Need a formula urgently

2013-09-04 Thread Rajan sharma
:) All this credit goes to this forum, Atually i have learnt from this forum and just used. Thanks With warm regards, Rajan Sharma On Wed, Sep 4, 2013 at 4:50 PM, Waseem Saifi wrote: > this is too good Rajan ! > > Regards, > Waseem Saifi > > > On Wed, Sep 4, 2013 at 3:01 PM, Rajan sharma

Re: $$Excel-Macros$$ Need a formula urgently

2013-09-04 Thread Waseem Saifi
this is too good Rajan ! Regards, Waseem Saifi On Wed, Sep 4, 2013 at 3:01 PM, Rajan sharma wrote: > Hi Murali, > > Chek the attachment too. Might it will also help you. :-) > > > > > > With warm regards, > Rajan Sharma > > > > On Wed, Sep 4, 2013 at 2:55 PM, Waseem Saifi wrote: > >> Your Welco

$$Excel-Macros$$ Query Regarding Range.Dirty

2013-09-04 Thread Soumyendu Paul
Hi Experts. I have found numerous examples of *Range("E3").Dirty* like standard VBA code in websites. As per their explanation; it forces "E3" cell to recalculate when Excel is manual calculation mode. Could anyone in this group give me an example of practical application of this property?

RE: $$Excel-Macros$$ Re: PDF to txt by vba code

2013-09-04 Thread danial mansoor
share code with me also. Date: Wed, 4 Sep 2013 04:48:52 -0600 Subject: Re: $$Excel-Macros$$ Re: PDF to txt by vba code From: pritiverma1...@gmail.com To: excel-macros@googlegroups.com Hi Basole Thanks for the code ,Could You Pls tell me the Password that is in Your code. On Tue, S

Re: $$Excel-Macros$$ Re: PDF to txt by vba code

2013-09-04 Thread priti verma
Hi Basole Thanks for the code ,Could You Pls tell me the Password that is in Your code. On Tue, Sep 3, 2013 at 12:37 PM, Basole wrote: > Hi, I adapted this code to use utility (PDFtoText.exe) free. > To run this code please paste all files (attachments) must be in the same > folder. > > tks. >

Re: $$Excel-Macros$$ Need a formula urgently

2013-09-04 Thread Waseem Saifi
Your Welcome Murali ! [?] On Wed, Sep 4, 2013 at 2:53 PM, MURALI NAGARAJAN wrote: > Dear Waseem, > > Thanks for your great support. > > On Wed, Sep 4, 2013 at 2:33 PM, Waseem Saifi wrote: > >> Dear Murali, >> >> Please see in attachment. >> it might be helpful. >> >> Regards, >> Waseem Saifi

Re: $$Excel-Macros$$ Need a formula urgently

2013-09-04 Thread MURALI NAGARAJAN
Dear Waseem, Thanks for your great support. On Wed, Sep 4, 2013 at 2:33 PM, Waseem Saifi wrote: > Dear Murali, > > Please see in attachment. > it might be helpful. > > Regards, > Waseem Saifi > > > On Wed, Sep 4, 2013 at 2:21 PM, MURALI NAGARAJAN wrote: > >> Dear All, >> >> I have a data base

RE: $$Excel-Macros$$ Need help on silly problem quickly

2013-09-04 Thread Ravi Kumar
Welcome friend Warm Regards, Ravi Kumar. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of KAUSHIK SAVLA Sent: Wednesday, September 04, 2013 2:40 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need help on silly problem quickl

Re: $$Excel-Macros$$ Need help on silly problem quickly

2013-09-04 Thread Waseem Saifi
Dear Kaushik, No need to close numbers in double quotes. just simply type numbers as numbers, like Type 1 instead of "1" or -1 instead of "-1" On Wed, Sep 4, 2013 at 2:37 PM, KAUSHIK SAVLA wrote: > Thanks Prafull and Noorain sir. > > > On Wed, Sep 4, 2013 at 2:33 PM, Prafull Jadhav > wrote: >

Re: $$Excel-Macros$$ Need help on silly problem quickly

2013-09-04 Thread KAUSHIK SAVLA
Thanks Ravi! On Wed, Sep 4, 2013 at 2:38 PM, Ravi Kumar wrote: > Hi, > > ** ** > > ** ** > > Here is ur solution > > ** ** > > Don’t use “1” when u put number in if condition always give numbers as it > is. There is no need to give like “-1”, “1”. Simply right -1, 1. > > ** ** > > *

RE: $$Excel-Macros$$ Need help on silly problem quickly

2013-09-04 Thread Ravi Kumar
Hi, Here is ur solution Don't use "1" when u put number in if condition always give numbers as it is. There is no need to give like "-1", "1". Simply right -1, 1. Warm Regards, Ravi Kumar. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf

Re: $$Excel-Macros$$ Need help on silly problem quickly

2013-09-04 Thread KAUSHIK SAVLA
Thanks Prafull and Noorain sir. On Wed, Sep 4, 2013 at 2:33 PM, Prafull Jadhav wrote: > > Remove* "" * from formula ...for number value > > > On Wed, Sep 4, 2013 at 2:25 PM, KAUSHIK SAVLA wrote: > >> Hi Team, >> >> Request you to kindly provide me solution to below silly problem I am >> facing i

Re: $$Excel-Macros$$ Need help on silly problem quickly

2013-09-04 Thread NOORAIN ANSARI
=IF(A2=9,N(1),IF(A2=10,N(1),IF(A2<=6,N(-1),IF(A2=N(7),"",IF(A2=N(8),"") On Wed, Sep 4, 2013 at 2:37 PM, NOORAIN ANSARI wrote: > Dear Savla, > > Please try it > > ** > > > On Wed, Sep 4, 2013 at 2:25 PM, KAUSHIK SAVLA wrote: > >> Hi Team, >> >> Request you to kindly provide me solution to bel

Re: $$Excel-Macros$$ Need help on silly problem quickly

2013-09-04 Thread NOORAIN ANSARI
Dear Savla, Please try it ** On Wed, Sep 4, 2013 at 2:25 PM, KAUSHIK SAVLA wrote: > Hi Team, > > Request you to kindly provide me solution to below silly problem I am > facing in excel. > > I am trying to get sum of data range B2 to B6 in cell B8. Answer which I > am getting is not correct, se

Re: $$Excel-Macros$$ Need help on silly problem quickly

2013-09-04 Thread Prafull Jadhav
Remove* "" * from formula ...for number value On Wed, Sep 4, 2013 at 2:25 PM, KAUSHIK SAVLA wrote: > Hi Team, > > Request you to kindly provide me solution to below silly problem I am > facing in excel. > > I am trying to get sum of data range B2 to B6 in cell B8. Answer which I > am getting is

Re: $$Excel-Macros$$ Need a formula urgently

2013-09-04 Thread Waseem Saifi
Dear Murali, Please see in attachment. it might be helpful. Regards, Waseem Saifi On Wed, Sep 4, 2013 at 2:21 PM, MURALI NAGARAJAN wrote: > Dear All, > > I have a data base like colum A contains State name & colum B contains > city name against state name, im going to create a report that cit

$$Excel-Macros$$ Need help on silly problem quickly

2013-09-04 Thread KAUSHIK SAVLA
Hi Team, Request you to kindly provide me solution to below silly problem I am facing in excel. I am trying to get sum of data range B2 to B6 in cell B8. Answer which I am getting is not correct, seems some problem with formatting. Pls help. -- *Warm Regards,* *Kaushik Savla* -- Are you =EXP(

$$Excel-Macros$$ Need a formula urgently

2013-09-04 Thread MURALI NAGARAJAN
Dear All, I have a data base like colum A contains State name & colum B contains city name against state name, im going to create a report that city name will be displayed in accordance with the change in the state name . Note:Sample data attached along with this mail. Do the needful. Thanks

$$Excel-Macros$$ Opening only file in folder

2013-09-04 Thread Jorge Marques
Hi guys, I have this macro to open a excel file in a specific folder, I now want to do the same in another folder, but the problem is that the file is always changing name. Set oWSHShell = CreateObject("WScript.Shell") OpenFile = oWSHShell.SpecialFolders("Desktop") & "\Logi Macro Project\VEEE\wee