Am I hallucinating or did they remove any or all options in 2007 in regards to CSV files? I'm trying to export a worksheet to csv with the normal settings, but I need each field to be enclose...
This should be very simple, however I can't seem to figure out how to do it!
Can someone tell me how to calculate the S matrix in the following:
http://www.itl.nist.gov/div898/handbook/pm...
In Excel VBA, I want to allow users a Browse button to go to a folder where a destination report will be sent. Sometimes this will be an empty folder. When using the following browse:
varF...
Ok guys, I've come to you with another annoying (for me anyway!) Excel VBA combo box problem. First of all, this is just something I am doing for fun, I have no professional programming exper...
Hi experts,
I'm trying to export data from a Excel sheet to a CSV format. I'm using the "save as type CSV" menu option. The output I'm getting is delimited fields by semicolon (";"), instea...
I have an excel file that needs to enter data into a web page. Click a button, wait for it to load the results and copy the results into excel.
Below is the source code for the site, and m...
I'm new to this forum and this is my 1st time to use VBA....
I've looked thru the forum and I found that the someone has answered similar question before but it only has the code posted . So ...
We have a couple workstations that seem to have different workbook defaults than others. How can I reset these machines so that when a new workbook is created, it is using the original defaul...
What is the syntax to sum a range?
For example
Sum Worksheets("test").Range("A1:D1")
Hi,
I'm trying to create a dynamic drop down list in excel.
I have a column of data and I want to make a drop down list from source criteria listed on a separate sheet.
How do I do this...
A user in our office is analyzing a large set of data with MS Excel. When graphing the data, the user applies a 6th order polynomial trendline. The trendline has this equation:
y = -1E-12...
I asked the same question earlier, but perhaps this question belongs in this section.
I am writing a small piece of VB code for Excel to prompt the user to open the file he needs to work w...
Excel 2003.
What I am trying to do is this. I have a spreadsheet with a header row. I know how to freeze the panes so that when I scroll down, my header row stays showing. What I need to...
Hi,
If I have two numbers (in dollars):
2005 Spend 2004 Spend
5000 2500
and I want to find what the percentage increase from 2004 to 2005 was, how do I ...
Hi!
I installed Office 2003 SP3 on many PCs of my company.
When I launch Excel, the error "System Error &H80004005 (-2147467259). Unspecified Error" appears.
To close the error form I need ...
I am not able to convert a number greater than 24 into h:m:s
I use the formula =(H5/24;"hh:mm:ss") but this only works up to 24.
When I try this with 27.50, the result is 03:30:00 because ...
I need to save as a .csv but have the delimiter be a ; instead of the default comma. How do I do this?
I have column1 with a list of values
I need column2 to give me the following:
if column1 between 0-30, then column2=1
if column1 between 30-60, then column2=2
if column1 between 60-90, ...
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...
I need to calculate the standard deviation for 11 data points (see below). I'm familiar with Excel's formula:
=StDev(cellrange).
Based on data, I'm not sure which column (B or C) I sho...
I have an Excel document that gives the following errors message on any computer (Office 2002/2003):
"not enough system resources to display completely"
This is a very large document and I...
Using VBA, how do I find a value in a worksheet? I want to find an integer in a row, and then return the value of the cell below it.
Thanks!
MV
MS Excel Workbook. Using a Command Button, I want to hide columns and rows based on a cell value. For example, Columns A thru D have these values: A1=1, B2=1, C1=0, D1=1; Rows 1 thru 4: R...
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 need to copy the cell value from one file cell and paste that value to another file cell. I cannot copy the entire sheet or do a range. The source file has no consistant pattern. However,...
