I found code online for something I wanted to do. As usual, I fired it up in Visual Studio and it works no problem. The problem occurs in that, when I try to port it over to Excel, it ceases to work. As I understand, VBA is a watered down version of VB. (Based on reading this article: http://stackoverflow.com/questions/993300/differenc...
How can I access a XML Excel format file with an OLE Connection? Can it be done? I have accessed the normal Excel Format 2003 xlsx file but when I generate the Excel XML format I can't access with OLE. Thanks in advance for any help. I can open the file manually in Excel but I'm unable to connect to it through the OleDb Connection. ...
I'm not particularly knowledgeable about spreadsheet wrangling, so I could use some assitance with a seemingly simple problem. I have a column of year values which I am sorting by. I'd like to find the quantity per year ( read: number of repeats of each year value ). I'd like to chart said values. I'm not sure how to make this happen. I...
I would like a table of the following form: Point A Point B Mileage Los Angeles Miami 292100 Palo Alto San Francisco 90 I was hoping to use Google Maps or some other geo api to generate mileage based on input cities dynamically. Any ideas on how to do this? UPDATE It looks like I could use ...
It's pretty straight forward. If a certain cell, such as A1, is the value "0", I would like A2 to contain an arbitrary value. Otherwise, I would like the user to be able to enter their own value. The first part is easy: A2=IF(A1 = "0", "value", "") However, if A2 is empty, and the user goes to edit the value, Excel presents the formula...
I want to use JavaScript to access the Google Maps API from Excel. What is the best way to do this? (Users will enter input data into Excel, and my JavaScript will query Google Maps for the corresponding values.) I am not concerned about the JavaScript itself, just how to get the script's output into Excel. What if I hosted the JS on ...
I have some conditional formatting styles. I don't want to keep creating new rules for new ranges; I would rather follow DRY by declaring it once and referencing it elsewhere. I'm having difficulty doing this. The conditional formatting rule works fine when it's just one range. =Travel!$C$5:$P$8 However, I then try to add another ran...
How do I import data in Excel from a CSV file using C#? Actually, what I want to achieve is similar to what we do in Excel, you go to the Data tab and then select From Text option and then use the Text to columns option and select CSV and it does the magic, and all that stuff. I want to automate it. If you could head me in the right di...
Hi all, I have written an ASP.NET web page with C# behind that runs an existing vb script. The idea is that the user uploads an Excel spreadsheet (.xls) using the web page, the C# does a few basic checks on the file (file type, file name etc) then saves the .xls to a network location. The C# then passes the network path of the .xls to...
i am using this to in a macro to find stuff in my sheet: Selection.Find(What:=email, After:=ActiveCell, LookIn:=xlFormulas, LookAt _ :=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _ False, SearchFormat:=False).Activate how can i tell whether or not it found something? ...
Hello everyone, I am using ooxml format for generating excel based sheets from xml data using xslt 2.0. The issues I am running into is . I have a multiple worksheets in xsl:template match as below: xsl:template match="Detail" Worksheet ss:Name="D" .... /Worksheet Worksheet ss:Name="A" ... /Worksheet Worksheet ss:Name="C" ... /W...
I would like to hide the current page that the user is looking at when they click a hyperlink within excel that takes them to a different worksheet within the same workbook. I tried using the following code Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink) On Error GoTo Cleanup ActiveSheet.Visible = False Applicati...
As I have known AJAX in the past, it has gone something like this: a server side language (in my case PHP) file generates xHTML has JS attached. The JS queries another file, with parameters set in GET or POST. This queried file's entire output is returned to the JS, which in turn makes a change on the original xHTML. Now, I'm trying to ...
The description I am writing a couple of Excel UDFs in COM Servers. I'd like to get the standard help (Insert Function dialog) that you get when you press fx. Yes, I can see my COM Server listed in among the Category drop down, but I also see Equals, GetHashCode, GetType, and ToString (which are fairly undesirable to expose to the Exc...
In my app, I'm downloading a spreadsheet from FTP, moving the data read from the spreadsheet to a DataTable, and, depending on certain conditions, emailing a new spreadsheet (one that contains certain rows from the 1st spreadsheet). My problem is creating the spreadsheet that will be mailed. I can't seem to work out how to add the row f...
How to convert Excel file to xml file using .NET framework 3.5 Please tell the approaches The format of excel sheet is xls and convert to standard xml format ...
The title is enough i think. I used to code VBA 2 years ago and I suppose I have forgotten lot of stuff. How Do I access the SelectedIndex of a activex combobox object in Excel? I need an integer :( ...
I'm looking through some VSTO excel code and there seems to be a major wheel reinvention swtich statement in an event handler which is attached to every control (text boxes, combos etc), calling Focus() depending on the Tag property (being used in place of a tabIndex property) Is tab order alien to VSTO? ...
Hai I have an application in which I have a JTable with line breaks(pressing Enter key while editing) included in each and every cell.The problem is when I copy the contents from my JTable to Excel I am not getting the contents in same format as in my Jtable(with line breaks) to my excel that is with line breaks.Is there any way to solve...
I have an OLAP pivot table in Excel and I'd like to get the list of measure groups (in the Pivot Table Field List, these are the things with the large summation symbol next to them). I'm using VSTO and Excel 2007 for this. I would have thought they'd be listed under PivotTable.CubeFields. This list does contain the actual measures, ...