MartyConnelly
martyconnelly at shaw.ca
Thu Aug 7 13:45:15 CDT 2003
I would probably standby for further announcements.
Supposedly Access 2003 Developer Extensions will be part of the new
Visual Studio Tools for the Microsoft Office System
Here is download for Visual Studio Tools for Office Beta
http://www.microsoft.com/downloads/details.aspx?FamilyID=9e0b1b7c-4ab5-40d2-b4d9-5817ab0bc1e5&DisplayLang=en
This works for Word and Excel only right now, Access not included
Requires Win XP Pro or Win2000 with IIS, MSDE,VSNet 2003,MSDN
Library(for help files and Help 2.0),Office 2003 Beta 2
plus others
Note caveats on installation order
This is so you can use VS.NET with Excel say you have a .Net WinForm
and you want to put
excel cells in a Winform ListBox
Private Sub Button1_Click(ByVal sender As System.Object, _
ByVal e As System.EventArgs) Handles Button1.Click
Dim xlApp As New Microsoft.Office.Interop.Excel.Application()
Dim objWorkbook As Microsoft.Office.Interop.Excel.Workbook
Dim objWorksheet As Microsoft.Office.Interop.Excel.Worksheet
Dim objRange As Microsoft.Office.Interop.Excel.Range
Dim intRow As Integer
Dim intCell As Integer
Dim strRow As String
' Change the path to SOLVSAMP.XLS to match the path on your computer.
objWorkbook = xlApp.Workbooks.Open _
("C:\Program Files\Microsoft Office\Office10\Samples\SOLVSAMP.XLS")
objWorksheet = objWorkbook.Worksheets.Item("Quick Tour")
objRange = objWorksheet.Range("A2", "F16")
For intRow = 1 To 15
For intCell = 1 To 6
strRow = strRow & objRange.Cells(intRow, intCell).value & vbTab
Next intCell
Me.ListBox1.Items.Add(strRow)
strRow = ""
Next intRow
End Sub
Gustav Brock wrote:
>Hi Marty
>
>But is this a thought or a decision?
>Sounds like those tools are not for free ...
>
>
>
>>>> 2 and 3 are free downloads.
>>>>
>>>>
>
>/gustav
>
>
>
>
>>Have a look at this to see if makes sense.
>>Microsoft Developer Tools Roadmap 2003-2005
>>http://msdn.microsoft.com/vstudio/productinfo/roadmap.aspx#office
>>
>>
>
>
>
>>Gustav Brock wrote:
>>
>>
>
>
>
>>>Sorry for being dense, but I still cannot see if/how Visual Studio
>>>fits into the picture of Access development.
>>>
>>>I'm aware that Visual Studio might bring some (Internet) features to
>>>Access development, but what is important is to distinguish between
>>>offers/features and needs. And if at all possible I do not want an IIS
>>>to run on my trusted development machine; if it _is_ needed I wish it
>>>to run on a server.
>>>
>>>By the way, what is "Office 2003 Windows Update CD"?
>>>
>>>/gustav
>>>
>>>
>>>
>>>
>>>>This hasn't been set in stone yet by Microsoft. Maybe they are waiting
>>>>for a marketing decision.
>>>>
>>>>
>>>>1. Is VS Net 2003
>>>> 2 and 3 are free downloads.
>>>>
>>>>
>>>>
>>>>Who knows they may switch to an MSI install, which would require 2 CD's
>>>>much like SageKeys
>>>>Office XP MSI wizard.
>>>>
>>>>
>>>>
>>>>The Microsoft Installer may require two CD's to be shipped, the Access
>>>>2003 Application CD created by the Packaging Wizard and the Office 2003
>>>>Windows Update CD. When the user inserts the Application CD, they are
>>>>prompted to load the Update CD first which loads the required
>>>>preconditioning components onto the target PC.
>>>>
>>>>
>>>>
>>>>By the way IIS must be installed prior to loading VS Net, if you plan
>>>>to use any of its features.
>>>>You can still use things like Net WinForms without IIS but not Web
>>>>Forms. If you install IIS after VS Net you can only use internal Web
>>>>Forms <local host>. To fix you have to do a clear and reinstall in
>>>>correct order, usually takes a couple of hours.
>>>>
>>>>
>>>>
>>>>>I'm slightly confused ...
>>>>>
>>>>>Does this mean you'll have to buy all this - in addition to Office
>>>>>2003 Pro, of course - just to create an Access 2003 runtime:
>>>>>
>>>>>1. Visual Studio
>>>>>2. Visual Studio Tools for the Microsoft Office System
>>>>>3. Access 2003 Developer Extensions
>>>>>
>>>>>as well as to soil your dearly beloved workstation with IIS?
>>>>>
>>>>>And which version of Visual Studio? I don't have it as I've never had
>>>>>a need for it.
>>>>>
>>>>>/gustav
>>>>>
>>>>>
>>>>>
>>>>>>Looks like below doesn't contain the Access deployment features
>>>>>>Access 2003 Developer Extensions Overview
>>>>>>
>>>>>>http://www.microsoft.com/office/preview/editions/accessdav.asp
>>>>>>
>>>>>>
>>>>>>
>>>>>>from recent posting newsgroup microsoft.public.vsnet.vstools.office
>>>>>
>>>>>
>>>>>
>>>>>>Subject: Re: Access 2003 Developer Extensions
>>>>>>From: "Peter Torr \(MS\)" <ptorr at microsoft.com> Sent: 7/16/2003
>>>>>>10:19:41 AM
>>>>>>"Urs Stettler" <stettler at e-wideweb.com> wrote in message
>>>>>>news:090401c34b7f$926f8de0$a401280a at phx.gbl...
>>>>>>
>>>>>>
>>>>>>
>>>>>>>According to the product description of the VS tools for
>>>>>>>Office, Access 2003 Developer Extensions are supposed to
>>>>>>>be part of it.
>>>>>>>
>>>>>>>Well, I purchased the Office 03 beta, purchased VS 03 just
>>>>>>>to be able to use Access depoloyment features. Having
>>>>>>>installed the VS tools, I can't find any packaging wizard
>>>>>>>or any link in Access 03 to start the packaging process.
>>>>>>>Am I missing something?
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>The Access Developer Extensions will be in the final retail product, which
>>>>>>has not shipped yet. The beta release of Visual Studio Tools for Office
>>>>>>just contains the Word and Excel managed code projects.
>>>>>>
>>>>>>
>
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>
>
>