Team,
I have 6 SUB procedures and to run all the 6 SUB procedures is taking me a while to run. I need a progress bar which displays the name of the current module the file is running and ho...
How can I convert hh:mm:ss to decimal hours for applying labor rate? I'd need to go to four decimal places for accuracy. For instance, a typical labor entry from my database indicates start ti...
What are the ways to remove leading and trailing whitespace in cells?
I've a sheet with a date colimn. Being a lazy SOB, I've grown tired of entering the a date for every new row I add.
Is there a way to, whenever a cell in that date column gets focus, to po...
I am developing an excel timesheet for my organization. I have two units A and B
Unit A :
--------
Work Start Time : 9:30 AM
Work End Time : 7:00 PM
Tea Break Time 1 : 11:45 AM
...
I can't believe this is so hard. I think I've seen 100 answers on EE to this exact question and I still can't figure it out.
I have a SQL Server database with a table called Branches. I w...
Hi,
I have a excel workbook in which have more then 5 work sheet and that excell workbook is password protected and I just want to edit in that workbook.
Please some one tell me how can I d...
Hi all,
When I start Microsoft Excel XP i'm getting this error:
"Compilation error in hidden module: ThisWorkBook"
How can i fix it?
Hi,
I need a way to convert millatery time value between two cells.
I.e.
A B C
1730 2130 04:00
So user enters 1730 and 2130 in relevant cells, ...
For some reason, all excel documents on the computer will not open by clicking the saved document. However, if I open Excel first and select the OPEN document option and select the saved docu...
In Excel
I have the following formula in a cell...
=IF(C5="","",(D4+B5-C5))
The basic idea is if cell C in a row is empty, then cell D will be empty also, otherwise it will fill in the form...
Hi Experts
I am using a COUNTIF formula on a summary sheet, to look in another sheet and count the number of matches to a criteria.
What I was hoping for is rather than adding in the sheet...
Hi, I am working through Microsoft Knowledge Base Article 213772 "How to Use System, User, and File Data Sources"
It describes how to use an Excel VBA Macro to link up (via ODBC) to the MS ...
I have a button on a form that runs a query with a date on the form being used as criteria in the query. I also have an Excel Woorkbook containing a sheet that is linked to the query, and a p...
A customer of mine just sent me an Excel spreadsheet they have been using for a couple of years. They need to change some calculations in various cell formulas. Big problem: the worksheet is p...
I have a range of cells in and Excel 2007 workbook. I would like to use a drop-down list to select from the range but have the ability to edit the value once selected. For example, I may sel...
I am copying an Excel sheet to word in Excel 2003 sp1.
If I use
AppWord.Selection.PasteSpecial Placement:=wdInLine, DataType:=wdPasteMetafilePicture
then I get exactly the same resul...
I found on this excellent site a short macro to export an excel chart to an image file.
Could someone provide additional VBA code to have all charts of the workbook exported instead of only...
Hi
I have a locked spreadsheet and i want to be able run a macro from a button to do the following:
1. Unlock the sheet
2. Ask user for a populated cell which they want to attach a hype...
I have two users who yesterday were given laptop computers to replace their desktops. These laptops have the same configuration exactly as more than 10 other laptops that we are using. Both ...
I have a large text file that i use vba to format. I would like to be able to count all duplicates on the 2nd row and then delete both the 2nd and 1st rows leaving only the first occurence wit...
I have created a macro to password protect sheets based on a predefined password.
Is there a way of creating a macro to un-password protect all sheets based on people inputting the password...
Is there a code to center the text in a range of cells. I have a macro that after it is ran the cells are left justified, but the formatting tool bar states that it is centered.
I am using the End xldown command to activate a range. I first search for text in a cell, the header, and then offset down one row to get to the first cell in the range I want to activate. M...
I have a list of items in Excel of which I would like to randomize the sequence. I have tried using the RANDBETWEEN function, but get the #NAME error. I copied the function from the Excel hel...
