Cannot solve array issue

[Acme]

Hi. I have hit a roadblock trying to send data to excel. I have created a table of Arrays where each record has an ArrayID, a record ID, an X unit and a Y unit. I want to be able to pick an ArrayID from a form and send the corresponding X and Y values to excel as part of a Linest calculation. I have tried over and over again, read numerous posts, and just do not have the experience. Instead of posting the code here, I am hoping someone can help. I am willing to email a $100 amazon gift card to the first person that provides the VBA code (access 2013). I hope this is allowed

 

[JHB]

I do not think the members are here to make money, but to help others or like you to get help from others.
But to get help it is necessary that you investigate a little time in it.
As a minimum, to show your code and tell where things go wrong and if there are error messages to display it.
What's even is better, is to post your database with some sample data and to tell which form/ module you use, (zip it if you haven't post 10 post yet), because there are thousands of ways to get data from MS Access to an Excel spreadsheet, and whether the data comes from an Array or from a recordset, it is more or less the same.
And since you have not been able to find examples on the Internet that matches your code, will it be for members that will help you, to guess your code, like winning the lottery.

 

[Acme]

Thx but I figured it out. Took all night tho

 

[JHB]

Good you got it - luck with your project, (only one night, that isn't so much ).