In VB I want to connect to an Access database and get the values from a given recordset, I want to then pass these values out of VB into the regular scheduler routine. Then I loop back into Access and go to the next recordset, do the same thing again, until rst.EOF I can write the code to connect to...

although i'm curious why the above didn't work, i've changed the code to use input from an ini file, now it works fine

MS Version 7.2.038e on Windows 2000, Excel '97 Here's my code... let>savePath=H:\Report_RunnerTesting\ let>bondAddr=bm-prod.ext.us.bank-dns.com let>rcPF_FTCIM=R1C2 DRQ>Excel,H:\PrintFiles.xls,%rcPF_FTCIM%,PF_FTCIM,10 ConCat>savePath,FTCIM.txt FTPGetFile>%bondAddr%,FTC_FTP,***,21,%savePath%,%fLoc_FTC...

thanks, i actually found this bit of vba that does almost exactly what i want. The problem is that i don't want it to overwrite the last column on the "merged" worksheet. How can i leave that last column static? Sub WSMerge() Dim sh As Worksheet Dim DestSh As Worksheet Dim Last As Long Application.S...

This might be the wrong place to ask this so maybe i'm just asking for a direction to go in. I need to update a worksheet in excel from other worksheets in the same book. basically, worksheet one should be all the rows from worksheets 2 through 5 which are updated once in a while. i think i can prog...

i don't see any such setting in the control panel... most sounds in my control panel are missing the associated chord.wav file too.

I'm on a tightly locked-down pc at work that won't let me change the date/time, install programs, etc... I think they use Novell Netware I don't think any of that matters for this, but there it is anyway. How do I disable the system speaker so my pc doesn't make noise when invalid keystrokes are pas...

thanks for the help, i just figured out a good workaround so i didn't try your code, but i have another question about your answer. the error i was getting is because the window i wanted to set the focus to didn't exist. it doesn't seem like your solution would allow me to close the warning from tha...

i want my macro to recognize when a warning window comes up because i try to setfocus to a window that's not open.

if the warning pops up i want to send an error flag to a field in excel and click ignore to the warning so the macro can continue... any ideas how i can do this?

thanks, i finally got this to work for me

let>ret=test
setfocus>Excel*
dderequest>Excel,c:\temp\pay8.xls,R1C1,ret,10
ddepoke>Excel,C:\temp\pay8.xls,R10C1,%ret%

alright, this will be simple here's my code: setfocus>Excel* dderequest>Excel,c:\temp\pay8.xls ,R1C1, ret, 10 ddepoke>Excel, C:\temp\pay8.xls, R10C1, ret ddepoke>Excel, C:\temp\pay8.xls, R11C1, %ret% all i'm trying to do is get dderequest to work for me, but when i check to see if it's pulling the r...