Recent content by miken127

This is a nice procedure. I would note, though, that the expression LookingForThisWorkbook in the InStr function should not be in quotes. Actually, in this particular application, the workbook I am looking for is blank. I copy data over to it for later printing. Since the application may...

That doesn't quite work in the VBA application; I get an error message trying to run the code. Instead, I put in a statement: workbooks.open filename:="path\filename.xls" and if the file is already open Excel issues a message asking whether I want to reopen it and lose all changes, or...

I have an application running VBA forms in an Excel workbook. I need to be sure that another workbook is also open in Excel. Is there a function which returns true or false for an open file? Anyone aware of a way of doing this? Thanks.

I tried that. But the macro recorder does not capture action outside of Excel.

I'm probably confusing this issue too much. The basic problem is that once I have a form displayed and allow the user to modify it as necessary, the printing function avaialble in a user form is only printform. This sends the output to the current default printer. What my user wants to do is...

I should have mentioned that this is Excel 2000 and that users are asking to be able to access other Excel workbooks while using this application. In hind sight it would have been better to create the application as a stand-alone program, but many months have gone into this project, too much to...

I have an Excel VBA project application which is designed around User Forms for data entry and internal calculation, with some help from various worksheets in the workbook. There is a need for users to be able to access Excel while the User Form is active. This doesn't appear to be possible...