Recent content by eoinm824

Thanks. The code you wrote with out defining things as objects doesnt work. the current implementation is as follows Private Sub Form_Load() Dim xl As Object ''Excel.Application Dim wb As Object ''Excel.Workbook Dim ws As Object ''Excel.Worksheet Dim ch As Object ''Excel.Chart Dim myRange As...

Hi, I am relatively new to access, and have no real knowledge of vba. I have a query that is pulling data from a table. What I want is to run vba code when i open a specific form that will plot this data to excel for a specific range of values. Currently I have the following but I do not know...