Hi
Check reference is given to Microsoft Visual Basic for Applications
Extensibility 5.x
Thanks
On Mon, Apr 28, 2014 at 5:50 AM, Sam Mathai Chacko samde...@gmail.comwrote:
Ondrej, for that you'll have to enable programmatic access to VBA. Just
search the internet how to do that, or post
Dear all excel champs friends
Can any one proper guide on this topic means it uis possible or not?
Regards
Amar
On Fri, Apr 11, 2014 at 12:21 PM, amar takale amartak...@gmail.com wrote:
Dear Ashish sir
Pls help me on this solution.
I would appreciate very much Sir
Regards
Amar Takale
On
Check the same link now…
http://excelvbasupport.com/forum/showthread.php?tid=8
Warm Regards,
Ravi Kumar.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Suyog Kulkarni
Sent: Monday, April 28, 2014 2:35 PM
To: excel-macros@googlegroups.com
Visit on the below link and check if you are asking for the same
http://excelvbasupport.com/forum/showthread.php?tid=22
Warm Regards,
Ravi Kumar.
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of amar takale
Sent: Monday, April
Hi Amar, PFB link for your solution, now you can add whatever the table in
excel and copy paste in word one by one,, pls revert if you are looking
something else. On this...
http://excelvbasupport.com/forum/showthread.php?tid=23
-Original Message-
From: excel-macros@googlegroups.com
No need to do anything just comment the two lines
'Dim wrdapps As Word.Application
'Dim wrddoc As Word.Document
It would work
Warm Regards,
Ravi Kumar.
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of amar takale
Sent: Monday,
Dear Ravi
Sheet not work with modified code Pls send me excel sheet with this
modified code. (In references show Missing: Microsoft Word 14.0
Object Library)
Regards
amar
On Mon, Apr 28, 2014 at 3:40 PM, Ravi Kumar excellearn2...@gmail.com wrote:
No need to do anything just comment the two
Ok check the below link
http://excelvbasupport.com/forum/showthread.php?tid=23
Warm Regards,
Ravi Kumar.
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of amar takale
Sent: Monday, April 28, 2014 4:02 PM
To:
Same error show cant find project or library
On Mon, Apr 28, 2014 at 4:10 PM, Ravi Kumar excellearn2...@gmail.com wrote:
Ok check the below link
http://excelvbasupport.com/forum/showthread.php?tid=23
Warm Regards,
Ravi Kumar.
-Original Message-
From:
Try this
Sub Button1_Click()
Dim wb As Workbook
Dim ws As Worksheet
Dim tbl As ListObject
Dim wrd As Object
Dim doc As Object
Dim sel As Object
Set wb = ThisWorkbook
Set ws = wb.Sheets(1)
Set wrd = CreateObject(word.application)
wrd.Visible = True
Set doc = wrd.Documents.Add
For Each tbl In
Dear ravi ,Can you Pls send me sample excel
On Mon, Apr 28, 2014 at 4:24 PM, Ravi Kumar excellearn2...@gmail.com wrote:
Try this
Sub Button1_Click()
Dim wb As Workbook
Dim ws As Worksheet
Dim tbl As ListObject
Dim wrd As Object
Dim doc As Object
Dim sel As Object
Set wb = ThisWorkbook
OK
On Mon, Apr 28, 2014 at 4:55 PM, Ravi Kumar excellearn2...@gmail.com wrote:
Ok PFA...
You can also post your queries in below link by click on New Thread
http://excelvbasupport.com/forum/forumdisplay.php?fid=6
Warm Regards,
Ravi Kumar.
-Original Message-
From:
Dear friends
can any one explain the use of getpivot data... i have excel 2010 and it
seems much advanced formulas and all so if any one have working with
examples of such new formula pls suggest me or guide me...
thanks to all
ashish
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do
dear experts
can u please explain the function of scenario manager and where can we use
this as some of my senior had told me that its very useful but i have not
much knowledge of this funtion.
ashish
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
Dear friends
can any one explain the use of getpivot data... i have excel 2010 and it
seems much advanced formulas and all so if any one have working with
examples of such new formula pls suggest me or guide me...
thanks to all
ashish
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do
Dear Sir
I have downloaded a file from the net but unable to understand the logic in
column Q AND R as the file is read only only so can anyone say me how that
delay had been calculated and interest is calculated...
thanks in advance
regards
LKM
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in
Vaibhav, before giving a solution, it is always a kind thing to do to
ensure you validate what you are saying. If the Applications Extensibility
library reference wasn't added, the sub-routine wouldn't have even execute
because the declaration in the following lines would have not compiled.
Dim
Hi Paul,
The code given above works well for the sheets in same workbook.
send me the code for data in two different work books.
Regards
Eugene
On Fri, Apr 25, 2014 at 9:15 PM, Paul Schreiner schreiner_p...@att.netwrote:
It works perfectly in my workbook.
Row 6 is unhighlighted in sheet1
Any place you have:
Sheets(
add the workbook name:
Workbooks(Firstfile).Sheets(
For the workbook that contains the code, you can use:
Thisworkbook.Sheets(
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the
Dear experts,
please help me
Thanks Regards´¨)
¸ •´ ¸.•*´¨) ¸.•*¨)
(¸.•´ (¸.•* ♥♥♥...♪♪♪RenukaChari. Kasee...♥♥♥...♪♪♪
P Let us do our best to save nature, save water, plant trees, protect
greenery, keep our surroundings clean, reduce usage of plastics, and
use renewable
Hi Modi,
Im not clear with Defaults month (column Q) because it does not match with
due date and payment day.
But Defaults Interest (column R) is calculate by if *defaults
months*greater than 0 then *TDS
amount * 1.5% * defaults months* else the defaults interest will be *0*.
Hi
Attachment is missing..
Thx
On Mon, Apr 28, 2014 at 7:14 PM, L.K. Modi ca.mod...@gmail.com wrote:
Dear Sir
I have downloaded a file from the net but unable to understand the logic
in column Q AND R as the file is read only only so can anyone say me how
that delay had been calculated
Hi
You can do using Pivot Table, see attached file.
1. In the Pivot Table, click the drop down arrow in the RowLabels field
heading.
2. In the pop-up menu, click Value Filters, then click Top 10 change
it to 5.
You can sort on Descending on Output by going thru More Sort option
23 matches
Mail list logo