11 Messages
Digest #4604
3b
Re: smfForceRecalculation Macro Run Time Has Increased Significantly by "Randy Harmelink" rharmelink
Messages
Mon Aug 19, 2019 12:29 pm (PDT) . Posted by:
pete_cook2001
Randy, thanks for that - I've been wondering if there was a logging capability. However, when I use it, I get a run-time error and when I click debug the following appears (attachment). And no file is created in my SMF Add-in folder.
Mon Aug 19, 2019 1:14 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
You need to enable logging first, in order to create it. The default is not
to do any logging.
On Mon, Aug 19, 2019 at 12:54 PM peterscottcook@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Randy, thanks for that - I've been wondering if there was a logging
> capability. However, when I use it, I get a run-time error and when I click
> debug the following appears (attachment). And no file is created in my SMF
> Add-in folder.
>
>
to do any logging.
On Mon, Aug 19, 2019 at 12:54 PM peterscottcook@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Randy, thanks for that - I've been wondering if there was a logging
> capability. However, when I use it, I get a run-time error and when I click
> debug the following appears (attachment)
> Add-in folder.
>
>
Mon Aug 19, 2019 1:36 pm (PDT) . Posted by:
pete_cook2001
I did that per your instructions - > SMF > Logging > Enable .
Pete
Pete
Mon Aug 19, 2019 2:20 pm (PDT) . Posted by:
pete_cook2001
I did that per your instructions.
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote :
You need to enable logging first, in order to create it. The default is not to do any logging.
On Mon, Aug 19, 2019 at 12:54 PM peterscottcook@... mailto:peterscottcook@... [smf_addin] <smf_addin@yahoogroups.com mailto:smf_addin@yahoogroups.com> wrote:
Randy, thanks for that - I've been wondering if there was a logging capability. However, when I use it, I get a run-time error and when I click debug the following appears (attachment). And no file is created in my SMF Add-in folder.
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote :
You need to enable logging first, in order to create it. The default is not to do any logging.
On Mon, Aug 19, 2019 at 12:54 PM peterscottcook@... mailto:peterscottcook@... [smf_addin] <smf_addin@yahoogroups.com mailto:smf_addin@yahoogroups.com> wrote:
Randy, thanks for that - I've been wondering if there was a logging capability. However, when I use it, I get a run-time error and when I click debug the following appears (attachment)
Mon Aug 19, 2019 2:23 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
After that, each new Internet request should append a logging entry to the
file. Clicking on the enable option doesn't create the file, it just
toggles a switch. The first new request should create the file.
On Mon, Aug 19, 2019 at 1:46 PM peterscottcook@... wrote:
>
> I did that per your instructions - > SMF > Logging > Enable .
>
>
>
file. Clicking on the enable option doesn't create the file, it just
toggles a switch. The first new request should create the file.
On Mon, Aug 19, 2019 at 1:46 PM peterscottcook@
>
> I did that per your instructions - > SMF > Logging > Enable .
>
>
>
Mon Aug 19, 2019 2:35 pm (PDT) . Posted by:
pete_cook2001
I understand. Let me clarify: I opened the file, right-clicked on a cell and chose SMF>Logging>Enable, then ran my data collection, which uses getyahooportfolioview. Then I right-clicked again and chose SMF>Logging>Open log file. It was at this point that I got a run-time error saying that the log file could not be found, and indeed it was not present in my SMF Add-in folder.
I did check to make sure write-access permission was enabled for my SMF Add-in folder. Still no joy.
I did check to make sure write-access permission was enabled for my SMF Add-in folder. Still no joy.
Mon Aug 19, 2019 3:03 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
At the point that smfGetYahooPortfolioView() retrieves the file from the
Internet, it should append the request information to the log file
(creating it if it doesn't already exist). If it's not working there, I'm
not sure what to tell you?
If the append wasn't working, I would think you'd get a run-time error at
that point. There's no error handling in that routine. That makes me think
it's not even attempting the append. That is, logging hasn't been enabled.
Where the process is going wrong, I couldn't say...?
How did you "run the data collection"?
On Mon, Aug 19, 2019 at 2:35 PM peterscottcook@... wrote:
>
> I understand. Let me clarify: I opened the file, right-clicked on a cell
> and chose SMF>Logging>Enable, then ran my data collection, which uses
> getyahooportfolioview. Then I right-clicked again and chose
> SMF>Logging>Open log file. It was at this point that I got a run-time error
> saying that the log file could not be found, and indeed it was not present
> in my SMF Add-in folder.
>
> I did check to make sure write-access permission was enabled for my SMF
> Add-in folder. Still no joy.
>
>
>
Internet, it should append the request information to the log file
(creating it if it doesn't already exist). If it's not working there, I'm
not sure what to tell you?
If the append wasn't working, I would think you'd get a run-time error at
that point. There's no error handling in that routine. That makes me think
it's not even attempting the append. That is, logging hasn't been enabled.
Where the process is going wrong, I couldn't say...?
How did you "run the data collection"
On Mon, Aug 19, 2019 at 2:35 PM peterscottcook@
>
> I understand. Let me clarify: I opened the file, right-clicked on a cell
> and chose SMF>Logging>
> getyahooportfoliovi
> SMF>Logging>
> saying that the log file could not be found, and indeed it was not present
> in my SMF Add-in folder.
>
> I did check to make sure write-access permission was enabled for my SMF
> Add-in folder. Still no joy.
>
>
>
Mon Aug 19, 2019 3:04 pm (PDT) . Posted by:
pete_cook2001
Here are links to the shots in case the attachments didn't come through.
https://www.dropbox.com/s/zisr2k8cyuuyaa8/Screenshot%202019-08-19%2015.10.47.png.jpg?dl=0 https://www.dropbox.com/s/zisr2k8cyuuyaa8/Screenshot%202019-08-19%2015.10.47.png.jpg?dl=0
https://www.dropbox.com/s/76yhv86nkmzqgwg/Screenshot%202019-08-19%2015.10.52.png.jpg?dl=0 https://www.dropbox.com/s/76yhv86nkmzqgwg/Screenshot%202019-08-19%2015.10.52.png.jpg?dl=0
https://www.dropbox.com/s/zisr2k8cyuuyaa8/Screenshot%202019-08-19%2015.10.47.png.jpg?dl=0 https://www.dropbox.com/s/zisr2k8cyuuyaa8/Screenshot%202019-08-19%2015.10.47.png.jpg?dl=0
https://www.dropbox.com/s/76yhv86nkmzqgwg/Screenshot%202019-08-19%2015.10.52.png.jpg?dl=0 https://www.dropbox.com/s/76yhv86nkmzqgwg/Screenshot%202019-08-19%2015.10.52.png.jpg?dl=0
Mon Aug 19, 2019 12:52 pm (PDT) . Posted by:
mrpatmcginnis
Thank you Randy. I reviewed the Guru Focus website and the data that can be downloaded directly to Excel looks wonderful. Pat
Mon Aug 19, 2019 6:18 pm (PDT) . Posted by:
joe_mo37
I have to run Auto_Open to see the SMF context menu. The option to Enable Logging remains with a green checkmark even if I select Disable. I can open the log file, but the most recent event on it is from three years back. I can't delete the log file using Delete log file on the context menu. The net result is I can't get the log file running to see what kinds of requests the add-in is making or their duration.
Any suggestions on how to rectify this?
Any suggestions on how to rectify this?
Mon Aug 19, 2019 6:40 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
The symbols on Enable and Disable are fixed. They won't change as you
enable or disable logging.
I'm not sure what to suggest. The code has never been an issue here.
Logging has always worked as I expected.
There isn't any error handling in those routines, so if you were to run
into an error, it should choke and report it to you.
Is it possible you have the add-in installed in multiple locations? That
shouldn't be an issue, as it should use the active one, but...
On Mon, Aug 19, 2019 at 6:19 PM joe_mo37@... wrote:
>
> I have to run Auto_Open to see the SMF context menu. The option to Enable
> Logging remains with a green checkmark even if I select Disable. I can open
> the log file, but the most recent event on it is from three years back. I
> can't delete the log file using Delete log file on the context menu. The
> net result is I can't get the log file running to see what kinds of
> requests the add-in is making or their duration.
>
> Any suggestions on how to rectify this?
>
>
enable or disable logging.
I'm not sure what to suggest. The code has never been an issue here.
Logging has always worked as I expected.
There isn't any error handling in those routines, so if you were to run
into an error, it should choke and report it to you.
Is it possible you have the add-in installed in multiple locations? That
shouldn'
On Mon, Aug 19, 2019 at 6:19 PM joe_mo37@... wrote:
>
> I have to run Auto_Open to see the SMF context menu. The option to Enable
> Logging remains with a green checkmark even if I select Disable. I can open
> the log file, but the most recent event on it is from three years back. I
> can't delete the log file using Delete log file on the context menu. The
> net result is I can't get the log file running to see what kinds of
> requests the add-in is making or their duration.
>
> Any suggestions on how to rectify this?
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar