Solved

Is there a way to pick up the date picture was created when importing a picture via VBA

Posted on 2010-11-22
2
263 Views
Last Modified: 2012-08-13
Hi experts

I'm using the VBA code below to insert a picture into Word. I'm wondering if there is a way to pick up the date the picture was created as if it is before a certain date I need to handle it differently.
Dim oDialog As Word.Dialog, lngPictureSize As Double
 Set oDialog = Dialogs(wdDialogInsertPicture)
 Dim pic As InlineShape
 
  With oDialog
    .Display
    
Application.ScreenUpdating = False
    
    If .Name <> "" Then
             Set pic = ActiveDocument.InlineShapes.AddPicture(FileName:=.Name, _
            LinkToFile:=False, _
            SaveWithDocument:=True, _
            Range:=Selection.Range)

Open in new window

0
Comment
Question by:Fi69
2 Comments
 
LVL 76

Accepted Solution

by:
GrahamSkan earned 250 total points
ID: 34195206
This line:

            LinkToFile:=False, _

means that you can't do it later.


But you can do this to decide whether the picture is new enough to add to the document.
Dim oDialog As Word.Dialog, lngPictureSize As Double
    Dim pic As InlineShape
    Dim myDate As Date
    
    myDate = DateSerial(2009, 11, 23)
    
    Set oDialog = Dialogs(wdDialogInsertPicture)
    With oDialog
        .Display
        Application.ScreenUpdating = False
        If .Name <> "" Then
            If FileDateTime(.Name) > myDate Then
            
            Set pic = ActiveDocument.InlineShapes.AddPicture(FileName:=.Name, _
                      LinkToFile:=False, _
                      SaveWithDocument:=True, _
                      Range:=Selection.Range)

Open in new window

0
 

Author Closing Comment

by:Fi69
ID: 34200785
Perfect.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.
This Micro Tutorial well show you how to find and replace special characters in Microsoft Word. This is similar to carriage returns to convert columns of values from Microsoft Excel into comma separated lists.

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question