+ Reply to Thread
Results 1 to 2 of 2

Can i insert embedded files (PDF) without fill and borders? Got macro for insertion.

  1. #1
    Registered User
    Join Date
    01-17-2015
    Location
    Denmark
    MS-Off Ver
    office 2010
    Posts
    1

    Can i insert embedded files (PDF) without fill and borders? Got macro for insertion.

    Hello Experts.

    I've found a macro with the function of inserting an embedded file, such as - Insert>Object>create from file>Browse.

    I would now like to be able to predefine the borders and lines of the insertet file, so there is none.

    My current macro goes like this:

    Sub Macro1()
    'declare a variable to hold the file name:'
    Dim FName As String

    On Error Resume Next

    'load the variable via an input box:'
    FName$ = Application.GetOpenFilename

    'get the file:
    ActiveSheet.OLEObjects.Add(Filename:=FName, _
    Link:=False, _
    DisplayAsIcon:=False).Select

    End Sub

    Is that possible?

    Thanks in advance.

    Regards - Emil

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474

    Re: Can i insert embedded files (PDF) without fill and borders? Got macro for insertion.

    Use code tags around code.

    Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

    Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

    You can edit your original post to add the code tags.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Macro to insert formula and fill down to last row
    By redzan in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 05-23-2014, 04:45 PM
  2. macro to print embedded pdf files in excel
    By sn79 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-18-2013, 03:26 PM
  3. exce; macro to open, save embedded pdf, word, excel, ppt files to a folder
    By mcledavid in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-16-2009, 05:17 PM
  4. Replies: 0
    Last Post: 09-16-2009, 05:11 PM
  5. Macro to insert row/fill cells
    By manny_cb in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-08-2008, 06:46 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1