VBA, Creating excel Spreadsheet from Access VBA

Creating excel Spreadsheet from Access VBA

Author	Message
Pete #1 / 3	Creating excel Spreadsheet from Access VBA Is there sites or books out there that can show me how to transfer data and commands to excel and word using vba. I can open and so on. I am increasingly doing more of this and am trying to learn these codes to navigate the excel template or word template. I am specifically looking at worksheet and cell items. I am using a getobject command to do this but it gives me a new sheet. I want to open and existing sheet and place data where it needs to be. Help is no good for this or at least I cant find it. Any help would be appreciated. Pete
Mon, 06 Jan 2003 03:00:00 GMT

Michael Kuca #2 / 3	Creating excel Spreadsheet from Access VBA Check out the Microsoft Knowledge Base, and do a search on "automation". There's an automation help file that you can download. I'm sorry I don't have the exact address for you, but it's been quite a while since I've downloaded it to my machine. Good luck, -- Michael Kucan To respond via e-mail, remove all numerics from my address. -- Quote: >Is there sites or books out there that can show me how to transfer data and >commands to excel and word using vba. I can open and so on. I am >increasingly doing more of this and am trying to learn these codes to >navigate the excel template or word template. I am specifically looking at >worksheet and cell items. >I am using a getobject command to do this but it gives me a new sheet. I >want to open and existing sheet and place data where it needs to be. Help is >no good for this or at least I cant find it. >Any help would be appreciated. >Pete
Mon, 06 Jan 2003 03:00:00 GMT

Ian Prat #3 / 3	Creating excel Spreadsheet from Access VBA Pete, You need to learn the Excel Object Model and then you access it by automation from Access. A really good book is "Excel 2000 VBA - Programmer's Reference" by John Green, published by Wrox . Most of the techniques are valid for Excel 97 as well. It is well written and easy to follow. Regards Ian Pratt Quote: > Is there sites or books out there that can show me how to transfer data and > commands to excel and word using vba. I can open and so on. I am > increasingly doing more of this and am trying to learn these codes to > navigate the excel template or word template. I am specifically looking at > worksheet and cell items. > I am using a getobject command to do this but it gives me a new sheet. I > want to open and existing sheet and place data where it needs to be. Help is > no good for this or at least I cant find it. > Any help would be appreciated. > Pete
Tue, 07 Jan 2003 03:00:00 GMT

Page 1 of 1

[ 3 post ]