Programming

External Data
I need some help with Excel VBA, currently I have the following line of code: PeakCPU = Application.VLookup(ServerName, Workbooks(Workbook).Sheets ("Server_Utilisation").Range("$C$25:$L$8100"), 7, False) This looks for a string in an already open spreadsheet but I'm running out of memory due to the number of s... 23 Sep 2009 09:55

Range Defined names loop
Hi all, How to loop through range names? range names like menu Insert| name | define similar to intention of (invalid) pseudocode below For each range in Worksheet.Ranges Debug.Print range.name next since i don't find a ranges collection the above won't work the reason i ask is i had named some ranges i... 23 Sep 2009 13:19

OO4O execute a query against Oracle, VBA Excel 2003
Any OO4O Oracle users out there ? Ok, I am making this Excel VBA thing that will execute a series of queries and bring in Analysis Data, the first step that I need to do is execute a DDL query to create a Table: Any variables that hold data are in the code, I just simplified it and removed them, that all is go... 23 Sep 2009 17:51

File owner attributes through Excel VBA
Is it possible to use VBA to determine the owner of a file saved on a network share? I am trying to get the ID of the person logged in when the file was created on the server. The file itself is not an MS office file however, I'm just trying to get the name of the owner as part of my macro in Excel. ... 22 Sep 2009 09:33

ActiveWorkbook.SaveAs Format(Date, "mmddyy") & ".csv"
Would you like to share with us what the error message says? "LuisE" <legonzales(a)yahoo.com> wrote in message news:C3F895B4-F76E-49CD-8883-7B8F4DEF9B43(a)microsoft.com... Using Excel 2007 I'm getting an error message. ActiveWorkbook.SaveAs "C:\Users\Michael Guergawi\Documents\" & Format(Date, "mm... 20 Sep 2009 23:04

Excel Table Width Pasted into Word
I have a range of cells in an Excel 2003 worksheet that I paste (using VBA) into Word 2003. However, the columns in the resulting table in Word have been stretched out. I tried adjusting the PageWidth in Word, but this does not seem to help. Is there a particular way I can do this to keep the width of the Word ... 23 Sep 2009 07:42

undo VBA procedure error when called via change event
Hi I have the code below to insert a worksheet formula into cells within the range G24:G35 of the active sheet, and to allow the user to undo if the inadvertently delete the contents of a cell. Type SaveRange Val As Variant Addr As String End Type Public OldWorkbook As Workb... 18 Sep 2009 08:52

how to use modules so that values calculated in one of them can be used by another?
Basically i am trying to put all of subroutines which are under thisworkbook section into different modules. for example if there are sub1,sub2,sub3 under thisworkbook code window such that sub0 call sub1 call sub2 endsub0 sub1 endsub1 sub2 end sub2 I want to write or move sub1 and sub2 into d... 16 Sep 2009 09:34

Excel 2007 print problem
Using a procedure which was originally created in Excel 2002 I am getting an error at the following line when running the same procedure on Excel 2007. ActiveSheet.PageSetup.PrintArea = Selection.Address I am at a loss as to why it comes out at this point and would value any guidance. Graham ... 17 Sep 2009 17:03

How to use "notify" callback with winmm.dll
I have an Excel user form with a button that plays a wav file using mciSendString. I am trying to make use of the notify parameter so I can take some action when the file is done playing, but I can't get it to work. Here is my relevant code: Call mciSendString("play WavFile notify", 0, 0, AddressOf mciSendSt... 15 Sep 2009 20:19