| |
|
|
|
| | Okay, I solved my problem. Basically, for whatever reason, a hyperlink always sends the double hit, whether it is in a macro or just clicked on a sheet, but if I use the VBS query table construct, i.e. "URL: http://www.collective2.com/...."; then only one command gets sent. |
|
| | |
|
| |
|
| |
| Subject: | Duplicate Excel API Commands |
| Posted by: | Flo Boe ( C2 Score: 936 ) |
 |
| |
|
| When: | 4/10/08 (15:53) | |
| Systems: | deepconcept, discourse, Diversified, Global Allocation, HermeQuantic, nicetalked, qualitatives, Sense Sensibility, Technical Timer Small, Test, prometheus, surfer |
|
|
|
|
| | In response to post by The Merlin Trading Group of 2/25/08 (15:40) Okay, I solved my problem. Basically, for whatever reason, a hyperlink always sends the double hit, whether it is in a ...
See entire
I got the same problem. But I don't understand your solution. Could you describe it more detailed?
I write in my Visual Basic Code: ActiveWorkbook.FollowHyperlink ...
How did you solve the duplication problem?
Thank you for help! |
|
| | |
|
| |
|
| |
|
|
|
| | In response to post by Flo Boe of 4/10/08 (15:53) I got the same problem. But I don't understand your solution. Could you describe it more detailed?
I write in my Visual Basic Code: ActiveWorkbook.FollowHyperlink ......
See entire
If you construct a hyperlink on a workbook sheet and execute it by clicking on it or invoking it in a macro, duplicate commands are sent. However, if I use the following VBS construct from within a macro, only one command is sent:
With ActiveSheet.QueryTables.Add(Connection:=C2CmdStr, Destination:=Range("A42"))
.Name = "url"
C2CmdStr is a variable that is constructed based on what needs to be done. |
|
| | |
|
| |
|
| |
|
|
|
| | In response to post by The Merlin Trading Group of 6/09/08 (23:15) If you construct a hyperlink on a workbook sheet and execute it by clicking on it or invoking it in a macro, duplicate commands are sent. However, if I use the following VBS construct from within a macro, only one command is sent:
...
See entire
|
| | |
|
| |
|
|
