5/31/2023 0 Comments Excel vba serial port programming![]() Our WinWedge example can be found at the bottom of the Launching WinWedge from an Excel Macro support article. For other applications, such as WinWedge or B-Coder, there is a much easier method facilitated by DDE (Dynamic Data Exchange). We recommend using this method if you are using BC-Wedge, TCP-Com, COM-File or TCP-File. This can be used for both our applications or any other windows program. Path = " C:\Program Files\BC-Wedge\BC-Wedge.exe"Ĭlosing any application from VBA can be accomplished with the example code below. ' Set the Path variable equal to the path of your program's installation Your path will also be different if you installed BC-Wedge in a location other than default or if you are trying to open a program other than BC-Wedge. ![]() Note that if you are running on a 64-bit machine, your path will be different. The example below is configured for the BC-Wedge installation on our Windows 7 machine. ![]() It can easily be used to open up any Windows program. Visual Basic for Applications (VBA) is part of all Microsoft Office products, including Excel, Access, Word, and more.
0 Comments
Leave a Reply. |