I have a textbox that is populated with either "File is Available" or "File is Not Available", depending on whether a certain file is present in a specific folder. Since other users can drop the file into the folder without the Access user's knowledge, I would like the Access user to be able to...
I have been using the method to minimize Excel, show the msgbox, and then maximize Excel.
excel_app.WindowState = xlMinimized
MsgBox "This Excel file does not fit the standard format."
excel_app.WindowState = xlMaximized
It's workable, but I just figured there has to be a way to...
Hmm, the problem is that the user is always processing new files that they get from another party so I don't think I'll be able to embed code in the Excel sheet. Can I use Access VBA to embed a macro in the Excel sheet?
I have VBA code in Access to open an Excel spreadsheet, modify, etc... That's all working fine.
When I create a MsgBox, the box pops up in the Access window (which is now obscured by the Excel sheet that's now in front). Is there a way to pop up the msgbox in Excel so that the user will see it?