Excel Vba Runtime Error 481 Invalid Picture
Contents |
360 games PC games excel vba runtime error 5 invalid procedure call or argument Windows games Windows phone games Entertainment All Entertainment
Runtime Error 481 Invalid Picture Fix
Movies & TV Music Business & Education Business Students & educators excel vba runtime error 438 Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security Internet
Excel Vba Runtime Error 9 Subscript Out Of Range
Explorer Microsoft Edge Skype OneNote OneDrive Microsoft Health MSN Bing Microsoft Groove Microsoft Movies & TV Devices & Xbox All Microsoft devices Microsoft Surface All Windows PCs & tablets PC accessories Xbox & games Microsoft Lumia All excel vba runtime error 1004 Windows phones Microsoft HoloLens For business Cloud Platform Microsoft Azure Microsoft Dynamics Windows for business Office for business Skype for business Surface for business Enterprise solutions Small business solutions Find a solutions provider Volume Licensing For developers & IT pros Develop Windows apps Microsoft Azure MSDN TechNet Visual Studio For students & educators Office for students OneNote in classroom Shop PCs & tablets perfect for students Microsoft in Education Support Sign in Cart Cart Javascript is disabled Please enable javascript and refresh the page Cookies are disabled Please enable cookies and refresh the page CV: {{ getCv() }} English (United States) Terms of use Privacy & cookies Trademarks © 2016 Microsoft
Forum Microsoft Office Application Help - Excel Help forum Excel Programming / VBA / Macros Runtime Error 481 Invalid Picture To get replies by our experts at nominal charges, follow this link to buy points and post your thread in our Commercial Services
Excel Vba Runtime Error 91 Object Variable Or With Block Variable Not Set
forum! Here is the FAQ for this forum. + Reply to Thread Page 1 of
Excel Vba Runtime Error 1004 Application-defined Or Object-defined Error
2 1 2 Last Jump to page: Results 1 to 15 of 18 Runtime Error 481 Invalid Picture Thread Tools Show Printable Version excel vba runtime error 1004 select method of range class failed Subscribe to this Thread… Rate This Thread Current Rating Excellent Good Average Bad Terrible Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 08-04-2011,09:24 AM #1 HangMan View Profile View Forum https://support.microsoft.com/en-us/kb/974899 Posts Forum Contributor Join Date 06-21-2010 Location - MS-Off Ver Excel 2010 Posts 1,204 Runtime Error 481 Invalid Picture I have a spreadsheet with a user form displaying different graphs based on a combo box user selection. This is based on John Walkenbach's solution and uses this code. Please Login or Register to view this content. This works perfectly in Excel 2007, however when the same file is run in Excel 2010, I http://www.excelforum.com/showthread.php?t=786930 get frequent 'Runtime Error 481 Invalid Picture' errors. Looking at Microsoft's site, there is a suggestion that I should use a BMP rather than a GIF file format (as this is a known Microsoft problem). Having amended the VBA accordingly, this made NO DIFFERENCE and the errors still happen. I also came across a site suggesting a 'HotFix' using an updated version of a file called 'mscomctl.OCX'. Having tried this, again, it makes no difference. I can save my file in Excel 2010, and reopen it in Excel 2007 and the errors don't occur. Has anyone come across this problem and found a successful resolution. Many thanks... Register To Reply 08-04-2011,09:39 AM #2 Andy Pope View Profile View Forum Posts Visit Homepage Forum Guru Join Date 05-10-2004 Location Essex, UK MS-Off Ver 2003, 2007, 2010 & 2013 Posts 17,492 Re: Runtime Error 481 Invalid Picture That test code works fine for me in xl2010. Try some tests. First try using the LoadPicture command on a gif file that you know is valid. Then try the ChartExport and use paint to check the file produced is valid. Also try jpg rather than bmp. Cheers Andy www.andypope.info Register To Reply 08-04-2011,09:53 AM #3 HangMan View Profile View Forum Posts Forum Contributor Join Date 06-21-2010 Location - MS-Off Ver Excel 2010 Posts 1,204 Re: Runtime Error 481 Invalid Pictur
picture ? If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the http://www.vbforums.com/showthread.php?609419-RESOLVED-Error-481-Invalid-picture register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 7 of 7 Thread: [RESOLVED] Error 481 - Invalid picture ? Tweet Thread Tools Show Printable Version Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode Mar 30th, 2010,07:29 PM #1 JohnSavage View Profile View Forum Posts runtime error Thread Starter Fanatic Member Join Date May 2006 Posts 612 [RESOLVED] Error 481 - Invalid picture ? I am trying to print a picture from the windows clipboard This is the code: Code: Clipboard.Clear Call keybd_event(VK_MENU, 0, 0, 0) Call keybd_event(VK_SNAPSHOT, 0, 0, 0) DoEvents Call keybd_event(VK_SNAPSHOT, 0, KEYEVENTF_KEYUP, 0) Call keybd_event(VK_MENU, 0, KEYEVENTF_KEYUP, 0) Printer.Orientation = 2 Printer.Print Printer.ScaleMode = vbCentimeters If Width > Printer.ScaleWidth Then lWidth excel vba runtime = Printer.ScaleWidth lHeight = (Printer.ScaleWidth / Width) * Height Else lWidth = Width lHeight = Height End If lWidth = lWidth - 3.2 lHeight = lHeight - 5 Printer.PaintPicture Clipboard.GetData, 2, 1, lWidth, lHeight Printer.EndDoc Debug reports: Error 481 - Invalid picture What am I doing wrong Reply With Quote Mar 30th, 2010,08:13 PM #2 RhinoBull View Profile View Forum Posts PowerPoster Join Date Mar 2004 Location New Amsterdam Posts 24,135 Re: Error 481 - Invalid picture ? Try this: Code: 'replace this line 'Printer.PaintPicture Clipboard.GetData, 2, 1, lWidth, lHeight 'with these: Dim myPicture As StdPicture Set myPicture = Clipboard.GetData() Printer.PaintPicture myPicture, 2, 1, lWidth, lHeight Printer.EndDoc Microsoft MVP - Visual Basic 2006-2013 Why VB clears the clipboard on startup and how to avoid it? . Filtering Arrays . Save File To Database . Extract File From Database . Extract picture from database without using hard drive . Change Menu BackColor . How to use MS Flexgrid . Make Frame Transparent . The Easiest Way to Create an NT Service With VB6 . How to comment blocks of code in VB5 and VB6 . How to find and replace missing members of control array Visual Basic 6.0 On-Line Documentation . Connection Strings