Results 1 to 4 of 4

Thread: Access and excel question

  1. Jun 2nd, 2003, 08:36 PM #1
    Buy2easy.com
    Buy2easy.com is offline

    Thread Starter
    Addicted Member Buy2easy.com's Avatar
    Join Date
    Jul 2002
    Posts
    200

    Access and excel question

    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.
    Reply With Quote Reply With Quote
  2. Jun 3rd, 2003, 04:51 PM #2
    MileOut
    MileOut is offline
    Lively Member MileOut's Avatar
    Join Date
    Nov 2001
    Location
    Glasgow
    Posts
    83
    Link
    Reply With Quote Reply With Quote
  3. Jun 3rd, 2003, 06:47 PM #3
    Buy2easy.com
    Buy2easy.com is offline

    Thread Starter
    Addicted Member Buy2easy.com's Avatar
    Join Date
    Jul 2002
    Posts
    200

    i got it

    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
    Reply With Quote Reply With Quote
  4. Jun 4th, 2003, 11:51 AM #4
    Ephesians
    Ephesians is offline
    Hyperactive Member
    Join Date
    Mar 2002
    Posts
    424
    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.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width