+ Reply to Thread
Results 1 to 2 of 2

Help with opening and closing workbooks

  1. #1
    Forum Contributor
    Join Date
    07-24-2012
    Location
    Denver, CO
    MS-Off Ver
    365
    Posts
    230

    Help with opening and closing workbooks

    Hello all,

    I have a testing workbook called "Alec" with a macro that opens up an excel file, copies information from it to "Alec", closes that workbook, opens another, and repeats the copying and pasting, over and over. The macro does this perfectly; however, every time it closes a workbook, I get that dumb message "Do you want to save this" and I have to continuously click "Don't Save". Is there a word or function or something that will do that for me? It's very tedious and I would prefer not to have to do it hundreds of times. Thank you,

    LaffyAffy13

  2. #2
    Forum Contributor
    Join Date
    07-24-2012
    Location
    Denver, CO
    MS-Off Ver
    365
    Posts
    230

    Re: Help with opening and closing workbooks

    Oh awesome. Never mind I found the answer online finally. Anyone with this same problem Just needs to place the word " False" after closing the workbook with VBA. Sorry guys

+ 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