The Excel-2007 tag is used for referencing the Excel Version 2007 spreadsheet application from Microsoft.
I am trying to import data from Excel 2007 (.xlsx) files into SQL Server 2008 using a T-SQL OpenRowset() command with the "…
tsql excel-2007 oledb openrowset isamHopefully this is an easy one. I have a series of charts in MS Excel that point to data on …
excel excel-2007 vbaI have an Excel (2007) spreadsheet with 433 rows (plus the header row at the top). I need to split this up …
excel excel-2007I have recently started writing some Macro's in Excel. I have a protected worksheet, and a few buttons that allow …
vba excel excel-2007How do I tell if an Excel 2007 spreadsheet is open and WHO has it open using VBScript? I am trying …
excel vbscript excel-2007I am not able to wrap the text of x-axis labels on Excel 2007 charts. As a result, the axis labels …
excel-2007Is there a way to see if an Excel Workbook, say DataSheet.xls, is open (in use) or not? I …
c# visual-studio-2005 excel-2007In VBA, how do I get a list of all the files with a specific extension in a specific directory? …
vba search filesystems excel-2007 file-extensionConsider the following Excel sheet: A B C 1 ASX:ANZ ANZ:ASX http://www.site.com/page?id=ANZ:ASX 2 …
excel excel-2007 excel-formulaI have a column DeviceName in Sheet1 and it contains data like RTRNY653, SWNY653, ... In Sheet2 I have a column …
excel excel-2007 vlookup