Search results for query: *

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...

Here's how I finally succeeded frmCreateConcern.OLE1.DoVerb frmCreateConcern.OLE1.object.Application.WindowState = xlMaximized frmCreateConcern.OLE1.object.ActiveSheet.Paste frmCreateConcern.OLE1.object.ActiveSheet.Name = "New Concern"...

Thanks SkipVought but...... I need to be able to reference that photo/object I just pasted into the Excel sheet. I just keep getting "it says that object is not selected or set" error. After I discover how to reference that object then I can use your code, correct? Thanks for the reply. Larry

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...

Thank you all very much.... There is a wealth of information here! Thanks again Larry

Thanks Zathras for your reply It would be easier to work with column numbers? I couldn't figure that one out but if you look at the above line "TheLastCol" it gives me the number of the last column. If I could just loop through the columns by using column numbers it sure would seem...

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...

I was able to get this running, what ya think Sub WhatHyperLink() Dim WhatIsName As String Dim Link As String Dim msg As String Dim msg1 As String Dim msg2 As String Dim msg3 As String WhatIsName = ActiveWorkbook.Path & "\" & ActiveWorkbook.Name...

PBAPaul Thanks for the reply. That process would be fine, I'm just trying to do this in VBA, so that a user just clicks a button, up comes the new message box, with the hyperlink already inserted. The user thens selects who recieves the file and clicks send. Can this be done....send link...

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...

Just a quik question. Should I put photos in the database or just put a reference in a database to the photo location? TNX Larry

Try and put "textbox2".setfocus in the current controls AfterUpdate() event. eg....Private Sub textbox1_AfterUpdate() textbox2.SetFocus End Sub "textbox1" is the name of the control you enter text/number into. textbox2 would be where you want to go to. Hope...