Add a button with code into Excel

[hewstone999]

I have an export function in Access that exports data into Excel. From Access i want to create a button in Excel and add some code to that button.

Any ideas or help or any code i could use, thanks.

 

[DCrake]

Simple Software Solutions

From what you imply you want to create a new workbook, then add data to it, then add a button to the worksheet, then add code to the button events a bit laborious don't you think? Why not have an existing worksheet that has the button and the code already there and simply append the data to the worksheet? or an I missing something?

CodeMaster:

 

[hewstone999]

I point of my program is that a user can save/create a workbook anyway or i would of gone down that route of creating a existing one.

And yes that is what to do imply.

 

[DCrake]

Simple Software Solutions

Fair enough, What events and actions will this button be generating? The reason why I am asking is that how will it know how many rows/cols to process? Another suggestion is to create the code in the users personal.xls and have a menu item instead of a button to generate the code. For example I have spreadsheets coming in to me everyday from an external source. The format is aways the same it just the row count that changes. I have to import this data in access. I created forms and modules in Excel and added custom menu items that runs the code to vaidate the worksheet contents and append to Access. By placing this in the Excel Personal.xls you can access this code anytime you open a workbook.

David