Are there any good books for learning MS Excel Visual Basic Macros ? Specifically covering the macro part for excel ? I know VB but i get confused when it comes to coding macros in excel.:confused:
hi
i have prepared a invoice template in excel for my business. now i wanted to know how to make a database so that everytime i use this template the data entered in excel is stored and so can be used to get different information such as history of invoices created material sold the total...
Hi,
Im trying to get excel to highlight a date 1 day before it arrives, i
have dates in a column ( Eg : Column I, from row 2 ), am preparing a follow up sheet in excel where i have to keep track of the customers to visit on coming days, thats the purpose of this formula, i will be greatful...
how do u make an excel file appear to be corrupt? so if someone asks me why I didn't finish my wrk, I can say that the file I wrked on has become corrupt.
Hi all
I am stuck with a problem in EXCEL.
By mistake I pressed 'Save' instead of 'Save As' for a file and I need the prior to Save file. How do I recover it ? Please help !!
Thanks
hi,
did anyone encounter with the situation where excel file are not being opened in IE7?? i have many excel files in google docs which i can open in opera but the same file in my win xp sp2 dosnt open up, actually the whole screen is just blank. in the left bottom, it displays done with...
Hello Experts,
I have 2 doubts in excel sheet.
1) i want to count no of colors i.e. how many rows/columns with blue color or red or white color.
2) i want to highlight particular column with some color if that value is set true/false
pls help me out with this
thanks in advance
Krunal Mehta
I want to put a password for my excel sheet,so that expect me nobody cant access it.please tell me how to protect my excel sheet.pls explain in detail(proper procedure):)
I tried to install MS Office 2003 SP 3 from this month's Digit DVD but the installation was not successful as it could not find some CAB files on my computer.
The problem is that now whenever i try to open excel from the start menu the installtion process starts again. But when i try to open...
Hi Guys!
I have a small problem with Excel. If I type a huge number in any cell, say "777777777777777", it automatically gets converted to "7.77778E+14". I dont want this to happen and want it to be displayed normally. How can I stop this from happening.
Chao...
Hi All,
I have a .XLS file (Microsoft Excel 2003) which has been password protected...
How can i remove the password from the file?
Please help me out as this is extremely urgent!!!
Thanx
I was thinking about good out of the box experience in Windows today, & thought why can't MS bundle a simple word or excel or powerpoint viewer in Windows Vista. Well, it seems they can't due to license restrictions.
However, MS does provides something for those who don't want to buy the whole...
This is what i need to do.some info come in excel
format.it is personal data info.
A
card #:abc
Expenses:1.00
Expenses:2.00
expenses:3.00
B
Card# cde
Expenses:1.00
Expenses:2.00
expenses:3.00
Expenses:4.00
.....
Like this around 60 emplyees every month.expense details varies...
It is quite easy to subtract dates and times in Excel but it doesn't always show reality.
E.g Lets say that some1 is working on a project. He works every weekday from 10am-5pm. Lets say that the person starts working on 1st Jan and ends the project on 31 Jan. Now Excel will show the effort to...
Hi Guest we just wanted to alert you to a major change in the forum. We will no longer be allowing the posting of outgoing links. Please use the attachment feature to attach media to your posts.