Top "Excel-2007" questions

The Excel-2007 tag is used for referencing the Excel Version 2007 spreadsheet application from Microsoft.

Append same text to every cell in a column in Excel

How can I append text to every cell in a column in Excel? I need to add a comma (",") to …

excel excel-2007
How do I convert a column of text URLs into active hyperlinks in Excel?

I have a column in excel, wherein I have all the website url values. My question is I want to …

excel-2007 hyperlink
How to do a "Save As" in vba code, saving my current Excel workbook with datestamp?

I have an Excel Workbook that on form button click I want to save a copy of the workbook with …

excel excel-2007 archive save vba
Excel "External table is not in the expected format."

I'm trying to read an Excel (xlsx) file using the code shown below. I get an "External table is not …

c# excel-2007 xlsx import-from-excel
Closing Excel Application using VBA

I have used the following without success. The active workbook closes, indeed, but the excel window remains open. Application.ActiveWindow.…

excel vba excel-2007
Excel Date Conversion from yyyymmdd to mm/dd/yyyy

I have been searching for about an hour on how to do this in Excel. I have an Excel file …

excel excel-2007 vba
Excel formula to reference 'CELL TO THE LEFT'

I'm trying to do conditional formatting so that the cell color will change if the value is different from the …

excel excel-2007 excel-formula
Delete entire row if cell contains the string X

I am new to VBA and I am trying to come up with a way to delete all rows (and …

excel vba excel-2010 excel-2007
Excel how to find values in 1 column exist in the range of values in another

I have two columns- column A which extends upto 11027(values) and column I which extends to 42000(values).Both the columns …

excel excel-2007 excel-formula excel-2010 vba
Writing a string to a cell in excel

I am trying to write a value to the "A1" cell, but am getting the following error: Application-defined or object-defined …

vba excel excel-2007