Workbook not Closing Properly by Excel VBA


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
    Posts
    1

    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?

    Blayne

  2. #2
    Join Date
    Dec 2003
    Posts
    2,750
    Where is code located that renames the folder the workbook is in?
    Paul
    ~~~~
    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, 02:27 PM
  5. Replies: 1
    Last Post: 12-23-2000, 08: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
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

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