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) 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)
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
>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)
>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) This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
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...
|
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 '~'...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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,...
|
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...
|
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...
|
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...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
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...
|
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...
|
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...
|
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)...
|
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
|
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...
| |