Bls: Re: $$Excel-Macros$$ Inserting BMP (Bitmap) Images Into A Predefined Cell Size

2013-10-03 Thread De Premor
g BMP (Bitmap) Images Into A Predefined Cell Size Hi De Premor, Yes this pretty much close to what I am looking for. Many thanks. On Thursday, October 3, 2013 10:44:12 PM UTC-4, De Premor wrote: > try this attached file, i hope you can find something there > > On 03-10-201

Re: $$Excel-Macros$$ Inserting BMP (Bitmap) Images Into A Predefined Cell Size

2013-10-03 Thread Bill Q
Hi De Premor, Yes this pretty much close to what I am looking for. Many thanks. On Thursday, October 3, 2013 10:44:12 PM UTC-4, De Premor wrote: > try this attached file, i hope you can find something there > > On 03-10-2013 7:22, Bill Q wrote: > > Hi Ashish, > > I put the macro in

Re: $$Excel-Macros$$ Inserting BMP (Bitmap) Images Into A Predefined Cell Size

2013-10-03 Thread Bill Q
Hi Ashish, Unfortunately, it has failed again. The message I get indicates... Run Time error '1004' "Insert method of pictures class failed". Not certain if it matters, but I am inserting bitmaps (.bmp). I am also using Excel 2007. On Thursday, October 3, 2013 9:54:51 AM UTC-4, ashish

Re: $$Excel-Macros$$ Inserting BMP (Bitmap) Images Into A Predefined Cell Size

2013-10-03 Thread ashish koul
try this Sub test() ActiveSheet.Pictures.Insert ("C:\Users\admin\Desktop\Excel Tips & Tricks\01.jpg") With ActiveSheet.Shapes(ActiveSheet.Shapes.Count) .LockAspectRatio = False .Left = Range("a1").Left .Top = Range("a1").Left .Width = 180 .Height = 180 End With End Sub On

Re: $$Excel-Macros$$ Inserting BMP (Bitmap) Images Into A Predefined Cell Size

2013-10-02 Thread ashish koul
try this see if it helps Sub test() ActiveSheet.Pictures.Insert ("C:\Users\admin\Desktop\Excel Tips & Tricks\01.jpg") With ActiveSheet.Shapes(ActiveSheet.Shapes.Count) .Left = Range("a1").Left .Top = Range("a1").Top .Width = Range("a1").Width .Height = Range("a1").Height End With

$$Excel-Macros$$ Inserting BMP (Bitmap) Images Into A Predefined Cell Size

2013-10-02 Thread Bill Q
Hi, I know how to insert the image. The thing is I want the cell to always be always the same size. Any advice ? Thanks. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.