Search results

Hello! I was wondering if there was a way to get Access (or Excel) to go to a website, and get the information itself. The website I want to get the info off of has no images, java, or anything else... it's just a straight text chart (here it is...

Hello! I have a recordset (called "hraftr"), and when I reach the end of the recordset, I'd like it to go back to the first entry again. I'm using the following code to do this, but I don't think it's working (or at least it returns a 'no current record' error during the transition): Dim db as...

Hello, I was wondering if I execute the following code: Dim oApp, oWB As Object ' open Excel Set oApp = CreateObject("Excel.Application") ' load a spreadsheet file Set oWB = oApp.Workbooks.Open("W:\Working Directories\Mike\RegressThis.xls") whether the startup macro in RegressThis.xls...

I have this code here, which works, but doesn't close excel (which I thought oApp.Application.Quit was supposed to do...). So I'm wondering how I could actually close it! Thank you! Dim oApp, oWB As Object Set oApp = CreateObject("Excel.Application") Set oWB = oApp.Workbooks.Open("W:\Working...

Hello! I've got a fairly complex problem here I think... so please bear with me! K... I have a table in Access, that I've already exported to Excel. Now I have vba code in a sub procedure called MultOLS in Excel (this sub procedure creates another worksheet in that workbook, which I then want...