Hi Paul
You are probably well past this by now but I only just got your reply.
I have never worked with Oracle so I don't have the specific knowledge.
However:
My logic was that the dynaset is a collection of collections. It is a
collection of records and the records are a collection of fields
Dear Excel Masters,
I have raw data that is in the following form:
1 name abc
2 address 234 john lane
3 company inc, co
4 website http://website.com
5 description company abc is abc
What I would like to do is have this information look like this, where the
data is taken from rows and transpos
Thanks Price,
but you have any idea of the best forum like we have this for VBA?
there are any forums but we wont know unless we join it so can you recommend
any like this one?
>
> From: Prince
>To: excel-macros@googlegroups.com
>Cc: hanumant shinde
>Sent
thanks David i can do that but i would like to know if there are any trial and
tested websites.
>
> From: David Grugeon
>To: "excel-macros@googlegroups.com"
>Sent: Wednesday, 30 January 2013 1:30 PM
>Subject: Re: $$Excel-Macros$$ .Net - Dot Net
>
>
>Put
>
Another way that can help you
Sub Statistics_sheetname()
Dim i As Integer
For i = 1 To ActiveWorkbook.Sheets.Count
ActiveSheet.Range("a" & i).Value = Sheets(i).Name
Range("a" & i).Select
Next i
End Sub
2013/1/30, Prince :
> Hi Amir,
> hope this can be help full for you.
>
> Sub test()
> Dim
Hi Yogananda,
I had given the solution to your query, please find the
attachment.
--
*Regards,*
*
*
*Excel Beginner*
On Wed, Jan 30, 2013 at 10:37 PM, yogananda muthaiah <
yogananda.mutha...@gmail.com> wrote:
>
> Dear All,
>
> I would a search engine within the excel sheets
Dear All,
I would a search engine within the excel sheets and to find the particular
finds... Attached excel contains the example shown for 1 code.
Request you to kindly help me out.
--
Regards
Yogananda Muthaiah
Ph : 973 123 7267
--
Join official Facebook page of this forum @
https://ww
Dear Paul,
Sorry, I didn't approach in right way.
Anil, Noorain & Ashish have given various solutions which really help me to
learn new things
I'm happy to be part of this group too.
Now I have attached new attachment where there are ref H5016306 , A506599 &
R5018636
In this case can we give
David,
thanks!
literally 5 minutes ago, I came across a posting on Oracle's forum
where a user recommended using:
TDate = Dynaset("filedate").Value.ToDate
which worked.
It's odd that the timestamp field type came out in v9.2 (I think)
and "= Dynaset("filedate").Value" worked in v10i, but now doe
This does not provide NEARLY enough information!
What do you mean by "extract"?
Are you wanting to "find" the string of characters?
what are you going to do with them?
where do you want them to be put?
are you trying to determine if the strings exist in the list?
are you trying to determine if wha
Hi Amir,
hope this can be help full for you.
Sub test()
Dim wks As Worksheet
Dim introw As Integer
introw = 1
For Each wks In ThisWorkbook.Worksheets
Sheet1.Cells(introw, 1).Value = wks.Name
introw = introw + 1
Next
End Sub
regards
Prince
On Wednesday,
Dear Aamir,
Pls try
*Sub Extract_SheetName()
Dim sh As Worksheet
Dim i As Integer
i = 1
For Each sh In ThisWorkbook.Sheets
If sh.Index <> 1 Then
Sheet1.Cells(i, 1).Value = sh.Name
i = i + 1
End If
Next sh
End Sub
*
On Wed, Jan 30, 2013 at 8:20 PM, Aamir Shahzad wrote:
> Dear Group,
>
> How to
Sub tes()
Dim i As Long
For i = 2 To Sheets.Count
Sheets(1).Cells(i - 1, 1) = Sheets(i).Name
Next
End Sub
On Wed, Jan 30, 2013 at 8:20 PM, Aamir Shahzad wrote:
> Dear Group,
>
> How to get the sheet names in one sheet? sample file is attached.
> Regards,
> Aamir Shahzad
>
> --
> Join offici
Dear Group,
How to get the sheet names in one sheet? sample file is attached.
Regards,
Aamir Shahzad
--
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,
Urgent, Need Hel
Join some best forums for this
On Wednesday, January 30, 2013 1:22:47 PM UTC+5:30, prashant shinde wrote:
>
> Hi friends,
>
> i dont know ANYTHING about .net. and now want to learn it does anybody
> know how shud i start with it.
> Any site or ebook for beginners.
>
> i am sorry this is off the
Dear Manjunath,
see the attached sheet.
Warm Regards,
Gawli Anil
On Wed, Jan 30, 2013 at 4:21 PM, Manjunath Narayanappa <
manjunath.narayana...@aon.co.uk> wrote:
> Dear Experts
>
>
>
> Thanks to all,
>
>
>
> Please find the attachment, please advise in case if we have K508 ,F508,
> E508, A50
Dear Experts
Thanks to all,
Please find the attachment, please advise in case if we have K508 ,F508, E508,
A508 in rows but in same column B
I have highlighted in red.
Regards
Manjunath
PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL
For Aon's
Put
Learn . net
into Google and you will get about 74 million possibles
Regards
David Grugeon
On 30 January 2013 17:52, hanumant shinde wrote:
> Hi friends,
>
> i dont know ANYTHING about .net. and now want to learn it does anybody
> know how shud i start with it.
> Any site or ebook for be
18 matches
Mail list logo
