I have two MS Excel spreadsheets and I want to link them so when
spreadsheet A is updated, spreadsheet B is updated automatically. I
can do this outside of the Notes Database (teamroom), but when I place
the files in the teamroom, the links break and I cannot figure out how
to restore them. Any ideas?
I don't have an answer, I'm afraid, but this reminds me of a questio
I've been meaning to ask.
I have a rather large Excel VBA Project which contains amongst it
weaponry a command to compose an e-Mail containing attachments of al
visible hyperlinks in the current sheet. We use this for filtering
long list of documents to a given category, then to automaticall
create an e-Mail which contains the 'found' documents as attachments.
I've put in all the work to do this using an Outlook message object
and has worked beautifully - only to find out that the company is goin
to move over from Outlook to Lotus Notes ..... aaaaaghhh!!
So I'd be grateful if anyone knows of any online reference guides t
objects, topics, methods and properties for Lotus Notes objects, i
there are any - assuming Lotus Notes presents a VB-automatable AP
(which, being Lotus, I wouldn't be surprised if there isn't).
One thing I will say is that I worked in a Lotus Notes environment
few years ago and I had no end of trouble with Rich Text Formatting an
hyperlinks then. Certainly hyperlinks would get broken at a space, i
included.
Actually - I've just thought of a POSSIBLE fix for you - if the link
are getting broken at spaces, try replacing all spaces with %20 and se
if the links remain intact. Also, try replacing any other 'no
alphanumeric' characters with % and the relevant hex ASCII code - tha
may solve the problem.
Lotus Notes is a nasty piece of work, if you ask me - I remembe
searching for ages to find its equivalent of Contact records - how wa
I to know that I should have been search for "Cards" in the Hel
file?!?!?! Adding a contact being called "Add Card"? Fields appearin
in a mock 'card index' graphic frame? Dear oh dear...
Some peopl
may like it for the transition from the old days, but it's not ver
intuitive for the rest of us!!!
M
