$$Excel-Macros$$ trend analysis in excel

Dear All it would be great if someone could provide ppt or sample workbook on trend analysis. with explanation Thank You, -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and link

Re: $$Excel-Macros$$ Importing data into excel

Peter, I have this macro I will customize it as per your need & will soon share the same with you. Regards, Deepak Rai On Fri, Oct 1, 2010 at 11:35 PM, Deepak Rai wrote: > Hi Peter, > > For this you need to have a common folder where you can store all your Data > files after that through VBA m

Re: $$Excel-Macros$$ Importing data into excel

Hi Peter, For this you need to have a common folder where you can store all your Data files after that through VBA macro you can consolidate all those N numbers of Data files into a consolidated excel file. You would not able to do this by manual approach. Regards, Deepak Rai On Fri, Oct 1, 2010

Re: $$Excel-Macros$$ Urgent Querry

Sheet attached for your query. On Thu, Sep 30, 2010 at 5:58 PM, Pankaj Kumar wrote: > > Hi, All Experts, > > Its Urgent > -- I need u r help i have two column in excelsheet Data1 & Data 2 we have > to match both data if its Match show "Match" or not Match shows "Mismatch" > in next coloum,,,Pls p

Re: $$Excel-Macros$$ Macro hangs

Yeah, back about 100 years ago  (ok, maybe that's exaggerating) I discovered that when moving top-to-bottom and delete a row, it makes the "next" row the "current" row, then the next loop iteration caused it to skip that row. You handled that by reducing the loop counter. But I decided that work

Re: $$Excel-Macros$$

Hi dave, Thank you so much I pasted in right place and now it is working Thanks once again Regards Ramkesh On Thu, Sep 30, 2010 at 9:02 PM, Paul Schreiner wrote: > Where did you place it? > It belongs in the Sheet module for the specific sheet. > Not a "standard" module, or the This workbook mod

Re: $$Excel-Macros$$ Importing data into excel

Dear Vijay, In the DATA menu of Excel I have options for Web, Text, Acess, and other source, I do not have a button for excel-files. I already tried several option in the menupath but I couldn't let it work . In the attachment an example. In practice there are several 100's of datafiles. The prob

$$Excel-Macros$$ bypass savepdf dailogue

Hi ALL am in a process of coding a macro that converts excel to pdf..this has to perform for an automation process..am almost close to the result..but need to bypass the savepdf dialogue ..can any body help me on this... earlier help is highly appreciated... Global Const dhcRegSz = 1

RE: $$Excel-Macros$$ Visible Row Below Freeze Pane

Hi, A simpler alternative for your second requirement: ActiveWindow.ScrollRow = 50 Regards - Dave. > Date: Tue, 28 Sep 2010 16:08:14 -0700 > Subject: $$Excel-Macros$$ Visible Row Below Freeze Pane > From: spa...@corbetteer.co.uk > To: excel-macros@googlegroups.com > > With the top row

RE: $$Excel-Macros$$ Visible Row Below Freeze Pane

Hi, "How would I prove row 32 is the first visible row through VBA" A = Activewindow.VisibleRange.Row "If i then wanted to make row 50 the first visible row, how could it be done through VBA" Range("A2").Select ActiveWindow.SmallScroll Down:=48 There's probably a better way of doing t

RE: $$Excel-Macros$$ Macro hangs

Hi Paul, This code is excellent! I've looked up the Help for the Dictionary object, which clarified it's use quite well. At first I wondered why you had decided to work backwards, up through the code; then realised (I think) that it's so you can delete a row (Delete Shift:=xlUp) without having

Re: $$Excel-Macros$$ Macro hangs

SumProduct DEFINITELY has its uses, but I try to avoid using Worksheet formulas in VBA when possible. I see that you're using Excel2007 (from the .xlsm extension) Excel2007 has a HUGE bug dealing with CPU priority. When the window "focus" changes to another window, and the CPU usage remains high

Re: $$Excel-Macros$$ macro to save it to a particular drive / file location.

I noticed that the email was off-line instead of to the group.. so I included it here. -- My solution seems to work if the file hasn't been named, so I got more elaborate: --

Re: $$Excel-Macros$$ Importing data into excel

Hi, You Can import Data from Web ,Other Excel sheets ,Text, etc by using Get External Data in The DATA MENU of Excel. Regards, Vijay Kumar -- -- Some important links for excel users: 1. Follow us on TWITTER for ti

$$Excel-Macros$$ Re: Help require to understand the Formula of the attached sheet

Dear Mr Hiren Sheth, Perhaps you are refering to {=TABLE(,B3)} listed in the cells. This is not an actual function but a table which is part of excel what if analysis. In Excel 2007 you can go to Data tab > What if analysis > Table and with older versions this feature is available in Tools menu.