13 Replies Last post: Oct 26, 2009 9:45 AM by Michael Love  
Dean Hoff Newbie 4 posts since
Sep 29, 2009
Currently Being Moderated

Sep 30, 2009 2:37 PM

Excel/VB App Question

Eric - I am using your Excel/VB tool (thanks for putting it together - save a ton of time).  Is there any way to place the results from multiple queries into the same worksheet?  I have to pull monthly data from 20+ profiles into a dashboard and would rather not have a separate worksheet for each profile and month....
Michael Love Newbie 11 posts since
Jan 12, 2009
Currently Being Moderated
Sep 30, 2009 4:02 PM in response to: Dean Hoff
Re: Excel/VB App Question

Dean:

 

I am actually the author of that application.  Your question comes at a very opportune time.  I had a bit of time on my hands and jus finished adding that code to the application and updated it to v1_1 as well.  I will send it to you since it has not been posted yet.

 

Mike Love

Senior Solutions Engineer

Webtrends

simon Barrett-Danes Newbie 2 posts since
Oct 9, 2009
Currently Being Moderated
Oct 16, 2009 4:15 AM in response to: Michael Love
Re: Excel/VB App Question

I also use this this excellent Excel/VB app, could you forward me the latest version of the excel spreadsheet.

Regards

Michael Love Newbie 11 posts since
Jan 12, 2009
Currently Being Moderated
Oct 16, 2009 10:32 AM in response to: simon Barrett-Danes
Re: Excel/VB App Question

Simon:

 

I hope you are getting a lot out of the sample application.  I have updated this version to support v1_1 of the REST API.  I have also added new functionality so that you can place multiple reports on a sheet as well as do multiple queries and add new data to an existing report.  I have added that new application with the updated documentation to this reply.

 

I am always interested in feedback on this.  So, let me know what you think.

 

Mike

Attachments:
simon Barrett-Danes Newbie 2 posts since
Oct 9, 2009
Currently Being Moderated
Oct 19, 2009 5:29 AM in response to: Michael Love
Re: Excel/VB App Question

Hi,

 

Could you attach the spreadsheet or better publish the latest version

 

Cheers

Michael Love Newbie 11 posts since
Jan 12, 2009
Currently Being Moderated
Oct 19, 2009 7:05 AM in response to: simon Barrett-Danes
Re: Excel/VB App Question

Simon:

 

The new spreadsheet is an embedded object in the Word doc attached to my response to you blog reply.  I am also attaching it here.

 

Mike

Attachments:
Pinda Bazley Newbie 4 posts since
Oct 23, 2009
Currently Being Moderated
Oct 24, 2009 12:13 AM in response to: Michael Love
Re: Excel/VB App Question

Hi Mike,

 

I downloaded your excel VBA file but my credentials did not work.  Microsoft account has different generator URL so I am not sure if I need to enter additional credential information.  Please advise.

 

Thanks,

Pinda

Michael Love Newbie 11 posts since
Jan 12, 2009
Currently Being Moderated
Oct 26, 2009 7:45 AM in response to: Pinda Bazley
Re: Excel/VB App Question

Pinda:

 

The sample application was written with the general customer in mind.  I do understand that Microsoft uses a different site to access their data.  If you wll provide me the domain name you use to access Webtrends via the generator, I can provide you either the changes needed to access your data or I can make the changes myself and send you a new Workbook.  It is about three lines of code.

 

Mike

Pinda Bazley Newbie 4 posts since
Oct 23, 2009
Currently Being Moderated
Oct 26, 2009 9:04 AM in response to: Michael Love
Re: Excel/VB App Question

Thanks Mike:)   Here is the MS Generator URL: https://msgenerator.webtrends.com/Account/Logon?ReturnUrl=%2f.  I would really appreciate if you would send me the new workbook.

 

Thank you very much!

Pinda

Michael Love Newbie 11 posts since
Jan 12, 2009
Currently Being Moderated
Oct 26, 2009 9:09 AM in response to: Pinda Bazley
Re: Excel/VB App Question

Pinda:

 

My mistake.  What I need is a sample of the REST URL  from the generator when you log in and create a REST URL.

 

Sorry.

 

Mike Love

Pinda Bazley Newbie 4 posts since
Oct 23, 2009
Currently Being Moderated
Oct 26, 2009 9:15 AM in response to: Michael Love
Re: Excel/VB App Question
Michael Love Newbie 11 posts since
Jan 12, 2009
Currently Being Moderated
Oct 26, 2009 9:20 AM in response to: Pinda Bazley
Re: Excel/VB App Question

Pinda:

 

A modified version is attached.

 

Mike

Attachments:
Pinda Bazley Newbie 4 posts since
Oct 23, 2009
Currently Being Moderated
Oct 26, 2009 9:42 AM in response to: Michael Love
Re: Excel/VB App Question

It works GREAT!!!  Thank you so much Mike:)

Michael Love Newbie 11 posts since
Jan 12, 2009
Currently Being Moderated
Oct 26, 2009 9:45 AM in response to: Pinda Bazley
Re: Excel/VB App Question

Pinda:

 

I am glad it works for you.  I'll have to keep in mind the MS issue in future upgrades to this.  To keep this as a single app I will probably add a check box on the log in to indicate which server gets the requests.

 

Mike

More Like This

  • Retrieving data ...