I've written the code below to open an existing 123 file from an action button atop a Notes form. It writes to the 123 file and saves/closes, but when you look at 123 you can't see the file (only see a blank 123 frame)! Who'd have thought? How do I get this 123 file to become visible?

Download this free guide

Download: IT certifications that stand out

Are you looking to advance your career? Expand your knowledge? Boost your credibility? Our editors put together this complimentary 19-page guide on everything you need to know about obtaining an IT certification—with special attention given to cloud and desktop certifications.

Here's the code I've come up with that works. Functionally, it's identical to yours, except I was having some problems with the GetObject function - it would keep opening up 123 without a file (similar to your problem). So, I decided to open 123 through a CreateObject function call, then tell 123 to go open the file.

The next problem was the Ranges. I don't know why, but I couldn't get it to plop any text into the range specified, so I dug up some sample code from lotus and changed the property being changed (they were doing the background color) to Contents, then put in your comment. Now it works fine!

I added the code to save at the end just to prove a point to myself. No user interaction is required - if you keep the application object invisible, the user will never know it went to 123.

There is a downside here, it takes 123 a pretty good length of time to save the document (don't know why), so you might want to keep that in mind, if you DO want to do anything in the background with 123.

Here's the modified code - I ran it from a button in a mail document, but it should work from anywhere that it's called from the UI (action buttons, hotspot buttons, etc):

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy