Messages In This Digest (5 Messages)
- 1a.
- Re: Incomplete Update and Missing Values From: Bob
- 1b.
- Re: Incomplete Update and Missing Values From: Randy Harmelink
- 2a.
- Re: Just want a simple start ... From: lk1_2000
- 3.
- READ FINANCIAL WEEKLY NEWSPAPER From: manish publication
- 4a.
- Re: Retrieving CSV or xls file from http://www.hsi.com.hk/HSI-Net/HS From: boo1712
Messages
- 1a.
-
Re: Incomplete Update and Missing Values
Posted by: "Bob" bbockjr@yahoo.com bbockjr
Sat Jun 25, 2011 5:33 am (PDT)
Sorry for the delay - was out of town.
I uploaded two files to the Uploads from Forum Members area. One is RCHTestDate1.xlsx and it's the one that gets the link error. The other is RCHTestDate2. xlsx that does not. As far as I can tell, they contain the same information - there must be siomething I can't see.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> On Tue, Jun 14, 2011 at 5:36 PM, Bob <bbockjr@...> wrote:
> > As you suggested, I created a new worksheet from scratch, entered the
> formula, saved it, and
> > reopened it and I did not get the error. That was promising.
>
> That's what should happen.
>
> > Then, I opened the spreadsheet with the one formula, got the error,
> deleted the cell, saved it,
> > reopened it and did not get the error. So it's probably the formula.
>
> Something not right there.
>
> > I tried creating a new workbook and copying each of the sheets in my
> original workbook to it and
> > I got a "NAME!" error in all of the cells containing the formula (because
> the add-in at the time was
> > in c:\Program Files\SMF Add-In instead of c:\Users\Bob\SMF_Add-In) . The
> link address was
> > contained in all of the formula cells. I used the Replace function to
> remove it from all cells, saved
> > the file, but when reopening, the error again occurred.
>
> If you are getting #NAME! errors when copying, I would think you would be
> copying cells that HAVE the hard-coded location in them. Otherwise, if you
> are copying normal looking add-in functions and getting #NAME! errors, that
> would indicate to me that the add-in has not been activated properly within
> EXCEL with the add-in manager.
>
> So this makes no sense to me.
>
> > I seem to be able to copy smaller parts of a worksheet to a new blank one
> and I don't get the error, but when I
> > add more sections containing the formula, or additional sheets, I get the
> error again. I'm still stumped.
>
> Sounds like you are copying more than just the formulas.
>
> > I can send you two files. The one called RCHTestDate1.xlsx is the one that
> gives me the link error.
> > RCHTestDate2.xlsx contains the same formula but does not. Can you supply
> your e-mail address
> > or let me know how to send them to you?
>
> Just upload them to the files area of the group. I can delete them after
> viewing them.
>
> > I'd like to see if you get the same error. If you need files that have the
> add-in located in
> > C:\Program Files\SMF Add-In, I can move mine back to there and recreate
> these files.
>
> The add-in can be located anywhere. It just causes problems if the file
> being opened had the add-in in a different location with the file was saved.
> If that is true, you need to manually edit out all of the unresolved links
> (i.e. the hard-coded location of the add-in that was saved with the file).
>
> > If you can find any difference or have any other suggestions for me to
> try, please let me know.
>
> Things aren't making sense to me.
>
- 1b.
-
Re: Incomplete Update and Missing Values
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sat Jun 25, 2011 5:59 am (PDT)
Sorry, but nothing strikes me about either file. I can't explain why the one
gives the link message...
On Sat, Jun 25, 2011 at 5:32 AM, Bob <bbockjr@yahoo.com > wrote:
> Sorry for the delay - was out of town.
>
> I uploaded two files to the Uploads from Forum Members area. One is
> RCHTestDate1.xlsx and it's the one that gets the link error. The other is
> RCHTestDate2.xlsx that does not. As far as I can tell, they contain the same
> information - there must be siomething I can't see.
>
- 2a.
-
Re: Just want a simple start ...
Posted by: "lk1_2000" lk1_2000@yahoo.com lk1_2000
Sat Jun 25, 2011 9:00 pm (PDT)
Hi, Randy,
I got this set up tonight without much problem ... last night I tried it late and got a bit confused because I was beat. TOday I followed your clear instructions for an array-entered function, and it works just fine!
Obviously, this is a much more powerful tool, and I'll probably play around with it more extensively when I get a chance. Pretty cool, thanks so much for your help!
Linda
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> I would actually suggest you load the most recent version, 2.1.2011.04.03,
> from the "Works in Progress" folder. You definitely do NOT want one of the
> obsolete versions. They are really there just for reference/backup.
>
> For what you used to do, an array-entered RCHGetYahooQuotes() function
> should cover everything you need and get the data very quickly.
>
> On Fri, Jun 24, 2011 at 1:05 PM, lk1_2000 <lk1_2000@...> wrote:
>
> > I use Excel 2002 and for years have used MSN Stock Quotes Add-in ... just
> > for investment spreadsheets, and literally the only functions I use are Date
> > of Last Sale, Last Price, and Percent Change for several stocks and mutual
> > funds. I just update quotes at the end of the day. In the past week, MSN
> > Stock Quotes has stopped working. Today I found this group, and my question
> > is this: since I'm using Excel 2002, should I use your version 2.1, or
> > should I download one of your "obsolete" 2.0 versions, and if so, which one?
> > Thanks!
> >
>
- 3.
-
READ FINANCIAL WEEKLY NEWSPAPER
Posted by: "manish publication" the_economic_revolution@yahoo.co.in the_economic_revolution
Sat Jun 25, 2011 11:07 pm (PDT)
READ FINANCIAL WEEKLY
GUJARATI EDITION ISSUE 27 YR 8 PUBLISHED
AVAILABLE IN GUJARAT MUMBAI
IF NOT AVAILABLE IN MUMBAI IN YOUR AREA
CONTACT OUR DISTRIBUTOR
SHOBNATH AND RAMNATH MISHRA
PHONE (022) 65208158
LOG ON www.theecon omicrevolution.com
Annual e mail subscription Rs.1000 only for both copies, contact no.
09825065387
- 4a.
-
Re: Retrieving CSV or xls file from http://www.hsi.com.hk/HSI-Net/HS
Posted by: "boo1712" boo1712@yahoo.co.uk boo1712
Sun Jun 26, 2011 12:01 am (PDT)
Understood.
Thanks again Randy.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Just use normal EXCEL processing for a workbook -- see this thread:
>
> http://finance.groups.yahoo. com/group/ smf_addin/ messages/ 12755?threaded= 1&m=e&var= 1&tidx=1
>
> The reason smfGetCSVFile() won't work on the ".csv" file is that the fields
> are NOT delimited by commas.
>
> On Thu, Jun 23, 2011 at 2:50 AM, boo1712 <boo1712@...> wrote:
>
> >
> > Is there any function from smf that can be used to download tables from the
> > following urls?
> > 1.
> > http://www.hsi.com.hk/HSI- Net/static/ revamp/contents/ en/indexes/ report/hsi/ HSI_17Jun11. xls
> >
> > 2.
> > http://www.hsi.com.hk/HSI- Net/static/ revamp/contents/ en/indexes/ report/hsi/ con_17Jun11. csv
> >
> > I tried using smfgetcsvfile but cannot display the table properly.
> >
> > I also tried using
> >
> > qurl = "
> > http://www.hsi.com.hk/HSI- Net/static/ revamp/contents/ en/indexes/ report/hsi/ HSI_17Jun11. xls
> > "
> >
> > QueryQuote:
> > With ActiveSheet.QueryTables. Add(Connection: ="URL;" & qurl,
> > Destination:=DataSheet. Range("a1" ))
> > .BackgroundQuery = True
> > .TablesOnlyFromHTML = False
> > .Refresh BackgroundQuery:=False
> > .SaveData = True
> > End With
> >
> > but also return error.
> >
> > Please advise.
> >
>
Need to Reply?
Click one of the "Reply" links to respond to a specific message in the Daily Digest.
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Individual | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe
Tidak ada komentar:
Posting Komentar