Search results for query: *

Awesome - exactly what I was looking for; thanks Marc!

Hello! I am trying to determine the syntax to merge 2 tables together with different schema into a View. The 2 tables are identical except one of them has an additional column. Whenever the View is called, it will retrieve all data from each table with no conditions or restrictions. The...

I found a simpler way using AutoItX3, which is a freeware automation tool that comes with a combined DLL/COM module called AutoItX with a separate HTML help file describing clearly the COM methods available. http://www.autoitscript.com/autoit3/downloads.php Here's the Ruby code now: require...

Hello, I am new to Ruby and Windows programming and have a question regarding the WIN32OLE. The following sample code is used to launch MS Internet Explorer. require 'win32ole' ie = WIN32OLE.new('InternetExplorer.Application') ie.visible = true ie.gohome What I would like to do is launch MS...

The problem was that it should be content.document.body, not window.document.body. Thanks for the suggestions!!

Thanks for the test code kaht; it works correctly and confirms your reply. The problem for me is that the .js file holding the function is being called from a .xul file (I am making the call using a Firefox extension i am creating), not an html file. For some reason the document.body call is...

Thanks kaht and tsuji. I have tried both of your suggestions w/o success. kaht, you mentioned that the outerHTML call only works for IE? I think this is the same issue for innerHTML call, as I am getting the same error message: 'Error: document.body has no properties' I am using Firefox...

Thanks for the tip tsuji. I am still getting the following error message: 'Error: window.document.body has no properties' The HTMLsource variable is unable to store the HTML code and I am confused as to why. Any ideas? Thanks!

Hello, I am having trouble creating a javascript function to parse through the HTML source code of a webpage using the Firefox browser. I have the following code, which attempts to make use of the built in function calls 'window.document.body.innerHTML' and 'HTMLsource.indexOf('bug.gif'...

Thanks for the help. I followed rzs0502's suggestion and things worked out. The _original code_ works on mySQL 4.0.14 and lower, but not 4.0.17.

Hi, I am running a script which is outputting the following error: Invalid default value for 'changed' This corresponds to the following portion of code: CREATE TABLE realm ( name CHAR(16) NOT NULL, title CHAR(64) NOT NULL, changed TIMESTAMP(14) NOT NULL DEFAULT '', PRIMARY KEY(name)...

Thanks for the prompt reply. I am trying to follow your suggestion with the following simple code: Sub Macro1() Dim aRange As Range ' Column to run Spell Check on Dim word As Range ' value of current cell Dim convertedword As String Set aRange =...

ActiveWorkbook.SaveAs FileName:=filename, FileFormat _ :=xlUnicodeText, CreateBackup:=False

Hi Mike, Thanks for the reply and I'll try to clarify my problem. I am importing a unicode(to support multiple languages) text file into Excel. I would like to run the spell check function on the list of words. This list of words will be all 'misspelled' words, but the spell check dialog box...

Hi, I am wondering if anyone can direct me to some help regarding the use of the Spell Check Dialog Box. I would like to access Microsoft Excel's spell checking tool, but instead of clicking 'ok' to change words, I want to modify it so that a list of words can be separated into two lists of...

The solution may be related to the following thread, but I am not sure exactly what to do! http://support.microsoft.com/default.aspx?scid=kb;EN-US;178510

This should be an easy question, but as a novice programmer, I am not sure how to solve it. If I have the simple code below: Private Sub Command1_Click() Dim ExcelApp As Excel.Application 'Excel-object Dim colRange As Range ' Column in which to read values from Dim i As Range...

For spellchecking a column such as the 'A' column you can use the Range property: Dim somerange As Range Dim i As Range Set someRange = Range("A1", ActiveSheet.Cells.SpecialCells(xlLastCell)) For Each i In somerange // i will cycle through words in column Next i

Hi, I would like to know how to import Unicode Text files into a list box. The method I am currently using is: Dim fnum As Integer Dim file_line As String fnum = FreeFile Open sDestFile For Input As fnum Do While Not EOF(fnum) Line Input #fnum, file_line lstDest.AddItem...

Private Sub cmdLoad_Click() Dim fnum As Integer Dim file_line As String lstLines.Clear fnum = FreeFile Open txtFile.Text For Input As fnum Do While Not EOF(fnum) Line Input #fnum, file_line lstLines.AddItem file_line Loop End Sub