VBA open Table In Excel

[rpadminserver]

Hello All..

I'm looking for VBA code that will open a specific table (data2xml) in excel.

The end result is to put this code in the on click procedure for a button.

Thanks all
Rob

 

[SydneyGeek]

Rob, assuming that you are running this from Access, you would first need to create an Excel object, then open the file, and then use Excel's GoTo feature to target the table. How far have you got with this already? Do you need a full routine, or just a pointer for getting to the table?

Denis

 

[rpadminserver]

Denis... Thanks for the response.
But if I understand you correctly you are recommending that I open excel then target the table and open the table in excel. My goal is to have a button (on an access form) that will open the specific table in excel.

Thanks
R

 

[Norie]

Rob

Is this a table in Access?

Why not just use TransferSpreadsheet or OutputTo?

 

[rpadminserver]

Thanks... That might be on the right track. I looked at both of those but I looks like I have to supply a destination (excel workbook) name.

This database (when finished) is going to be distributed to different users. These users are going to store their version of the database any where they want on their system

I'm looking for button that will open the table in excel and then the user, when done editing, will do a save as (in excel) and specify the location to save.

R

 

[SydneyGeek]

Rob, looks like I misunderstood the question.
If, as Norie asked, you want to transfer an Access table to Excel, use TransferSpreadsheet. Example in this thread...

EDIT: The above shows how to push the data to a specific file. You can capture that using a file picker if the file already exists, or make the Excel spreadsheet visible and then let the user save wherever they like.

Denis

 

[rpadminserver]

Perfect Thanks