|
|
Rank: Newbie
Groups: Member
Joined: 7/1/2011
Posts: 6
Location: USA
|
Hey Everytime I change the time interval or start or end time
I get this error "Resize to show all values"
is there away to do this automatically using VBA code
so if I click that button it will automatically do "Resize to show all values" on my cell B1 for all the time
Thank you
|
|
|
|
|
OSIsoft vCampus is a subscription-based, online offering that consists of providing everything people need to develop applications on the PI System. We invite you to take a "tour" of the OSIsoft Virtual Campus - also feel free to consult the FAQ or contact OSIsoft vCampus for more details.
|
|
|
Rank: Advanced Member
Groups: Member
Joined: 4/7/2011
Posts: 137
Location: KZN, South Africa
|
I'm not sure if you can do this from VBA
The other option you have is to expand your excel "array" to accommodate the maximum amount events you want to extract. Please give me more details and I might be able to help you?
|
|
|
Rank: Newbie
Groups: Member
Joined: 7/1/2011
Posts: 6
Location: USA
|
It should work, I read on this site, that above code could be used to do what I am trying to do but i am getting this Automation error this is the link where i read it http://www.rjksolutionsl...-pi-value-in-excel-.aspx
|
|
|
Rank: Administration
Groups: Administration
Joined: 6/20/2008
Posts: 617
Location: Cheshire, United Kingdom.
|
Hello, Change your code from: Code:
Sheet1.Range("B1").Call dlresize
to Principal Consultant
Real-Time Data Management @ Wipro Technologies
|
|
|
Rank: Newbie
Groups: Member
Joined: 7/1/2011
Posts: 6
Location: USA
|
Thank you I am almost there.
when I change the time interval or something I get this Resize to show all values and after clicking command button in which I have the Call dlresize, if I click that I get following error "DL resize : 1004 : No cells were found. "
|
|
|
|
Guest
|
