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.
Printable View
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.
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
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.