>>Well, this was why I mentioned what I did in my first post. After doing some reasearch, I must admit that I couldn't readily find a way to open the file via DDE. Much more direct, and easier IMHO, is to use the API to open the file and
>
>Hi George,
>
>You're a genius!!! It works!!!!!! I spent a good 15 minutes yesterday doing the happy dance once I got everything in the right order and cleaned up and all my little messageboxes in and everything. I'm going to save myself at least 30 minutes a month. Now, that's not a lot - but last month they needed this report 3 different times and I spent 30 minutes each time manually putting it together. So I'm a happy camper now!!
>
>But now that it works, I'm trying to figure out how/why. Mainly my questions are in regards to the shell.dll. I tried find on my computer and tried to search at MS's site, but couldn't find any kind of help file on the various functions that are in the dll. Is there some kind of help file that I can get ahold of to study the functions that you gave me?
>
>Also, now that I'm able to get the numbers right, the only thing I'm doing with the excel file now is changing the headers and printing. Do you know somewhere that you could point me so I could do some research to try to figure out how to do this? Maybe it's not possible but I'd like to try.
>
>I appreciate the help like you wouldn't believe!! I'm still happy-dancing over here. Thanks again.

You're welcome, Denise. As far as using the ShellExecute() function, I've posted a file (called File Runner) in the Win32 and other API download section. First, I'd suggest that you download that. Next, I'd suggest you look at the declaration for ShellExecute() and the code that follows. The first string parameter (lpOperation) can also be "print". If you pass the Excel file name to ShellExecute() with that parameter, it will print the document. You can also control whether or not Excel is visible with the last parameter (nShowCmn). If it's 0 (I think) Excel won't be visible.