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 Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Trying to collect data from OPC will only update in 1 cell ,not entire
I am collecting data from a OPC server. I was able to drag and drop a tag from opc to excel spreadsheet and the cell updates just fine,example:A2-48.6 , A2-46.3 , A2-47.7. But what I would like to do is have it update like a datalogger example: A2 47.7 , A3 46.3 , A4 48.6 ,A5 47.8, A6 45.9,etc...- Cydog
- Thread
- Replies: 1
- Forum: Microsoft: Office
-
How would I change this code to open existing Excel instead of new
Thanks for the reply HarleyQuinn. I will try a few things with your example. What section of this code would you insert your example. exlApp.Workbooks.Open() 'Start Excel and open new spreadsheet Set exlApp = New Excel.Application exlApp.Workbooks.Add Set exlWSheet =...- Cydog
- Post #3
- Forum: Visual Basic (Classic)
-
How would I change this code to open existing Excel instead of new
How would I change this code to open an existing Excel spreadsheet instead of new spreadsheet. I struggle terribly trying to understand VB code , or any code. What would be the easiest way to modify,this code below, to open an existing Excel spreadsheet instead of a new spreadsheet. Your...- Cydog
- Thread
- Replies: 4
- Forum: Visual Basic (Classic)
