Messages In This Digest (5 Messages)

1a.: Error when trying to update custom model built on another computer From: smaduck
1b.: Re: Error when trying to update custom model built on another comput From: Randy Harmelink
1c.: Re: Error when trying to update custom model built on another comput From: smaduck
1d.: Re: Error when trying to update custom model built on another comput From: Randy Harmelink

2.: FRED Economic Data From: Randy H

View All Topics | Create New Topic

Messages

1a.: Error when trying to update custom model built on another computer

Posted by: "smaduck" smaduck@yahoo.com smaduck

Tue Oct 11, 2011 3:43 pm (PDT)

I built up a spreadsheet using the smf-addin on a PC, but I am trying to execute on a Mac (excel 2011) and I am getting the following error:

"Compile Error, Can't Find Project or Library"

It highlights this line of code "ReDim vData(1 To 1, 1 To 1) As Variant" in the macro debugger in the "RCH_Stock_Market_Functions.xla - modGetYahooHistory " code window.

Does anyone know what the problem is, and if there is a fix to all me to update my model?

Thanks

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
1b.: Re: Error when trying to update custom model built on another comput

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Tue Oct 11, 2011 3:45 pm (PDT)

The add-in won't run on a Mac, in general. Some have gotten it to work in a
PC emulation mode. The add-in requires Windows DLL libraries -- which are
probably the project or library you're not finding.

On Tue, Oct 11, 2011 at 3:25 PM, smaduck <smaduck@yahoo.com> wrote:

> I built up a spreadsheet using the smf-addin on a PC, but I am trying to
> execute on a Mac (excel 2011) and I am getting the following error:
>
> "Compile Error, Can't Find Project or Library"
>
> It highlights this line of code "ReDim vData(1 To 1, 1 To 1) As Variant" in
> the macro debugger in the "RCH_Stock_Market_Functions.xla -
> modGetYahooHistory " code window.
>
> Does anyone know what the problem is, and if there is a fix to all me to
> update my model?
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
1c.: Re: Error when trying to update custom model built on another comput

Posted by: "smaduck" smaduck@yahoo.com smaduck

Tue Oct 11, 2011 3:48 pm (PDT)

Great, thanks. Also, are there any formulas that will pull cash, etc from the yahoo Key Statistics page? I imagine the same coding used for Market Cap, etc will do the same thing?

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> The add-in won't run on a Mac, in general. Some have gotten it to work in a
> PC emulation mode. The add-in requires Windows DLL libraries -- which are
> probably the project or library you're not finding.
>
> On Tue, Oct 11, 2011 at 3:25 PM, smaduck <smaduck@...> wrote:
>
> > I built up a spreadsheet using the smf-addin on a PC, but I am trying to
> > execute on a Mac (excel 2011) and I am getting the following error:
> >
> > "Compile Error, Can't Find Project or Library"
> >
> > It highlights this line of code "ReDim vData(1 To 1, 1 To 1) As Variant" in
> > the macro debugger in the "RCH_Stock_Market_Functions.xla -
> > modGetYahooHistory " code window.
> >
> > Does anyone know what the problem is, and if there is a fix to all me to
> > update my model?
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
1d.: Re: Error when trying to update custom model built on another comput

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Tue Oct 11, 2011 4:17 pm (PDT)

Yup, very similar -- just different search strings, or element numbers.

On Tue, Oct 11, 2011 at 3:48 PM, smaduck <smaduck@yahoo.com> wrote:

> Also, are there any formulas that will pull cash, etc from the yahoo Key
> Statistics page? I imagine the same coding used for Market Cap, etc will do
> the same thing?
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)