$$Excel-Macros$$ why 0 in excel is 0.0 in xml

I have a excel file in which a cell value is 0; when i look into xml the value is 0.0 and the workaround for this problem is carry any changes and save then the xml shows 0 WHAT IS THIS TYPICAL PROBLEM -- -- Some imp

$$Excel-Macros$$ why 0 in excel is 0.0 in xml

I have a excel file in which a cell value is 0; when i look into xml the value is 0.0 and the workaround for this problem is carry any changes and save then the xml shows 0 WHAT IS THIS TYPICAL PROBLEM -- -- Some imp

Re: $$Excel-Macros$$ COPY MODULES FORM LOCKED .XLSB FILE

HI GUYS...JUST WANT TO KNOW WHETHER THIS IS POSSIBLE TO DO OR NOT. On Tue, Oct 26, 2010 at 5:09 PM, sudheer lolla wrote: > > > -- Forwarded message -- > From: sudheer lolla > Date: Mon, Oct 25, 2010 at 10:42 AM > Subject: Re: $$Excel-Macros$$ COPY MODULES

$$Excel-Macros$$ COPY MODULES FORM LOCKED .XLSB FILE

-- Forwarded message -- From: sudheer lolla Date: Mon, Oct 25, 2010 at 10:42 AM Subject: Re: $$Excel-Macros$$ COPY MODULES FORM LOCKED .XLSB FILE To: Paul Schreiner , MS EXCEL AND VBA MACROS < excel-macros@googlegroups.com> Hi Theres no one who can help me out...Pleas

Re: $$Excel-Macros$$ COPY MODULES FORM LOCKED .XLSB FILE

Hi Theres no one who can help me out...Please guys Regards SUDHEER On Fri, Oct 22, 2010 at 12:17 PM, sudheer lolla wrote: > Hi Paul > > > As i told that "I WILL BE SENDING THE .AVI FILE OF MY QUERY" .since the > screen capture software is not available with me am

Re: $$Excel-Macros$$ XLSB and XLSX related problem

L SUDHEER On Wed, Oct 13, 2010 at 7:34 PM, Paul Schreiner wrote: > Is the XLSTART folder on a network drive? > > How are you opening "any other excel"? > Are you double-clicking on an excel file? > > First: a couple of definitions: > when you double-click the Excel

Re: $$Excel-Macros$$ DELETE OF A VALUE DELTES THAT FROM EVERY SHEET

Hi Siti Vi Sorry for that..This was the new query..i should have posted new link for this ...anyhow i apologize for this Reagrds L SUDHEER On Wed, Oct 13, 2010 at 7:38 PM, Paul Schreiner wrote: > How is this related to "Delete of a value Deltes that from every sheet" ??

$$Excel-Macros$$ XLSB and XLSX related problem

Hi This is a very peculiar problem which am facing i have an *xlsb* which has some macros and is placed in *XLSTART* folder when an excel is opened the *XLSB* is attached to the *XLSX* file i*am saying attached because when any other excel is opened,XL is popping up message saying "XYZ.xlsb is

Re: $$Excel-Macros$$ DELETE OF A VALUE DELTES THAT FROM EVERY SHEET

rolButton)* * With myCommandBarCtl* * .Caption = "Only one applicable"* * .Style = msoButtonCaption* * .TooltipText = "Only one applicable)"* * .OnAction = " Only one applicableSUB"* * End With* On Tue, Oct 12, 2010 at 3:33 PM, sudheer lolla wro

Re: $$Excel-Macros$$ DELETE OF A VALUE DELTES THAT FROM EVERY SHEET

Hi Siti Vi *Superbly codedThat was excellent..full praise you* Thanks for excellent reply Regards L SUDHEER On Tue, Oct 12, 2010 at 7:02 AM, siti Vi wrote: > Hi Lolla, > check this code > > - the VBA code - > Dim *DelValue*

Re: $$Excel-Macros$$ DELETE OF A VALUE DELTES THAT FROM EVERY SHEET

rder is same.You are comparing with target.row.This may not be the same in all sheets.I will end up deleting the other value.* * * *How can we overcome this problem* * * *Regards* *L SUDHEER * On Sun, Oct 10, 2010 at 6:58 PM, siti Vi wrote: > Hi Lolla, > > try this code (written in

Re: $$Excel-Macros$$ DELETE OF A VALUE DELTES THAT FROM EVERY SHEET

> Krrish > > > On Fri, Oct 8, 2010 at 6:40 PM, sudheer lolla wrote: > >> Hi guys >> >> >> I Have a column "xyz" which is there in every sheet of the workbook >> and the column number in sheet A is 1 ,sheet B is 2,sheet C is 1 >> >&g

$$Excel-Macros$$ DELETE OF A VALUE DELTES THAT FROM EVERY SHEET

Hi guys I Have a column "xyz" which is there in every sheet of the workbook and the column number in sheet A is 1 ,sheet B is 2,sheet C is 1 If i delete a value from that column "xyz" in sheet A,the deleted cell has to be deleted from these B,C sheets But the vice-versa should not happen i.e Del

Re: $$Excel-Macros$$ COPY MODULES FORM LOCKED .XLSB FILE

. 1) .XLSB IS LOCKED 2)WORKBOOK_OPEN OF .XLSB IS CREATING CUSTOM BUTTTON EVEN WHEN ITS LOCKD 3)VALIDATIONS ARE DONE ACCORDINGLY 4)BUT BUT THE MODULES ARE NOT GETTING COPIED INTO DESTINATION .XLSX FILE IF I REMOVE PROTECTION THIS WHOLE THING IS WORKING FINE BUT WITH PROTECTION AM HANGING A

Re: $$Excel-Macros$$ COPY MODULES FORM LOCKED .XLSB FILE

OPY FROM LOCKED XLSB FILE INTO XLSX FILE = On Mon, Oct 4, 2010 at 3:10 PM, sudheer wrote: > Hi > > IAM IN URGENT NEED OF AN ADVISE THAT COULD HELP ME GET OUT OF THIS > PROBLEM > THE STEP BY STEP THAT NEEDS TO BE DONE A

$$Excel-Macros$$ COPY MODULES FORM LOCKED .XLSB FILE

Hi IAM IN URGENT NEED OF AN ADVISE THAT COULD HELP ME GET OUT OF THIS PROBLEM THE STEP BY STEP THAT NEEDS TO BE DONE ARE GIVEN .ONLY THING IS HOW TO DO IT?? 1..Running a particular code from .XLSB file 2..This .XLSB file is locked and i know the password also. 3..Code which is in this locked .XLS

$$Excel-Macros$$ COPY CODE FROM WORKBOOK THAT IS LOCKED

amp; "lolla"           .SendKeys "{TAB}" & "lolla"           .SendKeys "{TAB}"           .SendKeys "{ENTER}"      End With ----

$$Excel-Macros$$ Excel Macros

Hi, I wanted to learn Excel Macros.Kindly help me. Thanks, Aswin -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN