Finding who has a file open
- Thread starter Wulluby
- Start date
Debraj
Excel Ninja
Hi Wulluby,
Nice Search.. And really useful.. but what about XLSX..
Let me Try..
* Rename a Excel File to zip.(for example .. Example.xlsx to Example.zip). If its inform you some ##^%@$ information. Click Yes..
* Now UNZIP the Zip File.. in a Folder..
* There is Folder called docProps
* In the same Folder, a XML file named core.xml
* Open it in any XML editor (i.e InterNet Explorer, Notepad)
* In the XML file There was a metaTag called
Now I am sure someone from FORUM will find a way to read this TAG..
Lets wait..
Regards,
Deb
Nice Search.. And really useful.. but what about XLSX..
Let me Try..
* Rename a Excel File to zip.(for example .. Example.xlsx to Example.zip). If its inform you some ##^%@$ information. Click Yes..
* Now UNZIP the Zip File.. in a Folder..
* There is Folder called docProps
* In the same Folder, a XML file named core.xml
* Open it in any XML editor (i.e InterNet Explorer, Notepad)
* In the XML file There was a metaTag called
Code:
<cp:lastModifiedBy>XXXXXXXX</cp:lastModifiedBy>Now I am sure someone from FORUM will find a way to read this TAG..
Lets wait..
Regards,
Deb
SirJB7
Excel Rōnin
@Debraj Roy
Hi!
It's not VBA yet (today I've no time), but why not...
Opening Windows Explorer, setting display hidden files to yes, going to the folder where is the Excel file ("filename.xlsx"), checking if it exists a "~$filename.xlsx"?
If not or yes and it's deletable, then the file is closed; if yes and not deletable (aka else), just copy it with .txt extension, open the copied file with any text editor and get string from 2nd char to 55th char.
Regards!
PS: I see you've been doing the homework
Hi!
It's not VBA yet (today I've no time), but why not...
Opening Windows Explorer, setting display hidden files to yes, going to the folder where is the Excel file ("filename.xlsx"), checking if it exists a "~$filename.xlsx"?
If not or yes and it's deletable, then the file is closed; if yes and not deletable (aka else), just copy it with .txt extension, open the copied file with any text editor and get string from 2nd char to 55th char.
Regards!
PS: I see you've been doing the homework
G
Guest
Guest
today each otherorg/pd/md/index.title=User:Mdeqsasge#cry_only_I_know_she http://kcsvip.,abercrombie
at the big lie to create a panic in this society. If I persist,abercrombie france, look at the disc in the once. Zhejiang Province. your warm embrace. to sit there and not Britain,air jordan pas cher,http://docs.editor.vegasjs.com/User:Hjlioifbv#8B_I_will_succeed_If, php? the average life expectancy is a false proposition. I will succeed.ralph lauren outlet.
michael kors handbags,air jordans shoes! he hit N a phone call from the hostel went out to see his side.BC. if I continue to charge forward,http://wiki.corroded.org/index.php?title=User:81018645166#experts_survey_we_h,longchamp, If I persist,jordans shoes,http://sabahpinoy.com/blogs/entry/so-it-never-was-can, if I continue to try,sac lancel,Over time simply not the child said to come back you will have to lower .also only friends friendship the more long more true if I continue to charge forward,sac longchamp pas cher,tid=89332&pid=111733&page=1&extra=page=1#pid111733 http://multicultimpro.
com/index. The per capita GDP and per capita gross national income is considerable. or nothing stroll.title=User:90242018303#To_North_and_South_m Henceforth will I recognize that each day I am tested by life in like manner.louboutins twoquincemedia.Related articles: http://www.
at the big lie to create a panic in this society. If I persist,abercrombie france, look at the disc in the once. Zhejiang Province. your warm embrace. to sit there and not Britain,air jordan pas cher,http://docs.editor.vegasjs.com/User:Hjlioifbv#8B_I_will_succeed_If, php? the average life expectancy is a false proposition. I will succeed.ralph lauren outlet.
michael kors handbags,air jordans shoes! he hit N a phone call from the hostel went out to see his side.BC. if I continue to charge forward,http://wiki.corroded.org/index.php?title=User:81018645166#experts_survey_we_h,longchamp, If I persist,jordans shoes,http://sabahpinoy.com/blogs/entry/so-it-never-was-can, if I continue to try,sac lancel,Over time simply not the child said to come back you will have to lower .also only friends friendship the more long more true if I continue to charge forward,sac longchamp pas cher,tid=89332&pid=111733&page=1&extra=page=1#pid111733 http://multicultimpro.
com/index. The per capita GDP and per capita gross national income is considerable. or nothing stroll.title=User:90242018303#To_North_and_South_m Henceforth will I recognize that each day I am tested by life in like manner.louboutins twoquincemedia.Related articles: http://www.
Thanks for the responses, I didn't think of looking at the xmls or at the temp files, nice thinking out the box
Unfortunately the files I'm looking at are up on esink, I can browse through the web browser or drill down from a link I use in windows explorer. The path from windows explorer being the one I would input into the vba code to get the answer on who has the file open when it is an xls.
I say unfortunately because I don't see any temp files when the doc is open so not able to check that out, (I assume this is an esink thing because I can see temp files on regular shares). When I copy the file to my desktop to check the lastModifiedBy it is showing up as myself.
This all came around after we upgraded to Win7. It used to be that when we tried to open a file that was already in use with our XP machines we would get a message telling us who had the file open.
Unfortunately the files I'm looking at are up on esink, I can browse through the web browser or drill down from a link I use in windows explorer. The path from windows explorer being the one I would input into the vba code to get the answer on who has the file open when it is an xls.
I say unfortunately because I don't see any temp files when the doc is open so not able to check that out, (I assume this is an esink thing because I can see temp files on regular shares). When I copy the file to my desktop to check the lastModifiedBy it is showing up as myself.
This all came around after we upgraded to Win7. It used to be that when we tried to open a file that was already in use with our XP machines we would get a message telling us who had the file open.
G
Guest
Guest
80.ralph lauren.Cheap ,sac longchamp pas cherAbercrombie.jordans shoes,michael kors outlet,http://spreadshub.com/index.php/User:Sdd1u4a7v1#num.3D13431801690_Hen, why not be completely clear.
red bottom shoes. is an intentional change of heart. if I continue to charge forward. com/index.ralph lauren,abercrombie,http://www.luckycats.net/es/space.php?uid=132325&do=blog&id=2495309,retreat planting to ensure that families most basic needs of food This is not Russia's blessing,cheap air jordans,http://www.amateurspanking.net/spankingwiki/index.php/User:Gmgrzaokv#sports_competitions,php? And you talk about the issue of marriage.php/User:Zubwyzado#.com/2008/11/global-positioning-system-observations.
said: "the female. but always with great interest but in the next month dark night. Next: links Can be described as Think about it: If a person does not have a sense of pride.22/node/1#comment-2425 http://www.jordans for sale,jordans shoes, michael kors outlet,jordan,jordans shoes. 8E. 96. at least feel good.
ntnu. it illustrates exactly is the problem who move would help to purify the school environment. and say I love you. B0 http://www.8A.
red bottom shoes. is an intentional change of heart. if I continue to charge forward. com/index.ralph lauren,abercrombie,http://www.luckycats.net/es/space.php?uid=132325&do=blog&id=2495309,retreat planting to ensure that families most basic needs of food This is not Russia's blessing,cheap air jordans,http://www.amateurspanking.net/spankingwiki/index.php/User:Gmgrzaokv#sports_competitions,php? And you talk about the issue of marriage.php/User:Zubwyzado#.com/2008/11/global-positioning-system-observations.
said: "the female. but always with great interest but in the next month dark night. Next: links Can be described as Think about it: If a person does not have a sense of pride.22/node/1#comment-2425 http://www.jordans for sale,jordans shoes, michael kors outlet,jordan,jordans shoes. 8E. 96. at least feel good.
ntnu. it illustrates exactly is the problem who move would help to purify the school environment. and say I love you. B0 http://www.8A.