Selasa, 31 Mei 2016

[belajar-excel] Digest Number 3868

3 Messages

Digest #3868

Messages

Mon May 30, 2016 2:26 am (PDT) . Posted by:

deddyacc

Dear para master,

Saya baru belajar macro, teknik yang saya gunakan masih dasar ( record macro sisipkan query nya ). udah 3 hari ini saya belum bisa memecahkan permasalahannya. mungkin ini sangat mudah, tapi bagi saya ruwetnya setengah mati... heheheh

mohon bantuannya para master


thx
Deddy


Mon May 30, 2016 5:34 am (PDT) . Posted by:

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

Hai Deddy,

Maksudnya ada pilihan all yang menampilkan semua item di kolom tersebut
ya...
Asumsikan saja :
a. semua kolom data yang akan difilter bertipe text.
b. cells filter di b2:b4 juga bertipe text.
c. teks filter semua item berbunyi 'all'

Untuk memfilter :
with activesheet
.autofiltermode=false
.range("a6").currentregion.autofilter 2, replace(lcase(
.range("b4").value ),"all","*")
.range("a6").currentregion.autofilter 3, replace(lcase(
.range("b2").value ),"all","*")
.range("a6").currentregion.autofilter 4, replace(lcase(
.range("b3").value ),"all","*")
end with

untuk clear filter :
activesheet.autofiltermode=false

Regards,
Kid

2016-05-30 16:08 GMT+07:00 deddyacc@yahoo.com [belajar-excel] <
belajar-excel@yahoogroups.com>:

>
>
> Dear para master,
>
> Saya baru belajar macro, teknik yang saya gunakan masih dasar ( record
> macro sisipkan query nya ). udah 3 hari ini saya belum bisa memecahkan
> permasalahannya. mungkin ini sangat mudah, tapi bagi saya ruwetnya setengah
> mati... heheheh
>
> mohon bantuannya para master
>
>
> thx
> Deddy
>
>
>
>

Mon May 30, 2016 9:26 pm (PDT) . Posted by:

deddyacc

Hai Om Kid....


terima kasih sudah reply email saya...

tapi kok gak bisa ya saya masukkan query nya ke excel saya

"Run time error 438 "

rumus macro nya :

Private Sub CommandButton1_Click()

ActiveSheet.AutoFilterMode = False
ActiveSheet.Range("A6").CurrentRegion.autofilter2 , Replace(LCase(ActiveSheet.Range("B4").Value), "all", "*")
ActiveSheet.Range("A6").CurrentRegion.autofilter3 , Replace(LCase(ActiveSheet.Range("B2").Value), "all", "*")
ActiveSheet.Range("A6").CurrentRegion.autofilter4 , Replace(LCase(ActiveSheet.Range("B3").Value), "all", "*")


End Sub

oh iya untuk fungsi "LCase" kok gak jalan ya om ???

heheheheh....maaf amatir ( tapi mau belajar )


terima kasih
Deddy
============================================================
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....

[smf_addin] Digest Number 3715

12 Messages

Digest #3715
1b
Re: smfGetAdvFN no longer working by "Randy Harmelink" rharmelink
1d
Re: smfGetAdvFN no longer working by "Randy Harmelink" rharmelink
1f
Re: smfGetAdvFN no longer working by "Randy Harmelink" rharmelink
3b
Re: Extracting data from etnet by "Randy Harmelink" rharmelink
3d
Re: Extracting data from etnet by "Randy Harmelink" rharmelink

Messages

Mon May 30, 2016 6:35 am (PDT) . Posted by:

jsawyermib

Hi Randy


I really appreciate all your great work, so many thanks.


I have been using the below template to pull in historic P&L data for a little while and it has worked fine, Last year, Advfn changed the url's and you very kindly pointed me to the new ones. It was working fine up to about a month ago, but when I tried to run it today it wasn't pulling in any data, so I was wondering if the url has changed again and if you might be able to help.


I have updated for your most recent addins, but that wasn't able to resolve the issue unfortunately. The template I tried was the one below on your site: I also tried running it on another machine in case something on the original setup might have changed, but this didn't resolve the issue.


http://ogres-crypt.com/SMF/Templates/#smfGetAdvFNElement() http://ogres-crypt.com/SMF/Templates/#smfGetAdvFNElement()
me Size Last Modified Description smfGetAdvFNElement-Template-All-Line-Items.xls http://ogres-crypt.com/SMF/Templates/smfGetAdvFNElement-Template-All-Line-Items.xls 3249664 2015-10-28 04:00 AM

kind regards


John

Mon May 30, 2016 10:03 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Hmm. Just tried both templates from the website with ticker symbol MMM and
they populated normally here. What do you get with:

=RCHGetElementNumber("Version")

On Mon, May 30, 2016 at 6:35 AM, jsawyermib@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> I really appreciate all your great work, so many thanks.
>
> I have been using the below template to pull in historic P&L data for a
> little while and it has worked fine, Last year, Advfn changed the url's and
> you very kindly pointed me to the new ones. It was working fine up to about
> a month ago, but when I tried to run it today it wasn't pulling in any
> data, so I was wondering if the url has changed again and if you might be
> able to help.
>
> I have updated for your most recent addins, but that wasn't able to
> resolve the issue unfortunately. The template I tried was the one below on
> your site: I also tried running it on another machine in case something on
> the original setup might have changed, but this didn't resolve the issue.
>
> http://ogres-crypt.com/SMF/Templates/#smfGetAdvFNElement()
> *me* *Size* *Last Modified* *Description*
> smfGetAdvFNElement-Template-All-Line-Items.xls
> <http://ogres-crypt.com/SMF/Templates/smfGetAdvFNElement-Template-All-Line-Items.xls>
> 3249664 2015-10-28 04:00 AM
>
>
> kind regards
>
>
> John
>
>
>
>

Mon May 30, 2016 11:57 pm (PDT) . Posted by:

jsawyermib

Hi Randy

I get the following result:

Stock Market Functions add-in, Version 2.1.2016.04.19 (C:\Add-ins\RCH_Stock_Market_Functions; www; Local; 44)


NB, the folder in which I have loaded your add-in is called "C:\Add-ins&#92;RCH_Stock_Market_Functions"


kind regards


John

Tue May 31, 2016 12:03 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Since you're in the UK, don't you get redirected to something other than
the "www" site?

When you say it wasn't pulling any data, what results WERE you getting?

On Mon, May 30, 2016 at 11:57 PM, jsawyermib@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> I get the following result:
>
> Stock Market Functions add-in, Version 2.1.2016.04.19
> (C:\Add-ins\RCH_Stock_Market_Functions; www; Local; 44)
>
>
> NB, the folder in which I have loaded your add-in is called
> "C:\Add-ins&#92;RCH_Stock_Market_Functions"
>
>

Tue May 31, 2016 12:30 am (PDT) . Posted by:

jsawyermib

Hi Randy


I get the below result. The "C:\Add-ins&#92;RCH_Stock_Market_Functions" is the directory folder that I have downloaded your add-in to.

Stock Market Functions add-in, Version 2.1.2016.04.19 (C:\Add-ins\RCH_Stock_Market_Functions; www; Local; 44)


Kind Regards


Ajohn

Tue May 31, 2016 12:35 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

I meant what result are you getting on the templates? You said they're not
pulling data. What are they giving you?

Where are you located? Do you need to set a prefix for AdvFN? When were
AdvFN functions last working?

On Tue, May 31, 2016 at 12:30 AM, jsawyermib@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> I get the below result. The "C:\Add-ins&#92;RCH_Stock_Market_Functions" is the
> directory folder that I have downloaded your add-in to.
>
> Stock Market Functions add-in, Version 2.1.2016.04.19
> (C:\Add-ins\RCH_Stock_Market_Functions; www; Local; 44)
>
>
>

Mon May 30, 2016 11:01 am (PDT) . Posted by:

jterrenceho

Randy,

Thanks, I think I am getting it a little.

Mon May 30, 2016 6:21 pm (PDT) . Posted by:

alankc_mok

Dear Randy,

Thanks for your reply.

I am also trying to extract data from the below site https://webb-site.com/ccass/choldings.asp?issue=44 https://webb-site.com/ccass/choldings.asp?issue=44
In particular, I am looking for CCASS ID A00003, Holding, Last Change, Stake, Cumul. Stake.

Thanks

Alan

Mon May 30, 2016 8:01 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Try:

=smfGetTagContent("https://webb-site.com/ccass/choldings.asp?issue=44
","td",2,">Row",">A00003",,,1)
=smfGetTagContent("https://webb-site.com/ccass/choldings.asp?issue=44
","td",3,">Row",">A00003",,,1)
=smfGetTagContent("https://webb-site.com/ccass/choldings.asp?issue=44
","td",4,">Row",">A00003",,,1)
=smfGetTagContent("https://webb-site.com/ccass/choldings.asp?issue=44
","td",5,">Row",">A00003",,,1)

On Mon, May 30, 2016 at 6:21 PM, alankc_mok@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> I am also trying to extract data from the below site
> https://webb-site.com/ccass/choldings.asp?issue=44
>
> In particular, I am looking for CCASS ID A00003, Holding, Last Change,
> Stake, Cumul. Stake.
>

Mon May 30, 2016 11:28 pm (PDT) . Posted by:

alankc_mok

Randy,

Thanks for your prompt reply.

I try the above , but cant retrieve the data.

Regards,

Alan

Mon May 30, 2016 11:55 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Not sure what to tell you. I just copied and pasted from the message, and
they worked fine for me.

What results are you seeing?

On Mon, May 30, 2016 at 11:28 PM, alankc_mok@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> I try the above , but cant retrieve the data.
>
>

Tue May 31, 2016 1:59 am (PDT) . Posted by:

alankc_mok

Randy,

It is working now after I upgraded the Add in to the latest version.

Thanks

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