Search results

Thanks SOS, Do you know if there's a way to get the window to show up over the open Excel sheet?

Thanks for the advice. I've found out the same thing the hard way also. You need to use strong naming conventions unlike inside Excel.

Access_guy49, I have a vbYesNo right now. If I change it to vbMsgBoxSetForeground they only have the option to press "ok". It also switches it to Access before displaying the msgbox which is not what I want. I want it to show up on top of the open Excel sheet. Right now I have: Dim...

Hi everyone, I wrote an Access 2003 function that takes in either a table or select query name. If you give the function a file path it will save it to disk. If you leave the file path out it opens it up in a new Excel application without saving it. You can also set booleans for visiblity and...

Thanks for the advice Simon, I'll check into that temporary file. When it is output to Excel, each user has their own filename they want to use. Also some of the options are for a quick view and they wouldn't want to save those. Transfering the Excel sheet to Access never needs to be saved...

The end user opens up an Excel sheet from a website and then presses a button on a form to bring the data into my Access 2003 table. Then when they press another button a query is run and output to another Excel sheet. I want to save the user from having to save the workbook before my code will...