ANmarS - Search results

Excel/VBA expert since Sep 1997 (21 years 2 months)

We are moving ...

We are moving to another location, better, faster and more resources .... check it out ANmar.Systems

3 Q & A posts found in year 2012

Mon
Feb 6
2012

Copy pictures from sheet to another

i have two workbooks, lets say, workbook A and Library Workbook
Workbook A is where all the code has been going, Library has no code in it. My project in Workbook A needs to look up and pull a worksheet out of Library Workbook - just a direct copy. Simple enough in general, only one problem. Most of the sheets in Library Workbook have images embedded in them that dont get copied when doing a direct Workbooks(Library)Cells.Copy
i can get all of the formatting, column widths, and values/formulas, but not the images
now, there is one thing i havent tried that I think will work, but it has drawbacks...i could copy the entire sheet, not just the cells, but the sheet itself and put it in Workbook A. I think that this would work in theory, but Im reluctant to try it for one reason
I have embedded sheet code in Workbook A in the sheet that I want to be the destination for the copied library contents. The sheet code is event-based, and Id like it to stay in the code. So I was trying to paste the library contents into this sheet to retain the sheet code, where if I paste the entire sheet directly from the library, I dont get to keep the sheet code, because the library, by definition, is supposed to be (vba free)

so...Ive been chasing two different possible solutions, neither one with much luck yet.
(1) Learn how to copy cells from a worksheet with the images included
i know you can use vba to copy images, but the sheets have varying numbers of images, so theres no good way to programatically handle all sheets
shapes(1).copy, ...
might be more than one image


Answer

you still can use shapes.count and start a loop, did you tried that?
however, there might be a downside, when you copy and paste, they will all be over each other, but you can override it by using:
Sheet1.shapes(x).left = Sheet2.shapes(x).left
sheet1.shapes(x).top = sheet2.shapes(x).top
assuming copying shape from Sheet2 to Sheet1
does that make sense?

Monday 2/6/2012
Sat
Jan 14
2012

Showing Arabic numeric in Word app

I have a question man, how can I change the numbers in Microsoft word 2010 from English to Arabic or I should say from Arabic to Latin? Thanks


Answer

I guess you meant from Arabic to Hindi, right?
here is the link to that in Word 2010
http://folder8.com/View/?A55FYE54TM73QB22WP7

In Word 2007
http://folder8.com/View/?6750

And in Word 2003
http://folder8.com/View/?AFI1X17TVDJT

Saturday 1/14/2012
Fri
Jan 13
2012

Opinion: memorizing maps?

I was just wondering if anyone else thought that memorizing maps (of countries) is completely useless.
In these times, if you wanted to study a riegon of the world, all you have to do is LOOK at maps...memorizing them seems un-necessary...because when would you ever not have access to a map?
I have noticed this too often in my school. Whenever the classes have map tests.....everyone would freak and put all their short term memory to the test. you see them the next week (or even day) and they don't remember a thing about the map. Just the whole idea of it seems stupid.
I would like anyone's ideas. If you don't agree with me, why do you think it's important to memorize maps?


Answer

So when some one told you "I am from Uganda", you are like, "hold on, let me see my MAP!".
I seam to understand the reason especially In this country of multi-culture.
The world is getting smaller and smaller (I mean the technology jumps for the last 2 decades) and therefore people are getting closer and closer to each other.
That when these maps are important, this is at least my opinion.

Also: besides the fact that people are depending more and more on machines now, there should be plenty of space to memorize other facts, don't you agree?

Friday 1/13/2012 5:15:36 AM

Tags

History