View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
blayne blayne is offline
external usenet poster
 
Posts: 14
Default Workbook closed by VBA not Closing Properly

I am stumped by this problem!
I have written code to open an excel workbook
modify information through a user form
close the work book
then 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).
I have tried to manualy renaming the folder and get a Windows Sharing Error
therefore I think the file is not closing proprerly
If I close Excel I can rename the folder immediatly
Can ANYONE explain what has happend & how to fix it?

--
Fuzzy logix