[belajar-excel] Digest Number 4757

Milis Belajar Microsoft Excel Group

5 Messages

Digest #4757

1a

Re: mencari start date & Finish by "Agus"

1b

Re: mencari start date & Finish by "Iman Darusman" idz.iman

2a

Re: Click Button di Internet Explorer dengan objectgetElementsByClas by "zainul ulum" zainul_ulum

2b

Re: Click Button di Internet Explorer dengan objectgetElementsByClas by "Mr. Kid" nmkid.family@ymail.com

2c

Re: Click Button di Internet Explorer dengan objectgetElementsByClas by "Agus"

Messages

1a

Re: mencari start date & Finish

Mon Apr 22, 2019 10:20 pm (PDT) . Posted by:

"Agus"

Dear Iman,
bukankah thread ini sudah dijawab oleh pak Ghozi?
apakah tidak bisa membaca jawabannya?
silahkan buka di nabble
<http://milis-belajar-excel.1048464.n5.nabble.com/belajar-excel-mencari-start-date-amp-Finish-1-Attachment-td5739499.html>
regard
NangAgus
On 4/23/2019 08:17, Iman Darusman idz.iman@yahoo.com [belajar-excel] wrote:
> Dear Master,
>
> mohon bantuannya (sundul)
>
> salam
> Iman
>
> Pada Selasa, 16 April 2019 17.33.52 WIB, idz.iman@yahoo.com
> [belajar-excel] <belajar-excel@yahoogroups.com> menulis:
>
>
> Dear Master.
>
>
> mohon bantuannya rumus untuk mengetahui start date & finish pada file
> terlampir.
>
>
> salam
>
> Iman
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (5) . Top ^

1b

Re: mencari start date & Finish

Mon Apr 22, 2019 10:49 pm (PDT) . Posted by:

"Iman Darusman" idz.iman

Pak Nan Agus,
Terima kasih pak. sudah bisa terbaca
salamIman
Pada Selasa, 23 April 2019 12.21.12 WIB, Agus nangagus@gmail.com [belajar-excel] <belajar-excel@yahoogroups.com> menulis:

 

Dear Iman, bukankah thread ini sudah dijawab oleh pak Ghozi? apakah tidak bisa membaca jawabannya? silahkan buka di nabble regard NangAgus
On 4/23/2019 08:17, Iman Darusman idz.iman@yahoo.com [belajar-excel] wrote:

  Dear Master,
mohon bantuannya (sundul)
salam Iman
Pada Selasa, 16 April 2019 17.33.52 WIB, idz.iman@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com> menulis:

 
Dear Master.


mohon bantuannya rumus untuk mengetahui start date & finish pada file terlampir.


salam

Iman



#yiv6273931895 #yiv6273931895 -- #yiv6273931895ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6273931895 #yiv6273931895ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6273931895 #yiv6273931895ygrp-mkp #yiv6273931895hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv6273931895 #yiv6273931895ygrp-mkp #yiv6273931895ads {margin-bottom:10px;}#yiv6273931895 #yiv6273931895ygrp-mkp .yiv6273931895ad {padding:0 0;}#yiv6273931895 #yiv6273931895ygrp-mkp .yiv6273931895ad p {margin:0;}#yiv6273931895 #yiv6273931895ygrp-mkp .yiv6273931895ad a {color:#0000ff;text-decoration:none;}#yiv6273931895 #yiv6273931895ygrp-sponsor #yiv6273931895ygrp-lc {font-family:Arial;}#yiv6273931895 #yiv6273931895ygrp-sponsor #yiv6273931895ygrp-lc #yiv6273931895hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6273931895 #yiv6273931895ygrp-sponsor #yiv6273931895ygrp-lc .yiv6273931895ad {margin-bottom:10px;padding:0 0;}#yiv6273931895 #yiv6273931895actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6273931895 #yiv6273931895activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6273931895 #yiv6273931895activity span {font-weight:700;}#yiv6273931895 #yiv6273931895activity span:first-child {text-transform:uppercase;}#yiv6273931895 #yiv6273931895activity span a {color:#5085b6;text-decoration:none;}#yiv6273931895 #yiv6273931895activity span span {color:#ff7900;}#yiv6273931895 #yiv6273931895activity span .yiv6273931895underline {text-decoration:underline;}#yiv6273931895 .yiv6273931895attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv6273931895 .yiv6273931895attach div a {text-decoration:none;}#yiv6273931895 .yiv6273931895attach img {border:none;padding-right:5px;}#yiv6273931895 .yiv6273931895attach label {display:block;margin-bottom:5px;}#yiv6273931895 .yiv6273931895attach label a {text-decoration:none;}#yiv6273931895 blockquote {margin:0 0 0 4px;}#yiv6273931895 .yiv6273931895bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv6273931895 .yiv6273931895bold a {text-decoration:none;}#yiv6273931895 dd.yiv6273931895last p a {font-family:Verdana;font-weight:700;}#yiv6273931895 dd.yiv6273931895last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6273931895 dd.yiv6273931895last p span.yiv6273931895yshortcuts {margin-right:0;}#yiv6273931895 div.yiv6273931895attach-table div div a {text-decoration:none;}#yiv6273931895 div.yiv6273931895attach-table {width:400px;}#yiv6273931895 div.yiv6273931895file-title a, #yiv6273931895 div.yiv6273931895file-title a:active, #yiv6273931895 div.yiv6273931895file-title a:hover, #yiv6273931895 div.yiv6273931895file-title a:visited {text-decoration:none;}#yiv6273931895 div.yiv6273931895photo-title a, #yiv6273931895 div.yiv6273931895photo-title a:active, #yiv6273931895 div.yiv6273931895photo-title a:hover, #yiv6273931895 div.yiv6273931895photo-title a:visited {text-decoration:none;}#yiv6273931895 div#yiv6273931895ygrp-mlmsg #yiv6273931895ygrp-msg p a span.yiv6273931895yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6273931895 .yiv6273931895green {color:#628c2a;}#yiv6273931895 .yiv6273931895MsoNormal {margin:0 0 0 0;}#yiv6273931895 o {font-size:0;}#yiv6273931895 #yiv6273931895photos div {float:left;width:72px;}#yiv6273931895 #yiv6273931895photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv6273931895 #yiv6273931895photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6273931895 #yiv6273931895reco-category {font-size:77%;}#yiv6273931895 #yiv6273931895reco-desc {font-size:77%;}#yiv6273931895 .yiv6273931895replbq {margin:4px;}#yiv6273931895 #yiv6273931895ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv6273931895 #yiv6273931895ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6273931895 #yiv6273931895ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6273931895 #yiv6273931895ygrp-mlmsg select, #yiv6273931895 input, #yiv6273931895 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv6273931895 #yiv6273931895ygrp-mlmsg pre, #yiv6273931895 code {font:115% monospace;}#yiv6273931895 #yiv6273931895ygrp-mlmsg * {line-height:1.22em;}#yiv6273931895 #yiv6273931895ygrp-mlmsg #yiv6273931895logo {padding-bottom:10px;}#yiv6273931895 #yiv6273931895ygrp-msg p a {font-family:Verdana;}#yiv6273931895 #yiv6273931895ygrp-msg p#yiv6273931895attach-count span {color:#1E66AE;font-weight:700;}#yiv6273931895 #yiv6273931895ygrp-reco #yiv6273931895reco-head {color:#ff7900;font-weight:700;}#yiv6273931895 #yiv6273931895ygrp-reco {margin-bottom:20px;padding:0px;}#yiv6273931895 #yiv6273931895ygrp-sponsor #yiv6273931895ov li a {font-size:130%;text-decoration:none;}#yiv6273931895 #yiv6273931895ygrp-sponsor #yiv6273931895ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv6273931895 #yiv6273931895ygrp-sponsor #yiv6273931895ov ul {margin:0;padding:0 0 0 8px;}#yiv6273931895 #yiv6273931895ygrp-text {font-family:Georgia;}#yiv6273931895 #yiv6273931895ygrp-text p {margin:0 0 1em 0;}#yiv6273931895 #yiv6273931895ygrp-text tt {font-size:120%;}#yiv6273931895 #yiv6273931895ygrp-vital ul li:last-child {border-right:none !important;}#yiv6273931895

Reply to sender . Reply to group . Reply via Web Post . All Messages (5) . Top ^

2a

Re: Click Button di Internet Explorer dengan objectgetElementsByClas

Tue Apr 23, 2019 3:43 pm (PDT) . Posted by:

"zainul ulum" zainul_ulum

mas Kid,maaf baru bisa replay.masalahnya solved. Ternyata ada dua
buttons dengan classname yang nama dalam page tsb.
Kapan bisa ketemuan langsung? aku banyak kerjaan yang pakai web
scrapping...

maturnuwun_zainul.

On Apr 18, 2019 1:39 AM, "'Mr. Kid' mr.nmkid@gmail.com
[belajar-excel]" <belajar-excel@yahoogroups.com> wrote:


mas Zain,
Mungkin tipe datanya dijadikan object malah bisa bekerja...
(mungkin loh ya)Dim oHTML_Element As object



On Thu, Apr 11, 2019 at 12:34 PM Zainul Ulum
zainul_ulum@yahoo.com <mailto:zainul_ulum@yahoo.com>
[belajar-excel] <belajar-excel@yahoogroups.com
<mailto:belajar-excel@yahoogroups.com> > wrote:


Teman-teman be-exceler,Hasil inspect element tombol cari dari
sebuah webpage adalah:;;===============inspect webpage element
<span class="input-group-btn"> <button type="submit&quot;
class="btn btn-success">Cari</button>
</span>
;;==========================
Untuk melakukan click / eksekusi tombol tersebut dari vba- excel,
saya membuat code sebagai berikut:
;;============fungsi ambil submit button by clasname

Private Function ClickSubmitButtonWithClassID(objBrowser As
InternetExplorer, ByVal sDelay As String, _
ByVal sClassID As String) As Boolean

Dim oHTMLDoc As HTMLDocument
Dim oHTML_Element As IHTMLElement
Dim i As Integer
ClickSubmitButtonWithClassID = False

sDelay = Format(TimeValue(sDelay) + TimeValue("00:00:" &
Format(i, "00")), "hh:mm:ss")
Do ' Wait till the Browser is loaded
Application..Wait (Now + TimeValue(sDelay))
'--->NOTE: dicoba pakai ini berhasil tetapi proses lama
Loop Until objBrowser.readyState = 4 'READYSTATE_COMPLETE

Set oHTMLDoc = objBrowser.document
On Error Resume Next
For Each oHTML_Element In
oHTMLDoc.getElementsByClassName(sClassID)
If oHTML_Element.Type = "submit" Then
ClickSubmitButtonWithClassID = True
oHTML_Element.Click: Exit Function
End If
Next
If Err.Number Then
Err.Clear
End If
End Function
;;===========================

Mohon koreksinya, kenapa fungsi di atas tidak melakukan action
click tombol cari di webpage?
Terimakasih,-zainul

Reply to sender . Reply to group . Reply via Web Post . All Messages (5) . Top ^

2b

Re: Click Button di Internet Explorer dengan objectgetElementsByClas

Tue Apr 23, 2019 6:25 pm (PDT) . Posted by:

"Mr. Kid" nmkid.family@ymail.com

Ayo kita ngobrolin Excel dimana gitu...
Sabtu Minggu sampai sebelum ramadhan sih ok
Kalau nggak, mungkin mulai akhir juni sabtu minggu juga ok

On Wed, Apr 24, 2019 at 5:44 AM zainul ulum zainul_ulum@yahoo.com
[belajar-excel] <belajar-excel@yahoogroups.com> wrote:

>
>
> mas Kid,
> maaf baru bisa replay.
> masalahnya solved. Ternyata ada dua buttons dengan classname yang nama
> dalam page tsb.
>
> Kapan bisa ketemuan langsung? aku banyak kerjaan yang pakai web
> scrapping...
>
> maturnuwun
> _zainul.
>
> On Apr 18, 2019 1:39 AM, "'Mr. Kid' mr.nmkid@gmail.com [belajar-excel]" <
> belajar-excel@yahoogroups.com> wrote:
>
>
>
> mas Zain,
>
> Mungkin tipe datanya dijadikan object malah bisa bekerja... (mungkin loh
> ya)
> Dim oHTML_Element As object
>
>
>
>
> On Thu, Apr 11, 2019 at 12:34 PM Zainul Ulum zainul_ulum@yahoo.com
> [belajar-excel] <belajar-excel@yahoogroups.com> wrote:
>
>
>
> Teman-teman be-exceler,
> Hasil inspect element tombol cari dari sebuah webpage adalah:
> ;;===============inspect webpage element
> <span class="input-group-btn">
> <button type="submit&quot; class="btn btn-success">Cari</button>
> </span>
> ;;==========================
> Untuk melakukan click / eksekusi tombol tersebut dari vba- excel, saya
> membuat code sebagai berikut:
>
> ;;============fungsi ambil submit button by clasname
>
> Private Function ClickSubmitButtonWithClassID(objBrowser As
> InternetExplorer, ByVal sDelay As String, _
> ByVal sClassID As String) As Boolean
>
> Dim oHTMLDoc As HTMLDocument
> Dim oHTML_Element As IHTMLElement
> Dim i As Integer
> ClickSubmitButtonWithClassID = False
>
> sDelay = Format(TimeValue(sDelay) + TimeValue("00:00:" & Format(i,
> "00")), "hh:mm:ss")
> Do ' Wait till the Browser is loaded
> Application..Wait (Now + TimeValue(sDelay)) '--->NOTE: dicoba
> pakai ini berhasil tetapi proses lama
> Loop Until objBrowser.readyState = 4 'READYSTATE_COMPLETE
>
> Set oHTMLDoc = objBrowser.document
> On Error Resume Next
> For Each oHTML_Element In oHTMLDoc.getElementsByClassName(sClassID)
> If oHTML_Element.Type = "submit" Then
> ClickSubmitButtonWithClassID = True
> oHTML_Element.Click: Exit Function
> End If
> Next
> If Err.Number Then
> Err.Clear
> End If
> End Function
> ;;===========================
>
>
> Mohon koreksinya, kenapa fungsi di atas tidak melakukan action click
> tombol cari di webpage?
>
> Terimakasih,
> -zainul
>
>
>
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (5) . Top ^

2c

Re: Click Button di Internet Explorer dengan objectgetElementsByClas

Tue Apr 23, 2019 8:19 pm (PDT) . Posted by:

"Agus"

Saya orang udik boleh gak ikut gabung?

On 4/24/2019 08:25, 'Mr. Kid' mr.nmkid@gmail.com [belajar-excel] wrote:
> Ayo kita ngobrolin Excel dimana gitu...
> Sabtu Minggu sampai sebelum ramadhan sih ok
> Kalau nggak, mungkin mulai akhir juni sabtu minggu juga ok
>
>
>
>
> On Wed, Apr 24, 2019 at 5:44 AM zainul ulum zainul_ulum@yahoo.com
> <mailto:zainul_ulum@yahoo.com> [belajar-excel]
> <belajar-excel@yahoogroups.com <mailto:belajar-excel@yahoogroups..com>>
> wrote:
>
> mas Kid,
> maaf baru bisa replay.
> masalahnya solved. Ternyata ada dua buttons dengan classname yang
> nama dalam page tsb.
>
> Kapan bisa ketemuan langsung? aku banyak kerjaan yang pakai web
> scrapping...
>
> maturnuwun
> _zainul.
>
> On Apr 18, 2019 1:39 AM, "'Mr. Kid' mr.nmkid@gmail.com
> <mailto:mr.nmkid@gmail.com> [belajar-excel]"
> <belajar-excel@yahoogroups.com
> <mailto:belajar-excel@yahoogroups.com>> wrote:
>
> mas Zain,
>
> Mungkin tipe datanya dijadikan object malah bisa bekerja...
> (mungkin loh ya)
> Dim oHTML_Element As object
>
>
> ----------------------------------------------------------
>
> Reply via web post
> <https://groups.yahoo.com/neo/groups/belajar-excel/conversations/messages/45447;_ylc=X3oDMTJyMWZnbTd0BF9TAzk3MzU5NzE0BGdycElkAzIwNjI3Njc4BGdycHNwSWQDMTcwODI5ODgyMQRtc2dJZAM0NTQ0NwRzZWMDZnRyBHNsawNycGx5BHN0aW1lAzE1NTYwNjkxMzU-?act=reply&messageNum=45447>
> • Reply to sender
> <mailto:mr.nmkid@gmail.com?subject=Re%3A%20%5Bbelajar-excel%5D%20Click%20Button%20di%20Internet%20Explorer%20dengan%20objectgetElementsByClassName>
> • Reply to group
> <mailto:belajar-excel@yahoogroups.com?subject=Re%3A%20%5Bbelajar-excel%5D%20Click%20Button%20di%20Internet%20Explorer%20dengan%20objectgetElementsByClassName>
> • Start a New Topic
> <https://groups.yahoo.com/neo/groups/belajar-excel/conversations/newtopic;_ylc=X3oDMTJmcXRtZGhuBF9TAzk3MzU5NzE0BGdycElkAzIwNjI3Njc4BGdycHNwSWQDMTcwODI5ODgyMQRzZWMDZnRyBHNsawNudHBjBHN0aW1lAzE1NTYwNjkxMzU->
> • Messages in this topic
> <https://groups.yahoo.com/neo/groups/belajar-excel/conversations/topics/45428;_ylc=X3oDMTM3OGEwamJvBF9TAzk3MzU5NzE0BGdycElkAzIwNjI3Njc4BGdycHNwSWQDMTcwODI5ODgyMQRtc2dJZAM0NTQ0NwRzZWMDZnRyBHNsawN2dHBjBHN0aW1lAzE1NTYwNjkxMzUEdHBjSWQDNDU0Mjg->
> (4)
>
> ----------------------------------------------------------
> Have you tried the highest rated email app? <https://yho.com/1wwmgg>
> With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated
> email app on the market. What are you waiting for? Now you can access
> all your inboxes (Gmail, Outlook, AOL and more) in one place. Never
> delete an email again with 1000GB of free cloud storage.
> ----------------------------------------------------------
> ============================================================
> Pojok Lowongan Kerja yang disediakan milis :
> http://milis-belajar-excel.1048464.n5.nabble.com/Pojok-Lowongan-Kerja-f5725753.html
> *** Posting lowongan kerja : ke link tersebut dan klik New Topic
> ============================================================
> bergabung ke milis (subscribe), kirim mail kosong ke:
> belajar-excel-subscribe@yahoogroups.com
> posting ke milis, kirimkan ke: belajar-excel@yahoogroups.com
> berkunjung ke web milis :
> http://tech.groups.yahoo.com/group/belajar-excel/messages
> melihat file archive / mendownload lampiran :
> http://www.mail-archive.com/belajar-excel@yahoogroups.com/
> atau (sejak 25-Apr-2011) bisa juga di :
> http://milis-belajar-excel.1048464.n5.nabble.com/
> menghubungi moderators & owners: belajar-excel-owner@yahoogroups.com
> keluar dari membership milis (UnSubscribe), kirim mail kosong ke :
> belajar-excel-unsubscribe@yahoogroups.com
> ----------------------------------------------------------
> Visit Your Group
> <https://groups.yahoo.com/neo/groups/belajar-excel/info;_ylc=X3oDMTJmbzM3dTRtBF9TAzk3MzU5NzE0BGdycElkAzIwNjI3Njc4BGdycHNwSWQDMTcwODI5ODgyMQRzZWMDdnRsBHNsawN2Z2hwBHN0aW1lAzE1NTYwNjkxMzU->
>
>
> Yahoo! Groups
> <https://groups.yahoo.com/neo;_ylc=X3oDMTJlNG0xZmN0BF9TAzk3NDc2NTkwBGdycElkAzIwNjI3Njc4BGdycHNwSWQDMTcwODI5ODgyMQRzZWMDZnRyBHNsawNnZnAEc3RpbWUDMTU1NjA2OTEzNQ-->
>
> • Privacy
> <https://info.yahoo.com/privacy/us/yahoo/groups/details.html> •
> Unsubscribe
> <mailto:belajar-excel-unsubscribe@yahoogroups.com?subject=Unsubscribe>
> • Terms of Use <https://info.yahoo.com/legal/us/yahoo/utos/terms/>
>
> SPONSORED LINKS
> .
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (5) . Top ^

============================================================
Pojok Lowongan Kerja yang disediakan milis :
http://milis-belajar-excel.1048464.n5.nabble.com/Pojok-Lowongan-Kerja-f5725753.html
*** Posting lowongan kerja : ke link tersebut dan klik New Topic
============================================================
bergabung ke milis (subscribe), kirim mail kosong ke: belajar-excel-subscribe@yahoogroups.com
posting ke milis, kirimkan ke: belajar-excel@yahoogroups.com
berkunjung ke web milis : http://tech.groups.yahoo.com/group/belajar-excel/messages
melihat file archive / mendownload lampiran : http://www.mail-archive.com/belajar-excel@yahoogroups.com/
atau (sejak 25-Apr-2011) bisa juga di : http://milis-belajar-excel.1048464.n5.nabble.com/
menghubungi moderators & owners: belajar-excel-owner@yahoogroups.com
keluar dari membership milis (UnSubscribe), kirim mail kosong ke : belajar-excel-unsubscribe@yahoogroups.com
---------------------------------------------------------------------

Visit Your Group

• Privacy • Unsubscribe • Terms of Use