tag:blogger.com,1999:blog-28492262.post2976014385099043604..comments2023-12-27T22:22:25.151-08:00Comments on VBA Tips & Tricks: Retrieve the file properties - VBAUnknownnoreply@blogger.comBlogger11125tag:blogger.com,1999:blog-28492262.post-20799500358448806242011-11-24T06:39:50.798-08:002011-11-24T06:39:50.798-08:00Is there any way to identify, is the word document...Is there any way to identify, is the word document is fully loaded or not in VBA macro.<br />For instance if the document has 100 pages, its ready state should return saying document is ready.kranthi kumarhttps://www.blogger.com/profile/14137222376330190261noreply@blogger.comtag:blogger.com,1999:blog-28492262.post-32916212654166508682011-09-21T18:44:04.701-07:002011-09-21T18:44:04.701-07:00Is it possible to pull the document contents, whic...Is it possible to pull the document contents, which shows the names of the worksheet(s)?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-28492262.post-32240567111603496632011-08-30T10:52:35.684-07:002011-08-30T10:52:35.684-07:00Is it possible to morph this to get a list of prev...Is it possible to morph this to get a list of previous savers? Example the past 10 or 20 or 100 (for the purposes of in-house review). How would that work please?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-28492262.post-32821049768854082852011-03-28T11:06:54.106-07:002011-03-28T11:06:54.106-07:00The last print date property is not working. Can y...The last print date property is not working. Can you please tell me how this will work as i need this in a project?rayhttps://www.blogger.com/profile/03671107279231577533noreply@blogger.comtag:blogger.com,1999:blog-28492262.post-67773828074888789762010-11-17T09:33:13.765-08:002010-11-17T09:33:13.765-08:00is there a way to call the document properties for...is there a way to call the document properties for a remote or closed file?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-28492262.post-62938889644700159842010-09-16T00:02:34.664-07:002010-09-16T00:02:34.664-07:00can anyone tel me how dis can be achieved in eithe...can anyone tel me how dis can be achieved in either java or webmethods?<br />Thank you in advance.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-28492262.post-7320168277361760032010-06-23T01:26:26.340-07:002010-06-23T01:26:26.340-07:00I need to find the author name of the track revisi...I need to find the author name of the track revision in table, how is it possible.kindly help out.Iniyalhttps://www.blogger.com/profile/12643167572495311771noreply@blogger.comtag:blogger.com,1999:blog-28492262.post-49396003836585291182010-06-21T18:58:33.950-07:002010-06-21T18:58:33.950-07:00@Andeww H: Current user can be taken from Applicat...@Andeww H: Current user can be taken from Application.UserNameM Shasurhttps://www.blogger.com/profile/17390752937266096344noreply@blogger.comtag:blogger.com,1999:blog-28492262.post-2933158911035142162010-06-17T07:53:47.501-07:002010-06-17T07:53:47.501-07:00Here is the code to get the username instead of Au...Here is the code to get the username instead of Author<br /><br />' Access the GetUserNameA function in advapi32.dll and<br />' call the function GetUserName.<br /> Declare Function GetUserName Lib "advapi32.dll" Alias "GetUserNameA" _<br /> (ByVal lpBuffer As String, nSize As Long) As Long<br />' Main routine to Dimension variables, retrieve user name<br />' and display answer.<br /> Sub auto_open()<br /> <br />' Dimension variables<br /> Dim lpBuff As String * 25<br /> Dim ret As Long, UserName As String<br />' Get the user name minus any trailing spaces found in the name.<br /> ret = GetUserName(lpBuff, 25)<br /> UserName = Left(lpBuff, InStr(lpBuff, Chr(0)) - 1)Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-28492262.post-17888430710306316682009-11-26T03:39:30.287-08:002009-11-26T03:39:30.287-08:00This is helpful, but is it possible to pull the cu...This is helpful, but is it possible to pull the current user's (instead of author / last author) name from anywhere?Andrew Hnoreply@blogger.comtag:blogger.com,1999:blog-28492262.post-45252403602407195362009-04-06T02:23:00.000-07:002009-04-06T02:23:00.000-07:00and custom properties?and custom properties?Anonymousnoreply@blogger.com