Results 1 to 2 of 2
  1. #1
    iamstupid is offline Novice
    Windows 2K Access 2003
    Join Date
    May 2011
    Posts
    3

    Access to Excel (2003 version) VBA coding help




    Hi guys, I can’t seem to find any resources online regarding my problem. In fact, I don’t even know how to start! Basically:
    - An investor can choose to acquire a maximum of 8 stocks for his/her portfolio
    - So for example, investor1 just chooses stock1, stock2 & stock3
    - The problem here is how to export these 3 stocks into the 8 fields as given in excel(I have to follow the excel template) . I cant just simply use “.cells(… , …)” as it needs to be in order eg cell 1 = stock1 , cell 2 = stock2, cell3= stock 3 , the rest of the 5 cells is left empty
    - So how do I sort of like “count” from access and export these data to fill in the excel cells accordingly based on the investorID (as different investors can purchase different no. of stocks)
    I hope this is possible to do so as it seems rather complex… I sincerely hope you guys can help me out here and I thank you all in advance for any advice

  2. #2
    NTC is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    Nov 2009
    Posts
    2,392
    I don't fully follow your post; Access exports to excel generically very simply as you probably know..........but depending on how I interpret your post - if your excel sheet has a fixed layout and you want Access data to populate specific cells; then with this approach one uses an Access query to gather the correct data. that's the extent of Access' role. One uses the excel feature of linking to an outside data source to link to the Access query - - on which you will get better assistance from excel experts on this.

    not sure this helps....maybe....

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 09-09-2015, 03:11 PM
  2. What version of VB does Access use
    By zapper222 in forum Programming
    Replies: 1
    Last Post: 08-03-2010, 03:54 PM
  3. MS Access 2003+Ms Excel 2007 Issue
    By putnum in forum Access
    Replies: 3
    Last Post: 12-20-2009, 09:24 PM
  4. Replies: 0
    Last Post: 05-07-2009, 02:32 PM
  5. Import Excel Worksheets into Access 2003
    By KramerJ in forum Programming
    Replies: 0
    Last Post: 03-18-2009, 04:11 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums