INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Excel 2007 DDE command send to PW5 Procomm

Excel 2007 DDE command send to PW5 Procomm

(OP)
Hello All

Been lurking for a few weeks looking around the forums and Knob's website - all very good info! Written an aspect script for procomm that is literally saving me hundreds of terminal command entries every day! Come from more of a hardware support role and completely new to Aspect, but did C++ back at uni.. cough ... 10 years ago.

I am however having a wee issue that is so lacking in info when searching online it makes me think I'm hitting a brick wall before I even get started.

All I'm trying to do at the moment is create a VB script from within Excel 2007 to just start the Procom and DDE server - not even started passing any commands across yet (which is the end goal of course). The vb dde script works fine to start winword for expample so I know they can't have gimped DDE in excel 2007. The machine is 32bit Window 7 Pro.

Eg. (Code nabbed from somewhere - I'm just re-purposing it for this example)

CODE --> Aspect

Sub Using_DDE1()

      ' Dimension the variables.
      Dim Chan As Integer
      Dim RequestItems As Variant

      ' Start a channel to Word using the System topic.
      Chan = DDEInitiate("winword", "System")


      ' Terminate the DDE channel.
      DDETerminate Chan

      End Sub 

Will start the winword2007 app

but

CODE -->

Sub Using_DDE1()

      ' Dimension the variables.
      Dim Chan As Integer
      Dim RequestItems As Variant

      ' Start a channel to Word using the System topic.
      Chan = DDEInitiate("pw5", "System")


      ' Terminate the DDE channel.
      DDETerminate Chan

      End Sub 

Gives an "Run-time error '13: type mismatch.

Am I missing something obvious? I can find loads of examples of DDE scripts for aspect within Procomm manipulating excel spreadsheets but not a single example VB script starting Procomms dde server that works for me. Firing "PW5" into the run bar starts Procommm so I know the association is valid.

The end goal for this is a simple button next to every one of 6000 individual phone numbers within an .XLS that will pass the number, baud, parity, stop bit, data length to procomm to dial. (We are looking after ANCIENT tech!) I found out that the directory within 4.8 maxes out at 500 sites the hard way....

RE: Excel 2007 DDE command send to PW5 Procomm

Is the run-time error being displayed by VB or is that an error returned from Procomm that is reported in VB?

http://www.aspectscripting.com

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close