|
|
Home
Search
Register
Login
Recent Posts
»Forums Index
»Archive (2017 and earlier)
»DTN.IQ Client Software Support
» Recording macros in Excel using DTNIQ and DDE Link
|
|
| Author | Topic: Recording macros in Excel using DTNIQ and DDE Link (8 messages, Page 1 of 1) |
 gdeboeck -Interested User- Posts: 6 Joined: Feb 11, 2005 |
Posted: Feb 11, 2005 04:33 PM
Msg. 1 of 8
In MyPortfolioSpreadsheet I am trying to record a macro. After entering a macro name, a shortcut key, a description I click OK. I then get a screen asking for VBA Password.
Whatever I enter is rejected and no macro can be recorded. Could you please inform me what VBA Password is for spreadsheets under DTNIQ? Or alternatively how to avoid having to enter a password for a macro . I already have lowered the security to low, but the spreadsheet is still asking for a VBA password. |
|
DTN_Jay_Froscheiser -VP, Product Operations- Posts: 1746 Joined: May 3, 2004 
DTN IQFeed/DTN.IQ/DTN NxCore |
Posted: Feb 11, 2005 10:24 PM
Msg. 2 of 8
Try the sample DDE spreadsheet that is available at ftp://www.dtniq.com/iq/ . I had updated this one with the macro that isn't password protected. If you replace the one included in the DTN.IQ installation with this one, I think it will take care of it for you.
Jay Froscheiser DTN Market Access, LLC. |
|
gdeboeck -Interested User- Posts: 6 Joined: Feb 11, 2005 |
Posted: Feb 11, 2005 10:39 PM
Msg. 3 of 8
at ftp://www.dtniq.com/iq/ i found no sample spreadsheet (links to sample don't work); furthermore why should I now rebuild all the spreadsheets I have done under the original sample spreadsheet. Why not simply provide me with the password that is imbedded in the original sample?
|
|
DTN_Jay_Froscheiser -VP, Product Operations- Posts: 1746 Joined: May 3, 2004
DTN IQFeed/DTN.IQ/DTN NxCore |
Posted: Feb 12, 2005 08:12 AM
Msg. 4 of 8
Clicking on the file while browsing that URL in a webbrowser it downloads fine for me. I don't have the password, which is why I gave you this URL.
Jay Froscheiser DTN Market Access, LLC. |
|
gdeboeck -Interested User- Posts: 6 Joined: Feb 11, 2005 |
Posted: Feb 12, 2005 09:01 AM
Msg. 5 of 8
At ftp://www.dtniq.com/iq/ I see under Name two listing of Sample
Clicking on either of them produces Sample: The system cannot find the file specified Hence I am not getting the same as you do... Is there no way to eliminate the VB password? |
|
DTN_Jay_Froscheiser -VP, Product Operations- Posts: 1746 Joined: May 3, 2004
DTN IQFeed/DTN.IQ/DTN NxCore |
Posted: Feb 12, 2005 10:30 AM
Msg. 6 of 8
PM me on the forums here with your email address and I will email the file to you. I don't have the password (which is the only way to get into it) with me while I am in NY. However, you may be able to just take the macro from the updated sample and put it in the old one (not too sure).
Jay Froscheiser DTN Market Access, LLC. |
|
DTN_Jay_Froscheiser -VP, Product Operations- Posts: 1746 Joined: May 3, 2004
DTN IQFeed/DTN.IQ/DTN NxCore |
Posted: Feb 12, 2005 10:34 AM
Msg. 7 of 8
My guess is the problem is in your browser downloading files with spaces in the names. I tried with IE as well as Firefox by just browsing to the FTP directory, then clicking on the file name and doing a "save as". Other than that I am not sure why it wouldn't be found for you.
Jay Froscheiser DTN Market Access, LLC. |
|
gdeboeck -Interested User- Posts: 6 Joined: Feb 11, 2005 |
Posted: Feb 12, 2005 12:39 PM
Msg. 8 of 8
I got the Sample spreadsheet; tested the macros and was able to add one...so this sample is less restrictive than the one posted earlier or the one included in the dtniq setup. Thanks for your help. My e-mail for future reference: guido@dokus.com
|
|
|