workbook activate

Good morning all, I'm using the typical method of using a window handle to re-activate an instance that launched a userform. However, I need to run the FindWindow routine from every control in order for it to work. I have well over 200 controls in the multi-page userform, and it will be...

Hi! This time I am really stuck. I have two workbooks Workbook1 (main file - named: h:\dekstop\somethingneweveryday.xlsm) Workbook2 (data file - named: H:\desktop\blomst.xlsx) I do my work in Workbook1. I use a macro in workbook1 to open and activate Workbook2 and do some stuff and collect...

Hi guys, <o:p></o:p> I’m trying to write VB code in workbook A that monitors the next workbook to open (we’ll call it workbook B) and reports back to workbook A whether or not Workbook B is read-only or not. Workbook B could be a VBA enabled or a non-VBA enabled workbook and could be any...

I have 3 different workbooks that I'm working with. 2 of the workbooks are reports that are automatically saved to a random temporary internet file folder. I was wondering if I can somehow activate the 2 workbooks without knowing the file path since they will saved to a random folder every time...

I created a macro in my workbook using an active worksheet from another workbook. I would now like to run my macro, but use yet another different active workbook to get my data. I have this line 20 times in my macro... Windows("IFS_round_1").Activate ...so I do not want to change it (ex...

Hello again, Back again with another problem. In brief: What I'm trying to do is open a workbook in a set directory (user inputted, but that's not the problem right now). The workbook location is inputted via a filedialogue box. I need to open the workbook, activate it, do stuff to it (Copy...