- partnering with microsoft
- microsoft excel
- oracle services for microsoft transaction server
- microsoft robotics - decentralized software servic
- microsoft solution for windows-based hosting
- office live basics, essentials and premium
- microsoft sdk for open xml formats
- starsuite
- visual studio tools for office
- innovate on office
- technology - integration and events
- scm - process manufacturing (opm)
- crm - field service
- technology - general discussion
- technology - 11i install/upgrade
- microsoft excel
- sharepoint - excel services
xlstart folder
Recently excel has of its own accord decided to save a copy of a workbook I've been using in the xlstart folder. I haven't known at the time that this happened and it has caused problems until I was able to determine what happened and delete the file from xlstart.Has anyone else had this...
0 answers | 332 bytes |
While validating an Excel Document
Hi,When I click the excel document I got the following error. 'Sorry an error occurred while validating box "Root" (While validating an excel document, automation error, unspecified error)'Any help would be appreciated.Thanks in advanceVijay...
0 answers | 277 bytes |
user controls
hi,i just want to know whether we can add user controls such as textbox , label to a excel sheet dynamically (say on a button click i need to add 5 textbox to the excel sheet) .if so can any one send me some materials or code.thanksgsk...
1 answers | 255 bytes |
Trading Formula
Howdy,I need help with a formula for calculating profit and loss for backtesting trade data.I need a third column to show profit or loss between the buy, sell, and buy.1 = Buy-1 = Sell1______ 100 18/32-1_____ 100 28/321______ 100 17/321______1______1______-1_____ 101 4/32In this case it would be...
0 answers | 546 bytes |
Run SAS with a excel macro VBA
It is possible to run another program with vba in excel?Specifically, I need to run SAS program with a macro VBA in excel. This is possible? Thanks in advance....
0 answers | 163 bytes |
Problems with using dates in formulas
Hi,I wonder if anyone knows how to solve this problem?I have built an excel database to track customer contact. As this is a tracking tool I need excel to give date driven prompts as to when to take the next action.I have used the following formuala, which works, but because it is refering to ce...
0 answers | 1025 bytes |
Preventing Refreshing in particular cells
I have developed a spreadsheet which is an interactive tool for students to practise mental addition of 2, 2 digit numbers. Using randbetween random numbers between 10 and 20 are generated. Student enters answer and is given feedback (Well done or Try again). Problem is, when sheet refreshes all...
0 answers | 489 bytes |
prevent string converting to date
One of our larger workbooks uses the string "06/7" as a heading which indicates the 2006/2007 financial year for our organisation. I am trying to use this in some vba code. I have defined a string constant sDateShort = "06/7" which I use to enter this heading in appropriate cells. The problem is...
0 answers | 780 bytes |
New Cracked Software(cad,cae,cam,eda,pcb,gis,cfd,cnc...)
Hi!If you are professional ARHITECT, ENGINEER, DESIGNER, PROGRAMMER or User, andyou can't buy expensive professional software - we will solve thisproblem.Our prices are very low.You pay only about 1%-15% of the price for the original software. Our prices very from $20 to $150 per program.For...
0 answers | 12394 bytes |
need help with changing the colour of cells by clicking on a command button
hi, i'm making a project in excel and need help. I have a highlighted grid of cells which represent seats in a cinema. another cell on the worksheet is used to sell a seat. so for example: if in cell b5,is written c5(in the grid) then a command button is clicked the colour of c5 should chang...
0 answers | 437 bytes |
name box appearance anomaly
I am using excel 2002. The name box on the formula bar is only about 1" wide. Immediately to the right of this white space is a grey section about 5/8 inches wide. Then the small drop down arrow is next.The drop down arrow doesn't work. To make the dropdown list of names appear I click the g...
0 answers | 492 bytes |
Multiple fonts in one cell
I have two cells:Cell A1Entry Bridge &Result Bridge (arrow)Cell B1Entry =A1Result Bridge &I used two fonts in A1, Arial for 'Bridge' and Wingdings to show an arrow.Does anyone know of a way to show B1 exactly like A1? It is returning the A1 value, only changing everything to the Arial fo...
5 answers | 371 bytes |
Julian Date format
Here is the issue. I am trying to draw up a formula to turn an entered date format of 050615 (yymmdd) into the 3-digit julian date code (166). I am trying to create a calculator for days based on the entered date format as shown above. Any help would be great.Mike...
0 answers | 272 bytes |
Insert into a Blanck cell
Hello All,I am trying to insert this line "newRow = Cells(Rows.count, 1).End(xlUp).Row + 1" (down below) so that when the data comes in it will go into the completed tab new row, but no luckDoes anyone have any ideas?Dim newRow As LongFor Each thing In Array("x1", "x2", "x3")Nextx = Cells(Rows.c...
0 answers | 701 bytes |
IF Statements
I am summing columns ex. =sum(a5,c5,e5,g5) from which I will get a total. What I want to do is IF that total is less than or equal to zero I want that cell to display the number zero, IF it is greater than zero I want the total to be displayed.Ex. Cell total = 35 the number displayed is 35 Cell...
0 answers | 423 bytes |
- Home - About Us - Contact - Privacy Statement - Link Exchange - Bookmark - Map.XML - Rss.Xml
- Copyright 2001-2009 by DEVELOPERMARK.COM Information Technology Co.,Ltd All rights reserved
- 0.75