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
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
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
Dear Murali,
Please see in attachment.
it might be helpful.
Regards,
Waseem Saifi
On Wed, Sep 4, 2013 at 2:21 PM, MURALI NAGARAJAN muralin...@gmail.comwrote:
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
Remove* * from formula ...for number value
On Wed, Sep 4, 2013 at 2:25 PM, KAUSHIK SAVLA savla.kaus...@gmail.comwrote:
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
=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 noorain.ans...@gmail.comwrote:
Dear Savla,
Please try it
**
On Wed, Sep 4, 2013 at 2:25 PM, KAUSHIK SAVLA savla.kaus...@gmail.comwrote:
Hi Team,
Request you to
Dear Savla,
Please try it
**
On Wed, Sep 4, 2013 at 2:25 PM, KAUSHIK SAVLA savla.kaus...@gmail.comwrote:
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
Thanks Prafull and Noorain sir.
On Wed, Sep 4, 2013 at 2:33 PM, Prafull Jadhav prafulltjad...@gmail.comwrote:
Remove* * from formula ...for number value
On Wed, Sep 4, 2013 at 2:25 PM, KAUSHIK SAVLA savla.kaus...@gmail.comwrote:
Hi Team,
Request you to kindly provide me solution to
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 Of
Thanks Ravi!
On Wed, Sep 4, 2013 at 2:38 PM, Ravi Kumar excellearn2...@gmail.com 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.
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 savla.kaus...@gmail.comwrote:
Thanks Prafull and Noorain sir.
On Wed, Sep 4, 2013 at 2:33 PM, Prafull
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
Dear Waseem,
Thanks for your great support.
On Wed, Sep 4, 2013 at 2:33 PM, Waseem Saifi waseemsa...@gmail.com 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 muralin...@gmail.comwrote:
Dear
Your Welcome Murali !
[?]
On Wed, Sep 4, 2013 at 2:53 PM, MURALI NAGARAJAN muralin...@gmail.comwrote:
Dear Waseem,
Thanks for your great support.
On Wed, Sep 4, 2013 at 2:33 PM, Waseem Saifi waseemsa...@gmail.comwrote:
Dear Murali,
Please see in attachment.
it might be helpful.
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 ricardo...@gmail.com 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
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,
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?
this is too good Rajan !
Regards,
Waseem Saifi
On Wed, Sep 4, 2013 at 3:01 PM, Rajan sharma rajansharma9...@gmail.comwrote:
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
:) 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 waseemsa...@gmail.com wrote:
this is too good Rajan !
Regards,
Waseem Saifi
On Wed, Sep 4, 2013 at 3:01
Thanks ashish Sir,
On Tue, Sep 3, 2013 at 9:43 AM, ashish koul koul.ash...@gmail.com 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 pritiverma1...@gmail.comwrote:
Please ignore
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 ricardo...@gmail.com wrote:
Hi, I adapted this code to
are thr multiple files in the folder
On Wed, Sep 4, 2013 at 1:39 PM, Jorge Marques leote.w...@gmail.com 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
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 that
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
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 ricardo...@gmail.com wrote:
Hi, I adapted
Replace your code with below one
openFile = Application.GetOpenFilename
Workbooks.Open (openFile)
On Wed, Sep 4, 2013 at 9:39 PM, ashish koul koul.ash...@gmail.com wrote:
are thr multiple files in the folder
On Wed, Sep 4, 2013 at 1:39 PM, Jorge Marques leote.w...@gmail.comwrote:
Hi
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
27 matches
Mail list logo