Hi Folks,
I use a macro to import pictures from a folder, but is not working perfectly.
If you check, this macro (see txt attachment) insert pictures in a sheet and create "footers" above the picture with texts.
Somehow the pictures insert points moving down slowly, and I can see growing difference between the "footer" and the picture (after 10 pictures is around 1/8 cell size....)
Do you have any idea how can I fix it? (my row height is default: 12.75)
Thanks,
encleadus
Check out how to post code here: http://www.excelforum.com/forum-rule...rum-rules.html
<----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left
If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.
Sorry,
here is my code:
Please Login or Register to view this content.
Excellent! I'm having a look now.
I took the freedom to mess around quite a bit with your code and made some modifications to make it run faster.
I think this does what you want.
Please Login or Register to view this content.
Thank you very much, it's worked perfectly!
Could you tell what what was the problem with my code? Why changed the difference between the merged cells and the inserted pictures?
encleadus
Here is a slight improvement, a basic errorhandling. If you specify more files than are available it just exits with no drama.
Please Login or Register to view this content.
Good to hear it worked!
I don't know for sure what was wrong with your code, I think maybe Excel has a problem with decimal numbers in row heights.
That's why I skipped that and referenced the position to the closest header cell instead.
I didn't need different names for the ranges in the end. Forgot to clean that up.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks