$$Excel-Macros$$ Re: VBA Copying range of cells from one workbook to another while retaining the formulae

[Ashish Jain]

Hi Mike,


Try this:
RR.Range("A" & LastRow_RR + 1 & ":CN" & LastRow_RR + LastRow_NWR -
5).Formula
 = NWR.Range("A6:CN" & LastRow_NWR).Formula

____
Thanks & Regards
Ashish Jain
McKinsey India Knowledge Center
(Microsoft Certified Application Specialist)
(Microsoft Certified Professional)
http://www.excelitems.com
http://www.openexcel.com


On Nov 16, 6:08 pm, Mike Magill  wrote:
> I have a macro that copies a large range of cells that contains a
> mixture of cells with values and text and other cells with formulae.
>
> I want to copy this range into a new workbook using VBA but I can't
> seem to retain the formulae (which are converted to their values). I'm
> sure there is a simple solution but I'm struggling to find it.
>
> I've tried two ways that don't work so far and included snippets from
> my macro below to show you what I've tried:
>
> Attempt 1:
>
> NWR.Range("A6:CN" & LastRow_NWR).Copy RR.Range("A" & LastRow_RR + 1 &
> ":CN" & LastRow_RR + LastRow_NWR - 5)
>
> Attempt 2:
>
> Data1 = NWR.Range("A6:CN" & LastRow_NWR)
> RR.Range("A" & LastRow_RR + 1 & ":CN" & LastRow_RR + LastRow_NWR - 5)
> = Data1
>
> Can anyone help?

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Re: $$Excel-Macros$$ Re: OPEN EXCEL - Needs your support and enthusiasm...

[Ashish Jain]

Thanks Andy, Anand & Rajesh :) I'm working on making more fast,
efficient, robust with lot of new user friendly and time-saving tools.
Hope it will be blast !!


Thanks & Regards
Ashish Jain
McKinsey India Knowledge Center
(Microsoft Certified Application Specialist)
(Microsoft Certified Professional)
http://www.excelitems.com
http://www.openexcel.com


On Nov 1, 1:55 pm, Rajesh Shah  wrote:
> Looks very useful
> Kudos on the good job
>
> Regards
> Rajesh Shah
>
> On 1 November 2010 13:10, anandydr  wrote:
>
>
>
>
>
>
>
> > Just downloaded the file. Let me play around with it for some time
> > before I can add any comment on its utilities. Somehow I was able to
> > see a few utilities which would be quite useful.
>
> > Warm regards,
> > Anand
>
> > On Oct 31, 10:57 pm, Ashish Jain  wrote:
> > > Dear Members,
>
> > > We're proud to launch OPEN EXCEL under the GNU Public License v3 which
> > > means it's available with source code to reach the maximum users
> > > around the globe with rapid development, more robust & innovative
> > > features. Since, public forums like these are hub of great
> > > professionals, knowledge sharers and bug shooters, hence we thought to
> > > launch it here. While beginners may download it, use it and can learn
> > > from it, amateur, experienced and professionals may contribute their
> > > some time and mind in developing it further ...
>
> > > Below are Google project links to download, develop and suggest new
> > > features in OPEN EXCEL :)
>
> > > Download -http://code.google.com/p/openexcel/downloads/list
> > > Suggest New Feature -http://code.google.com/p/openexcel/issues/list
> > > Develop - Reply this post with your mail id, so that you can be added
> > > as developer in the project and project's mailing lists.
>
> > > Thanks & Regards
> > > Ashish Jain
> > > McKinsey India Knowledge Center
> > > (Microsoft Certified Application Specialist)
> > > (Microsoft Certified Professional)http://www.excelitems.comhttp://
> >www.openexcel.com
>
> > --
>
> > --- 
> > ---
> > Some important links for excel users:
> > 1. Follow us on TWITTER for tips tricks and links :
> >http://twitter.com/exceldailytip
> > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
> > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> > To post to this group, send email to excel-macros@googlegroups.com
>
> > <><><><><><><><><><><><><><><><><><><><><><>
> > Like our page on facebook , Just follow below link
> >http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&;...

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

$$Excel-Macros$$ Excel VBA Macros eBook ..Absolutely FREE worth $45

[Ashish Jain]

Fantastic - Liked it !!
Really helpful :)


Thanks & Regards
Ashish Jain
McKinsey India Knowledge Center
(Microsoft Certified Application Specialist)
(Microsoft Certified Professional)
http://www.excelitems.com
http://www.openexcel.com


On Nov 8, 7:05 pm, Ayush  wrote:
> Dear Group Members,
>
> Good news for all of you !!
>
> Now you can download VBA macros ebook worth $45 for free.
>
> Here is the link to download :-http://recordexcelmacro.com/discussexcel.html
>
> I have talked to John Franco (Author) to get this eBook for our group.
> Please do not miss the chance to download the eBook. This eBook has
> 140 pages of valuable knowledge on recording macros and customize
> them.
>
> I am working with John to get more resources for you either free or
> paid.Keep watching this space.
>
> Feel free to forward this link and email to all your friends,
> coworkers and followers.
>
> So what are you waiting for...Download it now..
>
> Thanks.
>
> Best regards,
> Ayush Jain
> Microsoft MVP 2010

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

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

[Ashish Jain]

Hi Sudheer

Please elaborate your problem last time, I'm not able to understand
the chain mails. I hope, I'll be able to help you out, guide or
atleast learn something from your problem.



Thanks & Regards
Ashish Jain
McKinsey India Knowledge Center
(Microsoft Certified Application Specialist)
(Microsoft Certified Professional)
http://www.excelitems.com
http://www.openexcel.com


On Nov 11, 2:22 pm, sudheer lolla  wrote:
> -- Forwarded message --
> From: sudheer lolla 
> Date: Tue, Nov 2, 2010 at 9:56 AM
> Subject: Re: $$Excel-Macros$$ COPY MODULES FORM LOCKED .XLSB FILE
> To: MS EXCEL AND VBA MACROS , Paul Schreiner
> 
>
> 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 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...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 sending the screen 
> >> shots
> >> with comments
>
> >> The screen shots are named sequentially(1.JPEG,2.JPEG).I work in the same
> >> sequence .THERE WILL BE NINE JPEG FILES
>
> >> PLEASE HELP ME OUT OF THIS
>
> >> I WILL BE VERY THANKFULLY
>
> >> PLEASE LET ME KNOW FOR ANY QUERIES...
>
> >> THANKS
> >> L SUDHEER
>
> >> On Tue, Oct 5, 2010 at 11:08 AM, sudheer lolla 
> >> wrote:
>
> >>> HI PAUL
>
> >>> I GET U.BUT MY REQUIREMENT IS BIT DIVERTING...I WILL POST AN AVI FILE
> >>> THAT SHOWS THE ACTIVITIES WHICH ARE BEING DONE ON THE FILE
>
> >>> BY THE WAY CAN I KNOW U R FREE TIMINGS SO THAT OUR INTERACTION WOULD BE
> >>> QUICK ENOUGH
>
> >>> REGARDS'
> >>> SUDHEER
>
> >>> On Mon, Oct 4, 2010 at 11:30 PM, Paul Schreiner 
> >>> wrote:
>
> >>>> The macros that I posted will have an issue because you cannot
> >>>> remove the "ThisWorkbook" module and import a new one.
>
> >>>> What you MAY have to do is to put the macro into a "temporary" .xlsb or
> >>>> .xlsm file.
> >>>> then, when the .xlsx file is opened, copy the sheet to the temporary
> >>>> file
> >>>> and close the .xlsx file.
> >>>> If you planned to save and overwrite the file, you can always include a
> >>>> saveas statement.
>
> >>>> Paul
>
> >>>> *From:* sudheer lolla 
> >>>> *To:* excel-macros@googlegroups.com
> >>>> *Sent:* Mon, October 4, 2010 12:26:16 PM
>
> >>>> *Subject:* Re: $$Excel-Macros$$ COPY MODULES FORM LOCKED .XLSB FILE
>
> >>>> HI PAUL
>
> >>>> IF I KEEP A PIECE OF CODE IN "This Workbook" SAY I KEEP IN
> >>>> "WORKBOOK_CHANGE" THEN WHENEVER SHEET CHANGES THIS WILL BE INVOKED
>
> >>>> FOR THIS TO HAPPEN I NEED TO COPY A MODULE FROM .XLSB INTO THAT
> >>>> WORKBOOK.THATS THE REQUIREMENT
>
> >>>> THIS .XLSX IS OPENED ON THE FLY...DONT KNOW WHICH XLSX USER WILL
> >>>> SELECT..SO IAM KEEPING A MASTER .XLSB IN "XLSTART" FOLDER IN
> >>>> MICROSOFT-->EXCEL-->XLSTART
>
> >>>> THIS MASTER .XLSB HAS A CODE THAT GENERATES A CUSTOM BUTTON.(THE CODE
> >>>> FOR THIS IS KEPT IN "WORKBOOK_OPEN" EVENT IN .XLSB FILE)
>
> >>>> UPON CLICK OF THIS BUTTON..SOME VALIDATION ARE DONE ON THE SHEET(THE VBA
> >>>> CODE FOR THESE VALIDATIONS ARE WRITTEN IN .XLSB FILE) AND ALSO CODE IN 
> >>>> "THIS
> >>>> WORKBOOK" MODULE OF .XLSB IS COPIED INTO "THIS WORKBOOK" OF .XLSX FILE. 
> >>>> AND
> >>>> ALL MODULES IN .XLSB FILE ARE COPIED INTO .XLSX.
>
> >>>> FOR THIS WHOLE THING TO HAPPEN .
>
> >>>> 1) .XLSB IS LOCKED
> >>>> 2)WORKBOOK_OPEN OF .XLSB IS CREATING CUSTOM BUTTTON EVEN WHEN ITS LOCKD
> >>>> 3)VALIDATIONS A

Re: $$Excel-Macros$$ Re: Refreshable Web Query

[Ashish Jain]

My pleasure Kush and sorry to see your problem so lately.



Thanks & Regards
Ashish Jain
McKinsey India Knowledge Center
(Microsoft Certified Application Specialist)
(Microsoft Certified Professional)
http://www.excelitems.com
http://www.openexcel.com




On Nov 11, 1:15 pm, kush sharma  wrote:
> Hello Ashish,
>
> Thanks for the reply, I think the solution worked just fine. I aint recevng
> those messages regarding "running scripts". thanks a ton buddy. :)
>
> On Wed, Nov 10, 2010 at 12:25 PM, Ashish Jain wrote:
>
>
>
>
>
>
>
>
>
> > Hi Kush,
>
> > The method explained below will stop annoying you because the
> > Internet Explorer 4.0, 5.0, 6, 7, and 8 time-out is based on the
> > number
> > of script statements executed, the time-out dialog box will not
> > display
> > during ActiveX control or database-access delays. Endless loops in
> > script will still be detected.
>
> > Caution: Take a backup of registry before committing this change.
> > 1.  To change this time-out value in Internet Explorer 4.0, 5.0, 6, 7,
> > or 8,
> > follow these steps:
> > Using a Registry Editor such as Regedt32.exe, open this key:
> > HKEY_CURRENT_USER\Software\Microsoft\Internet Explorer\Styles
>
> > *Note If the Styles key is not present, create a new key that is
> > called Styles.
>
> > 2.  Create a new DWORD value called "MaxScriptStatements" under this
> > key
> > and set the value to the desired number of script statements. If you
> > are unsure
> > of what value you need to set this to, you can set it to a DWORD value
> > of
> > 0xFFFF to completely avoid the dialog.
>
> > For details Refer to MicroSoft Knowledge Base :
> >http://support.microsoft.com/kb/175500
>
> > 
> > Thanks & Regards
> > Ashish Jain
> > McKinsey India Knowledge Center
> > (Microsoft Certified Application Specialist)
> > (Microsoft Certified Professional)
> >http://www.excelitems.com
> >http://www.openexcel.com
> > 
>
> > On Oct 14, 9:02 am, kush sharma  wrote:
> > > Heloo Everyone,
>
> > > I have this problem whenever i try to create a refreshable web query. As
> > > soon as i eneter the link in the web address bar the window appears which
> > > asks something like "this page contains a script, do you wish to
> > continue?"
> > > now i do click yes, but this message appears again so fast that i cannot
> > get
> > > past it...is there any particular solution to this thing or any excel
> > > setting that i have to do?
>
> > > I'd be glad to have some good response.
> > > --
> > > *
> > > Regards
>
> > > Kushlesh Sharma
> > > *
>
> > --
>
> > --- 
> > ---
> > Some important links for excel users:
> > 1. Follow us on TWITTER for tips tricks and links :
> >http://twitter.com/exceldailytip
> > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
> > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> > To post to this group, send email to excel-macros@googlegroups.com
>
> > <><><><><><><><><><><><><><><><><><><><><><>
> > Like our page on facebook , Just follow below link
> >http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&;...
>
> --
> *
> Regards
>
> Kushlesh Sharma
> Research Analyst
> Swastika Investmart Limited
> Email: kushsha...@swastika.co.in
>
> *

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

$$Excel-Macros$$ Re: search until a blank cell is found.

[Ashish Jain]

Hi Lakshitha

There are many ways to find last row, one of them is using End method
of range.
Here is modified code and try let us know, if it works

---
Sub Macro1()
Dim count As Integer
Dim lstRow As Integer
Dim fCell As Range 'First Cell Found
Dim fAdd As String 'Adress of First Cell
'To determine the Last Row in the column B
lstRow = Range("B65536").End(xlUp).Row
Range("B1:B" & lstRow).Select
On Error GoTo ErrorH
Selection.Find(What:="sep", After:=ActiveCell, LookIn:=xlValues, _
LookAt:=xlPart, SearchOrder:=xlByRows,
SearchDirection:=xlNext, _
MatchCase:=False, SearchFormat:=False).Activate
fAdd = ActiveCell.Address
Do
Selection.FindNext(After:=ActiveCell).Activate
Range("DU10").Offset(0, count).Value = ActiveCell.Offset(0,
1).Value
count = count + 1
Loop While ActiveCell.Address <> fAdd
ErrorH:
End Sub
---

Try to understand the logic and post back, if need clarifications.



Thanks & Regards
Ashish Jain
McKinsey India Knowledge Center
(Microsoft Certified Application Specialist)
(Microsoft Certified Professional)
http://www.excelitems.com
http://www.openexcel.com





On Nov 11, 2:12 pm, Lakshitha  wrote:
> i have a column filled with month names. but not in order here and
> there. not in a list.
>
> I want to search for all "sep" in that whole column and put the values
> next to it another column. but How to end the loop once it reach the
> last "sept" in the column. In other words howt to stop it from endless
> looping
>
> --- 
> ---
> Sub Macro1()
>     Dim count As Integer
>
>     Columns("B:B").Select
>     Selection.Find(What:="sep", After:=ActiveCell, LookIn:=xlFormulas,
> _
>         LookAt:=xlPart, SearchOrder:=xlByRows,
> SearchDirection:=xlNext, _
>         MatchCase:=False, SearchFormat:=False).Activate
>
>     Do While ActiveCell <> ""
>     Selection.FindNext(After:=ActiveCell).Activate
>     ActiveSheet.Range("DU10").Offset(count, 0).Value =
> ActiveCell.Offset(0, 5).Value
>         count = count + 1
>
>     Loop
>
> --- 
> ---

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

$$Excel-Macros$$ Re: Fwd: Hide & Protect Sheet from other User

[Ashish Jain]

Hi Hemant

You can use these VBA methods to solve your problem:
Sheets(1).Visible = xlSheetHidden 'Hide the worksheet

Sheets(1).Visible = xlSheetVeryHidden 'Hide the worksheet and
won't be displayed in Unhide Worksheet dialog list

Sheets(1).Protect("Password")'Replace password with your own
password

Please modify them as per your need.


Please Note: I didn't opened your excel workbook and I suggest
you to send your problems rather sending workbook as it's a
dangerous practice.

________
Thanks & Regards
Ashish Jain
McKinsey India Knowledge Center
(Microsoft Certified Application Specialist)
(Microsoft Certified Professional)
http://www.excelitems.com
http://www.openexcel.com




On Sep 14, 2:10 am, hemant shah  wrote:
> Hi Team,
>
> Please help on the attached.
>
> Thanks in advance.
>
> Regards,
> Hemant Shah
>
>  Hide & Protect the Sheet from other Users.xls
> 54KViewDownload

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

$$Excel-Macros$$ Re: Using Web Services with Excel 2010

[Ashish Jain]

Hi David,


There is good walkthrough available on MSDN
http://msdn.microsoft.com/en-us/library/ms519100.aspx


You can also refer this article on MSDN:
http://msdn.microsoft.com/en-us/library/ms546696.aspx



Thanks & Regards
Ashish Jain
McKinsey India Knowledge Center
(Microsoft Certified Application Specialist)
(Microsoft Certified Professional)
http://www.excelitems.com
http://www.openexcel.com




On Sep 22, 12:29 am, David  wrote:
> At my company many of our customers us Excel Spreadsheets to load data
> into the software system we sell.  These spreadsheets were initially
> developed using Excel 2003.  Then used the Office Web Services Toolkit
> for 2003 to access an assortment of Web Services to load their data
> into our system.  Soap30 was loaded onto each client and everyone has
> been moving along nicely.  Web references/classes were added to the
> spreadsheets VB code modules to make all of this happen at the push of
> a button.
>
> Now enter Excel 2010.  Many of our customers are wanting to upgrade to
> 2010 and are waiting for us to upgrade our software.  I have looked on
> line for the 2010 version of the Web Services Toolkit to no avail.
>
> The question then becomes:  How do I use Web Services in Excel 2010?
>
> Thank You

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

$$Excel-Macros$$ Use in vlookup isna and isblank iserror

[Ashish Jain]

Hi Praveen,

Do you want to learn functions? If yes, follow the Microsoft help by
pressing F1(Functional Key near Esc). it contains very good examples.
Just search and practice these formulas from there. Do, come up with
questions, queries - we'll help you out here.


Regards
Ashish Jain
McKinsey India Knowledge Center
(Microsoft Certified Application Specialist)
(Microsoft Certified Professional)
http://www.excelitems.com
http://www.openexcel.com


On Sep 22, 5:05 pm, Aindril De  wrote:
> Hi Praveen,
>
> Can you be more specific with your question and if possible send a sample
> sheet in response to this email with some dummy data and explaination of the
> required result.
>
> Regards,
> Andy
>
> On Wed, Sep 22, 2010 at 4:52 PM, praveen kumar wrote:
>
> > hello
> > Dear Sir,
> >  this is praveen
> > i have some problem's please sort out my problem's
>
> > i want use in v lookup function isna,iserror,isblank,and if, and
> > nested if
> > how can i
> > please help me
>
> > --
>
> > --
> > Some important links for excel users:
> > 1. Follow us on TWITTER for tips tricks and links :
> >http://twitter.com/exceldailytip
> > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
> > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> > To post to this group, send email to excel-macros@googlegroups.com
>
> > <><><><><><><><><><><><><><><><><><><><><><>
> > HELP US GROW !!
>
> > We reach over 7000 subscribers worldwide and receive many nice notes about
> > the learning and support from the group.Let friends and co-workers know they
> > can subscribe to group at
> >http://groups.google.com/group/excel-macros/subscribe

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

$$Excel-Macros$$ Re: Excel Encyclopedia ppt

[Ashish Jain]

Thanks Raj for sharing these tips. Great. Keep it up :)


Regards
Ashish Jain
McKinsey India Knowledge Center
(Microsoft Certified Application Specialist)
(Microsoft Certified Professional)
http://www.excelitems.com
http://www.openexcel.com




On Nov 10, 5:30 pm, Rajasekhar Praharaju
 wrote:
> Hi Friends,
>
> I Just wanted to share this Excel power point presentation, it was my first
> presentation shared with  my college friends, However as this group is vast
> collection of useful tips and i Just wanted to take this small opportunity
> to share this stuff. hope you would like it.
>
> Please Suggest your valuable tips if any to add up in this presentation.
>
> Once again i would like thank one and all to this adorable group for your
> helping hands...
>
> Keep rocking
>
> Thanks,
> Raj
>
>  Tips_to_work_on_Excel.ppt
> 3730KViewDownload

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

$$Excel-Macros$$ Re: VBA code required for Copy a specific folder.

[Ashish Jain]

Hi Mari,

You can use CopyFolder method of File System Object as follows:

Sub CopyFolder()
  Dim fso
  Dim sfol As String, dfol As String
  sfol = "c:\MyFolder" ' change to match the source folder path
  dfol = "e:\MyFolder" ' change to match the destination folder path
   Set fso = CreateObject("Scripting.FileSystemObject")
   If Not fso.FolderExists(dfol) Then
   fso.CopyFolder sfol, dfol
   Else
   MsgBox dfol & " already exists!", vbExclamation, "Folder
Exists"
   End If
End Sub

For details refer to Microsoft MSDN:
CopyFolder Method
http://msdn.microsoft.com/en-us/library/xbfwysex(v=VS.85).aspx
FileSystemObject
http://msdn.microsoft.com/en-us/library/z9ty6h50(v=VS.85).aspx




____
Thanks & Regards
  Ashish Jain
  McKinsey India Knowledge Center
  (Microsoft Certified Application Specialist)
  (Microsoft Certified Professional)
  http://www.excelitems.com
  http://www.openexcel.com





On Sep 26, 3:38 pm, Mari Krish  wrote:
> Hi Team,
>
> Here I have a requirement to copy folder from one location to another
> location which is contain a specific Name.
>
> Ex:
>
> I Have a folder AAA
>
> AAA has 3 Subfolder as aaa1, aaa2, aaa3.
>
> All the above said subfolders contains Each 2 Folders as (aaa1_Input &
> aaa1_Output, aaa2_Input & aaa2_Output, aaa3_Input & aaa3_Output )
>
> Requirement:
>
> Now I have to copy all the Output Folder from each folders and copy it
> to a new location.
>
> Please assist me to make it possible through VBA code.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

$$Excel-Macros$$ Re: How do I copy some cells(including formatting) and save as image file using VBA?

[Ashish Jain]

Hi,

You can try this code. The code has been taken from Open XL where
through a utility a cell or range of cells are exported as image (GIF/
PNG).

//Here is the subroutine:
Sub SaveRangeAsGif()
Dim MyChart As Chart
Dim objPict As Object
Dim RgCopy As Range

On Error Resume Next
Set RgCopy = Application.InputBox("Select the range to copy / Saveas",
"Selection Save", Selection.Address, Type:=8)
If RgCopy Is Nothing Then Exit Sub

RgCopy.CopyPicture Appearance:=xlScreen, Format:=xlBitmap
ActiveSheet.PasteSpecial Format:="Bitmap"
Set objPict = Selection

With objPict
.CopyPicture 1, 1 ':=1
Set MyChart = ActiveSheet.ChartObjects.Add(1, 1, .Width +
8, .Height + 8).Chart
End With

With MyChart
.Paste
.Export Application.GetSaveAsFilename(FileFilter:="Image File
(*.gif), *.gif")
.Parent.Delete
End With

'// cleanup
objPict.Delete
Set RgCopy = Nothing
Set objPict = Nothing

On Error GoTo 0
End Sub

Hope this solves your problem, else feel free to write back for
clarifications.

____
Thanks & Regards
Ashish Jain
McKinsey India Knowledge Center
(Microsoft Certified Application Specialist)
(Microsoft Certified Professional)
http://www.excelitems.com
http://www.openexcel.com



On Sep 25, 1:14 am, LunaMoon  wrote:
> How do I copy some cells(including formatting) and save as image file
> using VBA?
>
> Ultimately, I want to do that via COM or ActiveX server. Yet I think
> VBA is the starting point.
>
> So lets start from VBA.
>
> How to do that in VBA?
>
> I know how to open and close the Excel sheet.
>
> But what's the command in VBA/COM/ACTIVEX  to copy a few cells
> (rectangular shape, including formatting), and save as image?

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

$$Excel-Macros$$ Re: Delete all defined workbokk names

[Ashish Jain]

Hi Jitendra,


There is no VBA way to delete all of them at once but manually you can
delete them very fast and efficiently.
1. Open the Name Manager (Formulas --> Name Manager(2007) or Insert--
>Name-->Define(2003))
2. Now select the first name.
3. Now Press, Ctrl + Shift + End to select all the defined names.
4. Click on Delete.


Hope this solves your problem efficiently. Do remember this action
cannot be replicated in VBA. VBA will perform action on individual
name at a time.




  Thanks & Regards
  Ashish Jain
  McKinsey India Knowledge Center
  (Microsoft Certified Application Specialist)
  (Microsoft Certified Professional)
  http://www.excelitems.com
  http://www.openexcel.com





On Sep 24, 11:51 am, "Jitendra Kumar Verma"
 wrote:
> Hi All,
>
> I have 3+ defined names in workbook and want to delete it.
>
> I have written code below,
>
> Dim nm as name
>
> For each nm in activeworkbook.names
>
>    Nm.delete
>
> Next
>
> But it takes too much time to delete.
>
> Is there any other way to faster delete the all defined names from
> workbook.
>
> Thanks
>
> Jitendra Kr. Verma  

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

$$Excel-Macros$$ Re: Hi....

[Ashish Jain]

Hi Sasikanth,


This is very wonderful. There are so many websites available
to give you a start. Buy some good Microsoft Press books:
http://www.excelitems.com/2009/03/free-e-book-on-vba-and-vsto-macros-and.html

Also subscribe us on Facebook and twitter for regular tips and
updates:
Facebook - http://www.facebook.com/pages/discussexcelcom/160307843985936
Twitter - http://www.twitter.com/exceldailytip


*Try and if have some issue, discuss here or on Microsoft Forums.
We will be pleased to solve and make you understand.




 Thanks & Regards
 Ashish Jain
 McKinsey India Knowledge Center
 (Microsoft Certified Application Specialist)
 (Microsoft Certified Professional)
 http://www.excelitems.com
 http://www.openexcel.com




On Sep 24, 9:58 am, "Sasikanth"  wrote:
> Hi Ayush,
>
> I'm sasikanth. I'm new joinee to your group. I want to learn excel macros
> (VBA). Could you please suggest me how to start because I don't know how to
> write VBA script. Please suggest me how to start with it.
>
> Thanks & Regards,
>
> Sasikanth.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

$$Excel-Macros$$ Re: Excel Macros

[Ashish Jain]

Hi Aswin,

This is very wonderful. There are so many websites available
to give you a start. Buy some good Microsoft Press books:
http://www.excelitems.com/2009/03/free-e-book-on-vba-and-vsto-macros-and.html

Try and if have some issue, discuss here or on Microsoft Forums.
We will be pleased to solve and make you understand.



 Thanks & Regards
 Ashish Jain
 McKinsey India Knowledge Center
 (Microsoft Certified Application Specialist)
 (Microsoft Certified Professional)
 http://www.excelitems.com
 http://www.openexcel.com




On Sep 23, 9:08 pm, aswin sudheer  wrote:
> 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 group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

$$Excel-Macros$$ Re: Refreshable Web Query

[Ashish Jain]

Hi Kush,

The method explained below will stop annoying you because the
Internet Explorer 4.0, 5.0, 6, 7, and 8 time-out is based on the
number
of script statements executed, the time-out dialog box will not
display
during ActiveX control or database-access delays. Endless loops in
script will still be detected.


Caution: Take a backup of registry before committing this change.
1.  To change this time-out value in Internet Explorer 4.0, 5.0, 6, 7,
or 8,
follow these steps:
Using a Registry Editor such as Regedt32.exe, open this key:
HKEY_CURRENT_USER\Software\Microsoft\Internet Explorer\Styles

*Note If the Styles key is not present, create a new key that is
called Styles.


2.  Create a new DWORD value called "MaxScriptStatements" under this
key
and set the value to the desired number of script statements. If you
are unsure
of what value you need to set this to, you can set it to a DWORD value
of
0x to completely avoid the dialog.

For details Refer to MicroSoft Knowledge Base :
http://support.microsoft.com/kb/175500






Thanks & Regards
Ashish Jain
McKinsey India Knowledge Center
(Microsoft Certified Application Specialist)
(Microsoft Certified Professional)
http://www.excelitems.com
http://www.openexcel.com






On Oct 14, 9:02 am, kush sharma  wrote:
> Heloo Everyone,
>
> I have this problem whenever i try to create a refreshable web query. As
> soon as i eneter the link in the web address bar the window appears which
> asks something like "this page contains a script, do you wish to continue?"
> now i do click yes, but this message appears again so fast that i cannot get
> past it...is there any particular solution to this thing or any excel
> setting that i have to do?
>
> I'd be glad to have some good response.
> --
> *
> Regards
>
> Kushlesh Sharma
> *

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

$$Excel-Macros$$ Re: Macro/Script to enter values into cells if the row contains data

[Ashish Jain]

Hi Val

There are several workarounds to solve your problem.
1. You can use formulas in O, P, AW and BL
linked directly to column D.

2. or create a macro to copy values from col.D
to O, P, AW and BL as required. Below is a
code, do reply if this was you looking for:

Sub Copy_Data()
Dim myCell As Range
Range("D:D").SpecialCells(xlCellTypeConstants,
23).SpecialCells(xlCellTypeVisible).Select
For Each myCell In Selection.Cells
myCell.Offset(0, 11).Value = myCell.Value 'O
myCell.Offset(0, 12).Value = myCell.Value 'P
myCell.Offset(0, 45).Value = myCell.Value 'AW
myCell.Offset(0, 60).Value = myCell.Value 'BL
Next
End Sub





____
Thanks & Regards
Ashish Jain
McKinsey India Knowledge Center
(Microsoft Certified Application Specialist)
(Microsoft Certified Professional)
http://www.excelitems.com
http://www.openexcel.com


On Nov 8, 11:15 am, Val367  wrote:
> Hi
>
> I need some help creating a script. I need it to loop through each row
> of a sheet and replicate the value from D to O, P, AW and BL. The
> number of rows of the sheet will change so I am thinking it will need
> a for - next loop to run to the last row and on each loop it will copy
> the data from cell D* (with * being the current row) to O*, P*, AW*
> and BL*.
>
> ie
> A     B     C    D        O    P   ...   AW   ...   BL
> s      g     e    12          12   12         12          12
> d      f      t     22          22   22         22          22
>
> the last 4 12s on the 2nd line are what the script would have copied
> for line 2, then the last 4 22s are the data copied for line 3 etc
> etc.
>
> Hope that is clear and that somone understands what I need and can
> help.
>
> Thanks
> Val

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Re: $$Excel-Macros$$ Re: is there a printer installed on this computer?

[Ashish Jain]

Yup Omar, you're right.
In your case it will be


SUB PAGE_SETUP()
On Error GoTo RESCUE
   '*PAGE SET UP LINES*
   '*
   '*
   '*HEADER & FOOTER
   'REST CODE OR EXIT SUB

RESCUE:
 '  Your  code  if error
 'RESUME NEXT (if required)
 END SUB


________
Thanks & Regards
Ashish Jain
McKinsey India Knowledge Center
(Microsoft Certified Application Specialist)
(Microsoft Certified Professional)
http://www.excelitems.com
http://www.openexcel.com



On Nov 9, 10:11 pm, عمر  wrote:
> THANKS ashish
> Before page setup lines we can use on error goto 1
> Line
> Line
> ...
>
> 1 end sub
>
> Is that true?
>
>
>
>
>
>
>
> -Original Message-
> From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On 
> Behalf Of Ashish Jain
> Sent: Tuesday, November 09, 2010 3:36 PM
> To: MS EXCEL AND VBA MACROS
> Subject: $$Excel-Macros$$ Re: is there a printer installed on this computer?
>
> Hi Omar,
>
> There are 2 ways:
> 1. You can get the printer name using
>      Application.ActivePrinter
> So, if there is no printer installed, skip through the code.
>
> 2. Error Handling to check printer installed or not
>       On Error GoTo RESCUE
>                Activesheet.printpreview
>                'your  code
>        GOTO  NEXTSTEP
> RESCUE:
>          '  Your  code  if error
> NEXTSTEP:
>          '  When all is OK
>
> 
> Thanks & Regards
> Ashish Jain
> McKinsey India Knowledge Center
> (Microsoft Certified Application Specialist)
> (Microsoft Certified 
> Professional)http://www.excelitems.comhttp://www.openexcel.com
> 
>
> On Nov 1, 10:31 pm, عمر  wrote:
> > I have a code to copy some data from sheet to another
>
> > In the end of this code
>
> > There is some lines to set up page layout
>
> > "page setup"
>
> > Header and footer
>
> > This part of code doesn't work when I run my file on computer without
> > printer installed
>
> > And give me an error
>
> > The question is
>
> > How can I make this code works well when the printer is installed or when
> > not installed ?
>
> > Thanks
>
> --
> --- 
> ---
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links 
> :http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below 
> linkhttp://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&;...

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

$$Excel-Macros$$ Re: Spreadsheet screen refresh is very slow AFTER macro runs

[Ashish Jain]

Hi Mike,

Can you notice and send the back the change in Memory Usage by Excel
application before and after running the macro? You can locate it in
Task manager. You can try clearing clipboard(Application.CutCopyMode =
False) to experiment harmlessly.




Thanks & Regards
Ashish Jain
McKinsey India Knowledge Center
(Microsoft Certified Application Specialist)
(Microsoft Certified Professional)
http://www.excelitems.com
http://www.openexcel.com


On Nov 1, 9:37 pm, Mike Magill  wrote:
> Hi,
>
> I have a rather long macro that controls and limits the printing
> process for the end user.  It works okay but after running and you
> return to the spreadsheet the screen is very slow to refresh as you
> scroll around the worksheet.
>
> The macro gives the user the choice of viewing a filtered set of
> results on screen (Print_View_Option = "V") or printing out the result
> (Print_View_Option = "V").  I think I've worked out that the issue
> only occurs when the user tries to print out the results and the macro
> adjusts the Page Setup.
>
> I've done some research that suggests the Page Setup routine is
> inherently slow but this doesn't explain the slowness AFTER the macro
> has finished.
>
> I've attached a slightly simplified version of the macro below that
> still manifests the same problem.
>
> Can anyone help?
>
> Sub Print_Options2()
>
>     Dim RR As Object
>     Dim LastRow As Long
>     Dim ReportOrder As String
>     Dim OverallFilterType As String
>     Dim IndividualFilterType As String
>     Dim PaperSize As String
>     Dim ReportType As String
>
>     Set RR = ThisWorkbook.Sheets("Risk Register")
>
>     Print_View_Option = "P"
>     PaperSize = "A4"
>     ReportType = "Full Risk Register"
>     OverallFilterType = "A"
>     IndividualFilterType = "All Individual Control Assessments"
>
>     Application.ScreenUpdating = False
>     Application.EnableEvents = False
>
>     RR.Unprotect Password:=Password
>
>     On Error Resume Next
>     RR.ShowAllData
>     On Error GoTo 0
>
>     ' Ensures any rows with wrapped text are expanded so that all text
> is visible
>     LastRow = RR.Range("AD" & Rows.Count).End(xlUp).Row
>     RR.Rows("6:" & LastRow).EntireRow.AutoFit
>
>     ' Hide rows with no data
>     Selection.AutoFilter Field:=30, Criteria1:="x"
>
>     If Application.Dialogs(xlDialogPrinterSetup).Show Then
>         RR.DisplayPageBreaks = False
>         With RR.PageSetup
>             If PaperSize = "A3" Then
>                 .PaperSize = xlPaperA3
>             Else
>                 .PaperSize = xlPaperA4
>             End If
>             .PrintArea = "$B:$AB"
>             .LeftFooter = _
>                 "&""Arial,Bold""Print Criteria:&""Arial,Regular""" &
> Chr(10) & _
>                 " - " & ReportType & Chr(10) & " - " &
> OverallFilterType & Chr(10) & _
>                 " - " & IndividualFilterType
>             .RightFooter = RR.Range("K1").Value
>         End With
>         ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
>     End If
>
>     ' Show rows with no data
>     Selection.AutoFilter Field:=30
>
>     ' When user has chosen to Print rather than View revert all
> settings back to standard
>     If Print_View_Option = "P" Then
>         ' Revert hidden columns to original state
>         If RR.Range("J2") = "Consolidation" Then
>             RR.Columns("A:A").EntireColumn.Hidden = True
>             RR.Columns("B:B").EntireColumn.Hidden = False
>         Else
>             RR.Columns("A:B").EntireColumn.Hidden = True
>         End If
>         RR.Columns("C:P").EntireColumn.Hidden = False
>         RR.Columns("Q:R").EntireColumn.Hidden = True
>         RR.Columns("S:V").EntireColumn.Hidden = False
>         RR.Columns("X:AB").EntireColumn.Hidden = False
>         RR.Columns("AC:CD").EntireColumn.Hidden = True
>
>         On Error Resume Next
>         RR.ShowAllData
>         On Error GoTo 0
>
>     End If
>
>     RR.Range("I3").Activate
>     RR.Protect Password:=Password, DrawingObjects:=True,
> Contents:=True, Scenarios:=True
>     Application.ScreenUpdating = True
>     Application.EnableEvents = True
>
>     Set RR = Nothing
>
> End Sub

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

$$Excel-Macros$$ Re: Delete values within an array

[Ashish Jain]

Hi Matt,

That's Great. We're our best teachers. Kudos :)



Thanks & Regards
Ashish Jain
McKinsey India Knowledge Center
(Microsoft Certified Application Specialist)
(Microsoft Certified Professional)
http://www.excelitems.com
http://www.openexcel.com


On Nov 4, 11:01 pm, RemyMaza  wrote:
> I ended up fixing this by using a filter on my array:
>
>     'ReDim arrDeviceNames() to trim the "EMPTY DEVICE"
>     arrNonEmptyDeviceNames = Filter(arrDeviceNames, "EMPTY DEVICE",
> False)
>
> Thanks guys,
> Matt
>
> On Nov 3, 9:13 am, RemyMaza  wrote:
>
>
>
>
>
>
>
> > I have an array of values that come in off of a form.  One of these
> > values is "Empty Device".  Here's the code I'm using to handle that:
>
> > Devices = Array(cmb1.Value, cmb2.Value, cmb3.Value, cmb4.Value,
> > cmb5.Value, cmb6.Value, cmb7.Value)
>
> > Now that I have my Devices array, I loop through the number of devices
> > that were selected and assign values to other variables and another
> > array.  Here's some of that code:
>
> >     For i = 0 To UBound(Devices)
> >         If Not Devices(i) = "" Then NumOfDevices = NumOfDevices + 1
> >         If Devices(i) = "EMPTY DEVICE" Then NumOfEmptyDevices =
> > NumOfEmptyDevices + 1
> >         'Match Description to Ganged
> >         Select Case True
> >             Case Devices(i) = "EMPTY DEVICE"
> >                 Ganged = Ganged & "X "
> >                 ReDim Preserve arrDeviceName(0 To i)
> >                 arrDeviceName(i) = "EMPTY DEVICE"
>
> >             Case Devices(i) = "20A RECEPTACLE"
> >                 Ganged = Ganged & "O "
> >                 ReDim Preserve arrDeviceName(0 To i)
> >                 arrDeviceName(i) = "D20120"
>
> >             Case Devices(i) = "20A GFI"
> >                 Ganged = Ganged & "G "
> >                 ReDim Preserve arrDeviceName(0 To i)
> >                 arrDeviceName(i) = "G20120"
>
> > I need to find out a way to handle "EMPTY DEVICES".  Later on in the
> > code, I loop through the TotalNumOfDevices which equals all of the
> > devices picked except for "EMPTY DEVICE".  That throws off my looping,
> > because the numbers aren't ever equal when these are chosen.  How
> > would I dip into the arrDeviceName array and trim out all of the
> > "EMPTY DEVICES".  Better yet, would be how to keep "EMPTY DEVICE" from
> > even getting into the arrary.  Currently, when I comment out the ReDim
> > statment for "EMPTY DEVICE", I still get a value of "" within my
> > array.  This essentially is throwing off the whole calculation.
>
> > I'd appreciate any input!
> > Cheers,
> > Matt

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

$$Excel-Macros$$ Re: Excel_tips

[Ashish Jain]

Thanks Viju for sharing these tips. Great. Keep it up :)



Regards
Ashish Jain
McKinsey India Knowledge Center
(Microsoft Certified Application Specialist)
(Microsoft Certified Professional)
http://www.excelitems.com
http://www.openexcel.com


On Nov 8, 4:05 pm, viju mobile  wrote:
>  Excel_tips simple.pps
> 574KViewDownload

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

$$Excel-Macros$$ Re: Happy Diwali

[Ashish Jain]

Wish you all fantastic work, appraisals and growth on the occasion of
Deepawali. May this auspicious occasion brings good health and lots of
wealth in your lives.

HaPpY CoDiNg !! HaPpY DiWaLi !! HaPpY ExCeL !!


Thanks & Regards
Ashish Jain
McKinsey India Knowledge Center
(Microsoft Certified Application Specialist)
(Microsoft Certified Professional)
http://www.excelitems.com
http://www.openexcel.com


On Nov 5, 10:54 pm, neil johnson  wrote:
> Hi Everyone,
>
> Wish you  happy Diwali to all my sir, and friends .
>
> Thanks

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

$$Excel-Macros$$ Re: Data Keep Varies

[Ashish Jain]

Hi Vaibhav,

You can use DYNAMIC NAMED RANGES or END Function.
1. Dynamic Named Range
=OFFSET(Sheet1!A1,0,0,COUNTA(Sheet1!$A:$A),1
Please refer Microsoft Help for Offset function to better understand
the arguments.

2. VBA END Function
You can determine last row instead of hard coding in your logic,
similar to this:
Range("A1048576").End(xlup).Row
or
Range("A1048576").End(xlup).offset(1,0).Row

Feel free to write, if further help required on this...


____
Thanks & Regards
Ashish Jain
McKinsey India Knowledge Center
(Microsoft Certified Application Specialist)
(Microsoft Certified Professional)
http://www.excelitems.com
http://www.openexcel.com




On Nov 4, 7:01 pm, vebhav jain  wrote:
> Hi All,
>
> With the help of macros, i recorded the whole data. The problem is that data
> keep varying every day and i have to adjust the data manually everyday to
> run the macros. Please can you suggest better way to take the data, instead
> of changing manually everyday.
>
> Example.
>
> Column A has 450 data on 1st november
>
> Next day
> Column A has 456 data..so i dont want to change the macros data everyday
> manually.
>
>         I hope you understood my query.
>
> Thanks
> Vebhav Jain

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

$$Excel-Macros$$ Re: is there a printer installed on this computer?

[Ashish Jain]

Hi Omar,

There are 2 ways:
1. You can get the printer name using
 Application.ActivePrinter
So, if there is no printer installed, skip through the code.


2. Error Handling to check printer installed or not
  On Error GoTo RESCUE
   Activesheet.printpreview
   'your  code
   GOTO  NEXTSTEP
RESCUE:
 '  Your  code  if error
NEXTSTEP:
 '  When all is OK



Thanks & Regards
Ashish Jain
McKinsey India Knowledge Center
(Microsoft Certified Application Specialist)
(Microsoft Certified Professional)
http://www.excelitems.com
http://www.openexcel.com




On Nov 1, 10:31 pm, عمر  wrote:
> I have a code to copy some data from sheet to another
>
> In the end of this code
>
> There is some lines to set up page layout
>
> "page setup"
>
> Header and footer
>
> This part of code doesn't work when I run my file on computer without
> printer installed
>
> And give me an error
>
> The question is
>
> How can I make this code works well when the printer is installed or when
> not installed ?
>
> Thanks

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Re: $$Excel-Macros$$ array sort issue

[Ashish Jain]

Hi Ted,

Instead of "Excel.WorksheetFunction.Len" just use "Len".
So your code would look like:
iLen = Len(ary(iLoc))

Len function is available as VBA function too, so you
don't need to use excel function. This is same as you
are doing for conditional statement, IF.

Note: The moment you press . (period or dot) all the
functions, objects and properties appear alongwith.
So, when you'll check, you won't find any LEN method
under WorksheetFunction.


________
Thanks & Regards
Ashish Jain
McKinsey India Knowledge Center
(Microsoft Certified Application Specialist)
(Microsoft Certified Professional)
http://www.excelitems.com
http://www.openexcel.com




On Nov 8, 11:46 pm, Ted  wrote:
> In an attempt to develop my own sort for an array, I seem to have run
> into a problem.  I don't know what I 'm doing wrong specifically, but
> as soon as I attempt to invoke the Len Function, the whole thing
> breaks.  subscript out of range error.  I think I may be overthinking
> this, so any guidance is much appreciated.
>
> Public Function arraySortByStringLength(ary As Variant)
>     Dim iLoc As Long, iLen As Integer, iAry As Variant, i As Long
>     Dim val As String, indx As Long
>     iLen = 
>     ReDim iAry(UBound(ary))
>     i = 0
>     indx = 0
>     Do
>         For iLoc = 0 To UBound(ary)
>             If Len(ary(iLoc)) < iLen Then
>                 iLen = Excel.WorksheetFunction.Len(ary(iLoc))
>                 indx = iLoc
>                 val = ary(iLoc)
>             End If
>         Next iLoc
>         iAry(i) = val
>         ReDim Preserve ary(UBound(ary) - 1)
>         ary = arraySlice(ary, indx)
>         i = i + 1
>     Loop Until UBound(ary) < 1
>     arraySortByStringLength = iAry
> End Function

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

$$Excel-Macros$$ Re: Excel 2007 to 2003

[Ashish Jain]

Hi Sachin,

Visit this link - http://excel2003menu.excelitems.com
Alternatively, if you remember the shortcuts of excel 2003, then you
can you use them too. Excel 2003 shortcuts works very well in Excel
2007 like Alt+D+S(to sort the values) & Alt+F+A(To save as) etc etc.





Regards
Ashish Jain
McKinsey India Knowledge Center
(Microsoft Certified Application Specialist)
(Microsoft Certified Professional)
http://www.excelitems.com
http://www.openexcel.com





On Nov 2, 7:50 am, "sachin83_1...@yahoo.com" 
wrote:
> hey friends, i need to knw is there any shortcut or key to convert
> Excel 2007 to 2003 n vise versa, pls help me out

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

$$Excel-Macros$$ OPEN EXCEL - Needs your support and enthusiasm...

[Ashish Jain]

Dear Members,

We're proud to launch OPEN EXCEL under the GNU Public License v3 which
means it's available with source code to reach the maximum users
around the globe with rapid development, more robust & innovative
features. Since, public forums like these are hub of great
professionals, knowledge sharers and bug shooters, hence we thought to
launch it here. While beginners may download it, use it and can learn
from it, amateur, experienced and professionals may contribute their
some time and mind in developing it further ...

Below are Google project links to download, develop and suggest new
features in OPEN EXCEL :)

Download - http://code.google.com/p/openexcel/downloads/list
Suggest New Feature - http://code.google.com/p/openexcel/issues/list
Develop - Reply this post with your mail id, so that you can be added
as developer in the project and project's mailing lists.





Thanks & Regards
Ashish Jain
McKinsey India Knowledge Center
(Microsoft Certified Application Specialist)
(Microsoft Certified Professional)
http://www.excelitems.com
http://www.openexcel.com

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

$$Excel-Macros$$ Re:

[Ashish Jain]

Hi Omar,

-5004 is equivalent to VB constant xlRTL (means Right to Left)

Difference between 2 lines is:
1st Line - Turn the Excel Sheet direction for all sheets and new
workbooks that will be opened in the Application. So, basically it
will change the default settings of the Excel Application.

2nd Line - Turn the Sheet direction only for one sheet(in this case
first sheet of the workbook as Sheets(1) is used). The Excel
application and new workbooks will remain unaffected.

Please Note: Like, xlRTL - xlLTR is also available.





Regards
Ashish Jain
McKinsey India Knowledge Center
(Microsoft Certified Application Specialist)
(Microsoft Certified Professional)
http://www.excelitems.com
http://www.openexcel.com



On Oct 29, 12:23 am, عمـر  wrote:
> Sheets(1).Application.DefaultSheetDirection = -5004
>
> Sheets(1).DisplayRightToLeft = true
>
> This number -5004
>
> What is this number mean?
>
> And what is the different between that two lines?

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

$$Excel-Macros$$ Re: Need Suggestion!

[Ashish Jain]

Hello,

Try using "Share Workbook" feature of MS Excel. This will also help
you in monitoring WHO changed from which OLD_VALUE to what NEW _VALUE
through hidden HISTORY worksheet.



Regards
Ashish Jain
McKinsey India Knowledge Center
(Microsoft Certified Application Specialist)
(Microsoft Certified Professional)
http://www.excelitems.com
http://www.openexcel.com

On Oct 26, 10:19 am, amrahs k  wrote:
> Dear Experts,
>
> I need quick suggestion to solve the below issue.
>
> Issue: Team use to update a spreadsheet for tracking their hours details for
> extending the shift. After a day the values in the spreadsheet gets changed
> this is because people might miss use it. So I want a backup spreadsheet of
> this to trace the changes.
> Whatever they are updating or changing in the spreadsheet1 will need
> to reflect in spreadsheet2 for my reference.
>
> Can this be done through VBA?
>
> Please share your thoughts to make life simple.
>
> Many thanks in Advance,
>
> -Sharma

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

$$Excel-Macros$$ Manipulating Userform controls' back color by one routine instead of separate change routines

[Ashish Jain]

Hi Paul & Learner

Sorry that's for VSTO guys - just got confused:
Try this:
Private Sub UserForm_Click()
Dim ctrl As Control
For Each ctrl In UserForm1.Controls
If TypeName(ctrl) = "TextBox" Then
With ctrl
If Trim(.Text) <> "" Then
.BackColor = vbRed
End If
End With
End If
If TypeName(ctrl) = "ComboBox" Then
With ctrl
If Trim(.Text) <> "" Then
.BackColor = vbYellow
End If
    End With
End If
Next ctrl
End Sub





Regards
Ashish Jain
McKinsey India Knowledge Center
(Microsoft Certified Application Specialist)
(Microsoft Certified Professional)
http://www.excelitems.com
http://www.openexcel.com


___

On Oct 27, 4:57 pm, Paul Schreiner  wrote:
> Interesting...
> I've not come across this before.
> I tried to pop it into one of my userforms, but it doesn't like the "Handles"
> part
> after the )... it expects the end of the statement.
>
> Is there some Reference I need to include?
>
> Paul
>
>
>
>
>
>
>
> - Original Message 
> > From: Ashish Jain 
> > To: MS EXCEL AND VBA MACROS 
> > Sent: Wed, October 27, 2010 7:34:35 AM
> > Subject: $$Excel-Macros$$ Re: Manipulating Userform controls' back color by 
> > one
> >routine instead of separate change routines
>
> > Hello Mr. Learner,
>
> > There are 2 ways to resolve your issue:
>
> > i. Sharing Event Handlers
> > Private Sub TextBoxes_TextChanged(ByVal sender As System.Object, _
> > ByVal e As System.EventArgs) Handles TextBox1.TextChanged, _
> > TextBox2.TextChanged, TextBox3.TextChanged
> >         TextBox1.BackColor = RGB(255, 150, 200)
> >         TextBox2.BackColor = RGB(255, 150, 200)
> >         TextBox3.BackColor = RGB(255, 150, 200)
> > End Sub
>
> > ii. Iterating Through Controls
> > Private Sub ChangeBackColor(ByVal container As Control)
> >     Dim ctrl As Control
> >     For Each ctrl In container.Controls
> >         If TypeOf (ctrl) Is TextBox Then
> >             ctrl.BackColor = ""
> >         End If
> >         If ctrl.HasChildren Then
> >             ClearText(ctrl)
> >         End If
> >     Next
> > End Sub
>
> > Regards
> > Ashish Jain
> > McKinsey India Knowledge Center
> > (Microsoft Certified Application Specialist)
> > (Microsoft Certified Professional)
> >http://www.excelitems.com
> >http://www.openexcel.com
>
> > On Oct 27, 3:00 pm, learner  wrote:
> > > Hi! All Members,
>
> > > I am a new member seeking guidance on a problem I can't solve.
>
> > > A Userform  having 96 Controls (TextBoxes + ComboBoxes) captures data
> > > to create a worksheet. I need to change back color of each control as
> > > data is entered by the user to indicate that the control is already
> > > visited. Instead of writing 96 change routines, I am sure there must
> > > be a simple solution.
>
> > > Please advise how to manage it by only one routine.
>
> > > Thanks
>
> > > Learner
>
> > --
> >-- 
> >
> >-
> > Some important links for excel users:
> > 1. Follow us on TWITTER for tips tricks and links :
> >http://twitter.com/exceldailytip
> > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
> > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> > To post to this group, send email to excel-macros@googlegroups.com
>
> > <><><><><><><><><><><><><><><><><><><><><><>
> > Like our page on facebook , Just follow below link
> >http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&;...

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

$$Excel-Macros$$ Re: Manipulating Userform controls' back color by one routine instead of separate change routines

[Ashish Jain]

Hello Mr. Learner,

There are 2 ways to resolve your issue:

i. Sharing Event Handlers
Private Sub TextBoxes_TextChanged(ByVal sender As System.Object, _
ByVal e As System.EventArgs) Handles TextBox1.TextChanged, _
TextBox2.TextChanged, TextBox3.TextChanged
TextBox1.BackColor = RGB(255, 150, 200)
TextBox2.BackColor = RGB(255, 150, 200)
TextBox3.BackColor = RGB(255, 150, 200)
End Sub




ii. Iterating Through Controls
Private Sub ChangeBackColor(ByVal container As Control)
Dim ctrl As Control
For Each ctrl In container.Controls
If TypeOf (ctrl) Is TextBox Then
ctrl.BackColor = ""
End If
If ctrl.HasChildren Then
 ClearText(ctrl)
End If
Next
End Sub






Regards
Ashish Jain
McKinsey India Knowledge Center
(Microsoft Certified Application Specialist)
(Microsoft Certified Professional)
http://www.excelitems.com
http://www.openexcel.com








On Oct 27, 3:00 pm, learner  wrote:
> Hi! All Members,
>
> I am a new member seeking guidance on a problem I can't solve.
>
> A Userform  having 96 Controls (TextBoxes + ComboBoxes) captures data
> to create a worksheet. I need to change back color of each control as
> data is entered by the user to indicate that the control is already
> visited. Instead of writing 96 change routines, I am sure there must
> be a simple solution.
>
> Please advise how to manage it by only one routine.
>
> Thanks
>
> Learner

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

$$Excel-Macros$$ Re: Excel Date format dd/mm/yyyy hh:mm:ss

[Ashish Jain]

Hi Anju,

There is no formula required. You need to understand the concept.
First follow these steps and see if you understand the problem or need
explanation.

1. Close all Excel applications.
2. Open "Regional and Language Options" from "Control Panel".
(Start --> Settings --> Control Panel --> Regional and Language
Options)
3. Under "Regional Options" tab, change "English (United States)" to
"English (United Kingdom)".
4. Click Ok.

This should resolve your problem.



Regards
Ashish Jain
McKinsey India Knowledge Center
(Microsoft Certified Application Specialist)
(Microsoft Certified Professional)
http://www.excelitems.com
http://www.openexcel.com




On Oct 27, 2:26 pm, Anju  wrote:
>  Hi ,
>
> Please help to format the dates in attached excel file to dd/mm/
> hh:mm:ss. when i treid formating the dates somedates format was dd/mm/yy
> hh:mm:ss...but i need as dd/mm/ hh:mm:ss for all the dates.
>
> Thanks
>
>  DateFormat.xlsx
> 538KViewDownload

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Re: $$Excel-Macros$$ Re: help in understanding code

[Ashish Jain]

Hi Omar,


Since the code is displaying in-built popups/windows, there is no "for
loop" required. However, sheets can be displayed using for loop but
here in this code, to select any sheet from workbook, it's not
required.


Regards
Ashish Jain
McKinsey India Knowledge Center
(Microsoft Certified Application Specialist)
(Microsoft Certified Professional)
http://www.excelitems.com
http://www.openexcel.com

On Oct 22, 4:32 pm, عمر  wrote:
> Sorry
> I don't understand from which line the code get the list of sheets names?
> There is no (for.. next) in code
> Thank u very much
>
>
>
>
>
>
>
> -Original Message-
> From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On 
> Behalf Of Ashish Jain
> Sent: Friday, October 22, 2010 10:34 AM
> To: MS EXCEL AND VBA MACROS
> Subject: $$Excel-Macros$$ Re: help in understanding code
>
> Hi Omar
>
> Here is line by line description of the VBA code you provided:
>
> Sub OMAR_QUERY()
> 'Error Handling ON: In case of error, it will skip to next line.
>     On Error Resume Next
>     'Error handling used specifically for this line of code.
>     'If there are more than 16 worksheets, it will execute else will
> throw an error.
>     'It will display the 'activate' window to activate the worksheet
> required.
>         Application.CommandBars("Workbook Tabs").Controls("More
> Sheets...").Execute
>         'In case of less than 16 sheets, error will be thrown and
> execution will enter in IF block.
>         If Err.Number > 0 Then
>             'Clear the error cache.
>             Err.Clear
>             'It will display a pop-up to activate the worksheet
> required.
>             Application.CommandBars("Workbook Tabs").ShowPopup
>         'End of If Block
>         End If
>         'Scroll to the first column of activated worksheet.
>         ActiveWindow.ScrollColumn = 1
>         'Scroll to the first row of activated worksheet.
>         ActiveWindow.ScrollRow = 1
> 'Error Handling OFF
>     On Error GoTo 0
> End Sub
>
> Regards
> Ashish Jain
> McKinsey India Knowledge Center
> (Microsoft Certified Application Specialist)
> (Microsoft Certified Professional)
>
> On Oct 21, 10:13 pm, عمر  wrote:
> > This code make a popup  with sheetsList
>
> > But I don't understand how it works
>
> > On Error Resume Next
>
> >   Application.CommandBars("Workbook Tabs").Controls("More
> > Sheets...").Execute
>
> >   If Err.Number > 0 Then
>
> >     Err.Clear
>
> >     Application.CommandBars("Workbook Tabs").ShowPopup
>
> >   End If
>
> >   ActiveWindow.ScrollColumn = 1
>
> >   ActiveWindow.ScrollRow = 1
>
> >   On Error GoTo 0
>
> > Except this
>
> > Application.CommandBars("Workbook Tabs").Controls("More Sheets...").Execute
>
> >   If Err.Number > 0 Then
>
> >     Err.Clear
>
> >     Application.CommandBars("Workbook Tabs").ShowPopup
>
> --
> --- 
> ---
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links 
> :http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below 
> linkhttp://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&;...

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

$$Excel-Macros$$ Re: Annoying popup for with Cancel button when opening workbooks

[Ashish Jain]

Hi Simon,

Application.DisplayAlerts = False still works !
It works in all versions of excels i.e.2003, 2007 & 2010.

Take Care of these points:
  1.  Use new event macro - Private Sub Workbook_Open()
  2.  Enable the Macros(Right below Formula Bar) whenever you open the
workbook.



Regards
Ashish Jain
McKinsey India Knowledge Center
(Microsoft Certified Application Specialist)
(Microsoft Certified Professional)
http://www.excelitems.com
http://www.openexcel.com

On Oct 22, 6:05 pm, simonl  wrote:
> We recently upgraded to Excel 2007 from Excel 2000. I have a VB6 app
> that uses Automation to start Excel, loop thru a lot of workbooks
> opening each of them and then check various things in the workbook. It
> worked fine in Excel 2000 and uses Application.Visible = False and
> Application.DisplayAlerts = False. I now find that Excel 2007 pops up
> a "progress bar" form with a Cancel button when opening some of the
> files (maybe where the size of the file exceeds some value). The files
> are in the "old" XLS format. Does anyone know of how to stop this form
> from appearing?
>
> Have tried googling but could only find the DisplayAlerts = False
> which I am already using.
>
> Thanks
>
> Simon

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

$$Excel-Macros$$ Re: Quite a bit of help needed for inexperienced MS Excel 2003 user.

[Ashish Jain]

Hi Dean,

Here is the solution:

1. & 2.  Just use this formula
Excel 2007 or Excel 2010
=IFERROR((I55/I54)*3600," ")
Excel 2003 or older
=IF(ISERROR((I55/I54))," ",(I55/I54)*3600)

3. In cell A10, use the formula below(any version of excel):
=If(A9<=0.5,2,If(A9<=0.8,3,If(A9>=0.8,4,3)))

4. Watch and then do the steps below:
   i. Press Ctrl+A to select all cells.
   ii. Right click and choose "Format Cells".
   iii. Go to Protection Tab and select "Locked" - Click Ok.
   iv. Now go to those cells which needs to be unlocked(allow to enter
data) -
repeat the steps above and uncheck the "Locked".
v.  In case of 2007/2010
Review --> Protect Sheet
v.  In case of Office XP/2003
Tools --> Protection --> Protect Sheet
vi.  and give password --> that's it :)




Regards
Ashish Jain
McKinsey India Knowledge Center
(Microsoft Certified Application Specialist)
(Microsoft Certified Professional)
http://www.excelitems.com
http://www.openexcel.com


On Oct 22, 2:49 pm, Dean Brown  wrote:
> Hi group.
>
> I am very inexperienced in using MS Excel however I am trying to
> develop a simple spreadsheet which will do a calculation that I have
> to do on a regular basis. I have several questions which I hope that
> the people within this group can kindly help me with.
>
> Ok, here goes.
>
> 1 - I want a cell to contain the calculation (I55*3600)/I54 is the
> syntax simply =(I55*3600)/I54 I've currently got the
>      formula =SUM(I55*3600)/I54 in this cell. I have believe that this
> formula is incorrect.
>
> 2 - The cell where the above formula is located contains the message
> #DIV/O! until a value is input into another
>      cell. How can I stop this error message from being displayed?
>
> 3 - I want cell A10 to look at cell A9. The value of cell A10 will
> vary depending on what value is in cell A9.
>      Basically I want a formula in cell A10 which says: If A9 is less
> than or equal to .5 then A10 = 2 but if A9 is
>      greater than .5 but less than or equal to .8 then A10 = 3 or if
> A9 is greater than .8 then A10 = 4
>
> 4 - I want the operator of the spreadsheet to be able to input
> information into some cells but not be allowed to
>      alter the data in other cells. How can I protect cells to prevent
> the user of the spreadsheet from altering their
>      content?
>
> Hope someone can help me out within the group.
>
> TIA.
>
> Dean.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

$$Excel-Macros$$ Re: An Alternative to 'Microsoft Visual Basic For Applications Extensibility'

[Ashish Jain]

Hi Chris

Due to the security reasons, this is not possible through VBA/VSTO.


Regards
Ashish Jain
McKinsey India Knowledge Center
(Microsoft Certified Application Specialist)
(Microsoft Certified Professional)
http://www.excelitems.com
http://www.openexcel.com



On Oct 20, 7:06 pm, ChrisDixon  wrote:
> I have a problem that could easily be solved using Microsoft Visual
> Basic For Applications Extensibility, but cannot enable the 'Trust
> Access to the VB Project Object Model' setting, so must find another
> solution
>
> From within Workbook A, I want to retrieve a list of forms, modules,
> functions and subs from Workbook B.  Either of the following methods
> would be fine:
>
> Workbook A to pull the details from Workbook B
>
> Workbook B to push the details to a text file and Workbook A to pick
> up the text files
>
> Does anybody know of a way to get these details out of Workbook B
> without resorting to VBE?

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

$$Excel-Macros$$ Re: An Alternative to 'Microsoft Visual Basic For Applications Extensibility'

[Ashish Jain]

Hi Chris

Due to the security reasons, this is not possible neither through VBA
nor VSTO.


Regards
Ashish Jain
McKinsey India Knowledge Center
(Microsoft Certified Application Specialist)
(Microsoft Certified Professional)
http://www.excelitems.com
http://www.openexcel.com




On Oct 20, 7:06 pm, ChrisDixon  wrote:
> I have a problem that could easily be solved using Microsoft Visual
> Basic For Applications Extensibility, but cannot enable the 'Trust
> Access to the VB Project Object Model' setting, so must find another
> solution
>
> From within Workbook A, I want to retrieve a list of forms, modules,
> functions and subs from Workbook B.  Either of the following methods
> would be fine:
>
> Workbook A to pull the details from Workbook B
>
> Workbook B to push the details to a text file and Workbook A to pick
> up the text files
>
> Does anybody know of a way to get these details out of Workbook B
> without resorting to VBE?

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Re: $$Excel-Macros$$ Fwd: Help please

[Ashish Jain]

Hi Hemant,

This group is to help MS Excel & Office applications users in their
day-to-day issues to raise their self-esteem with technology usage. We
encourage you to proceed with the first step and we'll help you rest :)

Regards
Ashish Jain
McKinsey India Knowledge Center
(Microsoft Certified Application Specialist)
(Microsoft Certified Professional)
http://www.excelitems.com
http://www.openexcel.com





On Fri, Oct 22, 2010 at 1:40 AM, hemant shah  wrote:

> Hi Team,
>
> Your help required for the attached sheet.
>
> Regards,
> Hemant Shah
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

$$Excel-Macros$$ Re: help in understanding code

[Ashish Jain]

Hi Omar

Here is line by line description of the VBA code you provided:


Sub OMAR_QUERY()
'Error Handling ON: In case of error, it will skip to next line.
On Error Resume Next
'Error handling used specifically for this line of code.
'If there are more than 16 worksheets, it will execute else will
throw an error.
'It will display the 'activate' window to activate the worksheet
required.
Application.CommandBars("Workbook Tabs").Controls("More
Sheets...").Execute
'In case of less than 16 sheets, error will be thrown and
execution will enter in IF block.
If Err.Number > 0 Then
'Clear the error cache.
Err.Clear
'It will display a pop-up to activate the worksheet
required.
Application.CommandBars("Workbook Tabs").ShowPopup
'End of If Block
End If
'Scroll to the first column of activated worksheet.
ActiveWindow.ScrollColumn = 1
'Scroll to the first row of activated worksheet.
    ActiveWindow.ScrollRow = 1
'Error Handling OFF
On Error GoTo 0
End Sub



Regards
Ashish Jain
McKinsey India Knowledge Center
(Microsoft Certified Application Specialist)
(Microsoft Certified Professional)





On Oct 21, 10:13 pm, عمر  wrote:
> This code make a popup  with sheetsList
>
> But I don't understand how it works
>
> On Error Resume Next
>
>   Application.CommandBars("Workbook Tabs").Controls("More
> Sheets...").Execute
>
>   If Err.Number > 0 Then
>
>     Err.Clear
>
>     Application.CommandBars("Workbook Tabs").ShowPopup
>
>   End If
>
>   ActiveWindow.ScrollColumn = 1
>
>   ActiveWindow.ScrollRow = 1
>
>   On Error GoTo 0
>
> Except this
>
> Application.CommandBars("Workbook Tabs").Controls("More Sheets...").Execute
>
>   If Err.Number > 0 Then
>
>     Err.Clear
>
>     Application.CommandBars("Workbook Tabs").ShowPopup

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

$$Excel-Macros$$ Re: Unable to open workbooks from custom functions?

[Ashish Jain]

Hi Mike,

You cannot use Event Methods like Open, Activate, Select etc in Custom
Functions.

Regards
Ashish Jain
Microsoft Certified Application Specialist (Excel)
http://www.excelitems.com
http://www.openexcel.com


__

On May 28, 9:11 pm, Mike Ratcliffe 
wrote:
> I have a custom function that needs to read data from an external
> worksheet.
>
> To make sure that the workbook is open I use the following method:
> Sub EnsureWorkbookOpen(ByVal fPath As String, ByVal fName As String)
>     On Error Resume Next
>     Err.Clear
>
>     Workbooks(fName).Activate
>     If Err.Number <> 0 Then
>         Workbooks.Open(fPath & fName).Activate
>     End If
> End Sub
>
> This works fine from ribbon buttons etc. but if this method is called
> from within a custom function (=myfunc(A4)) the worksheet is not
> opened because Workbooks.Open(...) returns Nothing.
>
> Is there some kind of limitation when it comes to making sure that
> files are open (and opening them if they are not open) from within
> custom functions and does anybody know a workaround?

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

$$Excel-Macros$$ Re: Need help to prepare control charts in Excel

[Ashish Jain]

Hi,

Hope it helps - http://www.wikihow.com/Create-a-Control-Chart

--
 Thanks & Regards
 Ashish Jain
 Ph. No. - 0x25402CF2B

 http://www.excelitems.com
* Excel,VBA,VSTO Trainer*

 http://www.openexcel.com
* (Developer of OpenXL)*

 http://www.mastweekend.com
* (Make different, this weekend)*

---

On Sep 15, 11:23 am, Chandu  wrote:
> Hi Friends,
>
> Can any one help me on how to prepare control charts in Excel.
>
> if possible send me some tutorials / information on the same...
>
> Look forward to your co-operations
>
> Regards,
> Chandu
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Change Slide in PowerPoint when Copying Charts from Excel in VBA

[Ashish Jain]

 Hi Robert

Please visit -
http://www.excelitems.com/2009/09/export-excel-2007-charts-to-powerpoint.html
for full code and usage.

or use the code below
 'Check that a slide exits, if it doesn't add 1 slide. Else use
the last slide for the paste operation
If ppApp.ActivePresentation.Slides.Count = 0 Then
Set ppSlide = ppApp.ActivePresentation.Slides.Add(1,
ppLayoutBlank)
Else
If AddSlidesToEnd Then
 'Appends slides to end of presentation and makes last
slide active
ppApp.ActivePresentation.Slides.Add
ppApp.ActivePresentation.Slides.Count + 1, ppLayoutBlank
ppApp.ActiveWindow.View.GotoSlide
ppApp.ActivePresentation.Slides.Count
Set ppSlide = ppApp.ActivePresentation.Slides
(ppApp.ActivePresentation.Slides.Count)
Else
 'Sets current slide to active slide
Set ppSlide = ppApp.ActiveWindow.View.Slide
End If
End If


 
--
 Thanks & Regards
 Ashish Jain
 Ph. No. - 0x25402CF2B

 http://www.excelitems.com
* Excel,VBA,VSTO Trainer*

 http://www.openexcel.com
* (Developer of OpenXL)*

 http://www.mastweekend.com
* (Make different, this weekend)*
 
---

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Puzzle #4 - Calculate Probabilities

[Ashish Jain]

Hi All,

@Satish -
You are just near the solution, which means that the information/
formulas contained in your workbook are not right. I asked for the
probabilities not the Sum. Try to modify your formulae and you will
achieve the perfect solution. Your try is appreciable. Just, take one
more step.

@Bruno,
Like always, you've done very well and fantastic. Your solutions are
very impressive and an honour for this group.

@All Group Members,
Future puzzles will judge your excel acumen unlike your logic as in
the previous puzzles. So, be ready and keep enjoying.

Thanks & Regards
Ashish Jain
http://www.excelitems.com
http://www.openexcel.com


On Sep 14, 9:58 am, "Sathish Jalendran"  wrote:
> Hi Ashish,
>
> Please find attached have solved the same
>
> Regards
>
> Sathish Jalendran
>
> From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
> On Behalf Of Ashish Jain
> Sent: 12 September 2009 AM 10:06
> To: excel-macros@googlegroups.com
> Subject: $$Excel-Macros$$ Puzzle #4 - Calculate Probabilities
>
> Hi All,
>
> This is challenge for all excel users. Solve these puzzles and sharpen your
> excel acumen. So, here goes the fourth puzzle of "Excel Macros Google Group"
> in the attached file.
>
> Old Puzzles:
> Puzzle #1 
> -http://groups.google.com/group/excel-macros/browse_thread/thread/3922...
> fa2b1
> Solved by - Harmeet Only.
> Puzzle #2 
> -http://groups.google.com/group/excel-macros/browse_thread/thread/b4d2...
> d7c8a
> Solved by - Harmeet, Bruno and Sandeep
> Puzzle #3 
> -http://groups.google.com/group/excel-macros/browse_thread/thread/9d12...
> e0452
> Solved by - Bruno and Sandeep only.
>
> --
> Thanks & Regards
> Ashish Jain
> (Excel Macros - Google Group 
> Manager)http://www.excelitems.com<http://www.excelitems.com/>  
> (Developer of OpenXL)http://www.openexcel.com<http://www.openexcel.com/>  
>
> Excel,VBA,VSTO Trainer
> Ph. No. - 0x25402CF2B
> ---
>
> The information contained in this electronic message and any attachments to 
> this message are intended for the exclusive
> use of the addressee(s) and may contain proprietary, confidential or 
> privileged information. If you are not the intended
>  recipient, you should not disseminate, distribute or copy this e-mail. 
> Please notify the sender immediately and destroy
>  all copies of this message and any attachments contained in it.
>
>  Puzzle 4 solved.xlsx
> 116KViewDownload
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Excel Macro to export graphs from Excel to Powerpoint

[Ashish Jain]

> Hi Mohit,
>
> Please visit -
> http://www.excelitems.com/2009/09/export-excel-2007-charts-to-powerpoint.html
> or check the VBA Code in attached file.
>
> --
> Thanks & Regards
> Ashish Jain
> (Excel Macros - Google Group Manager)
> http://www.excelitems.com
> (Developer of OpenXL)
> http://www.openexcel.com
> Excel,VBA,VSTO Trainer
> Ph. No. - 0x25402CF2B
> ---
>
>
>
> On Sat, Sep 12, 2009 at 7:19 PM, Mohit Agarwal wrote:
>
>>
>>
>> Hi Everyone,
>>
>> I am new to VBA and am not sure whether it is even possible to do it from
>> an Excel Macro.
>>
>> I am attaching an Excel Sheet and a powerpoint template. I have some
>> graphs in different worksheets. I want to export them to powerpoint as
>> Enhanced Metafile image. All the powerpoint slides have a pre-defined
>> constant structure and only the Graphs and text in red is to be changed
>> according to the information in excel. The graphs are always to be pasted at
>> a fixed location on the slide.
>>
>> So is it possible to have a macro code that automatically exports all the
>> graphs as Enhanced Metafile images at the fixed location on PPT and changes
>> the text as well. Even if i can have a macro code that just pastes the graph
>> at the fixed location without changing the text will do. I always have to
>> copy paste the graph and adjust its formatting. If it can be done it will be
>> really great.
>>
>> Regards
>> Mohit Agarwal
>> 09214368691
>>
>> "We are what we do repeatedly. Excellence then, is not an act, but a
>> habbit"- Aristotle
>>
>> >>
>>
>

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---



Export_Excel_to_Powerpoint.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

$$Excel-Macros$$ Re: Excel Macro to export graphs from Excel to Powerpoint

[Ashish Jain]

Hi Mohit,

Please visit -
http://www.excelitems.com/2009/09/export-excel-2007-charts-to-powerpoint.html
or check the VBA Code in attached file.

--
Thanks & Regards
Ashish Jain
(Excel Macros - Google Group Manager)
http://www.excelitems.com
(Developer of OpenXL)
http://www.openexcel.com
Excel,VBA,VSTO Trainer
Ph. No. - 0x25402CF2B
---


On Sat, Sep 12, 2009 at 7:19 PM, Mohit Agarwal  wrote:

>
>
> Hi Everyone,
>
> I am new to VBA and am not sure whether it is even possible to do it from
> an Excel Macro.
>
> I am attaching an Excel Sheet and a powerpoint template. I have some graphs
> in different worksheets. I want to export them to powerpoint as Enhanced
> Metafile image. All the powerpoint slides have a pre-defined
> constant structure and only the Graphs and text in red is to be changed
> according to the information in excel. The graphs are always to be pasted at
> a fixed location on the slide.
>
> So is it possible to have a macro code that automatically exports all the
> graphs as Enhanced Metafile images at the fixed location on PPT and changes
> the text as well. Even if i can have a macro code that just pastes the graph
> at the fixed location without changing the text will do. I always have to
> copy paste the graph and adjust its formatting. If it can be done it will be
> really great.
>
> Regards
> Mohit Agarwal
> 09214368691
>
> "We are what we do repeatedly. Excellence then, is not an act, but a
> habbit"- Aristotle
>
> >
>

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---



Export_Excel_to_Powerpoint.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

$$Excel-Macros$$ Re: adding keyboard shortcuts to XLA macros

[Ashish Jain]

Hi Sneddon,

This is true that add-in macros don't turn up in MACROS window (Alt +
F8). There is no way to show them up too. But, if you know the name of
your macros, you can run or assign keystrokes to them. Below are the
examples.

Syntax - ''!

Example
1. Workbook Name - Office Utils.xla
2. Macro Name - Generate_Invoice
So, you'll write in the macro window - 'Office Utils.xla'!
Generate_Invoice and press enter (or click on options to assign some
keystroke).

------
Thanks & Regards
Ashish Jain
(Excel Macros - Google Group Manager)
http://www.excelitems.com
(Developer of OpenXL)
http://www.openexcel.com
Excel,VBA,VSTO Trainer
Ph. No. - 0x25402CF2B
---


On Sep 14, 5:16 am, bsneddon  wrote:
> I create and XLA adding a few years ago.
>
> The user defined function show up in the list as expected.
>
> The macros do not show up in the menu from menu bar Tools->macro->macros.
>
> They will run if I can remember the keystroke.
>
> Is there a way to make them show up?
>
> Is there a way to a keyboard shortcut to these macros?
>
> Bill
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Classic Excel 2003 Style Menu in Excel 2007 (Free Download)

[Ashish Jain]

"You will have a classic mode, right?"
- Bill Gates to Jensen Harris, after seeing the Office 2007 ribbon

Bill Gates was smart enough to see that Office 2007 needed a classic mode.
But somehow, the Office development team convinced him that a classic mode
wouldn't fit with the future direction of Office. So, we have a huge
frustration point: Excel 2007 is the best new version of Excel in 10 years,
but no one will upgrade because they don't want to re-learn the user
interface.

So, here we thought of being different and planned to provide you with FREE
CLASSIC EXCEL 2003 STYLE MENU IN EXCEL 2007. (Just search Google and you'll
see the same product is available in $15 to $30, here it's free.)

[image: Excel_2003_Style_Menu.png]

Features
1. Bring back the Excel 2003 menus and toolbars to your copy of Microsoft
Excel 2007.
2. Frustrated by endless searches for features and commands on the Ribbon?
Download and install this software and easily use the classic style main
menu, the standard toolbar and formatting toolbar in Excel 2007, as you did
in Excel 2003.
3. Fast start!
4. The whole package just 16Kb.
5. Easy to install and uninstall.
6. Menu Manager Tool includes in the software.
7. Very stable and strong!
8. Download it less than 2 minutes, install it less than half a minute, and
it shows the main menu and toolbars immediately!
9. Now, you don't need any training and tutorials for Microsoft Excel 2007.



*Download Here* - http://www.excelitems.com/2008/09/downloads.html

------
Thanks & Regards
Ashish Jain
(Excel Macros - Google Group Manager)
http://www.excelitems.com
(Developer of OpenXL)
http://www.openexcel.com
Excel,VBA,VSTO Trainer
Ph. No. - 0x25402CF2B
---

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Difference between sumif & sumifs

[Ashish Jain]

Hi Aamir

Please check out - Hope it helps !
http://www.excelitems.com/2009/09/difference-between-sumif-and-sumifs.html

--
Thanks & Regards
Ashish Jain
(Excel Macros - Google Group Manager)
http://www.excelitems.com
(Developer of OpenXL)
http://www.openexcel.com
Excel,VBA,VSTO Trainer
Ph. No. - 0x25402CF2B
---

On Sep 11, 9:37 pm, "Aamir Shahzad"  wrote:
> Dear all,
>
> Can anybody describe with example the difference between sumif & sumifs?
>
> Regards,
>
> Aamir Shahzad
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Puzzle #3 - Identify Perfect and Smith Numbers

[Ashish Jain]

Well Done Sandeep and Bruno !! Both of you done it very well.

If I've to rank between Bruno and Sandeep, you will be ranked higher
than Sandeep for your fantastic presentation. I appreciate efforts of
both of you, and agree that this was much harder than previous ones.
But both of you represented superb intellect. Well Done Sandeep and
Bruno !

--
Thanks & Regards
Ashish Jain
(Excel Macros - Google Group Manager)
http://www.excelitems.com
(Developer of OpenXL)
http://www.openexcel.com
Excel,VBA,VSTO Trainer
Ph. No. - 0x25402CF2B
---

On Sep 10, 7:42 am, Bruno Bruno  wrote:
> Is it me, or this puzzle is (much) harder than the others?Not exactly hard
> to do it, but hard to do it in a smart way. What killed me is a way to
> identify Pseudo-Primes and their respective primes sum.
>
> Is there an easier way than simply testing all combinations of sums from a
> number's primes? Because when a number has N divisors (others than itself),
> there are 2^N different ways to sum them. When N >= 17 (Happens for 180,
> 240, 252, 288, 300, 336, 360, 396, 420, 432, 450, 468 and 480 in the first
> 500 numbers), this means 2^17 combinations -> enough to overflow my poor
> computer.
>
> So I had to treat this numbers (all of them pseudo-primes) apart from the
> general case. I believe the solution is working, but would be very pleased
> to learn a "more elegant" solution.
> (I also considered 0 and 1 special cases - don't know what kind of primes
> definition you're using)
>
> Thanks for the puzzle,
> Bruno
>
> On Wed, Sep 9, 2009 at 12:46 AM, Ashish Jain <26may.1...@gmail.com> wrote:
> > Hi All,
>
> > This is challenge for all excel users. Solve these puzzles and sharpen your
> > excel acumen. So, here goes the second puzzle of "Excel Macros Google Group"
> > in the attached file.
>
> > *Old Puzzles:*
> > Puzzle #1 -
> >http://groups.google.com/group/excel-macros/browse_thread/thread/3922...
> > Solved by - Harmeet Only.
> > Puzzle #2 -
> >http://groups.google.com/group/excel-macros/browse_thread/thread/b4d2...
> > Solved by - Bruno and Sandeep
>
> > --
> > Thanks & Regards
> > Ashish Jain
> > (Excel Macros - Google Group Manager)
> >http://www.excelitems.com
> > (Developer of OpenXL)
> >http://www.openexcel.com
> > Excel,VBA,VSTO Trainer
> > Ph. No. - 0x25402CF2B
> > ---
>
>
>
>  Puzzle #3.xls
> 108KViewDownload
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Need help in Web Query

[Ashish Jain]

Hi Ron,

Please login using ur palas...@gmail.com id. and attach your file in
the mail and then finally, send this mail to excel-
mac...@googlegroups.com and 26may.1...@gmail.com

--
Thanks & Regards
Ashish Jain
(Excel Macros - Google Group Manager)
http://www.excelitems.com
(Developer of OpenXL)
http://www.openexcel.com
Excel,VBA,VSTO Trainer
Ph. No. - 0x25402CF2B
---

On Sep 9, 7:40 pm, Ron  wrote:
> hi
>
> i m new to excel macro..i don't have an prior experience in
> writing macros, honestly. i am preparing this excel sheet which will
> act like my portfolio management tool (as i can't afford to buy any
> software ! !)...so what i did i got my stock tickers / symbols
> & did run a web query..it gives me the last price of my
> EQ..now my problem is i have to do it manually...like i have a
> particular cell in which i put the ticker & the web query
> automatically refresh the last price..from here i need some
> help / guidei want to auto mate the process.like i don't
> have to manually put the ticker ..the macro will pull
> automatically from the sheet..how to do so ?any can
> help plz ...
>
> thanks in advance
>
> Ron
>
> p.s. for more convenience i would be happy to upload my file but i
> don't know how  to do that heresorry ! !
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Invalid Procedure or Call Argument

[Ashish Jain]

Hi LD

The macro is corrected below. I removed the function
SetPasteRangebyColumn, since it was of no use and implemented
incorrectly. Since, in this function you're not setting the function's
return value - so it is set to Nothing, by default.
This is the range that when you paste the range, it doesn't understand
that where to paste and show you the error of invalid argument (rather
than invalid procedure/call).


Sub Headers_To_Macro_Test()
' Headers_To_MAcro_Test Macro
' Macro recorded 9/9/2009 by

Dim wksCopy As Worksheet
Dim wksPaste As Worksheet
Dim rngCopy As Range
Dim rngPaste As Range

With ThisWorkbook
Set wksCopy = .Worksheets("Sheet1")
Set wksPaste = .Worksheets("Sheet2")
End With

Set rngCopy = SetCopyRange(wksCopy, "B5:C5")
Set rngPaste = SetCopyRange(wksPaste, "A:B")
rngCopy.Copy rngPaste

End Sub

Function SetCopyRange(Wks As Worksheet, strAddress As String) As Range
Set SetCopyRange = Wks.Range(strAddress)
End Function



------
Thanks & Regards
Ashish Jain
(Excel Macros - Google Group Manager)
http://www.excelitems.com
(Developer of OpenXL)
http://www.openexcel.com
Excel,VBA,VSTO Trainer
Ph. No. - 0x25402CF2B
---

On Sep 10, 1:12 am, LD  wrote:
> Any ideas on why I get this error with the macro below?
>
> Sub Headers_To_Macro_Test()
> ' Headers_To_MAcro_Test Macro
> ' Macro recorded 9/9/2009 by
>
> Dim wksCopy As Worksheet
> Dim wksPaste As Worksheet
> Dim rngCopy As Range
> Dim rngPaste As Range
>
> With ThisWorkbook
> Set wksCopy = .Worksheets("Summary")
> Set wksPaste = .Worksheets("All_Data_Headers")
> End With
>
> Set rngCopy = SetCopyRange(wksCopy, "B5:C5")
> Set rngPaste = SetPasteRangeByColumn(wksPaste, "A:B")
> Error Here--->rngCopy.Copy rngPaste
>
> End Sub
>
> Function SetCopyRange(Wks As Worksheet, strAddress As String) As Range
>     Set SetCopyRange = Wks.Range(strAddress)
> End Function
>
> Function SetPasteRangeByColumn(Wks As Worksheet, strColumn As String)
> As Range
> Dim lngRow As Long
> lngRow = Wks.Rows.Count
> End Function
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: VBA / Macro to Download pages listed on a column

[Ashish Jain]

Hi Subu

This link can help you with
Step 1 - http://www.excelitems.com/2009/03/access-search-engines-on-browser.html

--
Thanks & Regards
Ashish Jain
(Excel Macros - Google Group Manager)
http://www.excelitems.com
(Developer of OpenXL)
http://www.openexcel.com
Excel,VBA,VSTO Trainer
Ph. No. - 0x25402CF2B
---

On Sep 8, 8:02 pm, Subu  wrote:
> Dear folks
>
> Thanks for the help so far...
>
> I wish to know if the following can be automated using VBA ?
>
> Step 1 : I have a list of URL listed in a column. I wish to download
> the contents of each of these pages one by one, i.e. without me
> clicking on each URL...or cutting and pasting the sameon my
> browser
>
> Step 2 : Once the web page appears I shall click on the face of the
> sheet shall take a screen copy (Contrl A + Contrl C) and paste them on
> the present active sheet...
>
> Is there a macro to do either step 1 or step 2
> or
> Could a macro help me with both Step 1 and 2 ?
>
> Thanks in advance
> Regards
> Subu
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: How to remove an add in

[Ashish Jain]

Hi Subu,

1. Close all excel applications.
2. Go to this folder - "C:\Documents and Settings\
\Application Data\Microsoft\AddIns"
3. Delete the file(add-in) from here.
4. Re-open Excel and check.

Note: Replace  with the username you're logged in.
e.g. if you login to system using administrator account.
Try this folder C:\Documents and Settings\\Application
Data\Microsoft\AddIns
 
--
Thanks & Regards
Ashish Jain
(Excel Macros - Google Group Manager)
http://www.excelitems.com
(Developer of OpenXL)
http://www.openexcel.com
Excel,VBA,VSTO Trainer
Ph. No. - 0x25402CF2B
---

On Sep 9, 6:34 am, Subu  wrote:
> Hi Folks
>
> I have used an add-in on one of my sheets ... and now wish to remove
> that
>
> This is what I have done : Double click the add in sent here, opened
> it on an active work book, saved the work book with the add in
>
> This is what I see : Tools -> Add ins -> shows the name of this add in
>
> This is what I have done further : I have checked OFF the add-in under
> Tools -> add ins. On the module ( Alt + F 11) I have deleted the
> module (remove module)
>
> Then saved the workbook
>
> Still the add-in appears under Tools - Add in when I open the sp sheet
>
> Request : I wish to un install / do away with that add in. How do I do
> that ?
>
> Thanks in advance
> regards
> Subu
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Puzzle #2 - Generate the Sample Pattern (VBA)

[Ashish Jain]

Hi All,

This is challenge for all excel users. Solve these puzzles and sharpen your
excel acumen. So, here goes the second puzzle of "Excel Macros Google Group"
in the attached file.

*Old Puzzles:*
Puzzle #1 -
http://groups.google.com/group/excel-macros/browse_thread/thread/39229051cfafa2b1/675fbe8fd61f2699#675fbe8fd61f2699

--
Regards
Ashish Jain
(Excel Macros - Google Group Manager)
http://www.excelitems.com
(Developer of OpenXL)
http://www.openexcel.com
Excel,VBA,VSTO Trainer
Ph. No. - 0x25402CF2B
--

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 5,200 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---



Puzzle #2.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Re: help plz

[Ashish Jain]

Hi Ashish,

Try OpenXL - http://www.openexcel.com


--
Regards
Ashish Jain
(Excel Macros - Google Group Manager)
http://www.excelitems.com
(Developer of OpenXL)
http://www.openexcel.com

Excel,VBA,VSTO Trainer
+91..40.48.43
--

On Sep 6, 6:06 pm, ashish koul  wrote:
> hi all
>
> hi can anyone give me code or macro to clean as well as trim my data in a
> sheet
>
> thanks
> ashish
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 5,200 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Puzzle #1 - Generate the Sample Pattern (VBA)

[Ashish Jain]

Hi Harmeet,

That's fantastic. and good that you protected the code. I want
everyone to try, so that their logic and vba skills can be sharpened.
Well Done Harry.


--
Regards
Ashish Jain
(Excel Macros - Google Group Manager)
http://www.excelitems.com
(Developer of OpenXL)
http://www.openexcel.com

Excel,VBA,VSTO Trainer
+91..40.48.43
--
On Sep 6, 12:55 pm, Harmeet Singh  wrote:
> *Hey **Ashish**,**Thanks a lot for this interesting puzzle.*
> *Looking forward for more innovative puzzles.*
> *
> *
> *Solution is attachedLet me know if I have done it
> appropriately.*
>
>
>
> On Sun, Sep 6, 2009 at 10:06 AM, Ashish Jain <26may.1...@gmail.com> wrote:
> > Hi All,
>
> > This is challenge for all excel users. Solve these puzzles and sharpen your
> > excel acumen. So, here goes the first puzzle of "Excel Macros Google Group"
> > in attached file.
>
> > ------
> > Regards
> > Ashish Jain
> > (Excel Macros - Google Group Manager)
> >http://www.excelitems.com
> > (Developer of OpenXL)
> >http://www.openexcel.com
>
> > Excel,VBA,VSTO Trainer
> > +91..40.48.43
> > --
>
> --
> Thanks & Regards,
>
> Harmeet Singh
>
> Sent via BlackBerry Wireless
>
>  Puzzle #1.xls
> 109KViewDownload
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 5,200 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Puzzle #1 - Generate the Sample Pattern (VBA)

[Ashish Jain]

Hi All,

This is challenge for all excel users. Solve these puzzles and sharpen your
excel acumen. So, here goes the first puzzle of "Excel Macros Google Group"
in attached file.

--
Regards
Ashish Jain
(Excel Macros - Google Group Manager)
http://www.excelitems.com
(Developer of OpenXL)
http://www.openexcel.com

Excel,VBA,VSTO Trainer
+91..40.48.43
--

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 5,200 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---



Puzzle #1.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Re: ASAP Utility - a useful add in for excel end user

[Ashish Jain]

Hi Prashant,

Try OPEN XL - http://www.openexcel.com
It's commercial/personal use is free.

--
Regards
Ashish Jain
(Excel Macros - Google Group Manager)
http://www.excelitems.com
(Developer of OpenXL)
http://www.openexcel.com

Excel,VBA,VSTO Trainer
+91..40.48.43

--


On Sep 5, 1:55 pm, "prashant"  wrote:
> Dear All,
>
> Just want to share , one useful  add in named ASAP Utility, which has lot of
> customized macros  for use.   Some good tricks are -
>
> 1.       Copy value to next line
>
> 2.       Create index page with clickable option
>
> 3.       Merge multiple txt, excel sheets
>
> 4.       Use of is error function , by automatically searching error cells &
> so on
>
> Link
>
> http://www.asap-utilities.com/download-asap-utilities.php
>
> Regards,
>
> Prashant Pawle
>
> Finance Executive,
>
> Landmark Group- Oman
>
> Cell: +968 96473119
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 5,200 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Excel multiple formula in a cell

[Ashish Jain]

Hi RajKumar,

Dilip is right and here is some more information:
Maximum Arguments in a function 30
Maximum Nested levels of functions  7
Number of available worksheet functions 329

For more information on MS Excel limits - please visit -
http://office.microsoft.com/en-us/excel/HP051992911033.aspx

--
Regards
Ashish Jain
(Excel Macros - Google Group Manager)
http://www.excelitems.com
(Developer of OpenXL)
http://www.openexcel.com

Excel,VBA,VSTO Trainer
+91..40.48.43

--

On Sep 2, 6:06 pm, Raj Kumar  wrote:
> hi,
>
> i am your new friend and i have some doubt in Excel so i want to ask a
> question to you The question is:-
>
> How many formulas can be applied in a particular cell at a  time?
>
> Thanks a lot
> Raj Bharti
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 5,200 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: help

[Ashish Jain]

Hi Ashish,

Try this formula - I just used trim function to solve your issue.
=INDEX(B$2:D$4,MATCH(TRIM(B10),A$2:A$4,0),MATCH(A10,B$1:D$1,0))

--
Regards
Ashish Jain
(Excel Macros - Google Group Manager)
http://www.excelitems.com
(Developer of OpenXL)
http://www.openexcel.com

Excel,VBA,VSTO Trainer
+91..40.48.43

--

On Aug 30, 10:01 am, ashish koul  wrote:
> hi
>
> thanks for the solving the previous  problem  can u plz help me in this one
> too
>
> i was trying to use index and match but it gave me some error
>
> thanks
>
> ashish
>
>  index example.xlsx
> 12KViewDownload
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 5,200 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Help require for attached file.

[Ashish Jain]

Hi Abdul,

Your requirements are not clear. The data can be fetched using macro/
UDF from sheet 2 but on what basis. Please specify. For elbow45/90
it's only elb in the description. So, please clear your requirements
and description column. The problem can be solved, it's an easy one.

--
Regards
Ashish Jain
(Excel Macros - Google Group Manager)
http://www.excelitems.com
(Developer of OpenXL)
http://www.openexcel.com

Excel,VBA,VSTO Trainer
+91..40.48.43

--

On Sep 4, 11:11 am, Abdul Hakim Khan  wrote:
> On Fri, Sep 4, 2009 at 9:10 AM, Abdul Hakim Khan
> wrote:
>
>
>
> > Dear All,
> > Help require either UDF OR macro or generalized Formulla for the said
> > problem in attached sheet.
>
> > --
> > -
> > A calm sea does not make a skilled sailor.
>
> > Wishing you and all your loved ones greatest of times ahead!
> > Aspiring 2 c u happy!
> > Abdul Hakim Khan
> > Al Jubail KSA.
> > Remember, growing older is mandatory. Growing up is optional.
> > We make a Living by what we get, we make a Life by what we give.
> > If you fill your heart with regrets of yesterday and the worries of
> > tomorrow,
> > you have no today to be thankful for.
> > ---
>
> --
> -
> A calm sea does not make a skilled sailor.
>
> Wishing you and all your loved ones greatest of times ahead!
> Aspiring 2 c u happy!
> Abdul Hakim Khan
> Open Xl  Dev.
> Al Jubail KSA.
> Remember, growing older is mandatory. Growing up is optional.
> We make a Living by what we get, we make a Life by what we give.
> If you fill your heart with regrets of yesterday and the worries of
> tomorrow,
> you have no today to be thankful for.
> ---
>
>  Test.xls
> 42KViewDownload
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 5,200 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ VBA Macros Collection #2

[Ashish Jain]

 Hi Friends,

Here is the updated collection of VBA Macros on http://www.excelitems.com.
If there is any general macro idea in your mind that could be useful to
excel users, please do reply to this mail. I'll post it on
http://www.excelitems.com with your name.

*Please note the links suffixed with **. They're new ones in comparison to
last update.*


--
*Visual Basic for Automation (Macros Collection)*
--
*Date/Time*

   1. Calculate Business Working Days* *(Excluding Saturdays and
Sundays)<http://www.excelitems.com/2009/05/calculate-business-working-days-between.html>
   *  ***

*Form*

   1. Resize Form during
Run-Time<http://www.excelitems.com/2009/03/resize-form-using-worksheet-event-macro.html>


*Format*

   1. Partly Background Color a Cell (Coloring only a portion of
Cell)<http://www.excelitems.com/2009/03/color-only-part-of-cell-using-macro-or.html>

*Event Macro*

   1. Example of Worksheet_Change Event
Macro<http://www.excelitems.com/2009/03/resize-form-using-worksheet-event-macro.html>

*Miscellaneous*

   1. Access Internet Explorer (Search Engine
Example)<http://www.excelitems.com/2009/03/access-search-engines-on-browser.html>
   2. Change Image
Location<http://www.excelitems.com/2009/03/change-picture-or-image-location.html>
   3. Copy Excel Worksheets to MS
Word<http://www.excelitems.com/2009/03/copy-excel-worksheets-to-microsoft-word.html>


*Number*

   1. Change a Number
Polarity/Sign<http://www.excelitems.com/2009/05/change-polarity-or-number-sign.html>
   2. Convert Numbers to
Text<http://www.excelitems.com/2009/05/convert-numbers-to-text-to-append-or.html>
   *  ***
   3. Convert Textual Numbers to
Values<http://www.excelitems.com/2009/05/convert-numbers-appearing-as-text-to.html>
*  ***
   4. Convert Formulas to
Values<http://www.excelitems.com/2009/05/convert-formulas-to-values.html>
   *  ***

* *
*Range*

   1. Color a range based on its percentage
value<http://www.excelitems.com/2009/03/color-only-part-of-cell-using-macro-or.html>

*Rows/Columns*

   1. Delete Blank
Rows<http://www.excelitems.com/2009/03/deleteremove-blankempty-rowscolumns.html>
   2. Remove Empty
Columns<http://www.excelitems.com/2009/03/deleteremove-blankempty-rowscolumns.html>
   3. Select Alternate
Rows<http://www.excelitems.com/2009/05/select-or-color-alternate-evenodd-rows.html>
   *  ***
   4. Select Alternate
Columns<http://www.excelitems.com/2009/05/select-or-color-alternate-evenodd.html>
   *  ***

*Select*

   1. Invert the
Selection<http://www.excelitems.com/2009/03/invert-selection.html>
   2. Select Alternate
Rows<http://www.excelitems.com/2009/05/select-or-color-alternate-evenodd-rows.html>
   *  ***
   3. Select Alternate Columns
<http://www.excelitems.com/2009/05/select-or-color-alternate-evenodd.html>
   *  ***

*Text*

   1. Change Case (Upper, Lower, Proper, Sentence and Toggle)
   <http://www.excelitems.com/2009/02/change-case-upper-case-lower-case.html>
   2. Remove Extra Spaces (Left, Right, Both sides and from
Inside)<http://www.excelitems.com/2009/03/remove-extra-spaces-from-cell-value.html>
   3. SuperScript/Subscript First or Last
Character<http://www.excelitems.com/2009/05/superscript-or-subscript-first-or-last.html>
*  ***
   4. Apply RainBow color to the
Text<http://www.excelitems.com/2009/05/rainbow-color-text.html>
*  ***
   5. Extract Alphabets from a Text (Removing all Digits
Occurrences)<http://www.excelitems.com/2009/05/extract-alphabets-remove-digits-from.html>
   *  ***
   6. Extract Digits from a Text (Removing all Alphabets
Occurrences)<http://www.excelitems.com/2009/05/extract-digits-remove-alphabets-from.html>
   *  ***
   7. Reverse the Text in Selected Cells (Mirroring the Entire Cell
   
Contents)<http://www.excelitems.com/2009/05/reverse-text-in-selected-cells.html>
*  ***
   8. Delete 'n' number of characters from selected
range.<http://www.excelitems.com/2009/05/delete-n-number-of-characters-from.html>
   *  ***


*Workbook*

*Worksheets*

   1. Sort all 
sheets<http://www.excelitems.com/2009/03/sort-all-worksheets-on-basis-of-sheet.html>
   2. Remove blank worksheets from Current
workbook<http://www.excelitems.com/2009/02/deleteremove-blankempty-worksheets.html>
   3. Color all Sheet
Tabs<http://www.excelitems.com/2009/03/color-all-sheet-tabs-in-workbook.html>
   4. Remove color from all sheet
tabs<http://www.excelitems.com/2009/03/remove-color-of-all-sheets-tabs.html>
   5. Protect all
worksheets<http://www.excelitems.com/2009/03/protect-all-worksheets-in-workbook.html>
   6. Remove Password (Unprotect) all
worksheets<http://www.excelitems.com/2009/03/unprotect-all-worksheets-in-workbook.html>
   7. Insert 'n' number of Blank
Worksheets<http://www.excelitems.com

$$Excel-Macros$$ Re: Macro for NAV calculation

[Ashish Jain]

Hi Mahesh,

The Group is not for providing start-to-end solutions. Try solving the
problem and we all are here to technically assist you whenever and
wherever you're stuck. I charge for solving such queries, since these
eat time.

-
Regards
Ashish Jain
http://www.excelitems.com
http://www.openexcel.com
*Developer of Open XL*
-

On Jun 8, 9:39 pm, mahesh parab  wrote:
> Hi Ashish
>
> i have alrady mail this query to this group, now can any one help to write
> macro for attach excel sheet.
> if any one can mail me steps it will be helpful for me.
>
> Thanks in advance
>
>  NAV Sample.xls
> 50KViewDownload
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: asset list

[Ashish Jain]

Hi Steef,

I don't know the program/algorithm/software you are using for barcode
scanning. But this could be of some help to you.
Jumping to right of cell - ActiveCell.Offset(0,1)
Selected cell jump 1 row down and 1 column left - Activecell.Offset
(1,-1)


-
Regards
Ashish Jain
http://www.excelitems.com
http://www.openexcel.com
*Developer of Open XL*
-
On Jun 8, 6:34 pm, steef83  wrote:
> Hi,
>
> I need to make an asset list where the serial number is attached to an
> asset number of the company.
> I need to do this with approxamitly 900 phones.
> My question now is :
> Is there any macro so that I can scan the barcode of the serial number
> and that the program is jumping to the cell right of it?
> Also I want to scan the asset tag and let the selected cell jump 1 row
> down and 1 column to the left.
> Is this posible??
>
> Appreciate the respond.
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: WARNING SIGNAL IN CASE OF ERROR

[Ashish Jain]

Hi Vivek,

Ofcourse this is possible, Use Workbook_BeforeSave event with if
condition and warning msg.

---
Regards
Ashish Jain
http://www.excelitems.com
http://www.openexcel.com
*Developer of Open XL*
---

On Jun 8, 9:30 am, "vivek jain"  wrote:
> Dear All groupmembers,
>
> I prepare financial statements in excel. To check whether the balance sheet
> tallied I check assets - liabilities in a particular cell which should be
> zero and add it to watch window.
>
> Is it possible that every time I open/save the file it would give me warning
> message that my balance sheet does not tally in case of any difference in
> assets and liabilities.
>
> Thanks & Regards...
>
> cid:image001@01C85EB8.0483F790 Vivek Jain, FCA, DISA (ICAI)
>
> Vivek Shantilal Jain & Co.
>
> Chartered Accountants
>
> 3010 Ram Kumar Arcade,
>
> Chatribari Road, A T Road,
>
> Guwahati-781001
>
> (0361-2603895,9435019908
>
>  image001.gif
> 2KViewDownload
>
>  image002.jpg
> 1KViewDownload
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Excel macros

[Ashish Jain]

Hi Mayank

Please refer to the group's files section and online resources. You
may search through excelitems.com too.
Excel VBA Learning Files --> http://groups.google.com/group/excel-macros/files
Website --> http://www.excelitems.com


-----
Regards
Ashish Jain
http://www.excelitems.com
http://www.openexcel.com
*Developer of Open XL*
-

On Jun 1, 7:15 pm, mayank khare  wrote:
> Hai,
> I want to learn indepth excel macros.
> Plz tell the resource to learn this.
> I do not know any language ie Visual Basic ,which i know is required to
> write a macro.
> Plz guide me.
>
> --
> Warm Regards
> Mayank Khare
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Material Requirment

[Ashish Jain]

Hi Kamlesh,

Check the files section of this group.
http://groups.google.com/group/excel-macros/files

-
Regards
Ashish Jain
http://www.excelitems.com
http://www.openexcel.com
*Developer of Open XL*
-

On Jun 2, 4:08 pm, kamlesh agrawal  wrote:
> Hi
> I am new to this group . i want some material for v b programming and list
> of  formulas for excels
>
> Thanks in Advance
>
> --
> Kamlesh S Agrawal
> "Try hard to get what you likeotherwise you'll be forced to like
> whatever you'll get"
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: How to force a spreadsheet to load from a server and not cache

[Ashish Jain]

Hi Dean,

This has nothing to do with excel. Either clear your Internet explorer
(or of the browser you're using) or permanently set its cache size to
0KB.


-
Regards
Ashish Jain
http://www.excelitems.com
http://www.openexcel.com
*Developer of Open XL*
-



On Jun 5, 1:46 am, DeanL  wrote:
> Hi guys,
>
> I have a web page with links to excel spreadsheets on a server.  The
> problem I'm having is that when I update the spreadsheet and upload a
> new version to the server then the links from the web page cause a
> copy cached on the user's local machine to open instead of calling the
> new version from the server.
>
> Is there a way to force excel to call the new copy each time or does
> this have to be done through the web page?
>
> Any help you can offer would be greatly appreciated.
>
> Many thanks, Dean...
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: drop down list

[Ashish Jain]

Hi Harish,

There can be a macro written based on your requirements using
Worksheet_Change event. But there is no inbuilt feature to accomplish
the same. For drop-down you can use Data --> Validation feature of MS
Excel.


-
Regards
Ashish Jain
http://www.excelitems.com
http://www.openexcel.com
*Developer of Open XL*
-

On Jun 5, 6:33 pm, Harish  wrote:
> Can we apply following feature in a cell in Excel ?:
> "Typing in a letter in cell should pick up the dropdown item (from
> down list ) that matches
> the letter"
>
> let me consider an example to explain this :
> suppose that drop down list contains following items:
> 1) America
> 2) India
> 3) Sri Lanka
> 4) Italy
>
> if user write "a" in cell,America should be selected
> automatically..
>
> Thanks in advance,
> Harish
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: UserForm Initializing after if.. then statement

[Ashish Jain]

Hi Alokeshwar,

This is absolutely normal.

1. When you try to fetch the values from userform1, it is initialized
and new value of Test set upon. To avoid this you can use activate
event of userform1. Difference between activate and initialize is of
Foreground visibility active state and Background invisible initiation
state.

2. But the above solution is a mere Jugad technique. Look below to
intelligently correct your problem

Instead of using
If UserForm2.TextBox1 <> "SomeValue" And UserForm1.TextBox1 <>
"SomeValue" Then
use this
If UserForm1.TextBox1 <> "SomeValue"  AND UserForm2.TextBox1 <>
"SomeValue" Then
and then it'll display same value across both Msgbox in UserForm2.

Hope you'll understand the difference. Let me explain with example for
all excel users.
When we use boolean expression similar to this A OR B OR C. The order
of evaluation is C --> B --> A.
If C is True, then it don't evaluates A and B and the result of
expression becomes true.
But When we use boolean expression similar to this A AND B AND C. The
order of evaluation is A --> B --> C.
If A is False, then it don't evaluates C and B and the result of
expression becomes False.


If you carefully see the code and run using F8, you'll better
understand the above 2 points. Try with different expressions to
really learn this.


-
Regards
Ashish Jain
http://www.excelitems.com
http://www.openexcel.com
*Developer of Open XL*
-

On Jun 6, 3:11 pm, Alokeshwar Tiwary 
wrote:
> Dear All,
>
> I encountered a very strange problem. I have two userforms and both of them 
> define values for few variables at Initialize event and also they both refer 
> to each other to verify certain conditions. Now what's happening is - 
> immediately after if.. then statement, the variables change .. as if the 
> other userform has been initialize. Though I have fixed this, just want to 
> know if this is normal. Please see below sample code for example:
>
> First userform has following code:
>
> Private Sub UserForm_Initialize()
> Test = "I am UserForm1"
> End Sub
>
> Second userform has following code:
>
> Private Sub UserForm_Initialize()
> Test = "I am UserForm2"
> MsgBox Test
> If UserForm2.TextBox1 <> "SomeValue" And UserForm1.TextBox1 <> "SomeValue" 
> Then
> 'Some code'
> End If
> MsgBox Test
> End Sub
>
> When I run UserForm2 where I have set value of Test to "I am UserForm2", it 
> shows msgbox "I am UserForm2" however immediately after if.. then statement 
> value of the variable Test changes and it shows msgbox "I am UserForm1" as 
> its in UserForm1. Looks like as soon as VBA reads following it changes the 
> variables:
>
> And UserForm1.TextBox1 <> "SomeValue"
>
> Do you have any idea about this?
>
> _
> "There are known knowns. These are things we know that we know. There are 
> known unknowns. That is to say, there are things that we know we don't know. 
> But there are also unknown unknowns. There are things we don't know we don't 
> know."
>
>       Explore and discover exciting holidays and getaways with Yahoo! India 
> Travelhttp://in.travel.yahoo.com/
>
>  Book1.xls
> 44KViewDownload
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: split data to different Excel files

[Ashish Jain]

Hi George,

Try this macro!

Sub Macro1()
Dim myDep As Range
Dim CWbk As Workbook
For Each myDep In Range("F1:F30").Cells
Workbooks.Add
Set CWbk = ActiveWorkbook
ThisWorkbook.Sheets("as is").Range("A1:A3").EntireRow.Copy
CWbk.Sheets(1).Range("A1")
'CWbk.SaveAs ThisWorkbook.Path & "\" & myDep.Value & ".xls"
CWbk.SaveAs "C:\destination\" & myDep.Value & ".xls"
CWbk.Close False
    Set CWbk = Nothing
Next
End Sub



-
Regards
Ashish Jain
http://www.excelitems.com
http://www.openexcel.com
*Developer of Open XL*
-

On Jun 6, 3:05 pm, George  wrote:
>  Dear group members,
>
> My need is to parse Excel file.
> I have names of departments in F column:
>
> aa
> ab
> ac
> df
> (et cetera, 30 departments)
>
> I have list of departments and other information in my source Excel
> file.
> My task is:
> 1) copy three first lines of sheet "as is"
> 2) copy all strings with "aa" in F column,
> 3) paste to other Excel file and to save it as C:\destination\aa.xls
>
> Then to do the same for "ab", "ac" and all the rest 30 departments.
>
> Tell me please how do I perform this.
> Thank you.
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Looking for a finance spreadsheet

[Ashish Jain]

Hi Ryan,

Did you tried templates on Microsoft website? Here is the link, plz
reply with your feedback.

http://office.microsoft.com/en-us/templates/CT101527321033.aspx?av=ZXL

Here you'll find templates on
Receipts
Invoices
Budget
Inventories
and Expense reports etc.

-
Regards
Ashish Jain
http://www.excelitems.com
http://www.openexcel.com
*Developer of Open XL*
-


On Jun 6, 11:51 am, spazlon  wrote:
> Hello,
>
> I am looking for a personal finance spreadsheet. I tried making one of
> my own, but quickly realized I lacked the knowledge to do what I
> wanted. Basically I want to have one sheet that will have all of my
> transactions on it with a Debit and Credit column. I will also have a
> sheet for each of my accounts. When I add a transaction to my main
> sheet, I want it to reflect in the corresponding account sheets.
>
> For example, if I debit $100 from Checking and credit Savings, I want
> that row to appear on the Checking and Savings sheets as well.
>
> Does anybody have a sheet that will do this?
>
> Thanks!
>
> - Ryan
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Please post your TIP in the post started by the Group Owner

[Ashish Jain]

Hello Everyone,

Thanks for your overwhelming response on this initiative. I request
you to post your tip in the thread and the post started by Group
Owner. It will be very difficult to keep track of tips posted under
different subject topics.

The title of the thread where you should post your tip is  :

  

Please remember that only the tips posted under this thread will be
considered for PRIZES.

Thanks for your great tips and Tricks.

Best regards,
Ayush Jain
Group Owner
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: i want protect cell only in first row

[Ashish Jain]

Hi Ravinder,

Protect First Row: Select the cells to be protected
Right Click on them and Select Format Cells
Click Protection tab, Check if Locked property is selected or not.
It should be checked/selected.

Unprotect Rest Rows: Now Select rest of the cells to be unprotected.
Right Click on them and Select Format Cells
Click Protection tab, Check if Locked property is selected or not.
It should not be checked/selected.

Excel 2007: Now Right click on sheet tab and select Protect Sheet.
Excel2003: Go to Tools --> Protection --> Protect Sheet

Provide the password and don't change rest settings.
You're done. That's it.

Regards
Ashish Jain
www.excelitems.com
Developer of Open XL

On Apr 30, 10:52 am, Punj  wrote:
> I want protect cell in first line only
>
> I want if i overwrite this black cells, it does not change.
>
> and changes in below all cells can be made.
> help required.
>
> --
> Regards,
> RAVINDER PUNJ
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: PROBLEM WITH OPENXL BETA 1.0.0.0

[Ashish Jain]

Hi Mr.Khan,

OpenXL is a Com Addin, it's not an .XLA, .XLAM or .XLL addin. Hence it
appears in Com-Addins list rather than just Addin list.
Please Check "Add/Remove Programs" and tell us that Microsoft .NET
Framework 3.5 and Visual Studio for Office 3.0 Runtime is installed or
not.
They're pre-requisites for it.


Regards
Ashish Jain
www.excelitems.com
Developer of Open XL
---
On Apr 29, 9:44 am, msakibkhan  wrote:
> Hi guys,
>
> I have just installed OpenXL Beta 1.0.0.0 successfully but it's not
> showing any addin/toolbar in Ms-Excel 2007. But it's appearing in list
> of installed application in Add/Remove Programs.
> Can anybody help me please.
> Thanks in ADVANCE.
>
> Regards
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: PREPARE INDEX WITH PAGE NUMBERS

[Ashish Jain]

Hi,

Try wsheet.Hpagebreaks.Count and Wsheet.VPageBreaks.Count.
and wsheet.HPageBreaks().Location.Row

Regards
Ashish Jain
www.excelitems.com
Developer of OpenXL

---

On Apr 28, 9:24 am, "vivek jain"  wrote:
> Dear All Groupmembers,
>
> I want to prepare an index sheet which will contain the name of all the
> sheets and their (continuous) page numbers (given in footer). The index
> should be able to update on any insertion of new sheet or on deletion of
> any. Further the page numbers should also be updated automatically. I had
> received a code from one of the group members which I am reproducing below
> which helps me in preparing index with sheet name. But I do not get the page
> numbers. It will be of great help if anyone can provide me the solution.
>
> Code for index:
>
> Private Sub Worksheet_Activate()
>
> Dim wSheet As Worksheet
>
> Dim M As Long
>
> M = 1
>
>     With Me
>
>         .Columns(1).ClearContents
>
>         .Cells(1, 1) = "INDEX FOR FINANCIALS"
>
>         .Cells(1, 1).Name = "Index"
>
>     End With
>
>     For Each wSheet In Worksheets
>
>         If wSheet.Name <> Me.Name Then
>
>         M = M + 1
>
>         With wSheet
>
>             .Range("H1").Name = "Start" & wSheet.Index
>
>             .Hyperlinks.Add Anchor:=.Range("H1"), Address:="",
> SubAddress:="Index", TextToDisplay:="Back to Index"
>
>         End With
>
>             Me.Hyperlinks.Add Anchor:=Me.Cells(M, 1), Address:="",
> SubAddress:="Start" & wSheet.Index, TextToDisplay:=wSheet.Name
>
>         End If
>
>         Next wSheet
>
> End Sub
>
> Thanks & Regards...
>
> cid:image001@01C85EB8.0483F790 Vivek Jain, FCA, DISA (ICAI)
>
> Vivek Shantilal Jain & Co.
>
> Chartered Accountants
>
> 3010 Ram Kumar Arcade,
>
> Chatribari Road, A T Road,
>
> Guwahati-781001
>
> (0361-2603895,9435019908
>
>  image001.gif
> 2KViewDownload
>
>  image002.jpg
> 1KViewDownload
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Sorting Values

[Ashish Jain]

Hi Savant,

Try this formula:
==IF(OR(AND(ISNUMBER(FIND(LEFT(B2,1),"JCR")),IF(SUM(COUNTIF(C2,
{"DST","LVN","DNM"}))>0,TRUE,FALSE)),OR( ISNUMBER(FIND(LEFT
(B2,1),"AWFUY")),ISNUMBER(FIND("SHORT", G2)),IF(SUM(COUNTIF(C2,
{"BOG","BLM","CMO"}))>0,TRUE,FALSE))),I2-0.01,J2)


Regards
Ashish Jain
www.excelitems.com
Developer of Open XL

On Apr 27, 5:13 pm, "caveman.savant"  wrote:
>  I've been using these formulas to sort some values and return
> results
>  I would like to combine these 2 into one formula
> =IF(AND(ISNUMBER(FIND(LEFT(B20368,1),"JCR")),IF(SUM(COUNTIF(C20368,
> {"DST","LVN","DNM"}))>0,TRUE(),FALSE())),I20368-0.01,J20368)
>
> =IF(OR(AND(B20368<>"", ISNUMBER(FIND(LEFT(B20368,1),
> "AWFUY"))),ISNUMBER(FIND("SHORT", G20368)), SUM(COUNTIF(C20368,
> {"BOG","BLM","CMO"}))),I20368-0.01, J20368)
>
> Each statement stands alone as far as filtering, so ISNUMBER(FIND
> (LEFT
> (B20368,1), "JCRAWFUY"))) won't work.
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: How to download openxl???

[Ashish Jain]

Hi

Try this link - http://26may.1984.googlepages.com/OpenXLBeta1.0.0.0.zip

Regards
Ashish Jain
www.excelitems.com
Developer of Open XL

--
On Apr 28, 3:45 pm, iactnow  wrote:
> I have tried to download openxl several times on two different
> computers and I get a popup message saying:
>
> "Title:  OpenXLBeta1.0.0.0.zip
>
> The server replies that you don't have permissions to download this
> file.
>
> Details
> HTTP/1.1 403 Forbidden
>
>                                              OK"
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Open XL - A Powerful Excel Addin

[Ashish Jain]

Hi Upendra,

Few Checks for you, please check and hence provide us your valuable
feedback.

1. Did you unzipped the file or ran the setup without unzipping?
2. Were you connected to internet when ran the utility?
3. Does prerequisites(.Net Framework3.5 and VSTO 3.0 RunTime)
installed on your system?
4. Are you running Windows XP or above on your system?
5. Do you use Office 2007 and above?

Regards
Ashish Jain
www.excelitems.com
Developer of Open XL

---

On Apr 28, 7:00 pm, "Upendra Singh" 
wrote:
> Hi Ashish,
>
> I have downloaded openxl add-in but on running, gives following error
> "Setup has detected that the file
> 'C:\Docume~1\TEMP\Locals~`\VSD3C6.tmp\DotnetFX30\dotnetfx3.exe' has changed
> since it was initially published. Clisk OK to retry the download, or Cancel
> to exit setup."
>
> Please suggest what to do...
>
> Regards,
>
> Upendra Singh
>
> -Original Message-
> From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
>
> On Behalf Of Ashish Jain
> Sent: Tuesday, April 28, 2009 6:32 PM
> To: MS EXCEL AND VBA MACROS
> Subject: $$Excel-Macros$$ Re: Open XL - A Powerful Excel Addin
>
> Hi Satish,
>
> are you sure? You are using the correct version.
> My solution may sound unappropriate but please check
> rightmost tab in the Office ribbon as given in
> its snapshots here:http://openexcel.blogspot.com/2009/03/screenshots.html
> or as in videos here:http://openexcel.blogspot.com/2009/03/videos.html
>
> Regards
> Ashish Jainwww.excelitems.com
> Developer of Open XL
>
> 
> --
>
> On Apr 28, 4:14 pm, satish  wrote:
> > Dear Friends,
> > I downloaded the zip folder and double clicked on setup file, the process
> > said, successfully installed, even then am not able to see "Open XL" icon
> in
> > my excel sheet. Can anyone help me to find a solution. Am using Excel
> 2007.
>
> > Regards
> > Satish
>
> > On Tue, Apr 28, 2009 at 2:57 PM, zaki l  wrote:
> > > Totally agree..!
>
> > > regards..
>
> > > On Mon, Apr 27, 2009 at 7:14 PM, Harmeet Singh
> wrote:
>
> > >> Hi Ashish,
>
> > >> I must say, Its a killer tool. Keep up the good work buddy.
>
> > >> U r simply Awesome.
>
> > >> What do u all say.?
>
> > >> On Mon, Apr 27, 2009 at 6:57 PM, Ashish Jain
> <26may.1...@gmail.com>wrote:
>
> > >>> If you want to do any or all of the following. Visit
> > >>>http://www.excelitems.com
> > >>> and Download Open XL.
>
> > >>> 1. Run Charts Slideshow
> > >>> 2. Calculate Business Working Days
>
> > >>> 3. Sort Worksheets
> > >>> 4. Merge Worksheets
> > >>> 5. Superhide a worksheet
>
> > >>> 6. Copy Multiple Selections
> > >>> 7. Learn VBA/VSTO
>
> > >>> 8. Copy Worksheets to MS Word
> > >>> 9. Invert the Selection
>
> > >>> 10. Remove all Empty Rows
> > >>> 11. Delete Blank Sheets
>
> > >>> and run such 125 utilities from single addin. Open XL is a freeware
> > >>> addin.
> > >>> Download, Install and Use.
>
> > >>> This is definitely gonna save your lots of hours. Enjoy Excel !
>
> > >>> Regards
> > >>> Ashish Jain
> > >>>www.excelitems.com
> > >>> Developer of Open XL
>
> > >>> --
> > >>> Thanks & Regards,
>
> > >>> Harmeet Singh
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Open XL - A Powerful Excel Addin

[Ashish Jain]

Hi Satish,

are you sure? You are using the correct version.
My solution may sound unappropriate but please check
rightmost tab in the Office ribbon as given in
its snapshots here:
http://openexcel.blogspot.com/2009/03/screenshots.html
or as in videos here:
http://openexcel.blogspot.com/2009/03/videos.html

Regards
Ashish Jain
www.excelitems.com
Developer of Open XL

--

On Apr 28, 4:14 pm, satish  wrote:
> Dear Friends,
> I downloaded the zip folder and double clicked on setup file, the process
> said, successfully installed, even then am not able to see "Open XL" icon in
> my excel sheet. Can anyone help me to find a solution. Am using Excel 2007.
>
> Regards
> Satish
>
> On Tue, Apr 28, 2009 at 2:57 PM, zaki l  wrote:
> > Totally agree..!
>
> > regards..
>
> > On Mon, Apr 27, 2009 at 7:14 PM, Harmeet Singh 
> > wrote:
>
> >> Hi Ashish,
>
> >> I must say, Its a killer tool. Keep up the good work buddy.
>
> >> U r simply Awesome.
>
> >> What do u all say.?
>
> >> On Mon, Apr 27, 2009 at 6:57 PM, Ashish Jain <26may.1...@gmail.com>wrote:
>
> >>> If you want to do any or all of the following. Visit
> >>>http://www.excelitems.com
> >>> and Download Open XL.
>
> >>> 1. Run Charts Slideshow
> >>> 2. Calculate Business Working Days
>
> >>> 3. Sort Worksheets
> >>> 4. Merge Worksheets
> >>> 5. Superhide a worksheet
>
> >>> 6. Copy Multiple Selections
> >>> 7. Learn VBA/VSTO
>
> >>> 8. Copy Worksheets to MS Word
> >>> 9. Invert the Selection
>
> >>> 10. Remove all Empty Rows
> >>> 11. Delete Blank Sheets
>
> >>> and run such 125 utilities from single addin. Open XL is a freeware
> >>> addin.
> >>> Download, Install and Use.
>
> >>> This is definitely gonna save your lots of hours. Enjoy Excel !
>
> >>> Regards
> >>> Ashish Jain
> >>>www.excelitems.com
> >>> Developer of Open XL
>
> >>> --
> >>> Thanks & Regards,
>
> >>> Harmeet Singh
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Querry regding OpenXL

[Ashish Jain]

Hi Ankur,

VBA/VSTO Macro Programming don't provide undo of automated tasks.
Application.undo works for manual tasks only where it saves the last
state of
opened workbooks in application.

But still we're working on this issue and future versions you'll find
that this
problem is solved with certain limitations.

Regards
Ashish Jain
www.excelitems.com
Developer of Open XL

---

On Apr 28, 11:48 am, Ankur Satija  wrote:
> One problem using Open XL...
>
> Once any function in  OpenXL is used it can't be undone using Ctr+Z .
>
> Plz solve this querry
>
>
>
>
>
> On Mon, Apr 27, 2009 at 6:57 PM, Ashish Jain <26may.1...@gmail.com> wrote:
>
> > If you want to do any or all of the following. Visit
> >http://www.excelitems.com
> > and Download Open XL.
>
> > 1. Run Charts Slideshow
> > 2. Calculate Business Working Days
>
> > 3. Sort Worksheets
> > 4. Merge Worksheets
> > 5. Superhide a worksheet
>
> > 6. Copy Multiple Selections
> > 7. Learn VBA/VSTO
>
> > 8. Copy Worksheets to MS Word
> > 9. Invert the Selection
>
> > 10. Remove all Empty Rows
> > 11. Delete Blank Sheets
>
> > and run such 125 utilities from single addin. Open XL is a freeware
> > addin.
> > Download, Install and Use.
>
> > This is definitely gonna save your lots of hours. Enjoy Excel !
>
> > Regards
> > Ashish Jain
> >www.excelitems.com
> > Developer of Open XL
>
> --
> Ankur Satija, Consultant
> GRID - Energy, Utilities & Mining
> PricewaterhouseCoopers Private  Ltd. Building 8, Tower B, Floor 8| DLF Cyber
> City, Gurgaon - 122022  | Haryana, India
> Mobile: +91 9871041757
> Email: ankur.x.sat...@in.pwc.com- Hide quoted text -
>
> - Show quoted text -
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Open XL - A Powerful Excel Addin

[Ashish Jain]

Thanks to all,

A Good news, Me and Ayush, planned to launch it for Excel 2003 (not
for any other previous versions).
It will be soon available to group members.

Please make a note Humans take a step forward, that's how
civilizations grows. This means no support and updates will be
available for Open XL (2003 users).
New features/bug fixes/support will be available with Open XL 1.0.0.0
(2007 and onwards) only.


Enjoy !!

Regards
Ashish Jain
www.excelitems.com
Developer of Open XL


---
On Apr 28, 11:02 am, Jitendra Kumar 
wrote:
> Dear Ashish,
>
> Is there any version which is compatible with Excel 2003 as i am using Excel
> 2003.
>
> Best Regards,
> Jitendra Kumar
>
>
>
>
>
> On Mon, Apr 27, 2009 at 6:57 PM, Ashish Jain <26may.1...@gmail.com> wrote:
>
> > If you want to do any or all of the following. Visit
> >http://www.excelitems.com
> > and Download Open XL.
>
> > 1. Run Charts Slideshow
> > 2. Calculate Business Working Days
>
> > 3. Sort Worksheets
> > 4. Merge Worksheets
> > 5. Superhide a worksheet
>
> > 6. Copy Multiple Selections
> > 7. Learn VBA/VSTO
>
> > 8. Copy Worksheets to MS Word
> > 9. Invert the Selection
>
> > 10. Remove all Empty Rows
> > 11. Delete Blank Sheets
>
> > and run such 125 utilities from single addin. Open XL is a freeware
> > addin.
> > Download, Install and Use.
>
> > This is definitely gonna save your lots of hours. Enjoy Excel !
>
> > Regards
> > Ashish Jain
> >www.excelitems.com
> > Developer of Open XL
>
> --
> Thanks & Best Regards,
> Jitendra Kumar
> Mobile # +91 9971694675
> Alt. Email - jitendra_kumar...@yahoo.com
>
> "It's not the strongest species that survive, nor the most intelligent, but
> the most responsive to change"- Hide quoted text -
>
> - Show quoted text -
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: VB one to 33 lessons

[Ashish Jain]

Hi All,

Here is the Link
http://excel-macros.googlegroups.com/web/VB+33+lesson+(39).doc

Regards
Ashish Jain
www.excelitems.com
Developer of Open XL

--

On Apr 27, 4:47 pm, girish gv  wrote:
> Hi,
>
> can u send me the link...
>
> Regards,
> Girish
>
> On 4/27/09, Aindril De  wrote:
>
>
>
> > Hi SK, Could not find it could you send a direct link..
>
> > Regards,
> > Andy
>
> > On Mon, Apr 27, 2009 at 4:07 PM, Suyog  wrote:
>
> >> Hi All,
>
> >> Refer uploaded VB 33 lesson (39).doc for new comers. Refer all 33
> >> lessons & start your VBAmacros.
>
> >> Thanks
> >> SK
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Open XL - A Powerful Excel Addin

[Ashish Jain]

If you want to do any or all of the following. Visit http://www.excelitems.com
and Download Open XL.

1. Run Charts Slideshow
2. Calculate Business Working Days

3. Sort Worksheets
4. Merge Worksheets
5. Superhide a worksheet

6. Copy Multiple Selections
7. Learn VBA/VSTO

8. Copy Worksheets to MS Word
9. Invert the Selection

10. Remove all Empty Rows
11. Delete Blank Sheets

and run such 125 utilities from single addin. Open XL is a freeware
addin.
Download, Install and Use.

This is definitely gonna save your lots of hours. Enjoy Excel !

Regards
Ashish Jain
www.excelitems.com
Developer of Open XL
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Macro to open Sharepoint documents?

[Ashish Jain]

Hi Gremlin,

You're doing right, except using the Chdir.
There is No need of it. You may directly use Workbooks.Open ..

Regards
Ashish Jain
www.excelitems.com
Developer of OpenXL



On Apr 14, 3:50 am, CF_Gremlin  wrote:
> I have a status report spreadsheet saved onto my desktop that links to
> 15 other excel spreedsheets on a Sharepoint location.
>
> I tried to record the macro and that would open those 15 excel
> spreadsheets from Sharepoint.  However when I attempt to run the macro
> I get a Run-time error '76' "Path not found".
>
> Here is what I have so far but it always errors out on the change
> directory command
>
> Sub Macro1()
> '
> ' Macro1 Macro
> '
> '
>     ChDir "https://projects.company.com/software/Notes";
>     Workbooks.Open Filename:= _
>         "https://projects.company.com/software/Notes/Issues%20Tracking
> %20List.xls"
>
> End Sub
>
> Is it possible to write a macro that can open documents that are not
> stored on your desktop, but rather in an information portal site?
>
> Any info or suggestions are appreciated
>
> Regards
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Sorting Data from Many excel Sheets

[Ashish Jain]

Hi Satish,

Try "Merge Worksheets" command. It's located in "Sheet Utils" -->
"Merge Worksheets" of "Open XL" addin available free on 
http://www.excelitems.com


Regards
Ashish Jain
www.excelitems.com
Developer of OpenXL



On Apr 23, 4:27 pm, satish  wrote:
> Dear Friends,
>
> Please share your knowledge with regard to following excel issue.
>
> I have about 100 sheets with exactly similar format but different
> data. for e.g., "Column A" has a 20 items in 20 row, next "row 2"
> about 20 items in 20 column (These are fixed). Now, there are inputs
> corresponding to cells within these boundary
>
> Now, i have some unique inputs in Cells D13, F15, G10 etc.
>
> I have created another excel sheet and given the column Heading as
> D13, F15, G10 and so on.
> I need the data to be extracted from these particular cells from all
> 100 sheets and to be placed one below the other in the new excel sheet
> created at respective column heading.
>
> Hope i am clear in explaining the issue.
>
> Early help is requested
>
> Thanks in advance
> Satish
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: User Defined Function Question

[Ashish Jain]

Hi Jake,

He is right and I won't say that it's absolutely impossible.
Using VBA only it's pretty not possible. By Overriding the
the function's class in a specific dll, you can do so.
But for that you should be aware of the dll name, class name
and the knowledge of API Prog. and building+deploying dll .
I know all this except the DLL and Class name, so won't be
able to help much.

Regards
Ashish Jain
www.excelitems.com
Developer of OpenXL


On Apr 24, 9:43 pm, Jake  wrote:
> Thanks Ashish.  I thought it might be something like that but I had
> actually pinged John Walkenbach about it and he said he's able to see
> his functions in that pop-up box.  In retrospect, I may not have been
> clear about what I was asking and he was talking about something
> else.  Again, thanks for the info.
>
> On Apr 19, 7:07 am, Ashish Jain <26may.1...@gmail.com> wrote:
>
> > Hi Jake,
>
> > No, there is no way to get your function listed in that box and the
> > reason is that you're using code behind(VBA). This restricts your
> > function to be used from a workbook only where your function code is
> > placed. Maximumly you can add it to a personal workbook or in an add-
> > in but still that will be code behind. The built-in functions are
> > defined in functions assembly of excel from where it fetches that
> > information.
>
> > For more tips, tricks, downloads and problem solutions: visit 
> > -->http://www.excelitems.com
> > 
> > Regards
> > *Ashish **Jain*
> > Analyst, CSC
> > Microsoft Certified Application (Excel) Specialist
> > Excel and VBA Trainer
> > Author ->www.excelitems.com
> > +91--40-48-43
> > ---­­­--
> > ---­­­--
>
> > On Apr 17, 11:08 pm, Jake  wrote:
>
> > > I just finished writing my first function.  It works fine and shows up
> > > in the User Defined section of the Insert Function dialog box.
> > > However, when I type it into a cell, it doesn't show up in the little
> > > auto complete pop-up window.  Is there any way to get my function to
> > > appear with the built-in functions in this pop-up box?- Hide quoted text -
>
> > - Show quoted text -
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Macro Help

[Ashish Jain]

Hi Karan,

If you're accessing the forums directly on web then you can't attach
the files with the message. But if you're accessing group via email
subscription then you can attach files as you does normally with your
e-mail client.


Regards
Ashish Jain
www.excelitems.com
Developer of OpenXL



On Apr 25, 10:36 pm, karan  wrote:
> Hi guys
> i m trying to make a macro but i m not able to get it
> can any1 help me in making a macro. I need a macro whcih gives me the
> foll :
>
> 1)the cel in whcih i press the macro short cut - it should add 8 - 10
> lines above that cell and then,
> 2)on that 8 - 10 lines it should have the foll :
>
> MP           x
> R            0.7
> J            =MP/R i.e. say 6500/0.7
> Population           x
> Sample Size   =population / J
> R/o to        =roundup(samplesize,0)
>
> (can any1 also let me know how do i upload an excel file here ?)
>
> Hope to get a rep soon.
> Thx...
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Want help on Lookup and pivot tables

[Ashish Jain]

Hi Jayesh,

Here is a good reference on How to use Lookup methods?
http://www.excelitems.com/2009/03/how-to-use-vlookup-function.html


Regards
Ashish Jain
www.excelitems.com
Developer of OpenXL



On Apr 25, 2:37 pm, Jayesh Joshi  wrote:
> Hello all ,
> This is jayesh joshi , i am looking for some help on Lookup and pivot tables
> as it is required in my job profile , so could some one help me out with the
> above subjects.
>
> Thanks
>
> Jayesh Joshi
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: ADD/SUBTRACT/MULTIPLY/DIVIDE Numbers in Macros

[Ashish Jain]

Superb Aindril - Hats Off !!! Keep enjoying the queries :)


Regards
Ashish Jain
Developer of OpenXL



On Apr 27, 3:39 pm, Aindril De  wrote:
> Hi Paresh,
>
> 1. 1st open a new workbook, Alt+F11 go to vba editor, on the left side,
> right click on a icon and choose insert userform, when click on this
> userform toolbox of controls appear, click the textbox button and click and
> drag a rectangle on the userform to create an entry box, create another
> textbox just underneath the 1st one.
> 2. click on the commandbutton on the toolbox, click and drag a rectangle to
> create a button on the userform, make another four for each of the
> calculation sign,
> 3. click on the label button on the toolbox, click and drag a rectangle to
> create a button on the userform, that would be for the displaying the result
> 4. click on each of the button, go to the properties window on button
> left(F4 to open if not already there), change the value right of caption to
> +, -, x, / respectively for 4 buttons
> 5. click on the label, go to properties and delete the value in right of
> caption, change the background color of this label(if like) by clicking on
> box right of Backcolor, palette,
> 6. right click on each of the calculation sign button,
> for + put the following into the "Private sub CommandButton Click()" and
> "End Sub"
> Label1.Caption = TextBox1.Value * 1 + TextBox2.Value * 1
> for - put the following into the "Private sub CommandButton Click()" and
> "End Sub"
> Label1.Caption = TextBox1.Value - TextBox2.Value
> for x put the following into the "Private sub CommandButton Click()" and
> "End Sub"
> Label1.Caption = TextBox1.Value * TextBox2.Value
> for / put the following into the "Private sub CommandButton Click()" and
> "End Sub"
> Label1.Caption = TextBox1.Value / TextBox2.Value
> 7. if you want to add feature to it like only calculate when both textbox
> have number add following line to each of the 4 sub
> If TextBox1.Value = "" Or TextBox2.Value = "" Then Exit Sub
> Hope the above helps,
>
> Regards,
> Andy
>
> On Mon, Apr 27, 2009 at 10:14 AM, Paresh Gugale 
> wrote:
>
>
>
> > Please give me program which can add/subtract/multiply/divide numbers
> > in macros.
>
> > Regards
> > Paresh
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: detect text styles...

[Ashish Jain]

Hi,

Can you please explain a bit more? Since your question can have many
answer. Whether you want to scan a CSS or HTML? Do you want to create
a table of all attributes and their corresponding values? Do you want
to create a CSS/HTML using Excel table? Please clear the smoke flowing
over your problem.


Regards
Ashish Jain
www.excelitems.com
Developer of OpenXL



On Apr 18, 7:37 am, emailceloftis  wrote:
> I want to be able to extract the styles (any CSS type, i.e. font-
> family, text-decoration, font-weight, color, etc.) applied to the text
> (not the cell) in an excel cell.
>
> I'll be doing this by automating Excel though a VB.NET program - your
> suggestions welcome.
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Learn VBA

[Ashish Jain]

Hi Sachin,

To Learn VBA or any other thing, follow this simple rule.
"Learn and Practice"

Yes, you'll make mistakes but that's how we learn. Explore the
discussions, try to solve other users queries, read online articles,
books suggested on www.excelitems.com . and gradually you'll be an
expert.


Regards
Ashish Jain
www.excelitems.com
Developer of OpenXL



On Apr 27, 1:36 pm, Sachin Shukla  wrote:
> Dear All,
>
> I want to learn VBA in excel. Please help me.
>
> Thanks
>
> Sachin Shukla
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Regarding MCAS EXAM AND FEE IN INDIA.

[Ashish Jain]

Hi Abdul,

To prepare for MCAS Exam Preparation, you may go through Microsoft
published books and articles. Try sample exams, you may find them on
search engines. Fee Structure is flat $50.
For running offers and discounts, please visit
http://www.prometric.com/microsoft

Regards
Ashish Jain
www.excelitems.com
Developer of OpenXL



On Apr 26, 10:21 pm, Abdul Hakim  wrote:
> Dear All,
>
> Can anybody tell me about MCAS Exam Preparation and  certification fee
> structure in India.
>
> Help is deeply anticipated.
>
> Regards,
> Abdul Hakim Khan

--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Can data be feeded to a form in Internet explorer ?

[Ashish Jain]

Hi Laxmikant

Yes, this is possible. Using VBA you can fill forms on internet, even
if it's https.

For more tips, tricks, downloads and problem solutions: visit -->
http://www.excelitems.com

Regards
*Ashish **Jain*
Analyst, CSC
Microsoft Certified Application (Excel) Specialist
Excel and VBA Trainer
Author -> www.excelitems.com
+91--40-48-43
---­--
---­--

On Apr 21, 10:56 am, Laxmikant Kotian  wrote:
> The form is from a secure page & would have some fields as dropdown.
> Main reason for this requirment is to fill the form very quickly
>
> On 4/20/09, Abhishek Jain  wrote:
>
> > Hi Friends
>
> > I have a simple worksheet having data as below -
>
> >       A             B              C             D                      E
> >               F                       G
> > Order No.   Item No.    P. Date   Party Name        In Date         Out
> > Date           W. Days
>
> > I have all columns filled as following criteria :
>
> > Order No. - Repetitive...may have one or more unique item nos.
> > Item No. - Unique nos.
> > P. Date - Date corresponding to Item Nos.
> > Party Name - RepetitiveParty name corresponding to Order No.
> > In Date - In Date corresponding Item. Nos.
> > Out Date - Out Date corresponding Item. Nos.
> > W. Days - Difference between In and Out date --
>
> > The details are sorted on party names. I have attached a sample worksheet
> > with filled data. Would help to understand better.
>
> > What I want --
>
> > I want to work out Average of W. Days for each party based on their no. of
> > orders - separate average for each order...and then a final average based on
> > no. of orders. Let me tell you how -
>
> > Reference file attached -
>
> >> Party ABC LTD. has 41 orders
> >> In the first order - SS012096 there are 05 item nos.
> >> The average W. Days for this order is 4.8 (28/5 = 4.8)
> >> In the same way I need to get average of each order no. separately.
> >> When I will have averages of all  41 orders, I would sum them up and
> > divide by 41, giving me the final average.
>
> > I have to repeat this step for all parties...
>
> > Now..can there be some automated way to do that...a macro or
> > somethingconsidering :
>
> > The no. of orders may vary.
> > No. of items against each order varies (from 1 to 100).
> > No. and Names of parties varies every month.
>
> > I am sorry for being so longI was just trying to make you people
> > understand.
>
> > Eagerly awaiting for solutionwhy I said solution because I know the
> > group's great guys would not disappoint me :-)
>
> > Best regards,
>
> > Abhishek Jain
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Guessing Cards

[Ashish Jain]

Hi Ronnie,

Here is your solution:
http://www.excelitems.com/2009/04/delete-or-remove-event-macros-vba-code.html








For more tips, tricks, downloads and problem solutions: visit -->
http://www.excelitems.com

Regards
*Ashish **Jain*
Analyst, CSC
Microsoft Certified Application (Excel) Specialist
Excel and VBA Trainer
Author -> www.excelitems.com
+91--40-48-43
---­--
---­--


On Apr 2, 4:15 am, ronnie  wrote:
> Hello,
>
> Use random function to generate a random value of S, H, D, or C for
> the four card suits (spades hearts diamonds or clubs).
>
> When user clicks the button, an input box pops up to accepts a value
> of S, H, D, C
>
> If the guess matches the random number respond with “Good guess”, if
> not then respond with “Incorrect”
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Any way to divide the cell for ex. by 1000 in its place

[Ashish Jain]

Hi Mayank,

Try this VBA code.
1. Select the cells and run the code below:
2. Code:
Sub Divideby1000()
 Dim myCell as Range
 For each myCell in Selection.cells\
 myCell.Value = myCell.value/1000
 Next
End Sub


For more tips, tricks, downloads and problem solutions: visit -->
http://www.excelitems.com

Regards
*Ashish **Jain*
Analyst, CSC
Microsoft Certified Application (Excel) Specialist
Excel and VBA Trainer
Author -> www.excelitems.com
+91--40-48-43
-----
-----

On Apr 2, 9:22 pm, Mayank Patel  wrote:
> Hi friends
> can anyone tell is thr any way to divide the cell in place.
> i am having the large scattered data which i want to divide by 1000.
> Please Suggest
>
> Rgds
>
> Mayank
>
>
>
> On Thu, Apr 2, 2009 at 3:04 PM, Aindril De  wrote:
> > Hi Mahesh
>
> >http://office.microsoft.com/en-us/excel/HA102223271033.aspx
>
> > The above link will give you the answer.
>
> > Regards,
> > Andy
>
> > On Thu, Apr 2, 2009 at 12:38 AM, mahesh parab  wrote:
>
> >> Dear All
>
> >> Any knw macro in excel which can speak the cell content. or any user
> >> define function is there. if any one have
> >> example sheet please mail it to me.
>
> --
> Regards
> Mayank Patel
> ITC LTD
> 9822978041
> 9422749110
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: run time ERROR 9

[Ashish Jain]

Hi Shrinivas,

Mr. Powell has rightly said, please debug the same way.
And If it helps please also check, if you have larger amount of
columns or rows than your friend, since this also cause "Subscript Out
of Range". Run on lesser or same amount of rows , also ensure correct
sheet/file names in the vba macro.


For more tips, tricks, downloads and problem solutions: visit -->
http://www.excelitems.com
----
Regards
*Ashish **Jain*
Analyst, CSC
Microsoft Certified Application (Excel) Specialist
Excel and VBA Trainer
Author -> www.excelitems.com
+91--40-48-43
-----
-----

On Apr 1, 2:54 pm, shrinivas shevde  wrote:
> Dear All
>
> I am having vba code not written by me but one of my friend.Now I am facing a 
> problem while running the same.
>
> This I am using to make a monthly report ,this programe open a indivisual 
> file from the given folsder and copy paste required data in given excel sheet.
>
> Now when I am try to run this it shows the
>
> Run-time error9'
> Subscript out of range
>
> Please help me to solve this problem
>
> shrinivas
>
> _
> So many new options, so little time. Windows Live 
> Messenger.http://www.microsoft.com/india/windows/windowslive/messenger.aspx
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Deleting module code

[Ashish Jain]

Hi Ajay and Yu,

Here is the solution:
http://www.excelitems.com/2009/04/delete-or-remove-event-macros-vba-code.html

For more tips, tricks, downloads and problem solutions: visit -->
http://www.excelitems.com

Regards
*Ashish **Jain*
Analyst, CSC
Microsoft Certified Application (Excel) Specialist
Excel and VBA Trainer
Author -> www.excelitems.com
+91--40-48-43
-----
-----

On Apr 2, 6:26 pm, Yu  wrote:
>   I have same questions as well!
>
> On Apr 2, 3:07 pm, Ajay Varshney  wrote:
>
>
>
>
>
> > Hi,
>
> > Can somebody provide me SUB for FUNCTION code for deleting a Module from
> > Excel
>
> > Regards,
> > Ajay
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Deleting module code

[Ashish Jain]

Hi Ajay and Yu,

Here is the solution:
http://www.excelitems.com/2009/04/delete-or-remove-event-macros-vba-c...

For more tips, tricks, downloads and problem solutions: visit -->
http://www.excelitems.com

Regards
*Ashish **Jain*
Analyst, CSC
Microsoft Certified Application (Excel) Specialist
Excel and VBA Trainer
Author -> www.excelitems.com
+91--40-48-43
-----
-----

On Apr 2, 6:26 pm, Yu  wrote:
>   I have same questions as well!
>
> On Apr 2, 3:07 pm, Ajay Varshney  wrote:
>
> > Hi,
>
> > Can somebody provide me SUB for FUNCTION code for deleting a Module from
> > Excel
>
> > Regards,
> > Ajay
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: XML

[Ashish Jain]

Hi Satish,

I don't know which format of XML is reqd. by your website and what
kind of manual intervention reqd. to input data else wise.
Either you can write a macro to create a custom XML file or
Go to FILE -> SAVE AS -> Save as Type XML SPREADSHEET.

For more tips, tricks, downloads and problem solutions: visit -->
http://www.excelitems.com

Regards
*Ashish **Jain*
Analyst, CSC
Microsoft Certified Application (Excel) Specialist
Excel and VBA Trainer
Author -> www.excelitems.com
+91--40-48-43
-----
-----

On Mar 30, 3:19 pm, satish  wrote:
> Hi
>
> Can anyone help how to create anxmlfile. Some websites allow to
> update data if it is inxmlformat. Ifxmlformat is not available the
> same website asks to type the data in the cells provided which is very
> tiresome. So i wanna learn how to createxmlfile as per the
> requirement of website. Any help plz...?
>
> Satish
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---