![]() View our Privacy Policy, Cookies Policy, and Terms of Use.Įxcel ® is a registered trademark of the Microsoft Corporation. You can earn a commission for sales leads that you send to us by joining our ![]() Any affiliate commissions that weĮarn when you click a link to Amazon or other sites is reinvested in keeping Web site are provided "as is" and we do not guarantee that they can be used in all The Formulas, Functions and Visual Basic procedures on this provides examples of Formulas, Functions and Visual Basic proceduresįor illustration only, without warranty either expressed or implied, includingīut not limited to the implied warranties of merchantability and/or fitness forĪ particular purpose. MsgBox "Please pick up the phone and either press Enter or click OK" ' If there is data in the buffer, then read it. ' Wait for "OK" to come back from the modem. Change the CommPort property to another port." ![]() ' Assuming that a mouse is attached to COM1, CommPort is set to 2 ' A carriage return, vbCr, is required when sending commands to the modem.ĭialString = "ATDT" + Number + " " + vbCr ' A semicolon tells the modem to return to command mode after dialing (important). ' Numbers is the phone number being dialed. ' DT means "Dial Tone." The Dial command uses touch tones, as opposed to pulse (DP = Dial Pulse). ' AT is the Hayes compatible ATTENTION command and is required to send commands to the modem. Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Excel.Range, Cancel As Boolean) 'input buffer when the Input property is used. 'Setting InputLen to 0 tells MSComm to read the entire contents of the I coded it so that it dials when I double click on a cell with the phone number. ![]() You will have to play with the code to make it work for you. You need to set a reference to the Microsoft Comm Control 6.0 through Tools, References before it will work. ![]() Paul, here is some code I came across, I don't have an analog phone line at my desk so I couldn't test it 100%, but it seemed to work. I think this holds the most promise for you. Mark, here is some code I passed along a few weeks ago to someone that was trying to use Excel to talk to a modem. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |