INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Nitro Range refresh

Nitro Range refresh

(OP)
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

RE: Nitro Range refresh

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

RE: Nitro Range refresh

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

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: Nitro Range refresh

(OP)
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?

RE: Nitro Range refresh

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,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: Nitro Range refresh

(OP)
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

RE: Nitro Range refresh

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

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: Nitro Range refresh

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

RE: Nitro Range refresh

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.

RE: Nitro Range refresh

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,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close