+ Reply to Thread
Results 1 to 4 of 4

Saving file seems to combine saving file with Personal.xlsb

  1. 04-24-2017, 03:52 PM #1
    taylorsm
    taylorsm is offline
    Forum Contributor
    Join Date
    01-09-2016
    Location
    USA,USA
    MS-Off Ver
    2016
    Posts
    1,192

    Saving file seems to combine saving file with Personal.xlsb

    This is part of a larger code, but this is how I save the file. It pops up and I put in the location and save. At that point, Personal.xlsb goes away and any changes to module is in THIS file. I have to close out of all to reopen and get personal.xlsb back. 



    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  2. 04-24-2017, 04:20 PM #2
    mike7952
    mike7952 is offline
    Forum Expert mike7952's Avatar
    Join Date
    12-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007, Excel 2016
    Posts
    3,520

    Re: Saving file seems to combine saving file with Personal.xlsb

    You have the workbook in your Personal Macro Workbook?

    Change 
    Please Login or Register  to view this content.
    TO 
    Please Login or Register  to view this content.
    Thanks,
    Mike

    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.
    Reply With QuoteRegister To Reply
  3. 04-24-2017, 04:47 PM #3
    taylorsm
    taylorsm is offline
    Forum Contributor
    Join Date
    01-09-2016
    Location
    USA,USA
    MS-Off Ver
    2016
    Posts
    1,192

    Re: Saving file seems to combine saving file with Personal.xlsb

    Smack my head against the wall!

    Thanks!
    Reply With QuoteRegister To Reply
  4. 04-24-2017, 04:48 PM #4
    mike7952
    mike7952 is offline
    Forum Expert mike7952's Avatar
    Join Date
    12-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007, Excel 2016
    Posts
    3,520

    Re: Saving file seems to combine saving file with Personal.xlsb

    Your welcome
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Functional code only works correctly after saving. Saving required each time file reopened
    By James2584 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-15-2016, 06:24 PM
  2. Excel 2016/Windows 10 Opening Hidden Personal.xlsb file instead of Desired File
    By Robert Gama in forum Excel General
    Replies: 1
    Last Post: 03-14-2016, 12:41 PM
  3. Problem with saving a workbook as a binary file (.xlsx -->>> .xlsb)
    By sanip in forum Excel General
    Replies: 0
    Last Post: 06-12-2015, 07:24 AM
  4. Personal.xlsb - Excel cannot open the file ‘~$PERSONAL.XLSB’
    By 0nyx175 in forum Excel General
    Replies: 0
    Last Post: 01-15-2015, 05:53 AM
  5. [SOLVED] Run PERSONAL.XLSB macro when any Excel file is opened
    By Aaron092 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-23-2014, 04:35 AM
  6. creating a loop for saving a file and increase a variable by one after every saving
    By freak11 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 08-23-2014, 01:28 PM
  7. Close Excel event to use with personal.xlsb file
    By richard.wilson in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-09-2014, 05:28 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1