someone please help me.
In excel 2013, I have pulling PI data using PIDataLink. 1st day of every month i update the current month date. I have over 25 array's and I have to resize all of them by right click and select recalculate (resize) function. It takes about 1 to update the whole file. I was wondering if I can set that to automate and have it done on 1st of the month. Anyone who i can set that up.
Thank you
Could you provide a sample workbook (with non-sensitive data). Also I need more explanation about what your 25 arrays are and exactly what you are doing to resize them. I am not familiar with this process. What happens when you record a macro to resize an array.
How is the data downloaded? Does the Excel file refresh the data, or do you get an Excel file with the data in it? Mostly this is to determine if I can embed the code in the spreadsheet that pulls the data, or if a need a spreadsheet to open the new spreadsheet that is provided every month.
I have a method for scheduling a task and running it using the windows task scheduler, but I have to know what it is the target macro is to do.
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks