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, 02:13 PM
By Jared Evans in forum VB Classic
Last Post: 05-29-2003, 04:44 PM
By Miroslav St. Jeliaskoff in forum .NET
Last Post: 10-03-2002, 09:08 AM
By Bob in forum VB Classic
Last Post: 03-14-2002, 02:27 PM
Last Post: 12-23-2000, 08:42 AM
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center