Automatic MOS Calculator Watchlist for Microsoft Excel --- *Temporarily Offline*

[jkruer01]

Originally Posted by mchadek

jkruer01,

I was thinking the same thing. I do have high speed at home but it's been running alittle slower lately. My advfn103 auto sheet is running to just fine but it gathers the data really slow. You might be on to something.

I just joined the boards. I don't know what the advfn103 auto sheet is. I am assuming it is an earlier version of the Automatic MOS Calculator spreadsheet.

If so, do you know where I can get it from? Even something with less functionality is better for now if it actually works. Can you post it here?

[Ravicide]

I just downloaded the spreadsheet and I am not getting a mos value.....It does its thinking then puts #name? in the mos box.....does this sound at all familiar and is there a solution??

[rharmelink]

Originally Posted by Ravicide

I just downloaded the spreadsheet and I am not getting a mos value.....It does its thinking then puts #name? in the mos box.....does this sound at all familiar and is there a solution??

Sounds like you haven't installed the required add-in? I'm assuming you're talking about the advfn103 workbook?

[Ravicide]

Originally Posted by rharmelink

Sounds like you haven't installed the required add-in? I'm assuming you're talking about the advfn103 workbook?

I'm not computer saavy enough to know what advfn103 is or where to get it........perhaps it is the problem............

[rharmelink]

Originally Posted by Ravicide

I'm not computer saavy enough to know what advfn103 is or where to get it........perhaps it is the problem............

Sorry, I thought you were replying to mchadek/jkruer's messages. Which automated MOS calculator did you download -- where did you get it?

You should be getting it from the first message in this thread. But, as far as I know, that won't return #NAME? ...

Before anyone can help out, we'll need to know at least:

-- Which workbook you're using
-- What operating system you're using
-- What version of EXCEL you're using

Any of those can make a difference in symptoms.

[Ravicide]

Originally Posted by rharmelink

Sorry, I thought you were replying to mchadek/jkruer's messages. Which automated MOS calculator did you download -- where did you get it?

You should be getting it from the first message in this thread. But, as far as I know, that won't return #NAME? ...

Before anyone can help out, we'll need to know at least:

-- Which workbook you're using
-- What operating system you're using
-- What version of EXCEL you're using

Any of those can make a difference in symptoms.

I got it from the first message in this thread.....and I am running it on 2003 windows xp.............hope this helps........

[rharmelink]

Originally Posted by Ravicide

I just downloaded the spreadsheet and I am not getting a mos value.....It does its thinking then puts #name? in the mos box.....does this sound at all familiar and is there a solution??

OK. I think you would get that result of you had the macros turned off when you opened the workbook. There is a function in the VBA code that is used in the workbook. If you turn off the macros, it can't find the function name and returns "#NAME?" instead.

I suspect either you have your security setting at "High", or you have it at "Medium" and answered "No Macros" when it prompted you upon the opening of the workbook.

[Ravicide]

Originally Posted by rharmelink

OK. I think you would get that result of you had the macros turned off when you opened the workbook. There is a function in the VBA code that is used in the workbook. If you turn off the macros, it can't find the function name and returns "#NAME?" instead.

I suspect either you have your security setting at "High", or you have it at "Medium" and answered "No Macros" when it prompted you upon the opening of the workbook.

rharmelink you are a genius........thanks for the help............

[jkruer01]

rharmelink

Any suggestions for my problem? I am running XP with Office XP (2002) SP 3.

Thanks!

[dansmith1982]

Greetings,

Love the website as I just found it quite a while after reading the book. I tried downloading the Excel MOS calculator but whenever I input a new stock i get the following: Runtime error 1004 - Unable to set the color index property of the interior class. Then it asks if I want to debug. Im using an ancient version of excel (1997) could this be the problem. Any help would be appreciated.