Re: $$Excel-Macros$$ Group in Whatsapp / Telegram

Hi Nilkanth, If you are looking for Excel Tips & Tricks send reply "Excel" to 8686836999. You will get awesome tips in Excel and also VBA regularly. Regards, Karthik On Sun, Feb 14, 2016 at 12:35 PM, Nilkanth Raval wrote: > Hi All, > > If any one has created excel vba group in whatsapp or Tel

Re: $$Excel-Macros$$ Hide Bookmarks using VBA

Hi Team, I got the solution. On Mon, Feb 22, 2016 at 3:18 PM, XL Macros wrote: > Hi, > > When i click on Button in Excel it should open the url ( > http://www.techonthenet.com/) in internet explorer and browser should not > contain any bookmarks (i.e all the bookmarks should be

$$Excel-Macros$$ Hide Bookmarks using VBA

Hi, When i click on Button in Excel it should open the url ( http://www.techonthenet.com/) in internet explorer and browser should not contain any bookmarks (i.e all the bookmarks should be hidden) How to do above task with VBA ? Regards, Karthik -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Exc

Re: $$Excel-Macros$$ How can I add 2-6 characters to the front of numbers based ONLY on how long the number is?

Paul, If i understood your requirement correctly then below formula works out for you [image: Inline image 1] I have attached sample file as well. Regards, Karthik On Thu, Feb 11, 2016 at 5:57 AM, Paul Bevins wrote: > Hi, I've got an odd problem. > > I have a database of some 15000 numbers.

$$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

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$$ How to get Account Information of Excel using VBA Hi All,

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 "Account". In this "Account" we can able to see user information, such as user mail id, Product details etc... I need this account details

Re: $$Excel-Macros$$ Comment macro code with macros (not manually)

Next VBComp > Module_Remove = True > End Function > > ' > Function Module_Import(ModName) > Dim VBAmodule > Module_Import = False > '-

$$Excel-Macros$$ Workbook_BeforClose Event working as expected only 1st time NOT the 2nd time

Hi All, My Requirement is When user click on Close button(Top Right) in Excel, one Pop-up message will appear which asks user "Really want to close workbook ?" If user click on Ok, it will close the workbook, if user click on "Cancel" it will not close the workbook. I have written code in "Thiswo

Re: $$Excel-Macros$$ Comment macro code with macros (not manually)

you > can,In all the places you can,At all the times you can,To all the people > you can,As long as ever you can.” - John Wesley* > - > > > On Wednesday, February 3, 2016 3:58 AM, XL Macros > wrote: > > > > Hi All, &g

$$Excel-Macros$$ Comment macro code with macros (not manually)

Hi All, Can we comment few line of code in existing macros using macros ? For more clarity on my question, i'm giving below macro code *Sub selectshapes()* *Dim shp As Shape* *For Each shp In ActiveSheet.Shapes* *ActiveSheet.Shapes(shp.name ).Select* *Select

Re: $$Excel-Macros$$ please suggest

Hi Kumar, For your 1st Question, you need to write the macro in Worksheet_Change Event. For your 2nd Question, yes you can get only formula text. You can use the formula called FORMULATEXT =FORMULATEXT(Cell_Refefence) Note: FORMULATEXT is a new formula in 2013 Version of excel. Previous versions

$$Excel-Macros$$ How to know VBA Constant number instead of text

Hi All, I want to know what is the constant number for any given Build-in Constant. For example: For the below mentioned property we can write text "True" OR 1. For few of the parameters I know the numeric number but for some them not. Is their any way to find the constant value number instead of