Programming

Case not recognized in Select Case
I am using Select Case in a macro that deletes worksheets to skip specifically named worksheets. Code is: For Each Worksheet In Worksheets Select Case Worksheet.name Case "Sheet1", 'Sheet2", "Sheet3", etc. Case Else Worksheet.Activate Application.DisplayAlerts = False ActiveShee... 29 Mar 2010 14:45

Selecting a point on a chart in Excel 2007 on Windows 7
Hi, I have a macro that operates on a point, selected on a chart. It works fine in Excel 2003 on Windows XP, Windows 7, and in Excel 2007 on Windows XP. However, I can't seem to select a point by clicking on it in Office 2007 on Windows 7. Sometimes when I select the chart *some* point gets selected, but I ... 29 Mar 2010 11:23

File name being changed
In 2003 Excel VBA, this code saved the name correctly: Application.Calculation = xlCalculationAutomatic ChDir "K:" wNFileName = "k:Safety\" & Left(wFileName, Len(wFileName) - 4) & " " & Format(Now(), "mmddyy") & ".xls" ActiveWorkbook.SaveAs FileName:=wNFileName ActiveWorkbook.Close ChDi... 31 Mar 2010 15:29

VB help with ExecuteExcel4Macro
Hi, I'd like to use ExecuteExcel4Macro to help me get data from closed workbooks but I'm definitely a novice when it comes to VB. I have a folder with a lot of workbooks I need to pull data from and the data is all in the same places, meaning, for example, on the UPLOAD tab, Row 2, Cells A-AA, but I only need... 11 Apr 2010 07:58

DoubleClick to return SeriesIndex & PointIndex
I see that on first double click the whole series is selected so arg1 = SeriesIndex, Arg2 = -1 On second double click a single point is selected Any way to get both Series & Point Index with a single double click? ... 29 Mar 2010 09:08

Select 'used range' except header row in excel 2007
Hello How can I use code to select populated cells in a worksheet but exclude the top row which is my header row? The spreadsheet has formulae down to about row 2000 but all 2000 rows aren't always used... thanks ... 29 Mar 2010 10:15

Disable share workbook option in VBA
I've got a workbook with a lot of code and want to prevent users from sharing the workbook. If they share the workbook, it only generates error messages for them and creates problems. If I could hide the command bar option or catch when they go to share the workbook and cancel the action, that would be great. But... 29 Mar 2010 19:14

Alternative way to show 12 tabs??
I'm thinking about creating a yearly Excel file where each month will have its own sheet and associated tab. This means that my file will contain 12 tabs. The problem with having 12 tabs is that they all cannot be visible at the same time at the bottom of the workbook, due to the limited width at the bottom. ... 29 Mar 2010 11:23

Opening file by partial name in same folder as master file
Please Help!! I have a master file called "All Reports.xls" that opens up various Reports files(Ex: ABC_G016_GPUS.xls, BCD_G027_GPUS.xls, JKL_G034_GPUS.xls). The Report files are in the same network folder as the master file and are updated frequently. The Report files also have names that constantly change wh... 29 Mar 2010 12:30

DYNAMIC RANGE FOR PIVOT TABLE
Hi I am using Excel 2007 and trying to create a dynamic range for a pivot table so that its source adjusts depending on the number of rows in the xternal workbook source. I have created a range "SalesDataset" with the following formula: =OFFSET(Summary!$A$1,0,0,COUNTA(Summary!$A:$A),COUNTA(Summary!$1:$1)) ... 29 Mar 2010 05:52