Recent content by eddie84

That makes sense. One point of confusion left. My supervisor asked me to first write a function in Access to export a sorted query to Excel (the query has Locations, in one case), then create a button that will refresh the Excel lists. This dao.recordset code is tied to a Updating Locations...

So, I do see a reference to a range: I'm guessing that in application, the field names don't really matter as long as you are referring to the specific sheet and it knows where to start? " Copy Replacement Worksheet Records With objShtLoc...

I do not see anything about fields in the code using DAO.recordset.

Thank you for asking that. I see from looking at the FE that it was done via DAO.recordset . Which I know nothing about.

Hmm, not following you on this one. To give you an example; In Access, I have a table called 'Locations'. I create a query of this for the purposes of Exporting it to Excel. In Excel, I also have a sheet named Locations. BUT, while both the table in Access and Sheet in Excel represent the same...

Yes. This is what I was thinking as well. How about the difference in field names?

Thank you. This makes sense. The name/path would actually be constant, so I am fine with using RunSavedImportExport. But two things I can't seem to figure out: a. how do I export from Access to Excel to a specific Sheet (Worksheet) that exists in that Workbook? I keep replacing the WHOLE excel...

I'm trying to export a sorted Query into Access via the BE. The query represents data required for a drop-down in Excel. Essentially, the goal is, if records are changed (added or deleted) on the Access side, I want these changes to be exported (pushed) to Excel. So first step is to create a...