Search results for query: *

That is because Set appIE = GetObject(, "InternetExplorer.Application") always raises error even if internet is open. That's way i was asking for the "path"-first argument of this method before the comma.

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...

Thanks again, i think i am slowly getting a gist of these transformations. Your suggestions saved me a lot of time. Cheers

thanks tsuji HTML output works perfectly The last thing i wanted to do is to get an output in xml format. I have tried to edit your xsl stylesheet syntax and got into trouble again: ----------------------------------------------------------- <?xml version="1.0" ?> <xsl:stylesheet...

thanks k5tm The reason why i am using xsl is that i want to decide WHAT TO SHOW (rather than how) from xml file content. Can you do this via XSD? I have tried a slightly different approach to achieve the same thing (ie extract Security names & prices from xml where price>110 by using xsl...

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"?>...

Ok, Geoff point taken. I will try to rephrase to make it more VBA-ish. My XPath query works fine - it does what i want (i.e. gets reference to all records in xml matching criterion price>100). I guess the real question that i am clumsily trying to formulate is : how do i use vba (and MSXML...

anyone?

tsuji, thank you for taking time to respond

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...

thanks combo I have amended SELECT statement as per below : sSql = "SELECT * INTO " & sNewSheetName & " IN ''[Excel 8.0;Database=" & sExportToFile & "]" & " FROM MyTable" It's working now however another problem appeared - I am losing some data e.g. I have a column with Id codes majority of...

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...

thank Litton it works well!

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...

Thanks Andy. I understand that i am probably aproaching the problem from the wrong side, but it's a good occasion to practise a bit with ADO which I haven't used before. Taking into account what you said I have changed my strategy and instead of creating/deleting tables/records I have tried...

Thanks for your response Jerry. It's all between excel files. As for why I am using ADODB to do that ...the honest answer would be that as a novice in VBA programming I am not familiar with any alternative apart from creating an array and transfering it to another file. The main thing...

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...

Cheers Combo, That's exactly what i was looking for.

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)...