Hi -

It is certainly easy to have Sesame open MS Word (and, of course other applications) using @ASynchShell. 

I was wondering whether it is possible to pass a value from a layout element in Sesame - to the "new document" in MS Word?

In other words, I want to take text from one of the layout elements and automatically have it inserted into the Word Document.

Am I dreaming ..... or must I wait for version 2.0 ?   lol

Bob -

I'm not sure that I understand what you are suggesting and am still hoping that something "simple" is available in Sesame.

In the event it is not, I am considering another alternative that "should be" simple.

I want to start word with a macro running.  So, far I am running into an MS Word problem.  I recorded and saved the macro and am trying to start it with a switch.  I even set macro security to "low" to be sure that there was no "interference" with it running.

It's supposed to be very simple:  winword.exe /mmacroname.  Unfortunately when I try to run it, I get a

"Runtime Error 91 - "Object Variable or With Block Variable not set" or some such "garbage." 

Grrrrrr!

Bob -

With regard to my Word macro problem, the "second" angle I've been playing with is this.

I thought that I could copy text to the clipboard from within Sesame. Haven't even tried it because I'm assuming that between Sbasic and or Sesame's macro, this would not be a problem.

All I want to do in Word is start a NEW (blank) document which I am already doing. When word is started, I simply want it to paste the clipboard to the blank document.  Using the switch in the @ASynchshell command would enable all programming to be done in Sesame except for the very simple recording of a Word macro to perform the paste.  

When I select "run" the macro in Word it does just what I want.

When I use the switch word.exe /mmacroname, I get the debug stuff I described.  If I look at the macro itself, I see:

Sub MacroPaste()
'
' MacroPaste Macro
' Macro recorded 2/3/2006 by Spencer Wulwick
'
   Selection.PasteAndFormat (wdPasteDefault)
End Sub

I posted this here only because you asked.  For my purposes, however, I do not want to get involved in this type of code.

I've recorded macros in Word many times in the past (long past) and had no problem starting Word with a switch, so I am baffled as to why I am having this problem.

Thanks, much, for trying to help.

Hi again -

Is anyone there?  I feel like I am having a one-sided converstion.  lol

I am hoping that if I present some code, someone will come up with an "alternative" for me. The following code works BUT I have to wait too long for Word to close (and, probably NOT long enough if I take too much time in MS Word).

var n as int

      Clear(Mark)

      If @isblank(Mark)
      {
      Mark = "DOIT"
      n = @AsynchShell("C:\Sesame\data\email.doc")
      }

      loiter(30000)

      if MARK = "DOIT"
      {
      LastEMail = @insert("C:\sesame\data\email.doc")
      Clear(Mark)
      }
 

Please don't worry about my using a layout element instead of a variable. I used the element on purpose to see what was in the "Mark" LE at any point in time. WHEN (not "IF" but "WHEN") I get it working, I will use a variable instead of the layout element. As I said, this works just fine but with a long delay.

If I OMIT the @loiter command, then what gets inserted is the PREVIOUSLY saved document; it does not reflect the most recent one saved.

In this situation (with @loiter ommited) then if I execute the command button a SECOND time it does enter the correct document but only after shelling out to MS Word first.

If I could get this close, it just seems to me that there MUST be a way to make it work.

Once again, here is my objective and I want this to work with one click on a Sesame command button:

 1) Click on a command button in Sesame  
 2) Have MS Word automatically open and present me with email.doc
 3) Modify and save my email doc.
 3) Exit Word which will return me to Sesame
 4) Have Sesame insert the e-mail doc

PLEASE tell me I'm on the right track and what it is that I am overlooking.  I must get on with my "other" (@isblank(Sesame) life.  lol

Mark -

I have to run out so I can't try anything now; however, I am very anxious to get this completed.

I prefer to use MS Word and have no problem saving it as a plain text (.txt) file nor do I have any problem importing the text file into Sesame so it does not appear that using MS Word has anything to do with the situation I am trying to rectify.

My problem is that I want the insert to execute after my return to Sesame without further user input.

As I said I have it working but only with the loiter command and only if I return to Sesame before loiter is completed.

I had tried @shell but had less success with that. 

So, I am still hoping to get some help on this from one of the programming gurus.

Once again, I want to click on a command button, have Sesame execute a shell (of some kind) command and when I return to Sesame after exiting the other program, have the remainder of the programming executed.

Thanks!

Bob -

What a treat it was to hear from you at your user's group today.  Very frustrating, though, that I couldn't hear you, although you were able to hear me.  I do hope you'll have a mike and perhaps a video cam at the next meeting.  Having been to your meetings in the past, I "ached" to hear about the meeting and not to have been there.

As for your suggestion, I don't know what you mean by "additional coding." Anything that would work would be welcomed but, at this point, after all it took for me to get this far, I guess I need some specific coding.

As for a macro in Word, I don't think that is needed.  I envsioned initially establishing a doc called filename.txt that Sesame would open when starting Word.  Simply saving and exiting Word is all that is needed.

Likewise, because the filename.txt document would "always" exist, "looping until it exists" would not work.

As I said, I am so close that I can't believe it is not doable.  I believe we already have all the necessary tools and commands and that it is just a matter of putting it together correctly.

I've made incredible progress since I first started toying with this but just can't seem to visualize the last missing piece.  

Ray, wherefore art thou?  lol

Spencer,

If your file is indeed saved as plain text, this might be much easier to approach from the other direction.

Say you want to insert the value in an element called FirstName into your doc.

1. Type your doc in Word (or any text editor). In the space where you want FirstName to appear, type a tag like [FirstName]. Save the doc as plain text.

2. In Sesame, program your button with something like the following:

var vDoc as String

    vDoc = @Insert("email.txt")
    vDoc = @Replace(vDoc, "[FirstName]", FirstName)
    LastEmail = vDoc