Open / edit excel macro in vba

[xarxas]

im trying to Open excel macro in vba to perform find and replace function in access.

any idea if this is possible?

Thank!

 

[ghudson]

You are trying to open Excel and you want Excel to perform a find and replace in a table in your Access database? If so, why not do everything in Access?

 

[xarxas]

You are trying to open Excel and you want Excel to perform a find and replace in a table in your Access database? If so, why not do everything in Access?

because i have lots of excel documents, and need to go manually to each file to change some "string". right now im be able to manipulate table, module and query in access, thats why i want to integrate this functionality (editing macro) from excel file.