PDA

View Full Version : Pics not being copied



zebradoby
11-19-2007, 04:17 PM
I have these pics at the bottom of Valuation Workskeet in SourceFile2.xls. When I run the macro, only the top 2 pics get copied over at the bottom of Valuation Worksheet of Sourcefile2.xls. But the remaning pics do not get copied over. There are 6 pics altogether. Rest of the pics do not get copied over. And the 2 pics copied also are not exactly at the same spot as source file.

Can anyone please help with these 2 issues?



I am saving 3 files in 2 separate zip files (Orig Macro and Template/Source File2).

To Run the macro:
1. Save the Template on C:\
2. Select SourceFile2.xls
3. Click Run on OrigMacro5.xls
4. Select SourceFile2.xls to process
5. File is saved at C:\

zebradoby
11-19-2007, 04:17 PM
I have these pics at the bottom of Valuation Workskeet in SourceFile2.xls. When I run the macro, only the top 2 pics get copied over at the bottom of Valuation Worksheet of Sourcefile2.xls. But the remaning pics do not get copied over. There are 6 pics altogether. Rest of the pics do not get copied over. And the 2 pics copied also are not exactly at the same spot as source file.

Can anyone please help with these 2 issues?



I am saving 3 files in 2 separate zip files (Orig Macro and Template/Source File2).

To Run the macro:
1. Save the Template on C:\
2. Select SourceFile2.xls
3. Click Run on OrigMacro5.xls
4. Select SourceFile2.xls to process
5. File is saved at C:\