Manipulating embedded objects

[AndyE]

I've cobbled some code together to embed a file to the next empty cell in a column on a worksheet, as follows.


What I can't figure out is how to change the size of that object to make it more manageable within the table. I'm assuming that I would have to rename the object to identify it & therefore be able to locate it. At the moment each embedded file follows standard naming convention, i.e. , Object 1, 2........


It is was to have to be renamed, I would like the name to reflect the adjacent cell contents, cell A2 data, cell B2 data, cell C2 embedded file.

Please Login or Register  to view this content.

Thank you

[Zer0Cool]

It looks to me glancing over your snippet and without a sample file to test that you are looping cells and if the contents length = 0 then selecting the cell. You then set the value of the cell to "Y". It then appears to me that your adding the object based on the implied selected cell?

First, the cell.select is not a good way to go about this. Most objects in Excel/VBA do not need to be selected to act upon them. Doing so is both slower and more prone to issues than simply acting upon the object.

IE:

Please Login or Register  to view this content.

No need for select in the psuedo code above. Same result, 1 less line of code and no need to change selections.

That however then leaves you needing to explicitly place the object as desired which I am not sure of how to do off the top of my head.

However, it does lead us to the answer to your question in a general sense.

If you drop selection as the method for how you manipulate things, then your object insertion would likely take place within your loop (if inserting multiple files). Either way, your best bet is to use a variable for the object for either the single object you will insert or each object you insert within the loop. By assigning/setting it to a variable you can then act upon it using the variable easily.

If you post a sample I could take a stab at it.

[AndyE]

File added.

Yes, you've got what I'm trying to do. As you can see from the file with the code above I'm trying to add the corresponding external file to Column C in the "Table1" sheet which will accompany the table entries for that file.


Hope that makes it clearer.

[AndyE]

I've found a workaround.