Hi Excel Experts,
i am looking VBA code for convering xls,xlsx file into .csv file. can
anybody support to get resource code in websites?
--
Thanks regards
Satheeshkumar
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise,
Hi,
I have the following macro which i am trying to get the price of a bond but
ends up giving me zero value. What could be the prblem?
Function PRICE364(settlement As Date, maturity As Date, rate As Double, yld
As Double, redemption, frequency)
'Initialize Variables
Dim COUPNCD As Date
Dim
Hi Kip,
I got 91.7021557489662 value in price variable and i call this function
as per the parameter provided by you ie :
Sub test()
Call PRICE364(31-10-2012, 22/4/2013, 11.5, 10.293, 100, 2)
End Sub
Please check may be you the way you passing the parameter in it is wrong.
Regards
Hi Satheeshkumar,
Please try this code hope this will help you.
Public Sub GetBrandsFiles()
Dim varArrFile As Variant
Dim intCtr As Integer
Dim strFilesAs String
Dim wbk As Workbook
varArrFile = Application.GetOpenFilename(*.xls,*.xlsx, , Select
Hi Prince,
Thanks for your feedback.
Attached is an excel sheet with the macro and am getting zerodid i do
it wrong?
Thanks and regards,
Boreh
On 11 December 2012 14:27, Prince prince141...@gmail.com wrote:
Hi Kip,
I got 91.7021557489662 value in price variable and i call this
Hi,
find below use this =SUMIF($A$2:$A$23,A2,$C$2:$C$23)
thankx
satendra
On Tue, Dec 11, 2012 at 5:59 PM, raghunandan rallapalli
raghunandan.rallapa...@gmail.com wrote:
sir,
I need a formula for total sum of each account no wise as given in excel
sheet.
Thanks in advance please.
your file (it's working only on one condition, that you account_no column is
SORTED!!!)
I didn't want to advice you to do pivot table as per request function.
awel
From: raghunandan rallapalli raghunandan.rallapa...@gmail.com
To: excel-macros@googlegroups.com
Thanks Prince
On Friday, December 7, 2012 4:06:27 AM UTC+5:30, satyas wrote:
Need to create a summary sheet for the attached Excel doc.
Tab “Detailed” is the input tab and works fine.
Tab “Summary” should show the name from the A column in “Detailed” in any
cell that corresponds.
http://www.automateexcel.com/2004/08/14/excel_vba_convert_excel_to_csv_comma_del/
http://www.java2s.com/Code/VBA-Excel-Access-Word/File-Path/ExportactiveworksheettoCSVfile.htm
http://www.ozgrid.com/forum/showthread.php?t=76720
On Tue, Dec 11, 2012 at 2:02 PM, Satheeshkumar Yadav
=MAX(IF(MONTH($E$7:$E$27)=MONTH(H8),$F$7:$F$27,))
press + ctlr + shift+ enter
On Tue, Dec 11, 2012 at 1:13 PM, amar takale amartak...@gmail.com wrote:
Hi All Champs
I will Request all anyone suggest me unique value from same month (formula)
Regards
Amar
--
Join official Facebook
My end goal is to have new worksheet templates scanningprocess.xltm auto
generate/name based on the values of cells on the main worksheet (A6:A99).
So far I have the following macro that auto creates a new worksheet. The
troubles I am having are the following:
1. It is a blank worksheet - not
Hi
replace this
* If wsNew Is Nothing Then Sheets.Add().Name = Target.Text*
*End If*
*
*
with below one
* If wsNew Is Nothing Then*
*
Sheets.Add After:=Sheets(Sheets.Count)
Sheets(Sheets.Count).Name = Target.Text
*
* End If*
*
*
Regards
Ashish
On Tue, Dec 11, 2012 at
Thank you! When I do that I get the following error (I attached screenshot
so you could also see the macro)
https://lh6.googleusercontent.com/--L6Q0IeYzz0/UMdwMTA9vmI/AEg/5oKDaPiV07Y/s1600/macroerror1.JPG
On Tuesday, December 11, 2012 12:32:27 PM UTC-5, ashish wrote:
Hi
replace this
add one more* end if* at the end see below
* If wsNew Is Nothing Then*
*
Sheets.Add After:=Sheets(Sheets.Count)
Sheets(Sheets.Count).Name = Target.Text
*
* End If*
* End If*
*end sub *
*
*
On Tue, Dec 11, 2012 at 11:11 PM, Laura Ann Dietrich
ldietri...@gmail.comwrote:
Thank
Nevermind, I figured out the reason for the error.
It solves my second issue. But not the first. What do I need to modify to
make the new worksheet it creates my template scanningprocess.xltm
instead of a blank worksheet?
Thank you.
On Tuesday, December 11, 2012 12:18:40 PM UTC-5, Laura Ann
how many sheets u have created in scanningprocess.xltm template
On Tue, Dec 11, 2012 at 11:15 PM, Laura Ann Dietrich
ldietri...@gmail.comwrote:
scanningprocess.xltm
--
*Regards*
* *
*Ashish Koul*
*Visit*
*http://www.excelvbamacros.com/*
*http://www.accessvbamacros.com/*
P Before
scanningprocess.xltm is one worksheet.
On Tue, Dec 11, 2012 at 12:47 PM, ashish koul koul.ash...@gmail.com wrote:
how many sheets u have created in scanningprocess.xltm template
On Tue, Dec 11, 2012 at 11:15 PM, Laura Ann Dietrich ldietri...@gmail.com
wrote:
scanningprocess.xltm
try this
*Private Sub Worksheet_Change(ByVal Target As Range)*
*Dim wsNew As Worksheet*
*Dim sht As Worksheet*
*If Target.Cells.Count 1 Then Exit Sub*
* *
*On Error Resume Next*
*If Not Intersect(Target, Range(A6:A99)) Is Nothing Then*
*Set wsNew =
Hi Laura
*Please try this code*
Private Sub Worksheet_Change(ByVal Target As Range)
Dim wsNew As Worksheet
Dim sht As Worksheet
If Target.Cells.Count 1 Then Exit Sub
On Error Resume Next
If Not Intersect(Target, Range(A6:A99)) Is Nothing Then
Set wsNew =
sorry forget to mention please change the path of template as per your
system and template name
C:\Documents and Settings\user\Desktop\sample.xltx
On Tue, Dec 11, 2012 at 11:31 PM, ashish koul koul.ash...@gmail.com wrote:
Hi Laura
*Please try this code*
Private Sub
Thanks. When I try that code (with the corrected file path), it no longer
creates a new worksheet or names one. It just points me to a random cell on
the last worksheet.
On Tue, Dec 11, 2012 at 1:03 PM, ashish koul koul.ash...@gmail.com wrote:
sorry forget to mention please change the path of
have u selected the correct template and extension of template
Pls check it once again
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Laura Ann Dietrich ldietri...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Tue, 11 Dec 2012 13:09:35
To:
I verified the path is correct (when I type the path into explorer, it
opens the template)
On Tue, Dec 11, 2012 at 1:20 PM, koul.ash...@gmail.com wrote:
**
have u selected the correct template and extension of template
Pls check it once again
Sent on my BlackBerry® from Vodafone
Hi Amar,
Try this array formula
=INDEX($F$7:$F$27,MATCH(MONTH(H8),MONTH($E$7:$E$27),0))
On Tue, Dec 11, 2012 at 1:13 PM, amar takale amartak...@gmail.com wrote:
Hi All Champs
I will Request all anyone suggest me unique value from same month (formula)
Regards
Amar
--
Hi Raghu,
please find the attachment.
--
*Regards,*
*
*
*Excel Beginner*
*
*
On Tue, Dec 11, 2012 at 5:59 PM, raghunandan rallapalli
raghunandan.rallapa...@gmail.com wrote:
sir,
I need a formula for total sum of each account no wise as given in excel
sheet.
Thanks in
Hi, Prince
I need to go a step further, is there any way that instead of number the
name of person will appear in the cell so that we can differentiate each
person.
On Tuesday, December 11, 2012 7:12:45 PM UTC+5:30, satyas wrote:
Thanks Prince
On Friday, December 7, 2012 4:06:27 AM
Thanks Very much Ashish Sir Excel user group
On Wed, Dec 12, 2012 at 12:00 AM, Ms Excel user msexcelu...@gmail.comwrote:
Hi Amar,
Try this array formula
=INDEX($F$7:$F$27,MATCH(MONTH(H8),MONTH($E$7:$E$27),0))
On Tue, Dec 11, 2012 at 1:13 PM, amar takale
Dear Prince Sir
Thanks for great guidance Now I repair my mistek. One more question sir,Can
I give different effect for animation.
On Tue, Dec 11, 2012 at 7:09 PM, Pravin Gunjal isk1...@gmail.com wrote:
*Dear Amar,*
*Pl find the attached file as per your requirement.*
*
*
*It was not
*Hi Amar,*
*
*
*Pl be noted that, I am not Prince and I am Pravin.*
*
*
*Also note that you can change the animation effects by changing it's
parameters as per your requirement.*
*
*
*Regards*
*Pravin Gunjal
*
-- Forwarded message --
From: amar takale amartak...@gmail.com
Date:
Dear Pravin
First Thanks for your valuable time for my solution sorry for change your
name.Now it s working fine
Regards
Amar
On Wed, Dec 12, 2012 at 10:58 AM, Pravin Gunjal isk1...@gmail.com wrote:
*Hi Amar,*
*
*
*Pl be noted that, I am not Prince and I am Pravin.*
*
*
*Also note
Dear Experts,
kindly find the attached sheet. i want to make the conditional format, but
how to make. revert me
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Thanks a lot Ashish, this is what exactly what i am looking.
I small addition required, Once the Formula is placed and formula resulted
converted to % format, the value should highlight in red font if the value
is more than 10% only for that result row.
Is this possible?
On Tue, Dec 11, 2012
Dear Neeraj,
Pl find attached.
Regards,
Gawli
On Wed, Dec 12, 2012 at 12:28 PM, neeraj chauhan neerajchauhan...@gmail.com
wrote:
Dear Experts,
kindly find the attached sheet. i want to make the conditional format, but
how to make. revert me
--
Join official Facebook page of this forum @
Hi Bill,
There are two variable defined in your module. These are RunWhen and
SaveWhen.
Both of them are being used with timeserial value.
You can provide your desired time in this parameter(TimeSerial).
Suppose you want to Run your code at 1500 hrs then you can modify your code
as below:
34 matches
Mail list logo