Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: larrykathy
  • Content: Threads
  • Order by date
  1. larrykathy

    Copy Range in Excel Tip

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

    Resize the ole object (picture) in excel sheet

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

    Loop through columns

    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 =...
  4. larrykathy

    Paste into a form image control

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

    Email an excel 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...
  6. larrykathy

    Photos in DB

    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

Part and Inventory Search

Back
Top