Minggu, 05 Juni 2016

[smf_addin] Digest Number 3721[1 Attachment]

15 Messages

Digest #3721

Messages

Sun Jun 5, 2016 5:00 am (PDT) . Posted by:

perseuslim11

Good evening Randy, I've encountered a weird problem starting just today, I'm unable to update the smfupdatedownloadtable table even if it's just one cell, i press update download table , however nothing happens.. hmm..

Sun Jun 5, 2016 2:02 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

If you just select one cell, it should try to update everything. If that's
doing nothing, it should mean the first row under the headers has no ticker
symbol.

You can check out the button, make sure it looks correct.

Try selecting one row and try updating it from the button, and from the
context menu.

On Sun, Jun 5, 2016 at 5:00 AM, perseuslim11@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> Good evening Randy, I've encountered a weird problem starting just today,
> I'm unable to update the smfupdatedownloadtable table even if it's just one
> cell, i press update download table , however nothing happens.. hmm..
>
>

Sun Jun 5, 2016 6:05 pm (PDT) . Posted by:

"joo zhi" perseuslim11

By the button do you mean the update table button from context menu? If so, then yes, I always use that button to update. If not, then which button do you mean?
And I've also tried updating one cell, or multiple cells, but yet to try while row
And the ticker symbol is still there, I didn't delete it, it's working fine till yesterday hmm.. 
However, when I tried the individual rch or smf function, they work fine..

Sent from Yahoo Mail on Android

On Mon, 6 Jun, 2016 at 5:02, Randy Harmelink rharmelink@gmail.com [smf_addin]<smf_addin@yahoogroups.com> wrote:  

If you just select one cell, it should try to update everything. If that's doing nothing, it should mean the first row under the headers has no ticker symbol.

You can check out the button, make sure it looks correct.

Try selecting one row and try updating it from the button, and from the context menu.

On Sun, Jun 5, 2016 at 5:00 AM, perseuslim11@yahoo.com [smf_addin] <smf_addin@yahoogroups.com> wrote:

Good evening Randy, I've encountered a weird problem starting just today, I'm unable to update the smfupdatedownloadtable table even if it's just one cell, i press update download table , however nothing happens.. hmm..

Sun Jun 5, 2016 6:28 pm (PDT) . Posted by:

perseuslim11

I've just tried selecting whole row and update (after performing the calculation refresh), however it still isn't working

I've also tried clearing a few previously working cells (with values) and reupdate them, they also didnt work, is it possible that the macro had been broken by something?

Sun Jun 5, 2016 6:35 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

It's working fine here...

What happens if you grab the smfUpdateDownloadTable-Sample.xls workbook
from the FILES area of the Yahoo group and try running the macro on it?
That would determine whether it's something to do with the macro or with
your workbook.

On Sun, Jun 5, 2016 at 6:28 PM, perseuslim11@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> I've just tried selecting whole row and update (after performing the
> calculation refresh), however it still isn't working
>
> I've also tried clearing a few previously working cells (with values) and
> reupdate them, they also didnt work, is it possible that the macro had been
> broken by something?
>
>

Sun Jun 5, 2016 6:38 pm (PDT) . Posted by:

perseuslim11

another odd thing I've noticed is that, since the unable to update problem started, it came together with another excel problem , which is that: the bottom status bar (the one with the zoom slider to the right) disappears whenever I run the smfupdatedownloadtable macro


I've ran this macro to get the status bar back
Sub StatusbarOn()
Application.DisplayStatusBar = True
End Sub



however, after trying the smfupdatedownloadtable again, the status bar disappears again.. hmm..


Sun Jun 5, 2016 6:44 pm (PDT) . Posted by:

perseuslim11

as you suggested, i've went to try out the sample.xls, it worked fine there...

Sun Jun 5, 2016 6:47 pm (PDT) . Posted by:

perseuslim11

means its due to a problem in my worksheet? How to identify the causative factor?

Sun Jun 5, 2016 6:55 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

You must have something causing an error in the macro and kicking you out,
because you mention you lost the status bar. One of the first things the
macro does is grab that status bar so it can report on progress. It isn't
until it's done that it releases the status bar again, and you're never
getting there.

The way I would identify it is to step through the VBA code until it exits.
Then I'd know the VBA statements that are choking.

Can you trim it down enough so you can email me a copy of the workbook, but
that workbook is still failing?

On Sun, Jun 5, 2016 at 6:47 PM, perseuslim11@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> means its due to a problem in my worksheet? How to identify the causative
> factor?
>
>

Sun Jun 5, 2016 6:57 pm (PDT) . Posted by:

perseuslim11

you want the whole workbook or just the worksheet? I'll try sending you the worksheet first, as I tried making a copy of the worksheet to a new workbook and retried the update, still it makes the status bar disappear and doesnt update as well..

I'll email you the file now ^^

Sun Jun 5, 2016 7:01 pm (PDT) . Posted by:

perseuslim11

May I have your email? since you ask me to mail it to you ^_^

Sun Jun 5, 2016 7:40 pm (PDT) . Posted by:

perseuslim11

I'll post it here since I do not know your email ^_^ additional info, my excel version is 2016




attached above is the table workbook (xlsm) file


Thanks Randy :)
Attachment(s) from
1 of 1 File(s)

Sun Jun 5, 2016 9:50 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Your worksheet has no cell named "Ticker". Without that, the macro has
nothing to do. Everything is keyed on that cell.

On Sun, Jun 5, 2016 at 7:40 PM, perseuslim11@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> [Attachment(s) <#m_-802859150162156517_TopText> from
> perseuslim11@yahoo.com [smf_addin] included below]
>
> I'll post it here since I do not know your email ^_^
> additional info, my excel version is 2016
>
> attached above is the table workbook (xlsm) file
>
>
>

Sun Jun 5, 2016 9:56 pm (PDT) . Posted by:

perseuslim11

But I thought if the cell to the left has a ticker symbol. it will work?

the cell contains this symbol "Magni", it was referring to another cell from a diff worksheet, in my workbook it has value :)
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Posting Komentar