Thanks. That's exactly what I was trying to learn.

I've been experimenting with trying to find how to create a dynamic Building Block that is based on a Field code value that the user will set. Specifically the user will set the File Path and File Name, and then I hope to have a set of building blocks that use those values.

In my current testing and learning, it appears the building block is being modified after a field update, and losing the Field code Doc Property, I gave it, thus becoming 'static' content.. So my current thought is to possibly recreate the building blocks when the user changes the file path and file name.

That make sense? I'll try and post back some sample code later in the week if I can. I'm still not sure if i'm taking the right approach yet.

The main goal is to have a set of building blocks of various tables that are OLE linked to Excel. And the user should be able to basically press a button, choose the new file, and then the building blocks with link to the tables in the new file.