$$Excel-Macros$$ Re: How to get Account Information of Excel using VBA Hi All,

Hi All, Does anyone know the answer to below question ? Regards, Karthik On Mon, Feb 8, 2016 at 4:44 PM, XL Macros wrote: > Hi All, > > I want to get the Account information of Excel using VBA, i.e When we > click on "File" button which is top left side of Excel, we see something > called "Acc

Re: $$Excel-Macros$$ Re: How to get Account Information of Excel using VBA Hi All,

Hi All, Does anyone know the answer to below question ? Regards, Karthik On Mon, Feb 8, 2016 at 5:06 PM, Mandeep baluja wrote: > Check this out !! > > Sub getproperties() > > On Error Resume Next > rw = 1 > Worksheets(2).Activate > For Each p In ActiveWorkbook.BuiltinDocumentProperties > C

Re: $$Excel-Macros$$ Re: How to get Account Information of Excel using VBA Hi All,

Hi Mandeep, Thanks for your code, I run the macro which you have given and its provided information like Author name etc... If i switch account ( you can find switch account in Excel - File/Account/Switch Account ) from my company account id to my personal account, in user information section mail

$$Excel-Macros$$ Re: How to get Account Information of Excel using VBA Hi All,

Check this out !! Sub getproperties() On Error Resume Next rw = 1 Worksheets(2).Activate For Each p In ActiveWorkbook.BuiltinDocumentProperties Cells(rw, 1).Value = p.Name Cells(rw, 2).Value = p.Value rw = rw + 1 Next End Sub Regards, Mandeep baluja -- Are you =EXP(E:RT) or =N