I am looking for a way to print things directly to Excel. Our ERP system creates reports that we can print, but I need them in Excel. A program called Print2Excel (www.print2excel.com) works...
Attempt to save changes in Excel and recieve the following error.
"Microsoft Excel is waiting on another application to complete and OLE action."
Windows XP Pro (SP2), Office 2003; I'm usi...
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...
Greetings...
I'm using the formula
=IF(ISERROR(VLOOKUP(Sheet1!A2,Sheet4!B$2:B$123,1,FALSE)),"",VLOOKUP(Sheet1!A2,Sheet4!B$2:$B123,1,FALSE))
to compare columns in 2 separate worksheets...
Hi,
in one of my workbooks I have a function TABLE() . It is actually inside an array formula. But I cannot find this function in the help.
Anyone know what it is?
I have an Excel VBA macro which I am trying to get to run a batch file.
My code so far appears to open the dos window and immediately close it. The batch file does not appear to run.
As...
I would like to know how to embed an images (jpg) into cells in Excel 2000. Each row will need to have a different product image embeded. I don't want to do Insert>picture>from file, since usi...
I'm a newie in the Access world, so I need a little "push" to get me in the right direction. What I'm wanting to do is build an Excel spreadsheet that will ask the user a series of questions ...
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...
Hi all,
I am creating a spreadsheet (each row is one continous record, using A-AD columns) and basically I want to highlight multiple non-adjacent cells when any data is inputed in A1. This ...
I need a macro for opening a file (User can select file), copy a range of cell from Sheet"Template", paste it to the exisiting open workbook (workbook with the macro) which has a sheet called ...
HI,
I want to write a Macro in Excel
Like if in macro I write below code it selects the cells A1 till F1.
Thats fine.
I want to get the value written in column F10. How to get ...
Hello,
I would like to clear the value from some cells from my range but not the formulas.
This is what I am using:
Range("A2:U1000").ClearContents
However, this deletes the form...
I want to create a chart with one x axis but multiple y axis points.
E.G. i receive excel spreadsheets for processses that our software runs. i would like to chart these results to anal...
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 ...
I have a physics lab due tomorrow and I can't seem to find out how to draw a tangent line..
I managed to graph the thing no problem.
but I'm supposed to use excel to draw the tangent line f...
I have a SBS 2003 server network. One user is allowed to modify an excel file on the server with multiple users only having read access to the file. I have checked folder and file permission...
I am consistently getting a "Cannot empty clipboard" error in Excel 2007 after a drag and drop. Copy and paste does not produce the error. The same error ocurs using Excel 2007 on both my Vi...
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...
I have a sub (see below) that is receiving the following error. This sub was working fine 2 hours ago. Can anyone help?
Run-time error '438': Object doesn't support this property or method
...
I need help to modify my Excel formula. This is what I want my formula to do:
1. If F16 and E16 is empty, G16 = " "
2. If F16 > E16, G16 = "F16 is bigger"
3. If F16 < E16, G16 = "E16 is big...
Hi -
I have a report that gives me the date in this format:
12/7/2006 2:07:25 PM (dd,m,yyyy)
I need to covert it to mm,dd,yyyy and would also like to drop the time portion of the f...
What is the Excel version of Word's "normal.dot"?
In windows I want to export the names of folders and files to an Excel spreadsheet. What would be the steps?
Thanks,
Mike
Hi All,
I am writing a marco to convert an excel sheet to a pdf. I have looked at similar threads here and have nearly got it working however it is crashing on the last line with the error ...
