excel macros

<TABLE style="WIDTH: 442pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=589><COLGROUP><COL style="WIDTH: 48pt" span=2 width=64><COL style="WIDTH: 54pt; mso-width-source: userset; mso-width-alt: 2633" width=72><COL style="WIDTH: 145pt; mso-width-source: userset...

Hi Guys, I was trying to be a bit innovative and was thinking can we write any other scripting language like PHP,JSP other than VB Scripts in Excel Macros Please guys advise me on this, whether we can write anyother scripts other than vb script in Excel macros. Regards, Jibanendu

Hi, I need to read a data into an excel macro. I have the macro ready which can process once if the data is read in. the text file will have only one line of data (of 4 characters). The location of this text file is also hard coded. All i want is to read the data from the text file to be...

I have 144 excel files in one folder, their name ranged from 001, 002, 003, .....156 (File names correspond to subject ID, some of the subjects are missing) I want to get partial data from each file and then paste into a new file to generate a table with three col. like below FileName (Name of...

Hello,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> I believe that after creating a macro on my Excel, the size of the file got huge (28Megs). I removed the macro but the size remains too large. What can I do to return to a smaller, more...

Does any one know already had done so in the past to have a Macro in Excel to search a column of accounts from workbook1 in many other workbooks. Example: Workbook1> Sheet1>Column1 has many account#. Workbook2> Sheet1, Sheet2, Sheet3 > Column1 also as account# & Column2 has Name of the the...