Recent content by morgan23

Where would I place the code: owkb.Close oXL.Quit to keep the excel application from wanting to close right way? For example, right now I have: oXL.Visible = True owkb.Close oXL.Quit Set oWks = Nothing Set oWkb = Nothing Set oXL = Nothing This causes the "do you want to save" window to come...

The excel spreadsheet comes up after command is ran. I just close it manually. Do I need to close it in the code, and how would I do that? Morgan

I figured out that if I save the spreadsheet, renaming it, after it has been opened by my procedure then it works fine. But if I just close the spreadsheet after my procedure as opened it is when I continue to have a lock on the spreadsheet and I am not able to open it again outside of my...

I have a procedure where I write a subform to an excel spreadsheet. The procedure works fine but after I have ran it and then try to open the spreadsheet I get a message that is in use. How do I get the lock off of the spreadsheet after my procedure runs? This is what I have: Private Sub...

Thanks for your quick response. The strings in the fields were not dates so the method FoFa suggested worked great. Thanks to both of you for your help. Morgan23

Hi, I am very new to MS Access and to VBA. I have a field in a table in MS Access that contains data in the format: xx-xxxx.xx , where x is a character. I need to be able to compare this field with another field in a different table with the format as: xxxxxxxx. I would like to know how to...