Office 2000 -> external web services

Nicolas Mailhot

Hi,

I've been tasked with doing a study of how to migrate our current
excel VBA macros (that currently dig in a very insecure and
uncontroled way in various corporate databases) to a setup were
everything is arbitrated by Weblogic web services (with EAI-provided
web services looming on the horizon)

The Office version currently deployed on clients Office 2000 on
Windows 2000 (+some NT4s).

It seems the Office Web Services toolkit is only available for Office
XP and 2003 and anyway depends on the SOAP Toolkit that is due to be
retired at the end of this month.

Will a .Net framework client deployment sufficient to have Excel 2000
talk to BEA web services ? Or must Office be upgraded to 2003 also
(since that is not such an easy thing to do this would give more
arguments to the people that want everything to be moved server-side
in the BEA java stack)

Regards,

--
Nicolas Mailhot

Nov 21 '05 #1

Subscribe Reply

1809

Dino Chiesa [Microsoft]

Correct, SOAP Toolkit is going out of support, so the recommendation is to
not do new development on it.

Office 2003 supports running .NET
and there are some nice tools "Visual Studio Tools for Office" available.
But as you point out, that requires an upgrade.

Office 2000 supports COM. A simple way to connect a COM environment to .NET
is :

- built a .NET client library for the various webservices
- tlbexp the .NET client library, to expose it as COM objects
- call those COM objects from Office 2000

This would utilize the existing Office 2000, but would also require .NET on
each client machine. Within the client lib you can do smart client stuff,
like online/offline detection, caching, asynch communications. You could at
some point migrate to all-.NET and Office 2003, but that isn't required.

A similar alternative is to just use the MSXML2.XMLHTTP component to
get/post to HTTP locations to retrieve info. In this case the "wrapper" for
the webservice would be a webpage that would return XML, or anything you
want. The webpage could be weblogic, or ASPX, or ... anything. This is
less flexible than the COM-to-.NET approach, because it's not as easy to do
the smart-client stuff I mentioned.

so you've got options.

-D
"Nicolas Mailhot" <ni************ *@laposte.net> wrote in message
news:e7******** *************** *@posting.googl e.com...

Hi,

I've been tasked with doing a study of how to migrate our current
excel VBA macros (that currently dig in a very insecure and
uncontroled way in various corporate databases) to a setup were
everything is arbitrated by Weblogic web services (with EAI-provided
web services looming on the horizon)

The Office version currently deployed on clients Office 2000 on
Windows 2000 (+some NT4s).

It seems the Office Web Services toolkit is only available for Office
XP and 2003 and anyway depends on the SOAP Toolkit that is due to be
retired at the end of this month.

Will a .Net framework client deployment sufficient to have Excel 2000
talk to BEA web services ? Or must Office be upgraded to 2003 also
(since that is not such an easy thing to do this would give more
arguments to the people that want everything to be moved server-side
in the BEA java stack)

Regards,

--
Nicolas Mailhot

Nov 21 '05 #2

Nicolas Mailhot

"Dino Chiesa [Microsoft]" <di****@online. microsoft.com> wrote in message news:<#p******* *******@tk2msft ngp13.phx.gbl>. ..

Office 2000 supports COM. A simple way to connect a COM environment to .NET
is :
[...]

Thanks for the overview - it helps me a lot

Regards,

--
Nicolas Mailhot

Nov 21 '05 #3

Similar topics

3541

Install Access 2000 on Windows XP that has Office 2002?

by: Fred | last post by:

Hi. Is it safe to instll Access 2000 on a system that already has Windows XP and Office 2002 (Word, Excel Access, Powerpoint). Anyone done this? I would install it in a searate directory but don't know about any common dlls etc. I ask this because at my work we use Access 2000 and would like to work at home, but don't want to get into compatability/conversion issues between the

Microsoft Access / VBA

2989

Office Developer and Office XP

by: Don Kuykendall | last post by:

I have Office 2000 and Office Developer and I want to upgrade to Office XP. Will my copy of Office Developer work with Access XP?

Microsoft Access / VBA

5872

Office 2003 Backwards Compatibility Issues

by: Todd D. Levy | last post by:

I recently picked up a copy of Office 2003, but have installed it (replacing my existing installation of Office XP Pro) yet because... I am in the middle of a client project using Access 2002 with Access 2000 file format (the client has Office 2000 in their offices). I am concerned that replacing Office XP Pro (Access 2002) with Office 2003 (Access 2003) may cause backward compatibility issues. Can anyone comment on this?

Microsoft Access / VBA

2693

Error from Office 2000 to Office XP

by: NQuinn | last post by:

I loaded an access application, which was created and runs fine on Office 2000, onto a computer with Office XP. The application creates a run-time error when running a procedure that creates a new Excel Object. I looked at the references and the only difference I can find is that on the computer with 2000 the references is: Reference: Excel Location: C:\Microsoft Office\Office\EXCEL9.OLB on the XP computer the reference is:

Microsoft Access / VBA

3122

Microsoft Office 2000 Developer Tools Licence question

by: Denzil | last post by:

Hi I own the full Office 2000 Pro suite and would like to distribute an Access database. I realize that I need to buy Office 2000 Dev Tools and I saw it for sale on a website for £20. The guy selling it says and i quote "there isnt a licence number with it, it installs on top of your current office 2000 and uses the licence from that." Is this correct?

Microsoft Access / VBA

1687

A question mostly about Word and Office and thus: OT

by: Lyle Fairfield | last post by:

I asked this question in Microsoft.Public.Word two days ago but I have not received an answer. I believe there are Office Experts here who may be able to help. --------- "A friend has Office 2000. She is a high school student. English is not her first language. I find the "Lookup" facility in Word 2003 very useful. I think she woud

Microsoft Access / VBA

5508

Different versions of Office

by: BK | last post by:

I have a .NET Solution (currently in 2003, FW 1.1) that uses Office automation for a few things (generates a Word document, dumps datagrids to Excel, etc.). One of my programmers works on the project from time to time. We always have problems when he loads up the latest version of the Solution however, and it appears to be a compatibility issue with difference in Office versions. My development platform is Xp Professional running...

Visual Basic .NET

1540

Office apps versioning issue

by: John | last post by:

Hi I have an access app that uses word and outlook and both are referenced in the access app. The problem is that my client have outlook 2000 and word 2000 while my development machine has outlook 2003 and word 2003. How can I package the app for distribution so that it installs fine at clients end? Thanks Regards

Microsoft Access / VBA

1702

Office 2000 to Office 2003

by: Tim Marshall | last post by:

General question - I'm installing Office 2003 on a machine that has Office 2000 installed. Are there any gothcas I need to worry about? I plan to uninstall the 2000 stuff if I can (they don't have a cd, the machine was set up by the dealer). For dual installations of office products, I know I must be careful about spefifying seprate directories. Thanks -- Tim http://www.ucs.mun.ca/~tmarshal/ ^o<

Microsoft Access / VBA

2597

office 2007 / Access 2000

by: David B | last post by:

Neighbour has got a new `puter which came with Office 2007 (without Access ) He needs Access to run an app for his business. He still has a copy of Office 2000 Pro. Are there any issues with installing Access 2000 alongside Office 2007. ? The app calls Outlook to send emails.

Microsoft Access / VBA

9512

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

10413

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

10200

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

9986

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

9021

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

7530

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

6769

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

3707

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

2909

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General