[ExcelVBA] Re: Using the Shell function in VBA

 

I also realized that I could have VBA save the .BAT file, but I'd rather not be installing (more unbeknownst to them) stuff on other's computers.
Steve

--- In ExcelVBA@yahoogroups.com, "noskosteve" <noskosteve@...> wrote:
>
>
> Derek,
>
> Do you mean that you used that very line and it worked?
>
> Shell (Environ("comspec") + " /c mode Com4:9600,n,8,2")
> (the port # (4) is correct)
>
> Which vers system, which Office?
>
> Lisa,
>
> I know batch files; I've done them, but it means having another
> file to install along with the Workbook - not cool.
> I make these available to other hams and many don't even have Office,
> so that is already asking too much and they can't use these things.
> Having to instruct them to install the .BAT file is more...take
> this file, do this, then this....then you can use my wonderful creation ... some will, some will walk.
>
> It always bugs me when other hams write software, then have complex
> instructions on installing this or that DLL, to install first, second
> and where to get them, instead of having: one file, copy it and use it.
>
>
> Hmmmm, I just thought ... Perhaps using CreatFile to set the port parameters, then close it, then using the old "OPEN, PRINT, CLOSE" commands will work (which is what I wanna' try using).
>
> An Italian Ham asked me to modify one of my workbooks for a European version of a radio and his Win 7 appears to have a long delaying pipeline for this I/O and I was wondering if OPEN/CLOSE might not have it.
> --
> 73, Steve, K9DCI
> P.S. Derek. If you haven't seen and are curious, I did
> something unique for the 706G CTCSS:
> http://k9dci.home.comcast.net/~k9dci/site/?/page/Amateur_Radio_Control/
>

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (5)

Recent Activity:

• New Members 6

Visit Your Group

----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___