DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Workbook not Closing Properly by Excel VBA

  1. #1
    Join Date
    Nov 2005

    Thumbs down Workbook not Closing Properly by Excel VBA

    I am stumped by this problem!
    I have written code to open an excel workbook.
    modify information through a user form
    & repost to the workbook and then
    close the workbook.
    the code then calls a Sub to rename the folder the workbook is in.
    Everything works fine Untill renaming the folder then I get I get error 75
    (path/file access error).
    While keeping excel open,
    I have tried to manually renaming the folder and get a Windows Sharing Error
    If I close Excel I can rename the folder immediatly
    therefore I think Excel VBA is not closing the file proprerly (totaly??)

    is the rename folder code processing before the save & close procedure is complete?
    Can anyone explain what has happend & how to fix it?


  2. #2
    Join Date
    Dec 2003
    Where is code located that renames the folder the workbook is in?
    Microsoft MVP (Visual Basic)

Similar Threads

  1. Matching data macro in VBA Excel
    By Werner in forum VB Classic
    Replies: 2
    Last Post: 06-15-2005, 02:13 PM
  2. Excel, VBA, SQL, DAO 3.6 help needed
    By Jared Evans in forum VB Classic
    Replies: 2
    Last Post: 05-29-2003, 04:44 PM
  3. Closing Excel
    By Miroslav St. Jeliaskoff in forum .NET
    Replies: 4
    Last Post: 10-03-2002, 09:08 AM
  4. Need Help with VBA for Excel
    By Bob in forum VB Classic
    Replies: 0
    Last Post: 03-14-2002, 03:27 PM
  5. Replies: 1
    Last Post: 12-23-2000, 09:42 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
HTML5 Development Center
Latest Articles
Questions? Contact us.
Web Development
Latest Tips
Open Source

   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center