Programming

How to copy range to diffrent workbook ?
Hi , Sorry for my English , hope you'll understand I need to copy values of (50+) * 3 Cells from about 60 workbooks ( i called them source workbooks ) to 1 Workbook (destination workbook) . Tried the following : In every source workbook : Set tempRange = Sheet1.Range(Cells(2, 1), Cells(RCount + 1, 9)... 17 Feb 2005 08:00

VBA-Excel. File-SaveAs
Hi All, Iam calling Excel page in ASP using VB Script. After the Excel page is loaded I want the user to SaveAs in different path. How can I do it. any help would be glad asap. rgds Ramesh ... 17 Feb 2005 03:46

VBA Split-function
I want to use the Split function in a custom made function and want the output to be used in a main procedure. My problem is with the following code: *************************************************** Public Function ExtractData(TextString as String, _ Separator as String, _ ... 17 Feb 2005 05:58

Having stack/heap memory in Excel VBA
I need to have a sort of Hashtable from within VBA/Excel; this is to prevent the retrieval of lots of data everytime the data is requested, eg - a text file of data. My initial thoughts are to create a com object that exposed the Hashtable from C#/.NET, create a public instance of this in VBA (so that it remains... 16 Feb 2005 14:56

Turning Spreadsheet into attachement in an Email
Can someone possibly help. I have written the following macro to send an excel spreadsheet as an attachment. It all seems to work well except, for some reason, it does not put the text "Please find attached" that I want in the body of the email. It only adds the attachment and the subject title. Can someone t... 16 Feb 2005 14:56

Code stops at range
Why does the following code stop running when it reaches Range("A1:A1000").Select Application.DisplayAlerts = False Range("D8:J900").Select Selection.Copy Application.DisplayAlerts = False Workbooks.Open Filename:= _ "\\office\shareddocs\My Documents\Excel books 2... 16 Feb 2005 14:25

Excel 2002 - Iterations - Find the iteration sequence number
Hi all, [A LOT OF TEXT, MIGHT HOP TO "QUESTION" BELOW, sry] I use Iterations/Circular references to solve for a variable (basically, it is a yield-to-maturity finder and no, the Excel functions do not suffice). The circular reference is basically set up such that I 1. Enter a value, i.e. Price 2. I have a ... 21 Feb 2005 05:10

Calculating Time and Date Differences
I have some Call stats that I need assistance with. I need to calculate the length of time a call has been open for, within an 10 working hour day. Current Data: 4 columns with the following:- CREATE DATE - in dd/mm/yyy Format CREATE TIME - in HH:mm:ss RESOLVED DATE - dd/mm/yyyy RESOLVED TIME 0 HH:mm:ss G... 16 Feb 2005 08:48

C# vba development
I created a button, to dynamically create a validation on cell the following is the code i wrote: ...... Excel.Range thisRange = ((Excel.Worksheet)(this.thisWorkbook.Worksheets.get_Item("XXXXX"))).get_Range("A1", Type.Missing); thisRange.Validation.Add(Excel.XlDVType.xlValidateList, Excel.XlDVAlertStyle... 17 Feb 2005 09:01

Excel
When a user clicks on open in excel, the default is to open a window that displays all of your excel files. There is an option that causes excel to go into a full screen mode when you click on open. This allow you to see all of the excel files that can fit on a full screen instead of having to scroll through the ... 15 Feb 2005 18:07