Access to Excel (2003 version) VBA coding help

[iamstupid]

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

 

[Beetle]

To answer your overall question, Yes, what you're describing can be done. However, there is not enough info in your post to give specifics on how to do it. You would need to provide more details, such as;

Are you transferring one Investors data at a time, or many?

Does each set of Investor data need to be transferred to different worksheets within the same Excel workbook? To different copies of the workbook?

What if an investor chooses stock1, stock2 and stock8? Does it need to transfer to Cell1, Cell2, skip 5 cells, then Cell8?

If you want a few examples of methods that can be used, see;

http://www.btabdevelopment.com/ts/default.aspx?PageId=10