LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sumproduct wont update properly on closed workbooks vane0326 Excel Worksheet Functions 0 August 17th 06 03:26 PM
Closing Hidden Workbook when Active Workbook is Closed SusanK521 Excel Programming 5 September 24th 05 12:27 AM
closing excel after closing a workbook CWalsh[_2_] Excel Programming 3 January 21st 04 03:33 PM
Help on closing object properly Snedker[_2_] Excel Programming 4 December 26th 03 11:52 PM


All times are GMT +1. The time now is 08:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"