Top Solutions

I have been getting this error lately when working with Excel 2000.  Basically when you are trying to copy&paste I get an error that says "Cannot empty clipboard" and I can't figure out why this is happening.  If I reboot it usually fixes it, but...

I have an Excel file with UsedRange = A1:CH102. The saved size is 4151 kB. I have found a way to reduce the size:

Option Base 1

Sub ReduceSize()
  Dim lAntR As Long
  Dim iAntK As Integer
  Dim aR() As Single
  Dim aK() As Single
  Dim...

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 within the same workbook and it returns what I would...

I want to loop through each row of a spreadsheet and based on the value of cells in column b,  copy the contents of the  cells in columns a,b , d, h, j, and copy it to another workbook. I have it working where I can copy the entire row but that...

What would be the VBA code for a macro in Excel that clears the contents of all cells in a range that were populated by a formula that said return "". (=IF(I2=0,"",H2)))

I want to clear the contents so that these cells are not included in a...

Yesterday I thought I understood isblank, but I was wrong.

Today I am 100% sure I really really understand it which means I'm sure to be wrong again.

Will someone just check this out and see if there are any glaring errors?

When cutting...

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 is to higlight the required information that must be...

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 formulas as well. Any ideas?

I have several hundred documents that now show up with .SHS file extensions (scrap objects).  When I open them, they open with Excel and I can easily view them.  When I change the file extension to XLS, they fail to open.

I guess my question...

Hi,

I have an Excel sheet with a button that runs code. When I click the button I get the error "Compile error in hidden module: Module 1". Someone else here at work was able to run it on her computer fine, even when I logged onto her pc I...

I am trying to use C# to generate a spreadsheet that has a chart graphing a few non-contiguous rows of data.  I have almost everything working.  There are two things remaining that I cannot figure out how to do.  One is to set the background...

I need a function that will take an entire cell value in Excel and convert the value into its MD5 hash equivalent in a new cell. I have seen several comments about using VBA or other software. However, I am not real familiar with VBA. I would...

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 pretty good, but it conflicts with our Unified...

Hi,

I've got aproblem at the moment where a machine on the network returns the following error
Visual Basic
System Error: &H80040111

Then returns an "out of memory" error
This happenes when macros are loaded in various excell forms we...

How do I successfully get (download) a SharePoint list via Visual Basic?  I know that you can link with MSExcel if you know the GUID , I also know you can link with MSAccess - again if you know the GUID.

I know the GUID, and I am attempting...

In Excel 2007, how do I program my Command Buttons?
I need to be able to assign a macro to a command button in Excel.  In Excel 2003, I used to go to View
--> Toolbars --> Control Toolbox.  Then what I would most often use would be "Command...

Excel Files Show 'Locked For Editing' when hosted on SharePoint, accessed via a mapped network drive, and a crash happens. (Temp files?)

The issue is: We use SharePoint to hold 'all data', yet some users prefer mapped drive access.  'Net Use'...

Anyone know where the default template location for Excel 2010 is (why is it so difficult to find!)
I have created a custom template and want it to appear in the users template list

I would like to compute the cube root of a particular number or the 5th root of a particular number.

Is there a function that does this?  A formula perhaps?  All I can find is squareroot.

Hello Experts,

Something weird just started happening: up until last week I was able to open files created with MS Excel 2007, but for some reason xlsx files cannot be opened with Excel 2003 now.

When I double-click on the xlsx file, Excel...

Here is the scenario,

User1 has an excel file open on the network. User2 tries to open that same file but it says locked by User3.

Why is it saying the wrong user has the file open? I thought it was DNS, but it displays the username, not...

I want to add hours and minutes in excel.
However when going over 24, the spreadsheet doesn't know what to do.

Example:
13:30 + 2:45 +  11:15

I tried changing the formatting to Time > 37:30:55 and it gave me 339:30:00
The cells that...

Hi,

I run monthly reporting. SPs generate the reports into tables in SQL 2000 server.
I have a linked workbook that contains links to the report table in SQL.

Everymonth a SSIS package runs the SPs to generate the reports in SQL server....

When I open an Excel spreadsheet I get the message "C:\Documents.xlsx could not be found" I have to click Ok. I then get "and.xls" could not be found and then ""settings.xls" could not be found.

Obviously  it is trying to open a file called...

This is horrible if it's by design, so please let me know if there is a fix or if this is also what others are experiencing:

An Excel 2007 xlsx file is created.  An Excel 2003 user, with the 2007 compatibility pack installed, can open the file...

I have embedded a non-Microsoft OLE object into my Excel worksheet.  When I click on the embedded object the text that appears in the formula window is:

=EMBED("TeeChart.TChart.8","")

I've looked everywhere in the Microsoft Excel help and...

I am receiving several errors when any add-in is loaded in Excel 2007...

The errors are as follows:

"System Error &H80004005 (-2147467259). Unspecified error."

"Out of memory"

"Compile error in hidden module: GlobalMacro"

"Compile...

Hi I am able to get the co ordinates of teh Excel cell for Excel 2007 version but the same code is not working for Excel 2003.

Actually the "PointsToScreenPixelsX"method is not there for Active Pane in Excel 2003 which is i guess is giving a...

Hi I presently have a difficulty with importing csv files into excel using VBA. I have created a macro which is meant to read each record from a csv file and put it into excel. The code also needs to handle the splitting into different sheets...

Hi,

Part of when I code and I add collections, I generally notice that an error 457 comes up stating that if a collection exists, you can't add it. Okay, so fine... which is why I'll end up using an error handler technique to go around the...

Our lab uses Macs and PCs.  Excel gives correct r^2 values on the PC.  When someone puts the data into the template on the mac, it gives bad r^2 values (most obvious are negative r^2 - this shouldn't happen with our data).  If the same file is...

Hi,

How can I test in VBA if the excel-cel is empty?

Now I have
  if Cells(x,5).Value <> "" And Cells(x,5).Value <> "''" then ...


But this don't work. If the cell is empty he execute the then-statement and not the else?


Thanks,...

Hi,

I would like to know what should I do in order to save an Excel work sheet (Password Protected) to an Excel unprotected work sheet.

For example:

Excel file A is protected by password '1234'

User open this file A then SAVE AS...

Dear All,

I have sheet1 which has:
numbers that i would like to use as criteria

Sheet2 which has:
the actual numbers i want to get the some of

for example, in sheet1, if any cell = 77,
then, go to sheet2 and get the actual number 0.2...

I'm trying to automate a File download dialog from a web site, using IE automation on VBA.

So far I've succeeded in getting the handle on the dialog window and the control (save button). But i can't click on it, although I've tried (as you can...

Sharepoint 2010 Enterprise with Excel Services
Excel 2010 x64, Excel 2007

The document library hosts a simple excel file for testing.
The Excel filedoesn't open in the web browser.
Error is:
The workbook cannot be opened because it...

I would like to create a pop-up calendar in certain cells of my worksheet in Excel 2010, to simplify the entry of dates. Please give me easy-to-follow step-by-step instructions. Thanks.

I have a program which automates a webbrowser application within a userform. There were a couple of reasons why this was initialy done like that.

The problem is the program is running the user can not do anything else... For example if you...

In inputbox input x and n
exponential function : e^x=1+ x/1! + x^2/2! +.....x^n/n!       ; n!=1*2*3...*n
inside the function we can use t(n)=x^n/n!  and for recurrence formula t(n)=t(n-1)*x/n
The partial sum to the n-th clause is expressed...

Now that I'm upgraded to 64-bit, I need to update some of my Declare statements.
However, I am also going to make sure this is backward compatible so those still on the 32-bit systems can run it.  I think I can handle that part with the #IF...

When the user attempts to copy text from Microsoft Excel and paste it back within Microsoft Excel or Microsoft Word, he receives the following error message.

Upon reviewing your system logs...the following error message was detected....
...

My client has a Windows Server 2003 R2 hosting a shared directory.  The share has an excel spreadsheet that everyone had "Write" access to through NTFS permissions.  The top level share has Share permissions set to Everyone Full Control.  ...

Hi all,
I used the code below to try to create a ADODB.RecordSet in Excel 2007 VBA.
The spreadsheet I'm pointing to has about 40,000 records and 20 columns.
Here's the glitch: The message box that displays Fields.Count accurately shows that...

There are a number of extensions our mail filters block for inbound emails;, .exe, .bat...One of those extensions by default (in the program we us:  Symantec Mail Security for SMTP) is a .bin file.  

On two occasions, someone has sent us a...

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 limited and only to 1 dp precision:

Delta T   ...

Hi Everyone-

I have gotten help on step 1 of the process below.  I need help with steps 2, 3, and 4 which are excel based.  Attached is the code I have been given so far.  I am stuck with getting the vba script in outlook to open the excel...

Hi guys

I have a XLA file that someone else created that i want to edit to chaneg some stuff.

How do i go about editing the XLA file?

Hello experts,
   Here is what i'm trying to do.  I have and excel 2007 sheet.  A1 and B1 have dates in them.  I need a function that will state if date is between 01/01/1990 and 09/30/2009 then C1 = 3, if date reange is between 10/01/2009 and...

Came across issue with EXCEL 2007 and EXCEL 2010 that have Adoe Reader X installed.  (Adobe Acrobat 8 Pro 8.2.5 also installed)

In EXCEL (2007 and 2010) when you:
1.) - -  INSERT -> OBJECT -> Create New; Display as icon; Adobe Acrobat...

I am using Reporting Services 2005 and SQL Server 2000.  I placed a reportviewer control on my ASP2.0 webpage to display a report.
 
When I tried to export my report to an Excel file, I get a lot of extra columns.  I cannot sort the result...

I would like to, from a vbscript file, open an Excel file, select a sheet, and insert a column. Easy enough, but not really :(.

Thanks.

I have Exchange 2007 and Office 2010. I would like our Global Address List in an Excel file.

I need to trim all characters following the "-" in the text in column A, including the space after the "-" if one is present.

For example:

12461 - Dixon      would return "Dixon"
2431 - Atkins       would return "Atkins"
etc...

I've...

When opening Microsoft excel 2007 i get error saying "unable to read file" and i hit ok, then i get another error saying "Excel cannot open the file '~$BOOK.xltx' because the file format or file format or file extension is not valid. Verify that...

We are slowly rolling out Office 2007 and have been experiencing problems with th eslow opening of spreadsheets in Excel 2007.  We did have the problem that when you double click a xls or xlsx file it could take upto 1min to open but that seems...

There is one user who accesses excel spreadsheets via a network share who often gets error message: "filename.xls is locked for editing by the username(its the user themselves) click to notify to open a read-only...." This happends when first...

How can I export Excel 2010 spredsheet to comma delimited file?
I can export it to semicolon separated CSV file only.

How do I get the last row in a column ?

the code snippet i've included doesnt seem to work (it get the lastrow for the whole sheet and not for a specified range/column.

I saw this somewhere -but i'm not able to port it to c#.

longRow =...

I have a file that uses Solver in xl2003 and xl2007 just fine.  Now when we try and use this file in xl2010 it is failing.  It is failing on line 52.  I know something has changed in Solver 2010 that VBA calls to it from older versions does not...

I have an excel spreadsheet with about 300 lines in it, each with a hostname on it.

I want excel to do an nslookup on each host and make a cell next to the hostname the IP address that is returned.

I believe this might be able to be done...

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 select from the list the phrase:

Pack XXX pieces per...

Hello.  I'm using Excel Professional Plus 2010 on Windows 7, SP1.  I have a worksheet with lots of conditional formatting to aid a team in keeping track of various maintenence tasks and projects.  I would like to know what formulas I can use at...

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 think this is due to the amount of formatting that is...

How do I insert a check box in Excel 2007?

Hi eberybody,

my webserver provides a dynamically generated csv-file using codepage Latin2 (ISO8859-2) or using unicode-characters.

When opening the file with excel (doubleclick on csv-file) evidently a standard-codepage will be used and...

Hi guys, I need to find out if there is a way to batch convert M/S Works .xlr spreadsheets to excel .xls files.

I am able to change the file extension manually and this half works as some of the formulas do not show up correctly, and what i'm...

I learned how to replace the spaces in between text in Excel via this method:
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_23286685.html

However: what if I have both present & wanted to use the ...

I am trying to use an excel Add-In (Wonderware Active Factory 9.2) and it doesn't work.

When I start EXCEL I always get the following message:

Compile Error:

object library invalid or contains references to object definitions that could...

OK, I got a tough one for you guys..  I have a couple users that are not able to save Excel files, and only Excel files, to any network shared drive, when they try, they get a set of errors that say Disk is full and Unable to save file.  Now,...

Does INDIRECT.EXT work in 2010?  After downloading and running the setup.exe for Morefunc UDFs three times, the INDIRECT.EXT never appears amongst the Informational functions in the More Functions group of the formula bar.  Is it because Morefunc...

I have a spreadsheet with a macro that runs and protects each worksheet.  I need to unprotect a specific range in the sheet so that users can type in new numbers.  The Columns that need unprotecting are E - N.  The row starts on 15 and ends with...

I am trying to create an Excel macro that will open up an mpeg video in Windows Media Player. I have added the media player references in the visual basic editor. The following code plays in the background -- I am unable to see the Media Player...

How do you count characters in a string in a cell in Excel 2007

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 enclosed by quotes.  I see no options anywhere for this.  Am...

I have been searching the web for a clear way on how to export gridview data to excel 2007/2010.  All I can find is how to do it to .xls (excel 2003).  Does anyone have an example or know how to export into excel 2007 or excel 2010.  My code as...

Need to insert text into specific cells.  To insert into K5 and L5, I understand this code to be:
    Range("K5").Select
    ActiveCell.FormulaR1C1 = "Text1"
    Range("L5").Select
    ActiveCell.FormulaR1C1 = "Text2"

In my program, I need...

Good Day,

Since upgrading to Office 2007 recently (SP1 installed, SP2 being pushed out to end users soon, but I have tested the problem on an SP2 machine and it didn't make any difference), my accounting department has run into a problem with...

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 Vista desktop at work and my XP Pro notebook.  I was...

What does DIM stand for? what purpose does it carry out?

and what do the following types of DIM mean/do?
Boolean
Integer
long
single
double
string
object
variant

Hello all.  I need to know if there is a way to dynamically pass a parameter value to the command text box in the "Edit OLE DB Query" window of Excel 2003 (working with SQL Server 2005 data).  This would NOT be using the Microsoft Query window...

We just switched from shared drives on a WIndows 2003 server to a shiny new TeraStation III and a couple of user periodically get an error message from Office 2007 products (Word and Excel) saying "The network is busy. Try again later." If you...

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 it

Thanks

Sub Macro1()
'
' Macro1 Macro
'
...

I have a pivot spreadsheet that I need to convert to a flat spreadsheet.  In addition to the Location, #units, type units, the table has 92 columns.

Location      # OF UNITS      TYPE UNIT  ....
A
B
C
...

I'm trying to get the VBA code below to...

I want to open lotus 123 files in Excel 2007, later on I will want to be use Excel 2010, but for now Excel 2007.

I know that lotus 123 is NOT support in Excel 2007.

But I have hundreds of lotus 123 files going back some time.

I could...

Hi EE,

Is it possible to control the margins when printing a spreadsheet? I want my spreadsheet to print on as many pages tall, but only one page wide.

This is the code:

  Dim strPrintArea As String
  Dim bCenterH As Boolean
  Dim...

Dear Experts:

    In encountered an Excel file that have its rows folded together(see the attached picture, it can be folded/unfolded), and I want to find out how it comes up. Can you give me some hint/information/reference how I can do the...

Hi Guys,

I have a problem where opening excel 2003 documents of certain sizes on a 2003 teminal server can take quite some time. A small excel document can flash up straight away but a document that's 2 or 3 meg in size will hang the...

I keep getting the error below on a user. Every time I have excel open and then go to file... send to as a attachment. I have recreated profile, reinstalled outlook and entire office and made sure outlook is default mail cilient. I cannot find...

What is the Excel version of Word's "normal.dot"?

This is  an excel vba code to download stock quotes from yahoo to excel.  This is the input that is needed.
Sheet1 B2 =startdate
Sheet1 B3= End date
Sheet B4= frequency

And starting from B1 and going on C1 d1 E1 F1 you enter the stock...

Dear Experts,

In Excel 2010 I have a relatively smalll but problem with moving sheets between workbooks. I am not sure what determines exactly but sometimes getting such message:

"Excel cannot insert the sheets into the destination...

I am exporting an .xml out of our call accounting application. Prior to using Office 2007, everything was fine. In 2007 the way the duration is formatted is incorrect. I can view the data from a PC with Excel 2003 and it is good. I am not doing...

When i try to import a spreadsheet in Microsoft Access, it gives me the Error "Error in Loading DLL". The title of the window is "Import Spreadsheet Wizard". I am able to import something from another access DB, just not from spreadsheets or the...

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 formula. But I want it be empty if and only if both cell B...

Hi,
On Windows XP Professional and IIS v5.1, I am running a C#, ASP.NET 3.5 web application. It references Microsoft.Office.Interop.Excel (Microsoft Excel 12.0 Object Library). I am using Excel 2007.

When I launch Excel from ASP.NET: excel =...

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 default workbook settings?  I'd like to be able to do this...

Hi There!

In Excel 2010 how can I email a single sheet rather than an entire workbook without copying to a new workbook?

Thanks in advance.

I am using VB.NET in my web application and just need to open and exiting Excel file, copy content of the worksheet A, and paste it to a worksheet of another (new or existing file)

I found some code in an old answers in EE post Q_21474186...