Recent content by SlakeB

That fixed it...Thanks so much!

I am having a problem with my recordset starting with a middle record instead of the first record. I'm trying to go through each record in the recordset to get values for a few arrays in my vbscript code. My DB table has the following form: BS_STP_NUM | LAT | LON 1 | -84 | 39 2...

When performing certain macros like 'transfer to spreadsheet', can you use relative paths (like ../spreadsheets/test.xls) to the files involved or do you need to use the full absolute path (like C:/spreadsheets/test.xls)? relative paths don't seem to be working for me.

does anyone know how to compact and repair a DB with either VBA or VBScript?

This is a question for xmsre: When you said: "No, but I have the opposite. I have one that you put into your sendto folder so that when you right click a file you get a sendto FTP site option." what sendto folder are you talking about? I would like to be able to add some of my own scripts to...

hey PHV, I used the code below and it worked great. Do you know how to stop the "Do you want to save changes" window from popping up? Dim X Set X=CreateObject("Excel.Application") Set W=X.Workbooks.Open("D:\Docs\JaydipDB\OutputFiles\testExcelMacros.xls") X.Run "macTest1" X.Run "macTest2"...

hey PHV, I used the code below and it worked great. Do you know how to stop the "Do you want to save changes" window from popping up? Dim X Set X=CreateObject("Excel.Application") Set W=X.Workbooks.Open("D:\Docs\JaydipDB\OutputFiles\testExcelMacros.xls") X.Run "macTest1" X.Run "macTest2"...

Here is what I have so far (something similar worked with Access macros that I was dealing with). It successfully opens the excel document, but it can't find the macro. Dim oWSH Dim retVal Set oWSH = WScript.CreateObject("WScript.Shell") retVal = oWSH.Run("excel.exe " & Chr(34) &...

Does anyone know how to do this? I have an excel spreadsheet with two buttons on it. Each button triggers a macro. I want an external .vbs file to run those macros without me having to go into excel and push the buttons.

Every time I run a macro of mine (which triggers a query) I get this error: "Microsoft Access Can't Append All the Records in the Append Query" It asks if I want to continue, and I click ok. Is there a way to keep this message box from popping up when this occurs? I've tried 'On Error Resume...

So would I do something like this?: Set Cmd = Server.CreateObject("ADODB.Command") sVBToRun = "externalScript.vbs" Cmd.Execute(sVBToRun)

Thanks! this worked: INSERT INTO yourNewTable SELECT * FROM ( SELECT * FROM yourTable1 UNION ALL SELECT * FROM yourTable2 UNION ALL SELECT * FROM yourTable3 );

I have three tables. Each of these tables have the same structure (same fields). I want to create a new table with the same structure, and I want to put all the records from the other 3 tables into it (kind of like a master table). Does anyone know how to do this with SQL? The SQL doesn't...

Is it possible to call a vbscript file from within another vbscript file without using the DOS shell?

Is it possible to Join more than two tables in a SQL statement?