Link help

leemac83

New Member
Joined
Mar 21, 2006
Messages
36
Can anyone help me with the below code? I am looking at an excel sheet that someone created years ago in 1997, but does not work in 2003. There are some links and formula like the one below, can anyone tell me what it does?

=REUTER|IDN!'PNDS,MONROW 4,,39,13'

Someone said that it links to the Reuters system, but I don't think so, it looks like it looks at a spreadsheet am I correct :confused:
 

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

GlennUK

Well-known Member
Joined
Jul 8, 2002
Messages
11,547
Someone said that it links to the Reuters system, but I don't think so, it looks like it looks at a spreadsheet am I correct
No, I'd say it links to the Reuters system too.
 

leemac83

New Member
Joined
Mar 21, 2006
Messages
36
So do you know why it would not work in 2003, but in 1997, do the links need updating?
 

GlennUK

Well-known Member
Joined
Jul 8, 2002
Messages
11,547
Have you tried linking to the Reuters system yourself? I'd have thought there would be add-ins or such-like to get this to work. Will have an ask around here to see if anyone has any knowledge of the specifics.
 

leemac83

New Member
Joined
Mar 21, 2006
Messages
36
thats what made me think that it was a s/s as I cannot see any add ins that would make this work, and as far as I know you could not link directly to Reuters, but I must be wrong! :rolleyes:
 

leemac83

New Member
Joined
Mar 21, 2006
Messages
36
I have had a look round and found some code that has been written in Microsoft Script? What does this do? I have only ever used VBA in excel :(
 

Forum statistics

Threads
1,136,370
Messages
5,675,367
Members
419,566
Latest member
moni2277

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top