While editing a comment in Excel I can highligt a single word, right click, format comment and change the format this one word without effecting the rest of the comment. How can I do this within VBA?
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
I have many instances in which I want my VB or VBA code to open an Excel file, perform some action, save the file, and close it. My standard technique has been to instantiate a new Excel or Access...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_23445794.html
I need to be able to determine the length of a text string in points using a particulat Font Name and size.
http://www.experts-exchange.com/Microsoft/Applications/Microsoft_Works/Q_23437808.html
I am using the below code to write data to one of the sheet in a xls file that contains predefined Pivot and some macro.. From within vb.net application I use the code to write a data set to the d...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Hi
Could one change the fill for a cell using a VBA function. For example, I want with the following formula in a cell:
=SetColor(A1:A5)
set the color of cells A1,A2,A3,A4 and A5 to RGB(24...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 10/15/2008 Grade: A Views: 119
I have a library of MP3 songs.
The Album Names and the artist names in the files are incorrect.
Using VBA, I was able to list the file names and the extended properties on excel sheet.
Going thr...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 09/27/2008 Grade: A Views: 26
