i know how to detect the data every minute already. now i transfer my data to excel. but how i can see the worksheet when the program is running? i just can saw my data after i close the program and open excel. if i open excel during program is runing, it requires may save the data in different name. but i just want to update the data each time i run the program only. my program is like this:
If you only want to see the Excel workbook opened by your program try:
x.visible = True
If you need to change data in your Excel workbook while your program is running you will need to modify your program to close the workbook after each update and then open it again before doing the next update.
You will NOT be able to keep the workbook open in read-write mode in both VB and Excel.
I have a 2d matrix with dimension (3, n) called A, I want to calculate the normalization and cross product of two arrays (b,z) (see the code please) for each column (for the first column, then the second one and so on).
the function that I created to find the ...
Write a C program that should create a 10 element array of random integers (0 to 9). The program should total all of the numbers in the odd positions of the array and compare them with the total of the numbers in the even positions of the array and indicate ...