You've created a named range on an Excel worksheet. You have placed photos into the specific range. Now how do you copy everything in that range to paste them into another workbook?
Very easy!!!!
1. Select the named range
2. Hold down SHIFT and click Copy Picture on the Edit menu
3. Open your...
Using VB, I select a photo and drag-drop it over a button. That opens another form that has an ole on it. The excel sheet opens on that form through the ole and displays nicely. Then the photo is pasted into the ole-excel sheet perfectly. All I'm trying to do now is resize the photo through code...
Using Excel VBA
First I'm finding the number of columns on a sheet with data....
"TheLastCol = ActiveSheet.Cells.Find(What:="*", SearchDirection:=xlPrevious, SearchOrder:=xlByColumns).Column" This gives me say 28...
Second, I use this line.......
"FirstCol =...
Here goes
How do I paste a photo I've edited with excel into an access form image control. I have the form set up so that when you double click on the image control, it will open excel (set objxl = excel.application) and I can then edit the photo, add text boxes, etc. Now I was thinking I could...
Sure could use some help.
I have a xls file on the network and I want other people to make additions to the file if I email them. I can sucessfully complete this by using the copy range/cells--and then--paste special link in outlook. No problem.
Any ideas how to do that in VBA? This is very...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.