See if it Helps
Sub CopyTextFromWord()
Dim wApp As Word.Application
Set wApp = New Word.Application
wApp.Visible = True
wApp.Activate
wApp.Documents.Open YourFilePath\SampleWord.docx
wApp.Selection.WholeStory
wApp.Selection.Copy
Range(A1).Activate
See if it Helps
Sub UpdateAll()
Dim sh As Worksheet
Dim pt As PivotTable
For each sh in ActiveWorkbook.sheets
For Each pt In sh.PivotTables
pt.PivotCache.Refresh
Next
next
End Sub
-Original Message-
From: excel-macros@googlegroups.com
See if it Helps
Option Base 1
Sub StoreInArrya()
Dim Arr() As Variant
Dim rng As Range
Dim Rw As Integer
Dim Cl As Integer
Set rng = Range(A1:C5)
ReDim Arr(rng.Cells.Rows.Count, rng.Cells.Columns.Count)
For Rw = 1 To rng.Rows.Count
Dear All,
I have attached sheet contains my query on Data Validation - Create a drop
down list containing only unique
--
*Best Regards,*
*Venkat*
*
*
*
*
--
--
Some important links for excel users:
1. Follow us
I want to keep record of accounting transaction in double entry book
keeping system. But how ? I have not advanced skill of vba macro.
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips
Attached Some data with more Clearification
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of jurich
Sent: Sunday, July 24, 2011 3:40 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ How to enter journal entry using VBA in
Hi,
I have one questions.Usually while doing reports what are errors you will
get ?
Thanks
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
Hi Rajan,
It's Working Thanks...
*Best Regards,*
*Venkat*
*
*
*
*
On Sun, Jul 24, 2011 at 4:19 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
*Hi Venkat*
*See the attached Sheet*
* *
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of
Hi Daniel,
Thanks..it's Working
*Best Regards,*
*Venkat*
*
*
*
*
On Sun, Jul 24, 2011 at 6:01 PM, Daniel dcolarde...@free.fr wrote:
Another way to do it (see attached workbook).
** **
Regards.
** **
Daniel
** **
*De :* excel-macros@googlegroups.com
Hi Vijay,
In Excel You May get errors are
#NULL!, #DIV/0!, #VALUE!,#REF!,#NAME?, #NUM! and #N/A
if u want avoid this Tou may us IFERROR or IFERROR ISERROR Function
*Best Regards,*
*Venkat*
On Sun, Jul 24, 2011 at 5:50 PM, vijayajith VA vijayajith...@gmail.comwrote:
Hi,
I have one
http://www.ozgrid.com/Excel/formula-errors.htm
http://chandoo.org/wp/2009/04/20/excel-formula-errors/
On Sun, Jul 24, 2011 at 6:12 PM, Venkat CV venkat1@gmail.com wrote:
Hi Vijay,
In Excel You May get errors are
#NULL!, #DIV/0!, #VALUE!,#REF!,#NAME?, #NUM! and #N/A
if u want avoid
Rajan,
A most excel-ant game, thank you for sharing.
Kind Regards.
Michael Brumby
Diese Email und samtliche beigefugten Anhange sind vertraulich zu behandeln und
sind vor Veroffentlichung geschutzt. Informieren Sie den Absender bitte
umgehend
und loschen Sie diese Nachricht mit allen
How can I get maximum value from a set of goup i.e there are two to three
families out of this from each family maximum age of family member is
require in next colum corresponding to maximum age member.
for example
A xyz 45
A uyy 33
A yss 65
B sas 34
B ree 45
B ww 55
taking to abobe
I'm looking more for an explanation, why cells.(r+1,1) = is not
working?
I have to use rng.Rows.Count always to do the equivalent?
Thanks
On Jul 24, 7:38 am, Rajan_Verma rajanverma1...@gmail.com wrote:
See if it Helps
Option Base 1
Sub StoreInArrya()
Dim Arr() As Variant
Dim rng
Use Date and Time Picker Control 6.0 (SP6) from the tool box. That
would list the control in the toolbox window. Click on it, and use it
on your userform.
On Jul 24, 6:13 pm, alisha malhotra alisha.malhotr...@gmail.com
wrote:
Hi,
I am using one userform, In that I need Date time Picker in
Vikas, if your data start from A2 (excluding the heading, use the
large function in an array formula
=IF(COUNTIF($A$2:A2,A2)=1,LARGE(($A$2:$A$15=A2)*($C$2:$C$15),1),)
Use CTRL+SHIFT+ENTER to confirm an array formula
On Jul 24, 4:55 pm, vickey vikasda...@gmail.com wrote:
How can I get maximum
check the attachment
On Sun, Jul 24, 2011 at 5:25 PM, vickey vikasda...@gmail.com wrote:
How can I get maximum value from a set of goup i.e there are two to three
families out of this from each family maximum age of family member is
require in next colum corresponding to maximum age member.
In case you need a sample workbook
On Sun, Jul 24, 2011 at 5:25 PM, vickey vikasda...@gmail.com wrote:
How can I get maximum value from a set of goup i.e there are two to three
families out of this from each family maximum age of family member is
require in next colum corresponding to maximum
Taking Ashish's example which showcases the more versatile sumproduct
function,
Use =IF(COUNTIF($A$2:A2,A2)=1,SUMPRODUCT(MAX(($A$2:$A$15=A2)*($C$2:$C
$15))),) to display the maximum salary only once against each family
Sam Mathai Chacko
On Jul 24, 4:55 pm, vickey vikasda...@gmail.com wrote:
Thank you so much sir, but I have one query, the maximum salary must reflect
against relative salary, becuase there is further formula for other members
to increase rest of the members their salary by 20% of maximum.
could you please help me out further please find attched sample excel.
Thanks for adding the date picker.
But I need the time picker also if you can add. In my PC, Additional
controls are not appearing. I think some reference has not been added.
I don't know which reference should I add to get the additional controls?
Regards,
Alisha
On Sun, Jul 24, 2011 at 7:51
=IF(B1SUMPRODUCT(MAX(($A$1:$A$13=A1)*($B$1:$B
$13))),B1+(0.08*SUMPRODUCT(MAX(($A$1:$A$13=A1)*($B$1:$B$13,B1)
On Jul 24, 8:46 pm, vickey vikasda...@gmail.com wrote:
Thank you so much sir, but I have one query, the maximum salary must reflect
against relative salary, becuase there is further
Generally it comes in toolbox after right click selecting additional
controls or From tool menu. But it is not appearing in my PC. I think some
of the reference has not been added.
So which reference should I add to get the additional controls?
Regards,
Alisha
On Sun, Jul 24, 2011 at 7:52 PM,
It is the same control, just need to change the format. I have sent an
attachment, with a new control, and changed the format.
Sam Mathai Chacko
On Jul 24, 9:11 pm, alisha malhotra alisha.malhotr...@gmail.com
wrote:
Generally it comes in toolbox after right click selecting additional
controls
Thanks a lot for ur help.
Regards,
Alisha
On Sun, Jul 24, 2011 at 9:54 PM, Sam Mathai Chacko samde...@gmail.comwrote:
Here
On Sun, Jul 24, 2011 at 9:36 PM, alisha malhotra
alisha.malhotr...@gmail.com wrote:
Thanks for adding the date picker.
But I need the time picker also if you can
Hi Vijayajith,
It depends which report having what kind of formula / function /
macros you are working on.
I have came across following errors so far:-
1) Excel Function errors - Can be corrected using ISError function(s)
2) VBA Macros - Can be prevented using Error handlers
3) Linking errors -
Hi Venkat,
I have managed to solve your query using defined Names in Excel.
Let me know if this works.
Regards,
DILIPandey
On 7/24/11, Venkatesan c venkat1@gmail.com wrote:
Dear All,
I have attached sheet contains my query on Data Validation - Create a drop
down list containing only
Hello, I need to take employee data, and run a macro that will allow
me to populate many different types of conclusions from this data.
For example,
If I have the resource, project, hours, description, spend, etc, I
would like to be able to quickly see the conclusions of resources
spend by
Try using a Pivot Table. one of the quickest and easiest ways for
data consolidation and view in Excel
Sam Mathai Chacko
On Jul 25, 1:43 am, Adam Hamilton adamchamil...@gmail.com wrote:
Hello, I need to take employee data, and run a macro that will allow
me to populate many different
That's what I'm currently doing, but want something more efficient.
On Sun, Jul 24, 2011 at 1:45 PM, GoldenLance samde...@gmail.com wrote:
Try using a Pivot Table. one of the quickest and easiest ways for
data consolidation and view in Excel
Sam Mathai Chacko
On Jul 25, 1:43 am, Adam
You might be looking for Excel dashboards then. Try chandoo.org, they
have some nice dashboards..
On Jul 25, 1:43 am, Adam Hamilton adamchamil...@gmail.com wrote:
Hello, I need to take employee data, and run a macro that will allow
me to populate many different types of conclusions from this
Hi Dilip,
ThanksWorking...
*Best Regards,*
*Venkat*
*
*
*
*
On Sun, Jul 24, 2011 at 11:47 PM, Dilip Pandey dilipan...@gmail.com wrote:
Hi Venkat,
I have managed to solve your query using defined Names in Excel.
Let me know if this works.
Regards,
DILIPandey
On 7/24/11, Venkatesan
Pivot will be useful rather than using macros.
Use macros only if excel functions are not there.
On 7/25/11, Adam Hamilton adamchamil...@gmail.com wrote:
Hello, I need to take employee data, and run a macro that will allow
me to populate many different types of conclusions from this data.
For
u can use removw duplicate option in excel. Data then available can bw
used as data validation range.
On 7/24/11, Venkatesan c venkat1@gmail.com wrote:
Dear All,
I have attached sheet contains my query on Data Validation - Create a drop
down list containing only unique
--
*Best
It depends upon the mistakes u do.
On 7/24/11, vijayajith VA vijayajith...@gmail.com wrote:
Hi,
I have one questions.Usually while doing reports what are errors you will
get ?
Thanks
--
--
Some important
U can use date function or today function of excel.
On 7/24/11, alisha malhotra alisha.malhotr...@gmail.com wrote:
Hi,
I am using one userform, In that I need Date time Picker in excel 2003.
But when I click on Additional controls Nothing Happens.
I need to add some reference for this? How
*Experience required for the Job:* 2 - 6 years
*Job Location:* Bengaluru/Bangalore
*Dear Candidate,*
Warm Greetings!!
We are Teamware Solutions, a professional IT services company head
quartered in Bangalore. Teamware is a division of Quantum Leap Consulting
Pvt. Ltd. and we specialize
Hi
First of all I have to thank you. Unfortunately you did something for excel.
But my query is about ms access. Please find the OP. Your help will be
appreciated.
--
*Great day,*
*viper*
On Fri, Jul 22, 2011 at 7:49 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
*Try the Attached
Hi Kaushik,
Yes We can remove duplicates I want in Formula that's the
reason... already got it..
Thanks for your suggestion
*
*
*Best Regards,*
*Venkat*
*
*
On Mon, Jul 25, 2011 at 6:09 AM, KAUSHIK SAVLA savla.kaus...@gmail.comwrote:
u can use removw duplicate option in excel. Data then
39 matches
Mail list logo