Re: $$Excel-Macros$$ Filtered Info must come into the Header or Footer

Hi! Steve, When I down loaded your attachment, found that the Excel file has a stand alone logo which has continued to remain in my computer also without any of my DLL files modified. I have been not able to pick up different logo for four files in a folder. Can you please guide how did you put

Re: $$Excel-Macros$$ UNIQUE values in Array

Hi, I'm not sure you found a solution for this. This link http://www.excelfox.com/forum/showthread.php?31-Data-Validation-Dependent-Dropdownsmight be a useful one. Kris -- -- Some important links for excel users:

$$Excel-Macros$$ Macro - Open PowerPoint and Update Links?

Thanks in advance, experts!! I have a PowerPoint presentation that has links to Excel charts that need to be updated each time the Excel file is changed. I have everything working fine (I can update, save, and close the Excel file, open PP, and it prompts me to Update Links - I click yes, and

Re: $$Excel-Macros$$ Slow Laptop execution

I forgot to mention that I'm using Excel 2007 and Excel 2010.   Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - Joh

$$Excel-Macros$$ Slow Laptop execution

I have an excel application that is used to create maintain Manufacturing Process documents in an Oracle database. These documents vary from 2 to 400 pages (averaging about 30) The application has (7) hidden worksheet "templates". I first turn off ScreenUpdating, Calculations, DisplayAlerts, Ev

$$Excel-Macros$$ Job

BUSINESS ANALYST - L2(T136767) Wipro Technologies *Experience:* 3 - 5 Years *Location:* Chennai *Education:* UG - Any Graduate - Any Specialization PG - Any PG Course - Any Specialization *Industry Type:* IT-Software/ Software Services *Role:* Business Analyst *Functional Area:* ERP, CRM *P

$$Excel-Macros$$ accessing crystal reports through VBA

How to access crystal report form with VBA ??? -- -- 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.

$$Excel-Macros$$ connecting code to the report

I used the following code to connect the report sheet Dim rep As New CrystalReport rep.ReportFileName = "f:\test" CRViewer1.ReportSource = rep CRViewer1.ViewReport End Sub But its throwing error as "USER DEFINED TYPE NOT DEFINED" -- -

$$Excel-Macros$$ doubt in report generation

I am trying to design report with crystal report 9. It is not having to design in FORM VIEW. All designs are in columner form. Pls do help me. -- -- Some important links for excel users: 1. Follow us on TWITTER for

Re: $$Excel-Macros$$ Drop Down Combo box Error

Dear Surya, Please use below.. *Private Sub ComboBox1_Change() TextBox1.Visible = True Select Case ComboBox1.Value Case 2 UserForm1.MultiPage1.Page2.Visible = False End Select End Sub * -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*

Re: $$Excel-Macros$$ how to consalidate from more sheets to one sheet

Try this without selections Option Explicit Sub consolidateSAS() Dim ns As Long Dim slr As Long Dim dlr As Long Dim i As Long Application.ScreenUpdating = False ns = Sheets.Count Sheets.Add After:=Sheets(ns) With ActiveSheet .Name = "Consolidated Sheet" .Range("A1") = "Name" .Range("B1") = "Resu

Re: $$Excel-Macros$$ Fwd: Create new worksheet from input box

Dear Ananta, Please see attached sheet, if it help to u... On Wed, Sep 14, 2011 at 12:00 PM, Ananta Sapkota wrote: > > > -- Forwarded message -- > From: Ananta Sapkota > Date: Sun, Sep 11, 2011 at 4:59 PM > Subject: Create new worksheet from input box > To: excel-macros@googleg

$$Excel-Macros$$ Excel VBA/ Access

Hi, I have posted this on the access group too, it can't really be classified as one or the other, but it's driving me mad, can anyone help. I have an Access 2010 database, which I have saved as .mdb. (ie not accdb) It has an update query in, which takes 2 string parameters. When I run it from

Re: $$Excel-Macros$$ Business Reporting Templates

Hi Noorain, Thanks for the file. Please let me know any other Business reporting dashboard available Regards Anu On Wed, Sep 14, 2011 at 3:38 PM, NOORAIN ANSARI wrote: > Hi Anu, > > Please find attached sheet, if it help to u > > On Wed, Sep 14, 2011 at 3:10 PM, anu gomathi > wrote:

Re: $$Excel-Macros$$ how to consalidate from more sheets to one sheet

Dear Naresh, See attached sheet.. Try it *Sub Consodilate_Macro() st_name = Sheets.Count Sheets.Add After:=Sheets(Sheets.Count) ActiveSheet.Name = "Consodilated Sheet" Sheets(Sheets.Count).Range("A1") = "Name" Sheets(Sheets.Count).Range("B1") = "Result" Sheets(Sheets.Coun

$$Excel-Macros$$ how to consalidate from more sheets to one sheet

Hi Team, I have a query, can you please tell me… Q: How to link data from different sheets to one sheet ? Ex: In attached excel there are 6 sheets. Sheet1, Sheet2, Sheet3, Sheet4, Sheet5 and consolidated sheet. I want to pull data into consolidate sheet from sheet1 to sheet5. I have shown in the

$$Excel-Macros$$ Drop Down Combo box Error

Hi Group, I have a Combo box in which the list is selected from 1 to 8 and i have 2 pages in the form when click on 1,3,5,7 the Frame1 in Page 2 should be disabled and vice versa , please help Thanks Prasad -- -- So

Re: $$Excel-Macros$$ Transpose Data from cell to columns

Thnx to all for this great help..! Kaяan