Hello NandKumar
Please scan through the recent posts and files on this group. You would find
links and reference to books for learning VBA.
Thanks and Regards,
Vivek Agrawal
Skype ID - vivek.agrawal83
GoogleMoonlight.com - Saving energy-Save Earth
On Wed, Jul 22, 2009 at 10:26 AM, Nandkumar
Hello Excel Experts and Learners,
I have uploaded a torrent file which contains N number of books
related to Microsoft Office 2007. They are indeed very helpful. I have
downloaded all of them and they seem to include all the GOOD books
present on this earth for learners of Office 2007. FYI - this
Hello Bro/Sis
Pls How to learn Vbs Macros pls send me link how to learn
Thanks My Big B/S
Nandkumar
On Wed, Jul 22, 2009 at 10:16 AM, vivek agrawal
wrote:
> Hello,
> According to me, the error is because of the mismatch of object type and
> not that you are not able to assign onaction property
Hi.. I cant able to understand the question.. also I ve not received any
attachment.. Pls mention the question clearly...
--
Best Regards
Anish
--~--~-~--~~~---~--~~
--
Some import
Can u please mail a sample excel sheet to make your doubt somewhat more
clear.
Thanks and Regards,Vivek Agrawal
Skype ID - vivek.agrawal83
GoogleMoonlight.com - Saving energy-Save Earth
On Tue, Jul 21, 2009 at 11:54 PM, Aamir Shahzad wrote:
> Dear all,
>
> Can anyone tell me please "How to
Hello,
According to me, the error is because of the mismatch of object type and not
that you are not able to assign onaction property to a shape object.
The new_shape is of "Excel.*Shape*" type where as you are assigning to the
new_shape - the duplicate of an Excel.*Shapes *type. While, SHAPE obje
Hi Daniel,
If i click CHART TITLE, formula bar not comes. it is just a text box,
so how to write formula in Chart Title?
U can try in the attachment.
On Tue, Jul 21, 2009 at 8:19 PM, Daniel wrote:
> HI,
>
> In cell G4 (or elsewhere, maybe hidden), enter :
>
> ="Revenue ("&G2&")"
>
> Select the
Instead of trying to fix this problem, could anyone tell me how I
could make multiple images execute the same code but with a different
parameter upon clicking?
--~--~-~--~~~---~--~~
--
Alright..i tried on another laptop and it works perfect..just its not
working on my work computer..any ideas?
On Jul 21, 1:26 pm, Paul Schreiner wrote:
> Have you tried setting a breakpoint and see if
> what it is actually doing by stepping through the code?
>
> and.. what do you mean that it st
Hi Ruchi,
Gud Morning,
Hope ur query is solved now.
With Love
Mahesh...
On Tue, Jul 21, 2009 at 5:38 PM, Anil Kumar Agarwala
wrote:
> Hi Ruchi,
>
> Why don’t you try with 1 in the vlookup instead of 0 thus
>
> =VLOOKUP(B2,F3:G99,2,1)
>
> I believe you will get the desired result.
>
>
>
> *[im
B1 = last traded price of crude oil futures ( get through DDE link so
keeps changing every sec ) e.g. 6500
B2 & B3 ( I define the range so if B1 goes between the value specified
in B2 and B3 then run another macro ( Call BuyBeansSellProducts )
which will enter multiple Buy Orders in to exchange)
Hi Ruchi,
Enter the below formula in the cell C2
=VLOOKUP(TIME(HOUR(B2),CEILING(MINUTE(B2),15),0),$F$2:$G$99,2,0).
Regards,
Upendra Singh
+91-9910227325, +91-9310760597
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Ruchi Saxena
Sent:
Thanks Ajit, but I've tried this. The define name dialog box accepts
it with the filepath, but once I close the other workbook and try to
update the range I get the error. Ive created two simple workbooks
that demonstrate the problem, if I can figure out how to post them
here.
Angelo
On Jul 21,
Hello all,
I was wondering if anyone could tell me why, when I Duplicate a Shape
(image), I can't assign OnAction property to it. Following is a simple
code that gives me "Run-time error 1004: Application-defined or object-
defined error":
Sub Image1_Click()
Dim new_shape As Excel.Shape
Yes, once I close the source workbook, the filepath isn't added
automatically and I get a REF error.
On Jul 21, 8:48 am, Luke Mercer wrote:
> Do you mean that the 'links' funciotnality is not updating the directory and
> path of the model when the link is via a rangename?
> Thats a good idea, to
I'd love to, but for whatever reason I can't see your email address
and can't attached a sample workbook in this post
On Jul 21, 8:33 am, "Daniel" wrote:
> Can you mail back a sample file ?
>
> Regards.
>
> Daniel
--~--~-~--~~~---~--~~
---
Name: Justo Morales
Subject: Data Summary
Detail: Sometimes you need to get a summary of many different values.
However, you may not be sure what fields you have listed. For
example, say you have the total number of colors produced by day for
an entire month. You want to know exactly how many of
Hello MartyH,
I was able to do this by installing NcFTP on my computer. It is
available here: http://www.ncftp.com/download/. You want to install
the client (not server.)
Once you install that program, modify the following code to accomplish
saving to an FTP file:
Sub SaveTXT2FTP()
'
' SaveTX
Dear all,
Can anyone tell me please "How to make unique key" for pick required data from
one sheet to another. If there is no similarity. e.g. for use of vlookup or
sumif funtions. Reply will highly appriciated.
Regards,
Aamir Shahzad
--~--~-~--~~~---~--~~
Have you tried setting a breakpoint and see if
what it is actually doing by stepping through the code?
and.. what do you mean that it stopped "recognizing" range 3 and 4?
What are the values you're testing?
B1 =
B2 =
B3 =
B4 =
Paul
From: TAlgo
To: MS EXC
Sorry, I missed this one. Calendar control is not shipped with every brand
of Office. It is usually shipped with MS Access. You can find on the
internet or use the "Microsoft date and time picker" control" instead.
Hope this helps.
Daniel
> -Original Message-
> From: excel-macros@google
Well Rajesh
I do not think there is a specific formula...
its just that i would create a vba application which would transfer the
entries from the trial balance to the respective target reports...
Regards,
Vivek Agrawal
Skype ID - vivek.agrawal83
GoogleMoonlight.com - Saving energy-Save Earth
any help??
On Jul 7, 8:55 pm, Lynn wrote:
> error --> missing MS calendar control 8.0
> pls help
>
> Thanks
>
> On Jul 7, 3:45 am, y2 kx wrote:
>
>
>
> > Hello Mr.CA Narendra Ashara,
> > Try this link very simple..
>
> >http://sudhirsunil.blogspot.com/2009/01/excel-pop-up-calendar-add-in
>
Trick to get serial number behind Date format
Select a cell and enter today date into the cell by pressing Ctrl+;
than press Ctrl+~.
Press Ctrl+~ again to restore the sheet to its normal appearance.
thx
On Jul 21, 11:18 am, Ayush wrote:
> Dear Members,
>
> Let us begin week # 29 quiz with the
Regards,
Vivek Agrawal
Skype ID - vivek.agrawal83
GoogleMoonlight.com - Saving energy-Save Earth
On Tue, Jul 21, 2009 at 7:21 PM, Rajesh Janardanan wrote:
>
> Thanks Vivek.
> But what are the tools or formulas in excel we can use for doing this
> package ? I would like to try my self.
>
> Be
are you there???
On Jul 20, 10:58 pm, Lynn wrote:
> could you teach me how you came up with this formula?
> thanks
>
> On Jul 20, 1:40 pm, Ashish Pradhan wrote:
>
>
>
> > Hello Lynn
>
> > In Conditional Formatting, you can use the formula (Please select the entire
> > column or rows where you h
Well Rajesh
Regards,
Vivei do not think there is a specific formula...
its just that i would create a vba application which would transfer the
entries from the trial balance to the respective target reports...
Regards
Vivek Agrawal
Skype ID - vivek.agrawal83
GoogleMoonlight.com - Saving energy
Dear Members,
Let us begin week # 29 quiz with the hope of high participation.
Last Date of Submission of tips : 26th July 2009.
PLEASE NOTE THAT THE TIPS SUBMITTED IN THIS POST WILL ONLY BE
CONSIDERED FOR PRIZES.
DO NOT START NEW THREADS OR POST FOR SUBMISSION OF TIPS.
You need to submit your
Dear members,
There were no tips submitted in the contest of week 29. So there is no
winner...
Please share your suggestions on how can we engage more people in this
contest, So that there is a learning for us each day.
Best regards,
Ayush Jain
--~--~-~--~~~---~--~--
Kamal,
Can you please forward the formula for standard exchange rate..thx
On Jul 19, 4:04 pm, kamal shah wrote:
> Are you looking for standard Exchange Rate or a variable?
> If so then u dont need macro for it. you can get it done with simple
> formula..
>
> let me know if u need it.
>
> kamal
hello,
I was successfully using the following code as entering orders to
trade commodity futures in to exchange.
Private Sub Worksheet_Calculate()
Const WS_RANGE As String = "B1" '<== change to suit
On Error GoTo ws_exit
If Range(WS_RANGE).Value = oldval Then Exit Sub 'value has not changed
oldv
HI,
In cell G4 (or elsewhere, maybe hidden), enter :
="Revenue ("&G2&")"
Select the chart title and, in the formula bar, enter :
=G4
Hope this helps.
Daniel
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of gyanesh jain
Sent: mardi 21 juillet 2009 14:
Hi Jonathan,
Use the following formula:
=IF(OR(WEEKDAY(TODAY(),2)=2,WEEKDAY(TODAY(),2)=3,WEEKDAY(TODAY(),2)=4,WEEKDAY(TODAY(),2)=5,WEEKDAY(TODAY(),2)=6,WEEKDAY(TODAY(),2)=7),TODAY()-1,TODAY()-2)
Please let me know if this helps.
Regards,
Andy
On Tue, Jul 21, 2009 at 6:35 PM, totalnatal
wrote:
Thanks Vivek.
But what are the tools or formulas in excel we can use for doing this
package ? I would like to try my self.
Best regards
Rajesh
On Tue, Jul 21, 2009 at 2:18 PM, Vivek Agrawal wrote:
>
> Hello Rajesh
>
> For this you would require to send the following excel files so that
> the for
Hello.
Try :
=TODAY()-INDEX({2,3,1,1,1,1,1},WEEKDAY(TODAY()))
Daniel
> -Original Message-
> From: excel-macros@googlegroups.com [mailto:excel-
> mac...@googlegroups.com] On Behalf Of totalnatal
> Sent: mardi 21 juillet 2009 13:35
> To: MS EXCEL AND VBA MACROS
> Subject: $$Excel-Macros$$ G
Hi,
You need to specify the file path in the Define Name -> Refers To box,
e.g.
=''!
Regards
Ajit
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Luke Mercer
Sent: Tuesday, July 21, 2009 6:19 PM
To: excel-macros@googlegroups.com
Subje
Do you mean that the 'links' funciotnality is not updating the directory and
path of the model when the link is via a rangename?
Thats a good idea, to correct for row insertion / column insertion - it had
never occured to me before.
Luke
--
Mercer PPP / Project Finance:
Excel Financial Model Se
Hi Ruchi,
Why don't you try with 1 in the vlookup instead of 0 thus
=VLOOKUP(B2,F3:G99,2,1)
I believe you will get the desired result.
CA_logo_icai Small1
Anil Kumar Agarwala
Anil Agarwala & Co.
Chartered Accountants
3rd Floor, Adiba Mansion
Maszid Lane, Kamarpatty
Fancy Bazar
Guwaha
Hi All,
check the attachment.
If you change the country, in the chart "chart Title" should be change
automatically.
example rite now Chart Title is *Revenue (Rs. m)*.
If I change the Select Country to USA, chart title should change to *Revenue
( USD m)*.
--
Thanks,
Gyanesh Jain
+91 98868 68488
Hi
open this link... this is a file uploaded to our group..hope this
helps
http://excel-macros.googlegroups.com/web/39Excel2003Macros.pdf?gda=dyJxeUcAAAB2J3ijGgZtJPJc1AvLZdlBxNf0CRgjgdhSYShN3uoFr4P9yQ_zYuLTRNWtNxCtoXlhmrMR3uGvvPr01Poh-10xeV4duv6pDMGhhhZdjQlNAw
All the Best
Thanks
Regards,
V
Hi,
I am using the following function =TODAY()-1 which gives me
yesterday's date. However, if we're monday it will give me sunday's
date whereas I only want weekdays.
Can anyone help?
--~--~-~--~~~---~--~~
-
hello
your question doesnt seem to very clear. can u pls post an excel file
with clearly depicting what u exactly want
thanks
On Jul 16, 8:09 pm, osiso wrote:
> to basically help with proramming in vb excel to do things such as:
>
> 1. create if then statement where the =if(file\1.xls\sheet1!a
Hello Rajesh
For this you would require to send the following excel files so that
the format and the structure can be used...
1. The report which you download from SAP
2. the format in which you want the P&L, Cash Flow and the Balance
sheet..
Thanks
On Jul 16, 7:42 pm, Rajesh Janardanan w
Dear Daniel.
Thank you for your reply. I am working in a small restaurant. I just want to
print computerized invoices and to record the sales data. In this regard I need
a point of sales type of software. Now you can assume fields better then mine
as I have not in depth konwledge of data
Thanks Dave..it works man..you rock
Thx
Deb
On Tue, Jul 21, 2009 at 3:14 PM, Dave Bonallack
wrote:
> Hi Dev,
> Your macro is more complex than necessary.
> You don't have to unhide sheets, or select ranges to work on them.
> The following 2 lines of code should do what you n
Dear Daniel
Can you please send a copy at the below given ID
rashid.imt...@gmail.com
i will pay you. if i got any customer for sure.
I just want to get things going
regards
rashid
On Tue, Jul 21, 2009 at 4:26 PM, Hitesh Taunk wrote:
> Hello Everyone,
> I have newly join
hi
your query doesnt seem to be clear can u please mail the worksheet
and clearly state what do you actually want
Thanks
On Jul 17, 12:21 am, osiso wrote:
> Guys,
>
> I am not well versed in vba, more just excel functions. So I recorded
> a macro where I typed in the if then statement sho
Regards,
Vivek Agrawal
Skype ID - vivek.agrawal83
GoogleMoonlight.com - Saving energy-Save Earth
-- Forwarded message --
From: vivek agrawal
Date: Tue, Jul 21, 2009 at 3:47 PM
Subject: addendum - Re: $$Excel-Macros$$ Re: Fill In Rows - Efficiency Issue
To: excel-macros@google
Welcome Sandeep...
just be in constant touch with the FILES section of our group... you would
get relevant material from there...
Thanks and Regards,
Vivek Agrawal
Skype ID - vivek.agrawal83
GoogleMoonlight.com - Saving energy-Save Earth
2009/7/21 ╚►♥ѕαη∂єєρ♥◄╝
> Thanks a lot vivek !! it i
Can you mail back a sample file ?
Regards.
Daniel
> -Original Message-
> From: excel-macros@googlegroups.com [mailto:excel-
> mac...@googlegroups.com] On Behalf Of AngeloUCF
> Sent: lundi 20 juillet 2009 21:08
> To: MS EXCEL AND VBA MACROS
> Subject: $$Excel-Macros$$ referenced named ra
Thanks a lot vivek !! it is really helpful for me ..if u have or this type
of file to learn functions plz send me likn or file ..
and again thank u so much fnd
Regards: ╚►♥ѕαη∂єєρ♥◄╝
On Tue, Jul 21, 2009 at 4:00 PM, vivek agrawal wrote:
> Hi Sandeep
> open this link... this is a file uploa
Hi Sandeep
open this link... this is a file uploaded to our group..hope this helps
http://excel-macros.googlegroups.com/web/39Excel2003Macros.pdf?gda=dyJxeUcAAAB2J3ijGgZtJPJc1AvLZdlBxNf0CRgjgdhSYShN3uoFr4P9yQ_zYuLTRNWtNxCtoXlhmrMR3uGvvPr01Poh-10xeV4duv6pDMGhhhZdjQlNAw
Thanks
Regards,
Vivek Agr
Hello Everyone,
I have newly joined this group about a day before. I
am very much interest of learning VB Macro in excel, but unfortunately i am
new for the same. I want to start the whole thing from scrap. Besides, I am
very poor in programming of VB...I would request our g
Well Ruchi,
For that, edit the "Vlookup function entered"... just replace the last
argument passed from "0" to "1")
hope it helps
Thanks
Regards,
Vivek Agrawal
Skype ID - vivek.agrawal83
GoogleMoonlight.com - Saving energy-Save Earth
On Tue, Jul 21, 2009 at 3:42 PM, Ruchi Saxena wrote:
>
Hello Dustin
You can also add the following one line code as the first line of code just
below "Sub."
Application.ScreenUpdating = False
this would not update the screen and would look as if the task has been done
in a flash of light.
Regards,
Vivek Ag
Hi
Thanks a lot to Ankit, Shreyans, Mahesh
but any other time entered say 5:16 does not give me answer (the attached
sheet says that till 5:15 it is "L" but from 5:16 to 5:30 it is "O" & so on)
so when i enter 5:16, it must give status as "O"
Can you please refine such that any time entered wil
Thank u so much vivek for writeing me ..i have scarch e book and helping
material but i did not find can u plz send me link of those file i will
really appreciate u for this help .
Regards: ╚►♥ѕαη∂єєρ♥◄╝
On Tue, Jul 21, 2009 at 12:14 PM, vivek agrawal
wrote:
> hi sandeep...
> pls check the files
Hey Ruchi i have attached soluction, see this one u requrired or something
eals .
Regards: ╚►♥ѕαη∂єєρ♥◄╝
On Mon, Jul 20, 2009 at 11:44 PM, Ruchi Saxena wrote:
> Hi friends,
>
> i m new to this group...
>
> Can somebody help me with the attached sheet
>
> Regards,
>
> Ruchi
>
> >
>
--
--~--
Hi Dev,
Your macro is more complex than necessary.
You don't have to unhide sheets, or select ranges to work on them.
The following 2 lines of code should do what you need.
Sub DoWhatDevNeeds()
Sheets("Dump").Cells.ClearContents
Sheets("Formula").Columns("A:B").ClearContents
End Sub
Hope thi
Hi
One solution is to control the axis on the graph.
This can be done a simple Macro.
ActiveSheet.ChartObjects("Chart 1").Activate
ActiveChart.Axes(xlValue).Select
With ActiveChart.Axes(xlValue)
.MinimumScale = Range("AA75").Value
.MaximumScale = Range("AA76").Value
Dear Shafiq:
I can give you my own built billing softwre (free) in MS Access. If you
require that then you have to send the data (i.e.Fields of your billing).
And accordingly I will build it for u.
Thanks
Daniel
On 7/6/09, shafiq online wrote:
>
>
> Hi,
>
> Can anyone has knowledge of Point of s
Hi Ruchi,
Attached is the solution.
I am presuming that the data in the yellow cell is extracted with the time
inputted in the adjacent cell.
Please let me know if you have any questions.
Thanks & Regards
Ankit Mehra
On 7/20/09, Ruchi Saxena wrote:
>
> Hi friends,
>
> i m new to this group..
Hi Friends,
A small query in pivot table i want convert vertical text of in horizontal.
in attached data sheet =main data
like this sheet=after pivot table (Result)
Please cheek the attached file.
Regards
Amresh
--~--~-~--~~~---~--~~
hi sandeep...
pls check the files of the group... there are many books and useful
material...
if still not satisfied... write back... will arrange for something else
all the best
Regards,
Vivek Agrawal
Skype ID - vivek.agrawal83
GoogleMoonlight.com - Saving energy-Save Earth
2009/7/15 ╚►♥ѕ
Hello,
Plse tell how to work
Pls tell me step
Thanks in advance
On Tue, Jul 21, 2009 at 10:55 AM, Pranaya Pradhan wrote:
> TRY THIS ONE
>
>
> Function SpellNumber(ByVal MyNumber, Optional incRupees As Boolean = True)
> Dim Crores, Lakhs, Rupees, Paise, Temp
> Dim DecimalPlace As Long, Count As
Hi All,
I have a user form wherein I set the variable of a global variable
based on the selection of certain radio buttons. Based on the value
chosen I have command buttons selected and deselected in the
worksheet.
But after I hide the form and activate the sheet, the control is not
transferred
You can use text to colum option to convert to date formate
select colum
data->text to column
select fixed width
select "Date" from column data format
Finish
Now your data will be converted to date format
Thanks
Udhay
On Mon, Jul 20, 2009 at 9:44 PM, Manoj Kukrej wrote:
> Hi
> I have dat
67 matches
Mail list logo
