I have a user in my office who is constantly working within excel. Recently she has been having an issue that she will open a file that she has been working on and all of the formatting (wheth...
I have a Excel 2007 worksheet that makes a connection to a OLAP Cube on a server.
When I change a cube member, i.e., a parameter, the cube values update themselves automatically (this is wh...
My manager that left a month ago, and has a file on his laptop that I'm using, it is a password protected Excel file of security issues that I would like to look at. He has no knowledge of wha...
I have forgotten the passwords to my excel spreadsheets. I have managed to get through the worksheet and workbook lock. Now I am just unable to view my macro code.
Would anyone know a way I...
I created an excel userform. I need help writing code to spell check the textboxes in the userform. Is there any way of doing this?
I attended an excel class a while ago, and one of the neatest tricks shown was this:( and now for the LIFE OF ME! I can not remember how to do it!)
If you have a long list (in a column) and y...
I have an excel spreadsheet with addresses but the address numbers start with 0s and I need to get rid of them but not all the 0s. for instance, 021035 should only be 21035 or 000123 should on...
I'm trying to remove the value 0 from a cell value. For example, I have several numbers that come up as 0-75, 0-209, or 0-02. I have written a formula to convert them into 75,209, and 02. H...
Issue:
I am hiding worksheets to ensure that users activate macros before viewing worksheets in workbook. Have used the code below, but it limits my ability to save the workbook as macro ena...
I have a workbook that has both a userform and a module. There is a particular string that is defined as the text submitted into a certain text box in the userform. I would like to use this sa...
Hi, I am trying to make some forms with excel vba. I have three text boxes. Is there a way i can check to see which of the other two was most recently changed? I need to be able to differen...
As you can see from the attached I am some of the way towards my solution. I am trying to get the sheet to look at the Start and End date and then tell me the interest due each month and also ...
Embed SQL with & parameters
Every time I save one document on Excel 2007 its crash in a Fatal Error. I'm using Windows Vista.
I would like to create a drop down box that allows me to select a beginning month and year in the text format "Jan-04" (for example) and have excel fill in rows to some selected ending month "...
Hi Experts,
How do i determine the folder path of a file programmatically?
Thanks
HI.
I have a Excel worksheet with about 30 microsoft word files which are embedded. Is there a way i can print all the embedded files instead of double clicking each one and hitting print....
Hey All, i was wondering if there is a macro that can compare 2 excel worksheets and extracts all new information on another work sheet. The report that i run gets updated daily I have to find...
we are having an issue where on opening a spreadsheet with a date formual such edate() or enmonth() the formula is lost and replaced by N/A. this is on windows XP sp3 and the excel is been SP ...
Hi!
I have a workbook in Excel 2007 that I saved to 2003 (xls) so that my coworkers can use it.
The Array dosen't work anymore. Here's the formula in office 2007 if someone know the answe...
Installed office 2003 on xp fresh install of OS and office but for some reason in excel and word when you go to save a document and in the SAVE IN column when you try to drop down to find a pa...
I have data in a cell that will have this kind of data (below). I need a formula to extract the four digit number after the letter "A" and before the letters "RMK", which would be 2986.
PABI...
Hi,
I'm trying to create an IF statement using 5 number ranges and 5 possible results. The number ranges and possible results are as follows: 0-12 = Unacceptable, 13 to 24 = Poor, 25 to 40 = ...
After windows auto-updated a couple of weeks ago it has begun opening each file in a separate process whereas before it used a single parent window. I'd uninstall whatever update screwed it u...
Ok,
I know this question has been asked before, but not to sure how to adapt it.
But I have cells in Columns E and F and they are Validated by a list.
It would be nice if as your typ...
