Programming

use command button to total datas in cells through VBA codes in ex
how can i establish a new command button in combo box to total datas in cells by wrinting VBA codes ?? thanks you ! Roy ... 1 Mar 2010 05:54

Text in cell is not visible! 8(
My cell is formatted to accept string type data. However, if the text length is bigger than the cell length then all I see are a bunch of "##################" characters in the cell. Can't Excel just show the text that fits in the cell and possibly clip off the text that extends beyond the cell??? How can I do... 1 Mar 2010 09:11

Collating stock market data
Dear Friends I have 1 blank excel file and around 200+ text files in the folder c: \stock. Here is a sample data in each text file. Name of the file PARAMOUNT.TXT PARAMOUNT.NS,20100226,09:01:00,521.00,521.40,517.20,519.00,1677 PARAMOUNT.NS,20100226,09:02:00,520.00,520.90,520.00,520.00,1872 PARAMOUNT.NS,201... 1 Mar 2010 03:43

Test named range exists & exclude worksheet if it doesn't
Hi All I'm trying to adjust the following code which some amazing experts from this discussion group have written for me - but (being a novice) I obviously haven't done it properly... Your help would be appreciated: The macro searches all workbooks except "Overview Template", GRP Wkly Collection, the desti... 1 Mar 2010 10:17

SendMail
Hi, how can I create an email with an attachment using the SendMail dialog. When I record a macro and "Send: Email as PDF Attachment" I get Sub Macro1() ActiveWorkbook.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _ "C:\DOCUME~1\ME~1.COM\LOCALS~1\Temp\REOI11.pdf", Quality:=xlQualityStandard, _ ... 28 Feb 2010 23:22

MSCOMM Control with Excel 2003
What is the correct version of MSCOMM to be used with Excel 2003. I am experiencing very strange behaviour and do not understand the root cause. Thank you in advance, TomC ... 28 Feb 2010 22:17

data validation, mouse action of select... then move right
Rigt click on the sheet tab and click "view code". Copy below code and paste it on the code window. A6 as the cell with validation. Change it to your cell address. ------------------------------------------------------- Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Me.Range("A6")) ... 28 Feb 2010 15:37

cpu usage when excel is in taskbar
hello all !! i have my big set of 200 open workboooks ... they all run a macro of analysis evry 2 seconds.. the question is that.. when the excel window is active window.. the cpu usage is 30 % ....when the active window is another one or.. when i send the excel window to the taskbar, the cpu usage rises ... 28 Feb 2010 11:06

VBA code to find first blank cell in a column and activate it
MS XP Pro, MS Office 2007. Can anyone assist with macro to find the first blank cell in a column and then to make it the active (selected) cell so that data can be pasted to it and the row in which it is placed. I cant find a stable and reliable solution with the Find Blank Cell procedure in the menu. ... 28 Feb 2010 10:00

Another '03 vs '07 Add-in Menu Question
Hi, I have successfully written menu code that runs each time an .xla opens along with Excel. It works fine on my machines in both XL 2003 and XL 2007 (as expected under the Add-in menu). However, on other people's machines, and much to my chagrin, the menu does not appear in XL 2007. I know they have properly i... 27 Feb 2010 19:54