Search results for query: *

The channelNumber keeps changing. For a certain channelNumber, I need to get values from more than one controlname. However, I tried and I found that the channelNumber keeps changing. I contacted the software provider and they confirm this. However, they did not tell me why they want to keep...

Forgot to mention that the DDE is dynamic in my case, which means the channel IDs keep changing. That is the reason why I initialize the close the DDE in evevy run. I donot know if there are other ways to get around this problem.

The problem is that when I run my code, if I assign a DDE as a formula to a cell and then keep reading the cell, the data does not update. I do not know if this is just for me or is there a magic switch somewhere I can play with. Thanks

Thanks for the reply. The return type is variant. the code for data_feed_justify is: Function data_feed_justify(row As Integer, col As Integer, flag As Integer) As Integer Dim temp As Integer If IsError(control_sheet.Cells(row, col)) Then If flag = 1 Then...

What I am dealing with now is to read data from another program in Excel by using DDE. the VBA code is something like following: channel = Application.DDEInitiate("cqgpc", "CLESK07") data_sheet.Cells(99 + row, 15) = Application.DDERequest(channel, "Y_Settlement") temp(row, 3) =...

I do have an additional question if someone can kindly answer as well. In my code, I roughly need to read more than 300 DDE data (1 program, 100+ topics and 300+ symbols). Since I need to do some computation and generate a table based on these data and these data keeps changing almost every...

Thanks a lot. I just tried again and it works. I do not know why I made such a stupid mistake and spend hours on it. I guess that I do not have that ' at first. Then, somehow the code did not work. Then I read somewhere says that special symbols need to be inside ' ' and then I tried it again...

I had an problem. I am doing a small project in Excel. Say that in a cell, I put something like "cqgpc|F.CLEK07!bid", the data from cqgpc is going to show in that cell and keeps updating. however, if I DONOT this (means there is no cell in the worksheet has this "cqgpc|F.CLEK07!bid"), and I use...

By the way, I did some range operation on the workingsheet. Therefore, the datasheet is not the active sheet. However, I tried to make it actively during the loop before the range operation and after, Excel still does not pick up the data. I do not if there is some code or simple command can...

Sorry. My bad. Here are some more details. The workbook mainly has 2 worksheets. One sheet I call datafeed. when I running a software bought from a realtime information provider, I can input certain symbols like "CLS7M8" into any cell in EXCEL, and it will should be the data and keeps changes...

I am working on a small project. some realtime data is coming into one of the Excel worksheet and I am using a VBA code to process it. Since the realtime data keeps coming, I keep my code running all the time. However, the problem is that if I do so, the automatic data updating for the realtime...