Jumat, 26 Februari 2016

[smf_addin] Digest Number 3649

4 Messages

Digest #3649
1a
Windows 10 by indinvestor111
1b
Re: Windows 10 by "T Shepherd" tonybshepherd
2b

Messages

Thu Feb 25, 2016 10:13 am (PST) . Posted by:

indinvestor111

Has anybody had problems with excel freezing since installing windows 10? Upon installing the update, excel freezes multiple times per day on me. Several online forums indicate that add-ins may contributing to the problem. I tried an online fix and now it's prompting me for my key number (which I've since lost) or else it'll loose functionality. Ugh!

Thu Feb 25, 2016 1:56 pm (PST) . Posted by:

"T Shepherd" tonybshepherd

Hi - Can't help with your exact question, but if you need your product key, look at the "ProduKey" utility on "www.nirsoft.net" - it claims to be able to get the key for you.
HTH - good luck.
-- Regards - tbs

From: "elandry@bmlcapital.com [smf_addin]" <smf_addin@yahoogroups.com>
To: smf_addin@yahoogroups.com
Sent: Thursday, February 25, 2016 1:13 PM
Subject: [smf_addin] Windows 10

  Has anybody had problems with excel freezing since installing windows 10? Upon installing the update, excel freezes multiple times per day on me. Several online forums indicate that add-ins may contributing to the problem. I tried an online fix and now it's prompting me for my key number (which I've since lost) or else it'll loose functionality. Ugh!     #yiv8456642590 #yiv8456642590 -- #yiv8456642590ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8456642590 #yiv8456642590ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8456642590 #yiv8456642590ygrp-mkp #yiv8456642590hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv8456642590 #yiv8456642590ygrp-mkp #yiv8456642590ads {margin-bottom:10px;}#yiv8456642590 #yiv8456642590ygrp-mkp .yiv8456642590ad {padding:0 0;}#yiv8456642590 #yiv8456642590ygrp-mkp .yiv8456642590ad p {margin:0;}#yiv8456642590 #yiv8456642590ygrp-mkp .yiv8456642590ad a {color:#0000ff;text-decoration:none;}#yiv8456642590 #yiv8456642590ygrp-sponsor #yiv8456642590ygrp-lc {font-family:Arial;}#yiv8456642590 #yiv8456642590ygrp-sponsor #yiv8456642590ygrp-lc #yiv8456642590hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8456642590 #yiv8456642590ygrp-sponsor #yiv8456642590ygrp-lc .yiv8456642590ad {margin-bottom:10px;padding:0 0;}#yiv8456642590 #yiv8456642590actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8456642590 #yiv8456642590activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8456642590 #yiv8456642590activity span {font-weight:700;}#yiv8456642590 #yiv8456642590activity span:first-child {text-transform:uppercase;}#yiv8456642590 #yiv8456642590activity span a {color:#5085b6;text-decoration:none;}#yiv8456642590 #yiv8456642590activity span span {color:#ff7900;}#yiv8456642590 #yiv8456642590activity span .yiv8456642590underline {text-decoration:underline;}#yiv8456642590 .yiv8456642590attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv8456642590 .yiv8456642590attach div a {text-decoration:none;}#yiv8456642590 .yiv8456642590attach img {border:none;padding-right:5px;}#yiv8456642590 .yiv8456642590attach label {display:block;margin-bottom:5px;}#yiv8456642590 .yiv8456642590attach label a {text-decoration:none;}#yiv8456642590 blockquote {margin:0 0 0 4px;}#yiv8456642590 .yiv8456642590bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv8456642590 .yiv8456642590bold a {text-decoration:none;}#yiv8456642590 dd.yiv8456642590last p a {font-family:Verdana;font-weight:700;}#yiv8456642590 dd.yiv8456642590last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8456642590 dd.yiv8456642590last p span.yiv8456642590yshortcuts {margin-right:0;}#yiv8456642590 div.yiv8456642590attach-table div div a {text-decoration:none;}#yiv8456642590 div.yiv8456642590attach-table {width:400px;}#yiv8456642590 div.yiv8456642590file-title a, #yiv8456642590 div.yiv8456642590file-title a:active, #yiv8456642590 div.yiv8456642590file-title a:hover, #yiv8456642590 div.yiv8456642590file-title a:visited {text-decoration:none;}#yiv8456642590 div.yiv8456642590photo-title a, #yiv8456642590 div.yiv8456642590photo-title a:active, #yiv8456642590 div.yiv8456642590photo-title a:hover, #yiv8456642590 div.yiv8456642590photo-title a:visited {text-decoration:none;}#yiv8456642590 div#yiv8456642590ygrp-mlmsg #yiv8456642590ygrp-msg p a span.yiv8456642590yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8456642590 .yiv8456642590green {color:#628c2a;}#yiv8456642590 .yiv8456642590MsoNormal {margin:0 0 0 0;}#yiv8456642590 o {font-size:0;}#yiv8456642590 #yiv8456642590photos div {float:left;width:72px;}#yiv8456642590 #yiv8456642590photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv8456642590 #yiv8456642590photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8456642590 #yiv8456642590reco-category {font-size:77%;}#yiv8456642590 #yiv8456642590reco-desc {font-size:77%;}#yiv8456642590 .yiv8456642590replbq {margin:4px;}#yiv8456642590 #yiv8456642590ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv8456642590 #yiv8456642590ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8456642590 #yiv8456642590ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8456642590 #yiv8456642590ygrp-mlmsg select, #yiv8456642590 input, #yiv8456642590 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv8456642590 #yiv8456642590ygrp-mlmsg pre, #yiv8456642590 code {font:115% monospace;}#yiv8456642590 #yiv8456642590ygrp-mlmsg * {line-height:1.22em;}#yiv8456642590 #yiv8456642590ygrp-mlmsg #yiv8456642590logo {padding-bottom:10px;}#yiv8456642590 #yiv8456642590ygrp-msg p a {font-family:Verdana;}#yiv8456642590 #yiv8456642590ygrp-msg p#yiv8456642590attach-count span {color:#1E66AE;font-weight:700;}#yiv8456642590 #yiv8456642590ygrp-reco #yiv8456642590reco-head {color:#ff7900;font-weight:700;}#yiv8456642590 #yiv8456642590ygrp-reco {margin-bottom:20px;padding:0px;}#yiv8456642590 #yiv8456642590ygrp-sponsor #yiv8456642590ov li a {font-size:130%;text-decoration:none;}#yiv8456642590 #yiv8456642590ygrp-sponsor #yiv8456642590ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv8456642590 #yiv8456642590ygrp-sponsor #yiv8456642590ov ul {margin:0;padding:0 0 0 8px;}#yiv8456642590 #yiv8456642590ygrp-text {font-family:Georgia;}#yiv8456642590 #yiv8456642590ygrp-text p {margin:0 0 1em 0;}#yiv8456642590 #yiv8456642590ygrp-text tt {font-size:120%;}#yiv8456642590 #yiv8456642590ygrp-vital ul li:last-child {border-right:none !important;}#yiv845664

Thu Feb 25, 2016 2:59 pm (PST) . Posted by:

herbshack13

Hi guys,


I have a list of about 100 urls I scrape daily from one source. It seems they put in a 503 error if one attempts to open more than about 10 urls.


Is there any way around this while using rchgettablecell -- something like a timer between queries?


Better yet, can you run the macro, smfforcerecalculation ONLY on selected cells?



Thanks,


Thu Feb 25, 2016 3:03 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Sorry, but smfForceRecalculation is an all or nothing deal.

I'd recommend using the smfUpdateDownloadTable process. It loads values
into the worksheet instead of having formula recalculate in the workbook.
And it allows updating of selected rows, selected columns, even a range
within the table. See the "Tips and FAQs" web page for more information on
this macro.

On Thu, Feb 25, 2016 at 2:27 PM, therber2@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> I have a list of about 100 urls I scrape daily from one source. It seems
> they put in a 503 error if one attempts to open more than about 10 urls.
>
> Is there any way around this while using rchgettablecell -- something like
> a timer between queries?
>
> Better yet, can you run the macro, smfforcerecalculation ONLY on selected
> cells?
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar