MSXML6.0 - Does exporting to Excel work for you

Miklos_Hollender
Miklos_Hollender Member Posts: 1,629
edited 2007-04-10 in NAV/Navision Classic Client
For me it complains about a missing automation server. Maybe it requires Office 2007?

Answers

  • trag
    trag Member Posts: 23
    Hi, it works for me and I'm using Office 2007. Probably you are right and it requires office 2007
  • kine
    kine 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_Hollender
    Miklos_Hollender Member Posts: 1,629
    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? :)
  • kine
    kine Member Posts: 12,562
    In beta there is no such a "feature"... :-)
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • Phenno
    Phenno Member Posts: 630
    Miklos Hollender wrote:
    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
  • Sorcerer
    Sorcerer Member Posts: 107
    works definitely with (german) office 2003.
  • Miklos_Hollender
    Miklos_Hollender Member Posts: 1,629
    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_Hollender
    Miklos_Hollender Member Posts: 1,629
    Actually I should look into Application Launch Management codeunit - but my NSC licence doesn't want to allow me to edit it...
  • Miklos_Hollender
    Miklos_Hollender Member Posts: 1,629
    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_Hollender
    Miklos_Hollender Member Posts: 1,629
    Wohooooo! It works!

    Get MSXML6.0 from here:

    http://www.microsoft.com/downloads/deta ... layLang=en
  • Phenno
    Phenno Member Posts: 630
    Miklos Hollender wrote:
    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.
  • Phenno
    Phenno 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_Hollender
    Miklos_Hollender Member Posts: 1,629
    ... 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.
  • MTC
    MTC Member Posts: 159
    Miklos Hollender wrote:
    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.
  • Phenno
    Phenno Member Posts: 630
    Miklos Hollender wrote:
    ... 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.
  • visu9211
    visu9211 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!
  • kriki
    kriki Member, Moderator Posts: 9,127
    [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!

  • gensmann
    gensmann Member Posts: 24
    Miklos Hollender wrote:
    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

Categories