Programming

VBA Dynamic range in Pivot table
I need to code the following: I have a pivot table that may contain any number of companies in the row section and one item in the data section. I am trying to figure out how I can code something that will drill down each companies row total without naming the companies in VBA and then move the new worksheet to a ... 25 May 2010 11:19

Open Excel file from SharePoint; opens as ReadOnly
I an using the code here: http://www.eggheadcafe.com/software/aspnet/33017666/vba-code-to-open-an-excel.aspx My Excel files keep opening as Read-Only. The files should NOT be opening as Read-Only and I'm not sure what's causing this. Did anyone here experience this before? Does anyone know how to disable this... 25 May 2010 11:19

Newsgroups going bye-bye
I read the thread that Microsofot is discontinuing this newsgroup in favor of a Forum format. The thread said that the newsgroups are being used less and less and the forums are being used more and more. So I went to the Microsoft Forums. I could only find one for Excel - 'Excel for Developers' Forum [http:... 26 May 2010 00:33

SendTo
I have a workbook which I have written code which will not allow the user to save the workbook unless they have provided specific pieces of information. I had intended to not allow users to Email the worbook without the specific information being present. My thought process was if they cannot save it they cann... 1 Jun 2010 15:19

Exporting to .txt converts single quotes to double quotes
Hi All Im making a module that will create a new spreadsheet, populate it with some fixed and variable values and save it as a text file. Unfortunately excel 2007 is saving the following line: <?xml version="1.0" encoding="ISO-885h9-1" ?> as "<?xml version=""1.0"" encoding=""ISO-885h9-1"" ?>" when I ... 27 May 2010 17:04

File not saving
I am trying to save another (differently named) version of my file whenever I save. It works fine if I use the normal save, but if the save is triggered from the Before_Close event, it just skips over the following line... ThisWorkbook.SaveAs Filename:=CurrPath & "\" & CurrName in debug, it finds t... 25 May 2010 08:02

Autocompletion For UDFs?
Seems like the site's not working OK. Posting again: I have VB Studio 2008 + Excel 2007 on my system. Any idea or source of detailed info as to how to create a simple UDF like =AddTwoNumbers(Number1,Number2) which after I create and install via an addin would recognize the same in the excel like a native func... 25 May 2010 02:39

Autocompletion For UDFs?
I have VB Studio 2008 + Excel 2007 on my system. Any idea or source of detailed info as to how to create a simple UDF like =AddTwoNumbers(Number1,Number2) which after I create and install via an addin would recognize the same in the excel like a native function. In other words, I could be able to use the same i... 27 May 2010 17:04

New functions needed
Consider the following entries in Column A1: CHRISTIAN 32 PATTERSON ME SW TOM & PAT 235 PROMINENCE HGTS SW CALG M 26 PATTERSON CL SW CALG L P 54 PATTERSON PK SW CA ROBERTO JOSE 27 PATTERSON PL SW CAL I want to parse this out. Here's here are the columns I want: B: Left(A1, find the first number)-2) ' ... 27 May 2010 17:04

Comparing Apples and Oranges
I just can't seem to get my arms around this. Here's the scenario. For a bunch of consultants, I'm calculating State Unemployment Tax (on a weekly basis, which I can call a period basis). The calculation is as such: =IF(H5="NY",MIN(554.62,(L5*0.06525)),IF(H5="NJ",MIN(274.73,(L5*0.00925)),IF(H5="CT",MIN(285,(L5*0... 24 May 2010 23:27