MSXML6.0 - Does exporting to Excel work for you

Miklos_HollenderMiklos_Hollender Member Posts: 1,598
For me it complains about a missing automation server. Maybe it requires Office 2007?

Answers

  • tragtrag Member Posts: 23
    Hi, it works for me and I'm using Office 2007. Probably you are right and it requires office 2007
  • kinekine Member Posts: 12,562
    Because I am using Office 2007 I haven't notice it. But it seems that they are using the Office 2007 libraries...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • Miklos_HollenderMiklos_Hollender Member Posts: 1,598
    Yeah, I was afraid that it's an incentive to upgrade Office :) Who wants to bet that in the final 5.0 or 5.1 there will be some sexy feature that will only work with Vista? :)
  • kinekine Member Posts: 12,562
    In beta there is no such a "feature"... :-)
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • PhennoPhenno Member Posts: 630
    Yeah, I was afraid that it's an incentive to upgrade Office :) Who wants to bet that in the final 5.0 or 5.1 there will be some sexy feature that will only work with Vista? :)


    I installed Vista on VMWare with dedicated 700MB RAM and phoooh... 3200+AMD 64b Proc, most of the time is 100% utilization. It doesn't look like it fully occupied RAM but it reacts very slow. (Aero is turned off cause of weak virtual VGA on VMWare).
    Does Offices2007 takes a lot of resources? It is bad idea if it happens that for fully 5.0 Navision, we must install Vista & Office2007 on customer's computers...


    On the other way, while we in grp3 get a final localized version, our customers will buy good-enough machines :D
  • SorcererSorcerer Member Posts: 107
    works definitely with (german) office 2003.
  • Miklos_HollenderMiklos_Hollender Member Posts: 1,598
    WOW! New hope! :) Could that be possible that it requires automation servers that are actually in the outlook integration package? That one I never install.
  • Miklos_HollenderMiklos_Hollender Member Posts: 1,598
    Actually I should look into Application Launch Management codeunit - but my NSC licence doesn't want to allow me to edit it...
  • Miklos_HollenderMiklos_Hollender Member Posts: 1,598
    Hm... there is something funny about this error message.

    It says could not create blah blah GUID={blah} 6.0 :{blah}

    6.0? I know that MSXML6.0 is one automation that's always missing which always causes headaches with ADCS etc. Maybe it's that again?
  • Miklos_HollenderMiklos_Hollender Member Posts: 1,598
    Wohooooo! It works!

    Get MSXML6.0 from here:

    http://www.microsoft.com/downloads/deta ... layLang=en
  • PhennoPhenno Member Posts: 630
    Wohooooo! It works!

    Get MSXML6.0 from here:

    http://www.microsoft.com/downloads/deta ... layLang=en

    Actually, on Vista ultimate and Office 2003 it works without any problems. Only thing I have noticed is that it makes XML office file (not standard) which, afaik, is not supported in Office 2003 by default... It seems that Vista gives that possibility. For all other OSs, solution with MSXML6 will probably be enough.
  • PhennoPhenno Member Posts: 630
    I thought that reports can be exported to excel but no... only forms can...

    aaaaaargh, why oh why... Am I missing something or what?

    I can already see myself how I'm making table forms with virtual tables instead of standard reports, just to be able to export it to excel (which is very standard request)...
  • Miklos_HollenderMiklos_Hollender Member Posts: 1,598
    ... well at least that's easier now with being able to show temp tables on forms...

    But I think there is a conceptual issue then. If exporting is considered so important, one should use JET or something like that. If it's just a few reports, probably directly writing to the Excel Buffer is fairly easy - Mark Brummel has a download about it.
  • MTCMTC Member Posts: 159
    Actually I should look into Application Launch Management codeunit - but my NSC licence doesn't want to allow me to edit it...

    Create new codeunit say 50000, Copy CU403,select CU50000, paste, renumber it to 50000, then rename it.

    You can then at least take a look at it.
  • PhennoPhenno Member Posts: 630
    ... well at least that's easier now with being able to show temp tables on forms...

    But I think there is a conceptual issue then. If exporting is considered so important, one should use JET or something like that. If it's just a few reports, probably directly writing to the Excel Buffer is fairly easy - Mark Brummel has a download about it.

    I'm not sure about that.
    There is nothing conceptually wrong in requests for exporting report to excel. I already has "preview"/print2pdf (with small external tool)/save As Html" and now in 5.0 (or Vista/Office 2007 feature) something like "Export to something that can be viewed as picture in Office tool".

    They even add a export to Excel/Word of Forms. But no export to excel of reports.

    I don't ask for advanced reporting features, I don't ask for olap cubes, I don't ask for pivot tables... Just another export type (among other three/four).

    P.S.
    Almost every (actually, every) customer had same request. Give me what I see on (simple) reports, in Excel spreadsheet.
  • visu9211visu9211 Member Posts: 3
    Thanks Dude, I didn't know you could do it.. Copy & Paste an object.. Its wonderful

    Thanks for the Trick... =D>
    .....
    Do not fear, VISU is here!
  • krikikriki Member, Moderator Posts: 9,118
    [Topic moved from Upcoming version NAV 5.1 forum to Navision forum]
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!


  • gensmanngensmann Member Posts: 24
    Actually I should look into Application Launch Management codeunit - but my NSC licence doesn't want to allow me to edit it...
    <snip from MS support>
    The Licenses will not be automatically updated. You will need to contact EOC and ask them to update your License.
    </snip from MS support>

    This goes for 004 licences...
    Best regards Poul Anker Gensmann
    http://www.gbusiness-solutions.com
Sign In or Register to comment.