+ Reply to Thread
Results 1 to 8 of 8

The fastest way to saved workbook copy and open it as invisible

  1. 09-27-2018, 07:35 AM #1
    jaryszek
    jaryszek is offline
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016-365
    Posts
    2,940

    The fastest way to saved workbook copy and open it as invisible

    hi,

    like in topic,
    what is your solution to saved copy from active workbook and open it as invisible and do it as quick as possible?

    I have to open saved copy of workbook and delete certain sheets from it...

    please help,
    best,
    Jacek
    Reply With QuoteRegister To Reply
  2. 09-27-2018, 11:19 AM #2
    Kaper
    Kaper is offline
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,616

    Re: The fastest way to saved workbook copy and open it as invisible

    Have you checked 
    Please Login or Register  to view this content.
    ?
    In general, I'd say that I/O operations on files (especially excel format) are rather slow in excel.
    Best Regards,

    Kaper
    Reply With QuoteRegister To Reply
  3. 09-27-2018, 02:30 PM #3
    jaryszek
    jaryszek is offline
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016-365
    Posts
    2,940

    Re: The fastest way to saved workbook copy and open it as invisible

    hi,

    i tried this.
    But i have to open this and delete some sheets.
    Not on current workbook but in copy.

    Did you try this code?:

    Please Login or Register  to view this content.
    or this one?

    Please Login or Register  to view this content.
    or this one ?:

    Please Login or Register  to view this content.
    codes are from here:
    https://stackoverflow.com/questions/...ithout-display

    what methos is the best?

    Best,
    Jacek
    Reply With QuoteRegister To Reply
  4. 09-28-2018, 03:24 AM #4
    jaryszek
    jaryszek is offline
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016-365
    Posts
    2,940

    Re: The fastest way to saved workbook copy and open it as invisible

    Anyone?

    @rorya you have always answer for my post

    Jacek
    Reply With QuoteRegister To Reply
  5. 09-28-2018, 05:38 AM #5
    jaryszek
    jaryszek is offline
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016-365
    Posts
    2,940

    Re: The fastest way to saved workbook copy and open it as invisible

    i tried use code:

    Screenshot_20.png

    sorry i can not paste it - some firewall is blocking it...

    but this is deleting from my active workbook, not copy...
    how can i do this?

    Best,
    Jacek
    Reply With QuoteRegister To Reply
  6. 10-01-2018, 04:03 AM #6
    jaryszek
    jaryszek is offline
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016-365
    Posts
    2,940

    Re: The fastest way to saved workbook copy and open it as invisible

    Anyone?

    Jacek
    Reply With QuoteRegister To Reply
  7. 10-02-2018, 12:34 PM #7
    jaryszek
    jaryszek is offline
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016-365
    Posts
    2,940

    Re: The fastest way to saved workbook copy and open it as invisible

    Any way?

    Best,
    Jacek
    Reply With QuoteRegister To Reply
  8. 10-03-2018, 01:07 AM #8
    jaryszek
    jaryszek is offline
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016-365
    Posts
    2,940

    Re: The fastest way to saved workbook copy and open it as invisible

    Hi,

    crossed post is here:

    https://www.mrexcel.com/forum/excel-...ml#post5153447

    Best,
    Jacek
    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. Invisible Workbook OPEN
    By Logit in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-30-2016, 11:16 AM
  2. Fastest way to copy values from one workbook to another
    By Ztv in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-17-2014, 03:31 AM
  3. Fastest way to copy old workbook into new workbook to change to current year and wk ending
    By kedeling in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-06-2013, 04:27 PM
  4. fastest way to retrieve saved data for editing.
    By foxguy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-05-2012, 04:49 AM
  5. Save an open workbook, then open template workbook and close the saved workbook
    By ondvirg in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-27-2009, 10:20 PM
  6. [SOLVED] How can I see a copy of a saved workbook before I saved it again?
    By Norma in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-11-2005, 06:06 AM
  7. [SOLVED] Unable to open saved workbook
    By CVS in forum Excel General
    Replies: 4
    Last Post: 02-06-2005, 01:06 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