Hi All
I have a application I use at work for calculating Construction work. It containes small tables as you can se on the Picture.
Sometimes we are 2 or 3 that work on the project, like: Capenter on WB1, Bricklayer on WB2 and painter on WB3.
I can import the tables from a other WB, but I am a bit stuck on the best way to get the links Shapes and then get them placed the right place.
The links and Shapes are placed in Column A and are named with the cell.adress of the cell in column B.
The link is for Documents or pictures or drawings.
I have uploaded a sample WB if you would take a look.
Make a copy of the WB and save it as Source WB then close it. Then open Target WB and press THIS ONE, (Button)
Select the Source WB in the filedialog. This will loop trough each table in SorceSheet (SourceWB) and copy them to TargetSheet (TargetWB)
I would like to get the Shape And LINK copied and keep its place when pasted in TargetSheet.
If you run into any Password it is 123.
I hope some one can help me on this as I hope to get it ready for monday
Bookmarks