Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: greenbambootea
- Content: Threads
- Order by date
-
what is the faster way to turn variant into integer?
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) =...- greenbambootea
- Thread
- Replies: 3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
A question regarding DDE in Excel
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...- greenbambootea
- Thread
- Replies: 12
- Forum: VBA Visual Basic for Applications (Microsoft)
-
how to update a remote data link?
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...- greenbambootea
- Thread
- Replies: 3
- Forum: VBA Visual Basic for Applications (Microsoft)
