Can I tellthe difference between 'Save' and 'Save As'?
I want to be able to respond differently when the user has clicked 'Save As' - is there something that allows me to test what the user has done to save the file? Thanks M ... 7 May 2010 06:44
Hi all, Rather frustrated here ;-) Trying to import a list from Sharepoint but I can't get the syntax right. Sharpoint Site = https://sharepoint.mycompany.com/company/css1/Lists/Historisch%20overzicht%20online%20diensten/Allitemsg.aspx List = Overzicht Online diensten Command = Set objListObject = Active... 7 May 2010 06:44
How to programme this??
Hey everyone. I need to make af program for our school, where we are going to play bingo. How do I get excel to do the following; Lets say a player has the following numbers; Line 1: 1, 2, 3, 4, 5 Line 2: 6, 7, 8, 9, 10 Line 3: 11, 12, 13, 14, 15 Then we play for 1 line, then 2 lines, and the full board... 7 May 2010 08:56
File Attributes Function
Hello, Jacob Skaria recently provided the very helpful function pasted below. I have a follow-up question, can the function also include a way to get other attributes such as: Datecreated, DateLastModified, and DateLastAccessed? Sub Macro() MsgBox GetLatestFileName("c:\test") MsgBox GetLatestFileName(... 7 May 2010 10:03
please help about handling "#NUM!" error !
Hello all, this time I will be much shorter: Is there any way that I can "handle" errors. When Excels' <function> returns error ("#NUM!") (in a worksheet) I may type in a cell "=IFERROR(<function>; -5.0) (my local settings needs semicolumn as argument separator) in order to display either value that <function... 7 May 2010 16:45
Select first cell in active row?
Good day all. Excel 2007 Can anyone assist with code to select the first cell in whichever row the currently active cell is to be found? If I record "Home" the macro given refers only to that specific cell, I need a dynamic result dependent an currently active row in the sheet. Thanks in advance for your always... 7 May 2010 00:15
Loop in Excel
I have some Names in the Column A, from A1:A34. In this Range from A1 to A34 some rows are empty. I mean some rows have no name. My requirement is that every week on Sunday I want my file to move last name from A34 to A1. After that A1 should move to A2, A2 should move to A3 and so on respectively. If there is no n... 6 May 2010 19:52
Excel formula needed to round up a value to a whole number
I'm making a cost estimation sheet, and need a cell to publish a whole number. This cell is the result of a division formula involving two other cells (ie. 300 sq ft of coverage divided by 200 sq ft of coverage per gallon = 1.5 gallons). I want my formula to round the 1.5 gallons up to 2 gallons. Please help... 6 May 2010 20:58
how to perform function (e.g. Sum, Average) on VB 3-d Array
Hi there can I use a excel function such as SUM on a 3d array? e.g. Dim array1(10,10,10) Dim av1 as integer av1 = Application.WorksheetFunction.average(array1(1,1,1):array1(10,1,1) debug.print av1 many thanks ... 8 May 2010 15:38
Any help with inserting, copying and transferring data.
Is there any way to conveniently accomplish this? My data is organized like this: 4626859EX 5422369 4427272 What I am trying to do is get it organized like this 4626859EX 5422369 4427272 5422369 4626859EX 4427272 4427272 4626859EX ... 6 May 2010 19:52