+ Reply to Thread
Results 1 to 7 of 7

Cannot view personal workbook on doc extracted from database

  1. #1
    Forum Contributor
    Join Date
    02-01-2011
    Location
    london, england
    MS-Off Ver
    Excel 2016
    Posts
    179

    Cannot view personal workbook on doc extracted from database

    Hello,

    I've saved a macro to my personal workbook, but cannot see it on document extracted from a database.

    If I open a blank excel document I can see it every time, just not on the excel documents I extract from the database?

    extracted database document attached.

    excel forum to the rescue?
    Attached Files Attached Files
    Last edited by fabrecass; 02-04-2011 at 09:43 AM.

  2. #2
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Cannot view personal workbook on doc extracted from database

    How do you extract from the database? If the database actually starts Excel via automation, then no startup files will be loaded by default.
    Remember what the dormouse said
    Feed your head

  3. #3
    Forum Contributor
    Join Date
    02-01-2011
    Location
    london, england
    MS-Off Ver
    Excel 2016
    Posts
    179

    Re: Cannot view personal workbook on doc extracted from database

    I think it may extract to a template? Would an Add-in work?

  4. #4
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Cannot view personal workbook on doc extracted from database

    No, I don't think so, because the add-in wouldn't get loaded either, for the same reason.

  5. #5
    Forum Contributor
    Join Date
    02-01-2011
    Location
    london, england
    MS-Off Ver
    Excel 2016
    Posts
    179

    Re: Cannot view personal workbook on doc extracted from database

    Crap. Thanks for the help, don't think there's anything i can do!

  6. #6
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Cannot view personal workbook on doc extracted from database

    You'll either need to load Personal.xls yourself or simply close and restart Excel then open the extracted file.

  7. #7
    Forum Contributor
    Join Date
    02-01-2011
    Location
    london, england
    MS-Off Ver
    Excel 2016
    Posts
    179

    Re: Cannot view personal workbook on doc extracted from database

    maybe I didn't explain myself correctly, because an add-in seems to have done the trick, Thanks for the words of advice anyway!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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