Rabu, 31 Desember 2014

[smf_addin] Digest Number 3281

3 Messages

Digest #3281
1.2
Re: New file uploaded to smf_addin by "Randy Harmelink" rharmelink
2
excel file by wongkayau

Messages

Tue Dec 30, 2014 8:44 pm (PST) . Posted by:

rlfaulk

Hello!

I am using the file and I have a problem. First I am not sure how to use it. I finally got the "Run List" button to work but it seems to take the currently highlighted information from the worksheet Main and just copies it into every row i the List sheet for which there is a ticker listed. So if I have IBM highlighted in the Main sheet and I hit "Run List", on the List sheet I get IBM's data for every row that happens to have a ticker in the first column. The Stock "Name" column also says "Error" for each stock in the List.


Is this a known issue? Can you help?


I like this concept a lot and it lays out pretty nicely. I am wondering if I am doing something wrong.


Thanks


Rod




Tue Dec 30, 2014 8:49 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Might help if you indicated which file you were using?

On Tue, Dec 30, 2014 at 9:08 PM, rlfaulk@... wrote:

>
> I am using the file and I have a problem. First I am not sure how to use
> it. I finally got the "Run List" button to work but it seems to take the
> currently highlighted information from the worksheet Main and just copies
> it into every row i the List sheet for which there is a ticker listed. So
> if I have IBM highlighted in the Main sheet and I hit "Run List", on the
> List sheet I get IBM's data for every row that happens to have a ticker in
> the first column. The Stock "Name" column also says "Error" for each stock
> in the List.
>
> Is this a known issue? Can you help?
>
> I like this concept a lot and it lays out pretty nicely. I am wondering
> if I am doing something wrong.
>
>

Wed Dec 31, 2014 2:50 am (PST) . Posted by:

wongkayau

Hi Randy,


Good morning.


Some website allows excel file download for data. Can we capture those data in excel, without downloading the excel file, and then manually copy and paste data? The function "smfGetCSVFile" does similar job. Another one for .xls file?


Thank you so much!


Cheers,
L
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Posting Komentar