We use office 2000 and 2003. I would like to know how to have excel open in a new window. Right now I open by clicking on an icon. If I open another excel file it opens in the same window. I w...
Hi, I need to know how many working days have gone through specific dates but do not include Saturday or Sunday, for example for July 2005:
A1 Beginning Date
A2 Todays Date
Answer for...
Hi
I am trying to count the distinct occurances of a variable (in this case a date) from a colum in excel.
I have a data string in column A consisting of dates (1st - 31st May) but they ...
Hi all,
Heres another simple one for you guys .........:-) I hope
In 3 different columns I have both numbers and text that is preceded by spaces (ASCII character 160) I have used the SUB...
Is mediabar 2.0 a bug / virus ?
Hi experts,
I have some data from sqlserver imported into an excel spreadsheet. I have also plotted a graph on the same sheet.
How do i write a macro to auto refresh excel one very minute...
I need to do a vlookup like function from within an Excel VBA procedure.
I am building the value to lookup from within the procedure, after that I simply want to do lookup on range, using t...
I've always had both the anlaysis toolpaks referenced as an add-in and currently have ATPVBAEN.XLA in the same location it's always in. I just opened my workbook and it's asking to link to ATP...
What are the ways to remove leading and trailing whitespace in cells?
I have an Excel spreadsheet where a user can select one or more of the cells in a column.
I don't know in advance how many cells in the column will have data, but I know that the cells will...
I am having trouble with an Excel Macro. I need to save the current file with the same name in it's current directory. I also need to save the file as *.xml with the same name in a second dire...
Hi:
I have been reading the forums here and have not been able to figure out how to convert and XLS file to CSV format.
The file is located in:
C:\Automated CFP Reporting\mail
The fi...
Last week Charlotte found that she was no longer able to save a shared Excel spreadsheet which was about 6MB in size. It just said "Document not saved". Sometimes it says that the disk is fu...
I need to create a Bar graph based on various Confiedence interval values.....in excel.... and I aint got a clue....
Hi,
When calculating the percentage difference YoY between 2 numbers, i.e.
2009 (cell A1) is 207, 2008 (cell B1) is 394, I use the forumula A1/B1-1 to get -47%. However, this falls d...
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...
I have an Excel file with several sheets. I accidently deleted a sheet that I need. I know that deleted files can be recovered from the recycle bin when needed but is there anyway to recover...
Hello Excel VBA Gurus,
I have 10 different stock symbols from cell A1 to cell A10. Cells B1 = Frequency (monthly, Daily) B2 = Start date, B3 = End date.
So here is what the macro is su...
I have some data points that match a sinusoidal function. I need to find a way of matching a generalised sine function of the form
f(x) = A * sin (W * (x - P)) + C
The source data is ...
Hi
Cell A1 has text " **1.0 " I want to use this regular expression \*\*\d.\d to remove the **1.0 is there a function that will allow me to do that.
Something like =removematch(A1,\*\*...
I am having a problem with x-axis labels on bar charts in Excel 2007. When the numbers I am charting are small (maximum integer being charted is 2, 1, or 0) the x-axis values repeat. For exa...
Hi Experts - I have an Excel file using the Special Formatting code for ZIP Codes that allows for leading zero's in this field. However, when it is saved as a csv file (necessary for import t...
I need to save as a .csv but have the delimiter be a ; instead of the default comma. How do I do this?
Hi folks
say we have at least two sheets in a book, one called costs, and one called quote.
i am in say costs!a5
i want to see if in sheet quote in column x is there a value equal to row()...
I am writing an Excel macro to save a file as *.xml. I need to keep the SaveAs path relative because my clients may store these files anywhere on a shared drive or web server. I am not sure of...
