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.

...ThisWorkbook.Path & "\" & "Portfolio - INTL .xls" & "]." sTable2Name = "[" & "B5LIPF$" & "]" sCol2Name = "[" & "SEDOL CODE" & "]" sSql = "SELECT * FROM " & sTable1Name & "," sSql = sSql & sDbase2Path & sTable2Name sSql = sSql & " " & "WHERE " & sTable1Name & "." & sCol1Name & "=" &...

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

...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 MyTable" 'sDataBase rsExcel.Open sSql, sConnect, adOpenDynamic, adLockOptimistic...

thank Litton it works well!

...Source= " + txtFilePath; OleDbConnection myConnection = new OleDbConnection(sCon); //SQL COMMAND string sSql = "SELECT * FROM [Gilts_Details]"; //CONNECT OleDbDataAdapter myAdapter= new OleDbDataAdapter(sSql, myConnection); //RETRIEVE DATA DataSet myQueryData =...

...as in previous table) which I wanted to be copied over and named as per below : sNewSheetName = Format(Date, "ddmmyy") sSql = "" sSql = "SELECT * INTO ['" & sSourceFile & "'].['" & sNewSheetName & "'] FROM [templatesheet$]" conExcel.Execute sSql When i run this code i get an error msg...

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