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

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

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

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 Certifie

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

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

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

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 Kn

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

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

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

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

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

'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 &

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

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 I

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

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

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

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

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

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 Knowledg

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

.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 Applicati

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

t 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 Kno

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

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

$$Excel-Macros$$ Re: Excel Macros

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

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

et 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 Applicat

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

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 Profession

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

ode 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.c

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

. 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

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

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

$$Excel-Macros$$ Re: Excel_tips

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

$$Excel-Macros$$ Re: Happy Diwali

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 I

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

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 (Microso

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

'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

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

ote: 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

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

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.co

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

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

$$Excel-Macros$$ Re:

. 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

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

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)

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

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

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

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 Professi

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

tings --> 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 (Micro

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

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 (Micr

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

ards 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

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

er 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

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

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

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

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

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

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

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

'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

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

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

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

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 * (Develope

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

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 * (Deve

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

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 As

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

> 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$$ Re: Excel Macro to export graphs from Excel to Powerpoint

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)

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

ice 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

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

celitems.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

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

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

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

f 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 Train

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

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 Ma

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

ion 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 (De

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

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 (Devel

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

g 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 (Develo

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

51cfafa2b1/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. - 0

$$Excel-Macros$$ Re: help plz

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

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

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 Ma

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

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 Macro

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

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.openexce

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

/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

$$Excel-Macros$$ Re: help

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

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

n 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.999

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

ve 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/2009/03/insert-n-number-of-worksheets-in-active.html> ---

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

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

$$Excel-Macros$$ Re: asset list

(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

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

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

$$Excel-Macros$$ Re: Excel macros

o 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

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

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

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 Op

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

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 h

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

;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. -

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

nge("A1") 'CWbk.SaveAs ThisWorkbook.Path & "\" & myDep.Value & ".xls" CWbk.SaveAs "C:\destination\" & myDep.Value & ".xls" CWbk.Close False Set CWbk = Nothing Next End Sub ---

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

s 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

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

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

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 al

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

ot. 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.

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

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:

$$Excel-Macros$$ Re: Sorting Values

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, {"B

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

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 ti

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

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: &

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

/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

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

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 functi

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

e 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

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

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

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

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

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

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

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

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

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

I 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 t

$$Excel-Macros$$ Re: Macro Help

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 Deve

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

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

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

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

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

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, colo

$$Excel-Macros$$ Re: Learn VBA

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 hel

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

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

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

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*

$$Excel-Macros$$ Re: Guessing Cards

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

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

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

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

e 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 T

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

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

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

s 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

$$Excel-Macros$$ Re: XML

wnloads 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

  1   2   >