excel-2007 Questions
25
Solved
I'm trying to read an Excel (xlsx) file using the code shown below. I get an "External table is not in the expected format." error unless I have the file already open in Excel. In other words, I ha...
Sennit asked 16/7, 2009 at 18:23
9
Solved
Is there a vba equivalent to excel's mod function?
Sappington asked 7/12, 2010 at 14:59
6
Solved
I have Column A:
+--+--------+
| | A |
+--+--------+
| 1|123456 |
|--+--------+
| 2|Order_No|
|--+--------+
| 3| 7 |
+--+--------+
Now if I enter:
=Match(7,A1:A5,0)
into a cell on the sheet I...
Passive asked 20/3, 2013 at 14:45
4
Solved
I'm trying to send an email automatically through Excel, but the new line commands aren't working! I've tried <br/>, vbCrLf and vbNewLine
.HTMLbody = "Hello" & vbNewLine & "Please fi...
Striction asked 19/9, 2014 at 10:23
5
Solved
I need two dynamic drop down lists for data validation. One containing a unique list of continents to choose from, and then the second list which is a dynamically generated subset of countries base...
Patois asked 31/12, 2013 at 1:5
1
I have an excel XLS developed with Visual Studio Tools For Office (VSTO) 2005. Most of the code is in C# VSTO, but there is also a VBA macro to implement a worksheet function. I'm not trying to hav...
Forfar asked 19/5, 2011 at 16:17
8
Solved
I have an Excel Workbook that on form button click I want to save a copy of the workbook with the filename being the current date.
I keep trying the the following
ActiveWorkbook.SaveAs ("\\filePat...
Brownout asked 18/6, 2013 at 16:12
5
Solved
In an Excel 2007 spreadsheet I want to find-replace with highlighting part of the text in a cell. Using find-replace reformats the entire cell though.
For example, if the cell contains:
Pellen...
Awlwort asked 6/6, 2013 at 14:6
7
Solved
When I set format of a cell as %, it automatically multiply the value with 100 & show the value. So 5.66 becomes 566 %.
I want to apply % format on a column but want to keep the values same as...
Lifework asked 29/5, 2013 at 6:23
8
Solved
Is there a way to see if an Excel Workbook, say DataSheet.xls, is open (in use) or not? I would like to close that Workbook if it is opened.
Deepsea asked 1/7, 2010 at 9:52
8
Solved
Is there a Python module that writes Excel 2007+ files?
I'm interested in writing a file longer than 65535 lines and only Excel 2007+ supports it.
Bertilla asked 23/11, 2010 at 15:36
7
I'm trying to find the last row in column A that contains a value with the following code:
LastRow = DataWorksheet.Range("A:A").Find(What:="*", SearchOrder:=xlRows, SearchDirection:=xlPrevious, Lo...
Justinejustinian asked 7/1, 2013 at 16:52
3
Solved
I have an Excel (2007) spreadsheet with 433 rows (plus the header row at the top). I need to split this up into 43 individual spreadsheet files with 10 rows each and one with the remaining 3 rows.
...
Higherup asked 1/8, 2013 at 15:10
3
Solved
I would like to work with internal .xlsx files (styles.xml). I was using <oXygen/> to navigate through internal structure, but now it is throwing an error.
How to unpack xlsx files (and then...
Arbitrary asked 3/9, 2009 at 18:20
3
Solved
I have two columns- column A which extends upto 11027(values) and column I which extends to 42000(values).Both the columns contains some code details.
Something like this
A B
q123 as124
as124 gh4...
Truesdale asked 28/8, 2013 at 13:19
8
Solved
I am looking for a way to add a custom tab in the Excel ribbon which would carry a few buttons. I chanced on some resources addressing it via Google but all look dodgy and outrageously complicated....
Norahnorbert asked 13/1, 2012 at 12:49
7
Solved
I'm trying to download Excel files (xlsx) using PHPExcel as follows.
require_once("../../phpExcel/Classes/PHPExcel.php");
require_once("../../phpExcel/Classes/PHPExcel/IOFactory.php");
$objPHPExc...
Justiceship asked 29/5, 2012 at 20:58
2
Solved
I can set the background color of a cell or range of cells like so:
rowRngprogramParamsRange.Style.Fill.PatternType = ExcelFillStyle.Solid;
rowRngprogramParamsRange.Style.Fill.BackgroundColor.SetC...
Rosetta asked 11/8, 2016 at 22:39
2
Solved
I'm running SQL Server 2012 on a 64bit Windows Server 2012 R2.
I don't have MS Office installed.
I now notice that when I start Start->Program Files->Microsoft SQL Server 2012->Import and Export Da...
Projector asked 20/5, 2015 at 20:10
6
Solved
In Excel, I want to check if a specific cell for instance "C12" has a picture?
How could I do this?
Dove asked 23/2, 2010 at 18:49
4
Solved
I have an excel 2007 file (OpenXML format) with a connection to an xml file. This connection generates an excel table and pivot charts.
I am trying to find a way with OpenXML SDK v2 to do the same...
Mudskipper asked 11/10, 2010 at 5:25
9
Hopefully this is an easy one. I have a series of charts in MS Excel that point to data on the same worksheet. The data on the worksheet is calculated using a VBA function. When the data is updated...
Jurado asked 16/12, 2010 at 22:50
34
Solved
Occasionally, I'll happen across a spreadsheet which suffers from magic buttons or listboxes which get bigger or smaller over time.
Nothing in the code is instructing this.
Has anybody else...
Abercrombie asked 15/10, 2009 at 16:3
3
I'm optimizing a macro in VBA which had none of the data types declared, so everything was clumsily treated by the compiler as a variant. I'm dealing with scientific measurements, so I need precisi...
Embry asked 18/6, 2015 at 13:57
7
Solved
I am trying to come up with a way to delete all rows (and shift cells up, if possible) where the website column cell contains the word none. The table contains 5000+ records and this would save me ...
Bashuk asked 12/7, 2013 at 1:10
© 2022 - 2025 — McMap. All rights reserved.