Programming

retrieving rowlevels
Hi All, How can I tetrieve rowlevels last set? E.g. After executing ActiveSheet.Outline.ShowLevels RowLevels:=3 I want to retrieve 3. Thanks, Stefi ... 21 Jul 2008 09:58

Adding a calendar item to Outlook.
Hi all I have been tasked with adding a calendar item to Outlook but the calendar is not mine. I have access to many other calendars and want to add the items to those. I'm using Excel/Outlook 2000. Cheers -- Solution 123 Ltd is providing cost effective solutions to the ordinary user. We don''t a... 17 Jul 2008 09:36

How do I stop formulas from calculating when I open a worksheet
I have a worksheet that calls several user defined functions. Every time I open up the file in Excel, I have to wait while it recalculates every cell with a formula. How do I prevent this from occurring on startup? ... 17 Jul 2008 09:36

extracting data from columns to summary sheet
I have a worksheet with up to 60 names in col A, called “AERIAL RESCUE” Each name is allocated 7 rows for different types of data entry. As below A……… J Q R7 20 R8 32 R9 33 R10 62 R11 38 R12 29 R13JONES 345 1 R14 56 R15 75 R16 95 R17 23 R18 43 R19 32 ... 17 Jul 2008 08:34

logical function template
I have two different data sets with the following characteristics: Data set 1: Brand names (e.g. Coca Cola) in Column A with an accompanying number in Column B. Data set 2: Brand names in Column C with an accompanying number in Column D. The numbers which accompany each brand name are different. Some brand... 17 Jul 2008 13:44

Copyin Formulas containg Names
I created a spreadsheet in an older version of Microsoft Excel (can't remember exactly which one). The sheet contains formulas that use names to refer to specific arrays, constants etc. Previously I was able to copy the formula and it would retain the names. In the new Excel (2007) when I copy the fomula, inste... 18 Jul 2008 11:20

running an Acess Macro from excel
hi everyone not sure if this is possible but you never know I have in an ms access database a macro that will export a table to a spreadsheet (not a vb macro but one of the objects in access type things - i get confused easily so thought id say) anyway, i have built up an excel application that will retrie... 17 Jul 2008 09:36

How to set values to a range vertically
Hi, I am writing a C# program that interacts with Excel. When I have a range in Excel that contains a few "horizontal" cells (e.g. "A1" to "D1"), I can fill the range with values from an array: Microsoft.Office.Interop.Excel.Range rangeSeries = wsData.get_Range("A1", "D1"); range.set_Value(missing, array)... 17 Jul 2008 11:40

CONVERTING EXCEL FILE TO DBF FILE IN OFFICE 2007
... 17 Jul 2008 06:31

Open Outllook through VBA
I would like to send the report generated (Excel sheet) from VBA to various receipients. I have certain queries 1. How to write VBA to send mails from excel 2. How to attach certain files to send mail - VBA codes ? 3. How to send current sheet as body message through Outlook - VBA codes to these activities ... 17 Jul 2008 06:31