This is a Macro that has taken me weeks of research to write, mainly because I have had no experience with Macro before and finding the information on how to write the different codes took alot of research so I am sharing this Macro on here so that anyone struggling with any part of their macro that is similar to mine can at least have a reference to start from, especially seeing as most of the Macro's I found had no real explanation to them and the code often didn't make any sense to someone who didn't know a thing about them!
1. The first part of the macro gets it to pause for 45 seconds before it is run (I have an outside program creating the files my macro needs and it triggers my macro so it has to wait before it starts for the files to be created.)
2. It then looks for a file path in the cell that has been called "JPEG" again this path is written by my outside program. So if the "picpath" = 0 (0 meaning the files isn't there) then got to "Start:" which as you can see sends it back to the start so that it pauses again. This stops the macro from crashing because even if the file isn't there it has a command to follow.
3. when the file has been created it then imports the file (an image) and puts it in the right place.
4. I then crops the image down to the sizes that I have specified (this was a bit of trial and error really) I just changed the numbers after it had been run a few times to suit what I needed.
5. It then looks at a different sheet to import a company logo. I done this last because the crop command crops all the pictures and it was cropping to logo down too which I didn't need it to do.
If this helps just one person it will be worth it! Good luck to any Newbies out there too... I feel for you!
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks