Hello,

I would like to know if what I am about to tell you is possible. I will try to make it simple and please apology, my English isn't very good.

The idea is to create a bridge between my ip phone system (A) connected to my computer and a program (B) that contains all of my customers profile pages.
To be more specific, when I receive a CALL (A), it sends a signal to (B) and it OPENS the profile page of the customer who's calling.

1- I am able to automatically import daily the folder that contains all the .txt files (incoming call history) (A) and refresh every second the .txt files in an Excel file (1).
2- I am also able to automatically import daily all of my customers (and new customers) profile from SQL 2014 to another sheet in Excel (2).

When I receive a call (A), the phone number is written in Excel (1) and sends a ''signal'' to Excel (2) to ''MATCH'' the phone number with the customer number.

Here's the part where I need help.

3- When there is a ''match'' between the phone number (calling) and the customer number in my Excel (2), I would like to send a ''signal'' to open my program (B) and write the customer number in the search bar so that it opens automatically the profile page of my custommers.

I have been searching for an interprocess communication solution to send data (customer number) from my Excel (2) to my program (B), but didn't find any clear solution.
(I can also use Access instead of Excel)

Is it possible ?

Thank you very much
Its PRETTY involved, but you could tap into Caller ID and use that as a means to identify who it is thats calling for repeat customers. Which VOIP system are you using? Some come with features that allow for you to avoid reinventing the wheel.

I made a system a while back that integrated with ShoreTel VOIP system for example with software that monitored the corporate network for 7 locations and it would call me on my cell phone and play WAV files telling me where the problem was for example, this way I was able to deal with a problem as it happened vs having to wait for people to complain that something isnt working. There were a few things I was not able to easily integrate which required some electronics and a audio bridge where I had a set of PC speakers in a cardboard box with a shoretel handset in the box with it and I added a relay to control when the handset was off the base of the phone to simulate the phone on and off the hook. I ended up using a USB Relay control with a program written in C++ to turn on and off the relay for the handset on and off the hook. So I wasnt able to do it all through just a software integration.

Yours though at least you wouldnt need any hardware modding like I did, however depending on the VOIP system, the ability to capture that Caller ID info is key.

First of all, are you a programmer looking for advice from other programmers or new to PROGRAMMING and need someone else to do the majority of the work? Trying to assess what level of help you will require and what programming language you plan to use to integrate this?

If the VOIP system was one that has open source software that integrates with it, that would be the easiest for modifying and tapping into the Caller ID info. Once you have the Caller ID info you can then run that across a database and have that display all the info you need. I wouldnt bother with Excel and would keep it all within the database and the GUI that you use with the database such as a web based interface. To me looking at this, you would want to write a service that monitors the Caller ID info, and when the service detects a change in the Caller ID when it checks it on say a 2 second interval it runs that number against the database, and then if there is a match it displays the info you need.
Thank you very much for your answer ! I really appreciate.

I use ShoreTel VOIP system with the ShoreTel communicator (14.2) .

I am actually studying to be an IT Engineer, so I am not the greatest programmer, but I am working real hard !

I am still thinking on which language to use.

But I think I will go with Importing the data from my SQL database to Microsoft Access. So when I receive a call, I can see in Access (Interface that I created) the entire profile of my customers before I answer a call.