Programming

C# Add-in and PivotTables
I am working on a C# add-in that modifies pivot tables. I have done this work in VBA, and the object model seems straightforward, e.g., PivotTable-PivotFields-PivotItems, but I can not get the object for PivotItems, or iterate through the items. Do I need something other than PivotItems? Code for PivotField... 18 Nov 2009 11:12

MSExcel and SAP
Hi, I have several years of experience integrating Excel (and MSOffice) and SAP so if you have questions, yo can send me an email to abmemail(a)yahoo.com. Regards, Rao wrote: Running SAP screens from script/macro 07-abr-09 Hi, I also need a similar solution. Actually I need to run several transaction ... 16 Nov 2009 18:04

Problem with Vlookup
Maybe there is a restriction on the number of cells I can search I don't know.. =VLOOKUP(A53078,$G$2:$H$84,1,FALSE) returns a result of #N/A when I copy that same formula to an entry for like the first 1000 entries it returns a result, but beyond it seems to not be working.. Is there a limit?? Is there a prob... 16 Nov 2009 13:33

VBA//Oracle Interfacing Question
All, I have been able to correct to my database but I have one question question: Within objSession I want to list all available tables and all available views. How exactly is this done? thank you. Set objSession = CreateObject("OracleInProcServer.XOraSession") Set objDatabase = objSession.OpenDatabase(... 16 Nov 2009 13:33

Please Help (Unusual Lookup)
Hi Guys, Below is a list of invoices from a supplier. What I am trying to do is to extract or delete the line items that are not duplicates. Ideally I want a code that will leave me with Row C1, C2 C6 and C7. Rows C3, C4, C5, C8 C9 and C10 can be deleted. I shall be grateful if anyoe can suggest how to extra... 16 Nov 2009 09:03

I learn that way
At least I would know from where to start JLGWhiz wrote: What is learned by someone else doing the homework? 15-Nov-09 What is learned by someone else doing the homework? Previous Posts In This Thread: EggHeadCafe - Software Developer Portal of Choice Karl Moore's Visual Basic .NET: The Tutorials ... 15 Nov 2009 12:17

Addin compatibility between Excel 2k3 and Excel 2k7
Hi, in oder to force Excel 2007 to generate Excel 2003 files I have been using this bundle of code inside an Addin Workbooks(genSyncQteParam.fileName).SaveAs _ fileName:=CStr(SaveAs_path & SaveAsExcel_sourceName), _ FileFormat:=xlExcel8, _ Password:="", _ WriteResPassword:="", _ ReadOnlyRe... 15 Nov 2009 11:11

Excel Pivot Items Using C# - Unable to Access
I am working on a C# add-in that modifies pivot tables. I have done this work in VBA, and the object model seems straightforward, e.g., PivotTable-PivotFields-PivotItems, but I can not get the object for PivotItems, or iterate through the items. Do I need something other than PivotItems? Code for PivotFields,... 16 Nov 2009 10:10

Macro to populate cell value from another sheet based upon the data validation list selection
Hi, How do i write a macro to populate cell value from another sheet based upon the data validation list selection ... 12 Nov 2009 02:55

Redefine a Range
I am given a range which is part of a single column, say D31:D257 I need an easy way to clip off the top cell, leaving D32:D257 Thanks in Advance -- Gary''s Student - gsnu200908 ... 12 Nov 2009 20:47