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

Are your AD admin tools letting you down?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

Question has a verified solution.

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

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.
Using Word 2013, I was experiencing some incredible lag when typing.  Here's what worked for me....
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

821 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