Click to See Complete Forum and Search --> : Access and excel question
Buy2easy.com
Jun 2nd, 2003, 08:36 PM
ok i am writing a program in vba (inside access) and i need to be able to insert some info into an excel spreadsheet can it be done? if so could some one give me a starting point.
thanks ahead of time.
MileOut
Jun 3rd, 2003, 04:51 PM
Link (http://www.access-programmers.co.uk/forums/)
Buy2easy.com
Jun 3rd, 2003, 06:47 PM
hey thanks anyways guys/gals but i figured out a pretty easy way to do it. you can save the info to a text file from access and shell(to excel w/another worksheet) that when loaded opens the file and places the data in the correct cells. if anyone were to want more details or need to know how i did it because maybe you need to do it to then reply AND I WILL SEE WHAT I CAN TO ABOUT GETTING YOU SOME CODE TO HELP YOU out
Ephesians
Jun 4th, 2003, 11:51 AM
That's great, B2E. Let's hope you don't have to change the format or add any formulas like that.
If this is resolved, edit your first post and add *RESOLVED* in the title.
vbforums.com
Copyright Internet.com Inc., All Rights Reserved.