Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / June 2006

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
How can I get Euros in the taskbar of Excel 200023 Jun 2006 06:22 GMT2
Does anybody have the software to put Euros in the taskbar of Excel 2000?
Simple code to append numbers to the existing data in the cells23 Jun 2006 06:02 GMT1
I have many colums of data (characters)
What I want to do is, highlight the required cells in the column and then
either press a button or whatever to trigger the code to run.
The code should append numbers to the existing data.
Is is possible to set a border NOT on the edge of a cell?23 Jun 2006 03:29 GMT1
I am looking to create a macro that either pastes a mini-image or
formats a diamond shaped border in each cell of a selected range.
I know how to do the macro, but cant figure out either how to paste an
small image in each cell or add a non-traditional border.
Sum the greatest run of negative numbers23 Jun 2006 03:18 GMT7
I have a list of returns like that listed below, I want to find out the
greatest continuous run of negative returns,
(i.e. -24-3 =-27, and is greater than -2-4-3-1-1-1=-12) so it would return a
result of -27
speech feature in excel23 Jun 2006 02:58 GMT3
How can I detect if the speech feature is installed in Excel?
Excel window closed but process still running23 Jun 2006 02:44 GMT2
 I'm using C# application to open an Excel workbook by using
        m_objExcel = new Excel.Application();
and it works fine but problem arises if user close Excel window and go
back to my C# application to open another excel workbook. the workbook
pivot tables23 Jun 2006 01:29 GMT1
Hi, i get pivot tables on a weekly basis. the data is to big to open in
excel. is there any way to get the data out of the pivot table into a text
file and then for me to import into a database. i do not have access to the
data source of the pivot tables. any vba script or ...
color on text in a cell23 Jun 2006 00:39 GMT4
How do u modify data in a cell with different color text thru VBA.
I want to append data with a different color to the existing cell.
How Do I Use an XLL Add-In Function from Code?23 Jun 2006 00:37 GMT1
My question, short form:
I have an Excel Add-In, packaged as an XLL, which contains a worksheet
function -- let's call it F(). Can I use F() from VB/VBA? If so, how?
My question, long form:
write array to range23 Jun 2006 00:36 GMT8
I'm picking up Excel VBA again and have some trouble with this:
Range("b2", "b501") = NPV,
where NPV is an array and it looks OK, but the output is all the same,
500 of the first element, what's wrong?
Stop marco allert and update link allert when opening spreadsheet23 Jun 2006 00:15 GMT1
When the macro security settings are set to High or Very High, i get a
warning each time I open a spread sheet that states that macros are turned
off.  I dont want to see this warning at all.  
Like wise, if a spreadsheet has links that need to be updated, when i open
conversion of text to numeric23 Jun 2006 00:14 GMT2
In a macro I have the following code
Cells(rs, cl) = Cells(7, 19)
What can I change to this or add after it that will force the numbers
to be numeric instead of string?
convert table of hyperlinks23 Jun 2006 00:03 GMT1
I have a large table (over 600 entries) of hyperlinks.
They are all in a single column.
They are all of the form:   =HYPERLINK("http://www.something.com","something")
I need to convert the table into a table of hyperlinks without function
module moving22 Jun 2006 23:22 GMT2
How do I insert a new module in between exisiting ones and have the order
change or rename the modules
Question about sizing Userforms programmatically22 Jun 2006 23:19 GMT2
Windows XP Pro SP2
Excel 2002 SP3
I have a Userform that I like to change the size of as I progress through
various steps of a setup wizard that the Userform in question serves as the
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.