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?
By Werner in forum VB Classic
Last Post: 06-15-2005, 03:13 PM
By Jared Evans in forum VB Classic
Last Post: 05-29-2003, 05:44 PM
By Miroslav St. Jeliaskoff in forum .NET
Last Post: 10-03-2002, 10:08 AM
By Bob in forum VB Classic
Last Post: 03-14-2002, 03:27 PM
Last Post: 12-23-2000, 09:42 AM
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL