Minggu, 28 Agustus 2016

[smf_addin] Digest Number 3784

6 Messages

Digest #3784
1a
Excel Hangs by jimw1705
1b
Re: Excel Hangs by "Randy Harmelink" rharmelink
1c
Re: Excel Hangs by jimw1705
2a
Re: Macintosh by jimw1705
2b
Re: Macintosh by jimw1705
2c
Re: Macintosh by "Randy Harmelink" rharmelink

Messages

Sat Aug 27, 2016 6:54 am (PDT) . Posted by:

jimw1705

SMF-Addin used to work well, as recently as last week.

However, today, when I load a Excel file with SMF-Addin, the it hangs with the spinning wheel. After a very long timeout the spreadsheet comes up but will not function; anything done just causes it to go to the spinning wheel again. Any ideas how to make this work again. I saw a post on a security fix that might be the problem but it didn't say which one or how to fix. I'm using the .xlsx sheet.

Or is there a way to just disable the add-in at startup?


Sat Aug 27, 2016 7:12 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

The security problem is related to a recent MicroSoft security update. It's
not letting EXCEL load the add-in when EXCEL starts up. As a result,
workbooks get link errors, because EXCEL can't resolve the links to the
add-in.

For a workaround suggested by Microsoft, until they fix the issue, see:

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

However, I don't recall anyone else mentioning your symptoms. I think the
easiest way to disable the add-in externally would be to rename the .XLA
file to something else. Then EXCEL has nothing to load.

Otherwise, you could try the /s startup switch. See:

https://support.microsoft.com/en-us/kb/291288
http://www.delphifaq.com/faq/windows_user/f1087.shtml

On Sat, Aug 27, 2016 at 6:54 AM, jimw@
​...wrote:

>
> SMF-Addin used to work well, as recently as last week.
>
> However, today, when I load a Excel file with SMF-Addin, the it hangs with
> the spinning wheel. After a very long timeout the spreadsheet comes up but
> will not function; anything done just causes it to go to the spinning wheel
> again. Any ideas how to make this work again. I saw a post on a security
> fix that might be the problem but it didn't say which one or how to fix.
> I'm using the .xlsx sheet.
>
> Or is there a way to just disable the add-in at startup?
>

Sat Aug 27, 2016 8:09 am (PDT) . Posted by:

jimw1705

Thanks. Will do this.

Sat Aug 27, 2016 8:56 am (PDT) . Posted by:

jimw1705

I get the same user type error in Excel 2016.

In Excel 2016, found the Excel Add-ins located under the Developer Menu; then selected Excel Add-Is

I got the panel to deselect all the missing items; then got the undefined user type error.

When I tried to use the rchgetyahooquotes function, it doesn't produce any error message - just doesn't do anything.

I also tried putting the SMF-Add-in in the Applications Folder and it does the same thing.

Still, it looks like things are getting closer to working on the Mac which is good.

Sat Aug 27, 2016 9:06 am (PDT) . Posted by:

jimw1705

oops forgot to mention:

The compile error is coming from this module;

smfDeleteFromCellMenu

Sat Aug 27, 2016 4:53 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

You guys need to contact Paul with your Mac issues. I don't know anything
about the Mac setup.

Sounds like another reference library issue though.

On Sat, Aug 27, 2016 at 9:06 AM, jimw@premier1.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
>
> oops forgot to mention:
>
> The compile error is coming from this module;
>
> smfDeleteFromCellMenu
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar