> Since you have experience with C, let's transpose your VBA question
> into a C question:
i'm sorry but I have not experience in c
regards
r
--
--
Some important links for excel users:
1. Follow us on TWITTER for t
Hi Group,
Pls help me on this, it will make my life easy...
- Original Message -
From: Dave Bonallack
To: excel-macros@googlegroups.com
Sent: Monday, September 20, 2010 4:15 PM
Subject: RE: $$Excel-Macros$$ Column Data in Rows Table
Hi,
Sorry, but someone else will have
Dear Group,
Please let me know, if any of you are interested in training a group of
folks on Microsoft Excel in Bangalore. They are looking for 30 hours of
training..
Thank You,
Shreedar
--
--
Some important links f
How do I copy some cells(including formatting) and save as image file
using VBA?
Ultimately, I want to do that via COM or ActiveX server. Yet I think
VBA is the starting point.
So lets start from VBA.
How to do that in VBA?
I know how to open and close the Excel sheet.
But what's the command i
Excel chart plotting, depending on weightage
Hi experts,
Need help in ideas and plotting a graph to show a weightage of
temperatures hit in 4 zones. I cannot relate this to x axis, i want to
represent all in one chart so that i present a viewer, the number of
times a particular temperatures are hi
On 23 Sep., cyber 1000s wrote:
> Hi cyberspace,
>
> I have some c programming background...
> Is it possible to increment a worksheet object (worksheets collection)
> in a loop such as below ?
>
> Public Sub CopyShNamesFromWkbToWkb2()
>
> Dim i As Integer
> Dim wkb As Object
> Set wkb = Wor
Dear members,
You have been doing excellent job in keeping this group alive and my
sincere thanks for same.I am glad to share that our page
"discussexcel.com" is launched on facebook.
You may follow the below link to like this page.
http://www.facebook.com/pages/discussexcelcom/160307843985936
T
Hi There,
I receive a report via email every morning and would like to have an
excel macro that can open the email, extract the report data and use
it in the spreadsheet i want to update.
Is this possible? I've searched and search and can't find anything
about how this might work.
Any thoughts w
try:
Sub Test()
Dim oVBP As VBProject
Dim oVBP2 As VBProject
Dim oComp As VBComponent
Dim oComp2 As VBComponent
Dim s As String
Set oVBP = ThisWorkbook.VBProject
Set oVBP2 = Workbooks("Cartel3").VBProject
Set oComp = oVBP.VBComponents.Item("Thisworkbook")
Set oComp2 = oVBP2.VBComponents.Item("Th
Dear Siti,
Thanks a lot
Best Regards,
Venkat
On Fri, Sep 24, 2010 at 3:47 PM, siti Vi wrote:
> Sub splittabel()
> ' siti Vi / jakarta, 24 sept 2010
> Dim RefTbl As Range
> Dim DesTbl As Range
> Dim sNames As String, ArrNames
> Dim r As Long, n As Long, i As Long, c As Integer
>
> Set RefTbl
try this code
Sub dosomething()
'* siti Vi / jakarta, sept 24, 2010*
Dim refTbl As Range
Dim DesTbl As Range
Dim r As Long, i As Long, c As Long
Set refTbl = Cells(1, 1).CurrentRegion
Set DesTbl = refTbl(1, 1).Offset(0, refTbl.Columns.Count + 3)
For r = 2 To refTbl.Rows.Count
Alternatively you can also use a Collection with the advantage of
using also the key in item, more to index:
Sub test2()
Dim wb As Workbook
Dim ws As Worksheet
Dim colWs As New Collection
Set wb = ThisWorkbook
For Each ws In wb.Worksheets
colWs.Add ws, ws.Name
Next
Set ws = colWs.Item(wb.W
is not possible.
Worksheets is a set of dependent objects of workbook.
use the Properity WorkShets is the only way to return this set.
viceversa you could use a array of worksheet
Sub test()
Dim wb As Workbook
Dim ws As Worksheet
Dim wss() As Worksheet
Dim l As Long
Set wb = ThisWorkbook
For Eac
Dear Kalyan,
Please see attachment...
Thanks,
Noorain Ansari
On Thu, Sep 23, 2010 at 3:08 PM, Kal xcel wrote:
> Dear expert,
>
> I am facing a problem to create dependent dropdown list.
>
> Please check the attached file & help.
>
> Thanks in advance
>
> Kalyan
>
> --
>
> -
Hi All,
I have 3+ defined names in workbook and want to delete it.
I have written code below,
Dim nm as name
For each nm in activeworkbook.names
Nm.delete
Next
But it takes too much time to delete.
Is there any other way to faster delete the all defined names from
workboo
Hi,
I think the easiest way to loop though worksheets is:
Ex.
Dim ws as worksheet
...
i = i+1
For Each ws In wbk2.Worksheets
wbk.Sheets(3).Cells(i, 4) = ws.name
i = i+1
Next ws
But in your example you need to use the item property of the
worksheets collection to access the sheet via an
HI,
The easiest way to loop worksheets would be:
Dim ws as worksheet
Dim wbk as workbook
Dim wbk as workbook
'assign your workbooks to files
for each ws in wbk.worksheets
next ws
On 24 Sep, 00:55, cyber 1000s wrote:
> Hi,
>
> I'm looking for a more general answer about objects in vba like :
>
>
Hi,
I do that, but not using a msdos command. I have an excel workbook,
containg the password (encrypted) that will call the workbook/
workbooks that I want to run through the windows schdule event.Ex.
Th workbook has one or more updates of other excel workbooks to run -
an update function is call
Hi!
FIND OUT DRPODOWN LINS
AFTAB
On Thu, Sep 23, 2010 at 3:08 PM, Kal xcel wrote:
> Dear expert,
>
> I am facing a problem to create dependent dropdown list.
>
> Please check the attached file & help.
>
> Thanks in advance
>
> Kalyan
>
> --
>
> --
please find the excel with result of 3 column comparision:
i have checked for isblank formula & assigned with weightage as 1,2,4 for
col a,b,c
On Fri, Sep 24, 2010 at 10:40 AM, Srinivasan Ethirajalu <
srinivasan.ethiraj...@gmail.com> wrote:
> Please clarify:
> Below are all possibilities:
>
> *
20 matches
Mail list logo
