Nitro Range refresh

[Meghraj]

Hi Team.

I am looking for a VBA to refresh a range in Nitro Application. Can you please help me on this.

Thanks in Advance

 

[SkipVought]

https://datanitro.com/docs/vba.html

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[Meghraj]

Hi Thanks for sharing this link. I am looking for VBA code to refresh Bluebeery range. Can you please suggest me?

 

[SkipVought]

Did you search for "refresh" in the reference I posted?

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[Meghraj]

Yes, it's only Pivot table refresh;however I need Nitro range to be refreshed . Can you please code it and share it with me?

 

[SkipVought]

Maybe you ought to explain what it is you are tying to do, and don't say refresh a Nitro range? What is this range, where is this range and what about it needs to be refreshed.

Plz be very specific. I, nor most other members, probably ever heard of Nitro, so what are you using it for? What does Excel have to do with nitro?

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[Meghraj]

Hi, Thanks for the response.

Please find the below link for the range.

Nielsen Nitro is an application to extract data from the Database.Also range is called Blueberry range to refresh the data

I've tried to use below VBA, but it was not working

Dim acnNitro As New ACNNITRO
Dim acnNitroUpdate As ACNielsenNitro.ACNNitroUpdate
Dim WS As Worksheet
Dim bret as Boolean
acnNitro.ParentApp = Application
acnNitroUpdate = acnNitro.ACNNitroUpdate
WS = ActiveSheet 'or Set WS = WorkSheets("My Sheet")
bret = acnNitroUpdate.UpdateAllNRanges(WS, ntrSelectGet)
acnNitro = Nothing
acnNitroUpdate = Nothing
WB = Nothing

 

[SkipVought]

Your VBA code is incomplete. Please post all the code in your module.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[Meghraj]

Hi, I have pasted everything from Module. so its not working.

 

[strongm]

Er, this code seems to be simply a copy and paste from a poor example at Stack Exchange

The final TestUpdate function in this thread, although obfuscating the fact that it is about Nitro, is better.

 

[SkipVought]

Your code, as posted, is incomplete and will not compile.

Of course "it was not working."!

http://www.functionx.com/vbaexcel/Lesson05.htm

https://msdn.microsoft.com/en-us/library/office/gg251432.aspx

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[SkipVought]

It seems, from the snapshot of your Excel, that you have some Nielsen Data tools, that you have circled. Use them in conjunction with your macro recorder to accomplish the refresh you desire MANUALLY. Then COPY the recorded code and PASTE the code here for help customizing.

But more pressing is for you to have a clear understanding of this Nielsen product and how it integrates with Excel. If you can't explain that to us (don't believe anyone here is a Nielsen expert) you won't get must good help.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]