Changing Workbook Code Using a Macro

[jamesryan]

Hi,

I have a Macro that opens a file and gets data out, however within this macro i want to enter some code into the workbook module of the newly opened file.

Is this possible?

[royUK]

You can, but the VBA Project cannot be protected.

Google for Chip Pearson & search his site for VB Editor for sample code.

[jamesryan]

Hi Roy,

cheers for the reply, however after searching the site i acnnot find the sample code i'm looking for.

Any ideas?

Thakns

[royUK]

Read this page

http://www.cpearson.com/excel/vbe.aspx