473,320 Members | 2,003 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

How to learn Office Automation with Access?

pw
Hi,

I use Visual FoxPro all the time to import and export data from and to
Excel (creating workbooks in code, etc...).

There is an excellent book on how to do this with VFP from
Hentzenwerke Publishing. Is there a good book on how to do this using
MS Access? If not, where else should I look? I am concerned with
Word too, and perhaps Powerpoint.

We are presently using A97 but may be converting our application to
A2003.

Regards,
-pw
remove astericks (*) from e-mail address
(use paulwilliamson at spamcop dot net)
Nov 13 '05 #1
4 2089
PW,
Start with the help files. Excel and Access play very nice together. You
can use data from either in either without coding anything.
"pw" <***paulwilliamson@***spamcop.net> wrote in message
news:7m********************************@4ax.com...
Hi,

I use Visual FoxPro all the time to import and export data from and to
Excel (creating workbooks in code, etc...).

There is an excellent book on how to do this with VFP from
Hentzenwerke Publishing. Is there a good book on how to do this using
MS Access? If not, where else should I look? I am concerned with
Word too, and perhaps Powerpoint.

We are presently using A97 but may be converting our application to
A2003.

Regards,
-pw
remove astericks (*) from e-mail address
(use paulwilliamson at spamcop dot net)

Nov 13 '05 #2
Alan Webb wrote:
PW,
Start with the help files. Excel and Access play very nice together. You
can use data from either in either without coding anything.
"pw" <***paulwilliamson@***spamcop.net> wrote in message
news:7m********************************@4ax.com...
Hi,

I use Visual FoxPro all the time to import and export data from and to
Excel (creating workbooks in code, etc...).

There is an excellent book on how to do this with VFP from
Hentzenwerke Publishing. Is there a good book on how to do this using
MS Access? If not, where else should I look? I am concerned with
Word too, and perhaps Powerpoint.

We are presently using A97 but may be converting our application to
A2003.

Regards,
-pw
remove astericks (*) from e-mail address
(use paulwilliamson at spamcop dot net)


You can download this Microsoft 2000 Automation Help File
http://support.microsoft.com/default.aspx?kbid=260410

Bob
Nov 13 '05 #3
pw
>PW,
Start with the help files. Excel and Access play very nice together. You
can use data from either in either without coding anything.
Thank you Alan. I'll try the help files again. Hadn't had too much
success, especially with Excel's.
"pw" <***paulwilliamson@***spamcop.net> wrote in message
news:7m********************************@4ax.com.. .
Hi,

I use Visual FoxPro all the time to import and export data from and to
Excel (creating workbooks in code, etc...).

There is an excellent book on how to do this with VFP from
Hentzenwerke Publishing. Is there a good book on how to do this using
MS Access? If not, where else should I look? I am concerned with
Word too, and perhaps Powerpoint.

We are presently using A97 but may be converting our application to
A2003.

Regards,
-pw
remove astericks (*) from e-mail address
(use paulwilliamson at spamcop dot net)


-pw
remove astericks (*) from e-mail address
(use paulwilliamson at spamcop dot net)
Nov 13 '05 #4
pw
>Alan Webb wrote:
PW,
Start with the help files. Excel and Access play very nice together. You
can use data from either in either without coding anything.
"pw" <***paulwilliamson@***spamcop.net> wrote in message
news:7m********************************@4ax.com...
Hi,

I use Visual FoxPro all the time to import and export data from and to
Excel (creating workbooks in code, etc...).

There is an excellent book on how to do this with VFP from
Hentzenwerke Publishing. Is there a good book on how to do this using
MS Access? If not, where else should I look? I am concerned with
Word too, and perhaps Powerpoint.

We are presently using A97 but may be converting our application to
A2003.

Regards,
-pw
remove astericks (*) from e-mail address
(use paulwilliamson at spamcop dot net)


You can download this Microsoft 2000 Automation Help File
http://support.microsoft.com/default.aspx?kbid=260410

Bob


Just downloaded it. Thanks for the link Bob!
-pw
remove astericks (*) from e-mail address
(use paulwilliamson at spamcop dot net)
Nov 13 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: M. C | last post by:
Hello, Since I installed Office 2003, I'm experiencing problems with an automation procedure in Access (created in Access 2000) that colonizes fields in a Word merge file. I keep getting a...
1
by: RWC | last post by:
Hello, I'm getting an odd error in my Package and deployment wizard that seems to have cropped up for no good reason. The erros is as follows; Error -2147221163 Method '~' of Object '~'...
4
by: Richard | last post by:
Office Addins are easy in .NET. Try this from Visual Studio's main menu: File New Project "Other Projects" Extensibility Projects Shared Addin Run the wizard and you're off...
0
by: Luis Esteban Valencia Muñoz | last post by:
I am trying to access a word document, preferably on the client side in my intranet. The document is stored on the sever which is also a mapped network drive. I have been able to access and save...
7
by: scorpion53061 | last post by:
Has anyone done automation with Office 2003 with vb.net? How did it go(esp Word, Excel, Access)? Any problems I should be aware of? I am getting my copy next week so I thought I should do some...
0
by: Steven Thomas | last post by:
I have a windows service that uses office xp automation. Here is the code --------------------------------------- Public Sub CAccessSnapShot() Try Dim objAccess As New Access.Application() Dim...
0
by: Marco Singer | last post by:
Hi all, I want to create an Office automation client for Office 97 (and newer) which should automate Access, Excel and Word. On my developer computer I have Office XP installed. In KB244167...
2
by: William LaMartin | last post by:
I have created a program that allows for the automation of things in Word documents, like changing the values of DocVariables and the links to Excel Sheets. I did it using interoperoperatability,...
12
by: Tomas | last post by:
Hi, I have worked with VB.NET for half a year (semi-newbie). Currently I am looking around for some books for those that crossed the starting hurdle. There are too many books out there-make...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.