+ Reply to Thread
Results 1 to 5 of 5

Changing code name of excel 2010 sheet using word 2010 vba

  1. #1
    Registered User
    Join Date
    08-10-2012
    Location
    germany
    MS-Off Ver
    Excel 2003
    Posts
    34

    Changing code name of excel 2010 sheet using word 2010 vba

    Hello guys,
    I hope somebody out there can help me with the problem I am facing.
    I have some word 2010 VBA codes that open a new excel 2010 sheet and now I want to change the code name of the active excel sheet from word vba itself.
    the codes that i am using to change the code name of the excel sheet dont seem to work .
    Please Login or Register  to view this content.
    the error message that i am getting is "The programatic access to the visual basic project is not safe"

    thank you.

  2. #2
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Changing code name of excel 2010 sheet using word 2010 vba

    you need to trust access to the vb project in the Trust Center settings
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  3. #3
    Registered User
    Join Date
    08-10-2012
    Location
    germany
    MS-Off Ver
    Excel 2003
    Posts
    34

    Re: Changing code name of excel 2010 sheet using word 2010 vba

    thnx for the reply, but how can I do that?

  4. #4
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Changing code name of excel 2010 sheet using word 2010 vba

    File-Options-Trust Center and click the Trust Center Settings... button and then in the Macro Settings section check the 'Trust access to the vba project object model' option

  5. #5
    Registered User
    Join Date
    08-10-2012
    Location
    germany
    MS-Off Ver
    Excel 2003
    Posts
    34

    Re: Changing code name of excel 2010 sheet using word 2010 vba

    Thanks will try it out..

+ 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. Importing data from an Excel 2010 worksheet into a Word 2010 form.
    By Kuriakos in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-27-2012, 02:49 PM
  2. Copying worksheets from excel to word in vba as images
    By papasideris in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-18-2012, 11:32 AM
  3. Searching the particular numberfrom excel'2010 table and locate the number in Word'2010
    By jaffirahamed1 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-21-2012, 08:09 AM
  4. Code for Forms from Word 2010 to Excel 2010
    By birth19 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-29-2011, 05:38 AM

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