Search results for query: *

Hi I've got 2 excel files which i want to compare and find out how many records with the same code (Sedol) exist in both of them. In other words it is an equivalent of creating an inner join on 2 tables. The problem is that my 2 tables(SHEETS :B5LEPF$,B5LIPF$) are in different workbooks. I...

Hi I am a newbie to XSL therefore my question may not be very challenging to you guys but i would appreciate your help. I have an XML file : ----------------------------------------------------------- <?xml-stylesheet href="XSLforGilts.XSL" type="text/xsl"?> <?xml version="1.0"?>...

Hi I have managed to achieve the objective which was to import records from xml file that would match my parameter (e.g. price >100)into excel spreadsheet, however i have a sneaky suspission that there is an easier (and faster) way of doing this than using loops. Ideally i would like to...

HI I am having a problem with 'selectSingleNode' method. It is not finding the node and i have no idea what am i doing wrong. It didn't work with my original code - i had a look on the net and found the below simple example from which i copied code and pasted xml content to my xml file but it...

HI I have a macro that suppose to select data from a named range in excel and transfer it to the newly created sheet in another spreadsheet using ADo recordset. It seems like there is a bug in this piece of code : sSql = "SELECT * INTO ['" & sExportToFile & "'].['" & sNewSheetName & "'] FROM...

Hi All I am just starting learning C# and trying to do a simple excercise : I have an Acess database from which I would like to extract all data from one table and write it to the XML file. This is my code : ---------------------------------------------------------- 1. Load a default file...

I have macro that runs a little check and extracts data which is then transferred to another excel file (Price check.xls). Before the transfer happens I wanted it to clear all the records from the previous run. Initially I tried "DELETE... WHERE.. Price_date<> date" syntax but it seems like it...

Does any one know how to achive the same thing as below With ActiveSheet.PageSetup .PrintArea = "$A$1:$b$80" .FitToPagesWide = 1 .FitToPagesTall = 1 .PrintTitleRows = "$1:$1" End With by using faster ExecuteExcel4Macro or Application.Dialog(xlDialogPageSetup)...

HI All, I am trying to create an error handler that would automatically inform administrator by e-mail about unexpected erorrs occured. I am using Err.Description and Err.Number methods, however they often don't provide exhaustive explanation of a problem. WHat i would like to do is to...

A wanna-be programmer needs some career advise from people who have been there before and are kind enough to lend their opinion about making career steps in IT. Before I started learning programming I worked in accountancy and banking on administrative positions for about 3 years. More or less...

It's my first visit on this forum so hello to Everyone. I have a problem with the below code. I am trying to import recordset into excel with the option to specify parameter value each time the records are imported. The code works when i use numeric or text parameters the problems start when i...