Sabtu, 31 Desember 2016

[belajar-excel] Digest Number 4054

1 Message

Digest #4054
1a
Re: Macro Crash by "Sony Ario"

Message

Fri Dec 30, 2016 3:26 pm (PST) . Posted by:

"Sony Ario"

Pak Hendrik,

Maaf. Saya lupa melampirkan file nya. Berikut ini file macro nya.
Beberapa fungsi / skrip bisa berjalan normal. Tapi ada beberapa proses yang
kemudian jadi error, hang dan berikutnya malah jadi crash.

Terima kasih sebelumnya.

Sony

On Fri, Dec 30, 2016 at 4:53 PM, hendrik karnadi hendrikkarnadi@yahoo.com
[belajar-excel] <belajar-excel@yahoogroups.com> wrote:

>
>
> Hai Sony,
> Jawabannya pasti akan sulit karena pembaca tidak dapat mengerti dengan
> jelas maksud pertanyaan anda.
> Sebaiknya lampirkan dummy file dengan contoh 4 Form dan 2 module yang akan
> dibuat.
>
> Salam,
> Hendirk Karnadi
>
> ------------------------------
> *From:* "Sony Ario sony.ario1@gmail.com [belajar-excel]" <
> belajar-excel@yahoogroups.com>
> *To:* belajar-excel@yahoogroups.com
> *Sent:* Friday, 30 December 2016, 16:10
> *Subject:* [belajar-excel] Macro Crash
>
>
> Assalamualaikum.
>
> Saya lagi coba bikin 1 file Macro. Isi nya hanya 4 Form dan 2 Module.
> Dalam 1 prosedur line nya juga nggak sampe 100 baris (untuk saat ini
> belum). Controls yang digunakan nggak macem2. Pake standard Userform
> controls semua. Masalahnya setiap di save selalu Hang dan kemudian crash.
> Saya pake Excel 2013 dan Windows 7.
>
> Mungkin teman2 disini ada yang punya solusinya / bisa bantu ?
>
> Wassalam
> Sony
>
>
>
>
============================================================
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
---------------------------------------------------------------------
READ MORE....

Jumat, 30 Desember 2016

[smf_addin] Digest Number 3874

2 Messages

Digest #3874

Messages

Thu Dec 29, 2016 9:04 am (PST) . Posted by:

justy_sports

I am using smfGetTagContent to retrieve data from the following URL - http://www.advfn.com/stock-market/NYSE/A/financials http://www.advfn.com/stock-market/NYSE/A/financials


I am doing so via the smfUpdateDownloadTable macro.


The table populates correctly when I first run the macro. The problem is, I then try to run smfForceRecalculation followed by smfUpdateDownloadTable and the data does not update (it still displays the old values; ex. Price).


If I close out of the workbook, re-open, and run smfUpdateDownloadTable the data updates correctly (ex. Price). This leads me to believe the smfForceRecalculation macro is not working correctly.


Any ideas?



Thu Dec 29, 2016 12:29 pm (PST) . Posted by:

justy_sports

I tested similar functionality with another source (MSN) and it worked just fine.

Any thoughts on why smfForceReconciliation may not be working for items retrieved from AdvFN?


Thanks!
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
READ MORE....

[belajar-excel] Digest Number 4053

2 Messages

Digest #4053
1a
Macro Crash by "Sony Ario"
1b
Re: Macro Crash by "hendrik karnadi" hendrikkarnadi

Messages

Fri Dec 30, 2016 1:10 am (PST) . Posted by:

"Sony Ario"

Assalamualaikum.

Saya lagi coba bikin 1 file Macro. Isi nya hanya 4 Form dan 2 Module. Dalam
1 prosedur line nya juga nggak sampe 100 baris (untuk saat ini belum).
Controls yang digunakan nggak macem2. Pake standard Userform controls
semua. Masalahnya setiap di save selalu Hang dan kemudian crash. Saya pake
Excel 2013 dan Windows 7.

Mungkin teman2 disini ada yang punya solusinya / bisa bantu ?

Wassalam
Sony

Fri Dec 30, 2016 1:53 am (PST) . Posted by:

"hendrik karnadi" hendrikkarnadi

Hai Sony,Jawabannya pasti akan sulit karena pembaca tidak dapat mengerti dengan jelas maksud pertanyaan anda.Sebaiknya lampirkan dummy file dengan contoh 4 Form dan 2 module yang akan dibuat.
Salam,Hendirk Karnadi
From: "Sony Ario sony.ario1@gmail.com [belajar-excel]" <belajar-excel@yahoogroups.com>
To: belajar-excel@yahoogroups.com
Sent: Friday, 30 December 2016, 16:10
Subject: [belajar-excel] Macro Crash

  Assalamualaikum.
Saya lagi coba bikin 1 file Macro. Isi nya hanya 4 Form dan 2 Module. Dalam 1 prosedur line nya juga nggak sampe 100 baris (untuk saat ini belum). Controls yang digunakan nggak macem2. Pake standard Userform controls semua. Masalahnya setiap di save selalu Hang dan kemudian crash. Saya pake Excel 2013 dan Windows 7.
Mungkin teman2 disini ada yang punya solusinya / bisa bantu ?
WassalamSony #yiv9397169332 #yiv9397169332 -- #yiv9397169332ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9397169332 #yiv9397169332ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9397169332 #yiv9397169332ygrp-mkp #yiv9397169332hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv9397169332 #yiv9397169332ygrp-mkp #yiv9397169332ads {margin-bottom:10px;}#yiv9397169332 #yiv9397169332ygrp-mkp .yiv9397169332ad {padding:0 0;}#yiv9397169332 #yiv9397169332ygrp-mkp .yiv9397169332ad p {margin:0;}#yiv9397169332 #yiv9397169332ygrp-mkp .yiv9397169332ad a {color:#0000ff;text-decoration:none;}#yiv9397169332 #yiv9397169332ygrp-sponsor #yiv9397169332ygrp-lc {font-family:Arial;}#yiv9397169332 #yiv9397169332ygrp-sponsor #yiv9397169332ygrp-lc #yiv9397169332hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9397169332 #yiv9397169332ygrp-sponsor #yiv9397169332ygrp-lc .yiv9397169332ad {margin-bottom:10px;padding:0 0;}#yiv9397169332 #yiv9397169332actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9397169332 #yiv9397169332activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9397169332 #yiv9397169332activity span {font-weight:700;}#yiv9397169332 #yiv9397169332activity span:first-child {text-transform:uppercase;}#yiv9397169332 #yiv9397169332activity span a {color:#5085b6;text-decoration:none;}#yiv9397169332 #yiv9397169332activity span span {color:#ff7900;}#yiv9397169332 #yiv9397169332activity span .yiv9397169332underline {text-decoration:underline;}#yiv9397169332 .yiv9397169332attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv9397169332 .yiv9397169332attach div a {text-decoration:none;}#yiv9397169332 .yiv9397169332attach img {border:none;padding-right:5px;}#yiv9397169332 .yiv9397169332attach label {display:block;margin-bottom:5px;}#yiv9397169332 .yiv9397169332attach label a {text-decoration:none;}#yiv9397169332 blockquote {margin:0 0 0 4px;}#yiv9397169332 .yiv9397169332bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv9397169332 .yiv9397169332bold a {text-decoration:none;}#yiv9397169332 dd.yiv9397169332last p a {font-family:Verdana;font-weight:700;}#yiv9397169332 dd.yiv9397169332last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9397169332 dd.yiv9397169332last p span.yiv9397169332yshortcuts {margin-right:0;}#yiv9397169332 div.yiv9397169332attach-table div div a {text-decoration:none;}#yiv9397169332 div.yiv9397169332attach-table {width:400px;}#yiv9397169332 div.yiv9397169332file-title a, #yiv9397169332 div.yiv9397169332file-title a:active, #yiv9397169332 div.yiv9397169332file-title a:hover, #yiv9397169332 div.yiv9397169332file-title a:visited {text-decoration:none;}#yiv9397169332 div.yiv9397169332photo-title a, #yiv9397169332 div.yiv9397169332photo-title a:active, #yiv9397169332 div.yiv9397169332photo-title a:hover, #yiv9397169332 div.yiv9397169332photo-title a:visited {text-decoration:none;}#yiv9397169332 div#yiv9397169332ygrp-mlmsg #yiv9397169332ygrp-msg p a span.yiv9397169332yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9397169332 .yiv9397169332green {color:#628c2a;}#yiv9397169332 .yiv9397169332MsoNormal {margin:0 0 0 0;}#yiv9397169332 o {font-size:0;}#yiv9397169332 #yiv9397169332photos div {float:left;width:72px;}#yiv9397169332 #yiv9397169332photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv9397169332 #yiv9397169332photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9397169332 #yiv9397169332reco-category {font-size:77%;}#yiv9397169332 #yiv9397169332reco-desc {font-size:77%;}#yiv9397169332 .yiv9397169332replbq {margin:4px;}#yiv9397169332 #yiv9397169332ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv9397169332 #yiv9397169332ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9397169332 #yiv9397169332ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9397169332 #yiv9397169332ygrp-mlmsg select, #yiv9397169332 input, #yiv9397169332 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv9397169332 #yiv9397169332ygrp-mlmsg pre, #yiv9397169332 code {font:115% monospace;}#yiv9397169332 #yiv9397169332ygrp-mlmsg * {line-height:1.22em;}#yiv9397169332 #yiv9397169332ygrp-mlmsg #yiv9397169332logo {padding-bottom:10px;}#yiv9397169332 #yiv9397169332ygrp-msg p a {font-family:Verdana;}#yiv9397169332 #yiv9397169332ygrp-msg p#yiv9397169332attach-count span {color:#1E66AE;font-weight:700;}#yiv9397169332 #yiv9397169332ygrp-reco #yiv9397169332reco-head {color:#ff7900;font-weight:700;}#yiv9397169332 #yiv9397169332ygrp-reco {margin-bottom:20px;padding:0px;}#yiv9397169332 #yiv9397169332ygrp-sponsor #yiv9397169332ov li a {font-size:130%;text-decoration:none;}#yiv9397169332 #yiv9397169332ygrp-sponsor #yiv9397169332ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv9397169332 #yiv9397169332ygrp-sponsor #yiv9397169332ov ul {margin:0;padding:0 0 0 8px;}#yiv9397169332 #yiv9397169332ygrp-text {font-family:Georgia;}#yiv9397169332 #yiv9397169332ygrp-text p {margin:0 0 1em 0;}#yiv9397169332 #yiv9397169332ygrp-text tt {font-size:120%;}#yiv9397169332 #yiv9397169332ygrp-vital ul li:last-child {border-right:none !important;}#yiv9397169332

============================================================
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
---------------------------------------------------------------------
READ MORE....

Rabu, 28 Desember 2016

[smf_addin] Digest Number 3873

1 Message

Digest #3873

Message

Tue Dec 27, 2016 8:46 pm (PST) . Posted by:

mff2805

I'm not sure if it was AdvFn or something different, but i downloaded yearly stock financial page info, maybe quarterly also, but then had a page with some nice graphs of he information. the graphs were what was really handy, as trends were readily discernible. Something got broken with that web page, i recall, then maybe got fixed, then maybe broken again. I've tried to do something similar, but get screwed up when less than a full array of data is pulled, AdnFn and FinVix don;t quite seem to get good source.
or maybe I'm just not looking close enough.
if someone can point me back to a template, I'd much appreciate it.
thanks,
mike


For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
READ MORE....

[belajar-excel] Digest Number 4052

1 Message

Digest #4052

Message

Tue Dec 27, 2016 5:02 am (PST) . Posted by:

"Nang Agus"

Coba di O2 diketik formula: =M2+N2-A2-D2
copy ke bawah.

2016-12-27 13:59 GMT+07:00 'Matzen, M. (Matzen)'
matzen.subroto@akzonobel.com [belajar-excel] <belajar-excel@yahoogroups.com>
:

>
>
> Dear Master
>
>
>
> Semoga para master Exceller selalu dilimpahkan Kesehata, saya mengalami
> kendala untuk menghitung waktu Chek Out ketika menemui tanggal Keluar
> dengan beda hari, mudah2an ada pencerahan dari para exceller
>
>
>
>
>
>
>
> *Terima Kasih*
>
>
>
>
>
> *Matzen*
>
>
>
>
>
============================================================
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
---------------------------------------------------------------------
READ MORE....

Selasa, 27 Desember 2016

[smf_addin] Digest Number 3872

3 Messages

Digest #3872

Messages

Mon Dec 26, 2016 12:30 pm (PST) . Posted by:

mff2805

Hi,
I'm been using the add-in for years now. specifically with the IBD website. i've had the issue with getting script errors when trying to log in to the investors.com web site. Usually, I can persist with clicking no the the message box, hunders of times if needed, before finally getting to log in and having a cookie stored.
But over these last few times, i cannot get to a login page.
What version of Excel do you use, with success, i assume. and what version of windows?
I use excel 2010 with now windows 10 and previously with windows 7 and 8. nothing has changed on my part for many months.
is there any way to working around this difficulty?
thanks for any insights. i realize this is not so pertinent to the smf addin, but i've nowhere else to ask
Mike


Mon Dec 26, 2016 1:04 pm (PST) . Posted by:

brad.reel

Look up message thread 29124. It has instructions on how to get around this problem. I've used it when needed.



Mon Dec 26, 2016 1:05 pm (PST) . Posted by:

brad.reel

Here is the thread, link. Sorry, my copying / pasting and searching skills got the best of me in my last reply.

https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/29124 https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/29124




For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
READ MORE....
Postingan Lebih Baru Postingan Lama Beranda