Hi All,
I am new to the forum and to VBA. Below is an extract of code I have written which aims to format the margins and headers based upon the version of excel the template is opened in. It works perfectly except for the formatting of the existing center header picture. Please advise
Please Login or Register to view this content.
You did not explain whether the problem is with Excel2007 or Excel2010 or both.
And you did not explain what it is doing wrong. Is it placement, size, ... etc?
Instead of accepting the current image, delete it, and instead add it in via VBA and see if that solves the problem
- this is the VBA that you need to add (amend the file path to your image)
Tested with Excel2010 (do not have 2007 on my machine)Please Login or Register to view this content.
Incidentally your code will be ignored if anyone is running anything after 2010.
You could amend:
to:Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by kev_; 06-06-2017 at 04:42 AM.
Click *Add Reputation to thank those who helped you. Ask if anything is not clear
Thanks Kev,
The issue is that I get a Runtime Error 1004 when I run the code. I had considered this but am concerned that someone may delete the image or the file path could change. Is there any way to edit the existing image?
I've not tried it in 2007 yet, but I'm hoping it will run. Thanks for pointing out the version issue- I've ammended that now!
Thanks again,
Andrew.
I replicated Runtime Error 1004 when I deleted &[Picture] from the Center Section Header - so that is probably a big clue
How did you insert the picture originally? Like this perhaps?
InsertPicture.jpg
If you insert this into your code (within With ws.PageSetup) what does it return?
Please Login or Register to view this content.
Yes, I inserted the image in the page setup tab as you've shown. Do I have to insert a new image each time? When I enter that line the message box says the file name of the existing image.
Many Thanks,
Andrew.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks