Export Information to specific Cells in Excel by way of button

fixemup27

Registered User.
Local time
Today, 09:52
Joined
Feb 23, 2012
Messages
11
Hello All. I have been rummaging through lines and lines of code and just when I think Ive got something, I hit another wall. Simply put, I need a code that allows the user to Click a button, information in a table exports to specific cells in an Excel spreadsheet, and that is it. There has to be a more simple approach to this than what Ive been finding.

It's mostly how to reference the specific cells between Access and Export that I cant seem to get a grasp on

Ex: .Cells(1,1).Value = "(I need the value of the access cell here, how do I tell it that?)... in Row 2, Column 4"

- what does each "1" in the perenthasis after the ".Cells" represent and in which program Access or Excel?

- Also, Will the VBA need to be written in the Access VBA or Excel VBA to get this done?

Thanks!
 
You can write the code in either, I tend to "push" data from Access into Excel because most of the actual donkey work is being done in Access but you could easily do it the other way round.

Cells(1,1) simply means Row 1, Column 1 on the worksheet.
 
Understood. Now if I am filling out a form in Access and I want the information that is being entered in each box to export to specific cells in Excel, How do I tell it that. I provided attachments from the form I need information to export from, and the excel spread sheet and cells I need the information to export to. Thanks!
 

Attachments

Last edited:

Users who are viewing this thread

Back
Top Bottom