Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Tell OS to refresh?
Is there a way, say after a file has been renamed using code, to force the
operating system to refresh so that it recognizes the change in the file name? Or do I need to pause my code for a few seconds to give it time to do this? Thanks much in advance. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Tell OS to refresh?
A file is renamed by saving it with a new name. The OS shouldn't have to
refresh since part of saving it includes writing that information to the directory. What are you trying to do that is causing problems? -- Regards, Tom Ogilvy "quartz" wrote in message ... Is there a way, say after a file has been renamed using code, to force the operating system to refresh so that it recognizes the change in the file name? Or do I need to pause my code for a few seconds to give it time to do this? Thanks much in advance. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Tell OS to refresh?
I am working on a utility for users to re-organize large numbers of files. It
allows the user to select multiple files in a folder (using file picker). The utility then prompts for a new name. The program loops through the array of file names and changes the name of each file to the new name and appends a new sequential number at the end. I was getting an error indicating that a file with that name already exists, even though the counter was incrementing, but I just found an error in my code that fixed it. Sorry - please disregard. Thanks for your time. "Tom Ogilvy" wrote: A file is renamed by saving it with a new name. The OS shouldn't have to refresh since part of saving it includes writing that information to the directory. What are you trying to do that is causing problems? -- Regards, Tom Ogilvy "quartz" wrote in message ... Is there a way, say after a file has been renamed using code, to force the operating system to refresh so that it recognizes the change in the file name? Or do I need to pause my code for a few seconds to give it time to do this? Thanks much in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy Excel functions formula and auto refresh refresh | Excel Worksheet Functions | |||
Create refresh button in worksheet to refresh Pivot Table Data | Excel Worksheet Functions | |||
Timing of automatic query refresh and macro pivot table refresh | Excel Programming | |||
Pivot Table REFRESH Flaw -- Saves Old Data in Selection Area AFTER REFRESH | Excel Programming | |||
Excel does not close from VB!! (when i refresh Refresh query with BackgroundQuery:=False) | Excel Programming |