Programming

Updating Pivot Tables Dynamically
I'm currently looking to implement a solution to automate the process of updating 5 pivot tables (one after another) on the same worksheet in an Excel workbook. Within the workbook there is a worksheet which is used as the data source for the pivot tables. If the number of items in the data source does not ... 10 Feb 2010 11:09

Prevent deleting of cells
Hello, I have a spreadsheet that is used by many people to enter information. I want to stop them from deleting individual cells or sections of cells but do not want to protect the cells as I still need them to be able to enter information. Any ideas? Thank you. ... 10 Feb 2010 10:01

excel 2007 errors on chart changes
In excel 97 & 2000, everything works fine. Not in 2007 My macro changes chart type. It works in excel 2007 too untill I protect the worksheet. Then I get errors on this ActiveSheet.ChartObjects("Chart 1").Activate I assume it is because the chart is protected. How do I change the charts protected status so... 10 Feb 2010 10:01

I have many excel files, would like to aggregate into one
Your efforts are very nice. Please try to define the variabels names more clearly and try to put more comments for easy understanding of beginners. But code is very useful. "Tom Ogilvy" wrote: Assume all the files (and only the files) are in a subdirectory - C:\MyFolder for illustration Sub Gath... 10 Feb 2010 00:09

Hyperlink events
I am trying to do what I assume would be simple. I want to initiate some code when a hyperlink is clicked. I have put to following code in Sheet1, which has the hyperlink(s). Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink) Sheets("Sheet1").Range("B1") = "It Ran" End Sub The hyperlink ... 9 Feb 2010 17:27

Selecting a specific sheet by codename in an opened workbook (XL03
I have a master data workbook, and will be pulling in data from source XL files from various locations. At the moment, I'm trying to create a function that will allow me to pass a location (workbook to pull), and specify which sheet to grab from the source workbook, and which sheet in the master data workboo... 9 Feb 2010 17:27

C++ Excel 2007 SDK
Anyone here have any experience creating XLL's using Visual Studio 2008 C++? (XLL in terms of native Excel formula development) ....or is this all VBA-related programming discussion. I need to figure out how to get my UDF to return an array of values. I know it needs to be an XLOPER12 struct, but everytime I ... 9 Feb 2010 12:52

Jet Engine MaxScanRows without an ini file or registry
I'm doing this: oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=C:\;" & _ "Extended Properties=""text;HDR=No;FMT=CSVDelimited""" I want to set the "MaxScanRows=0" setting, but the only ways I can find to do this are to edit the registry or create a .ini file, a... 9 Feb 2010 11:43

RECORDSET file name length limit?
Here's a snippet of the code I'm using: oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=" & strFilePath & ";" & _ "Extended Properties=""text;HDR=Yes;FMT=Delimited""" Set oRS = CreateObject("ADODB.RECORDSET") 'Now actually open the text file and impor... 9 Feb 2010 08:23

Working of formula in Macro.
Hi, I have written a macro which process around 50000 rows in a spreadsheet and i have used VLOOKUP function in it. When i use this function normally(I mean manually) it takes around 2 mins to pop-up the values in spread sheet and macro process it in seconds. I just wanted to know does that macro waits untill th... 9 Feb 2010 06:12