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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

This article describes how to use the Send to Mail Recipient command. The instructions apply generally to Office 2007 and later versions, but Microsoft® Word 2013 was used for the specific steps and figures.  What is Send to Mail Recipient? Send…
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
In this video, we show how to convert an image-only PDF file into a PDF Searchable Image file, that is, a file with both the image (typically from scanning) and text, which is created in an automated fashion with Optical Character Recognition (OCR) …
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.

939 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now