Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 401
  • Last Modified:

VBA/ How to Position Word Document Window and VBE Window Side By Side

In a nutshell: I want to be able to quickly position the word document window (left half of screen) side by side with the VBA code editor (right half of the screen)

I am looking for some VBA code (will probably include api calls) that will position:
1) The window of the word document I am working with (identifying it by application.caption, I suppose) to the top left hand corner of the screen, and resize the window to take up half of the screen horizontally and the full screen vertically.
2) The VBA code editor to take up the right half of the screen.
0
PioneerSolutions
Asked:
PioneerSolutions
  • 2
  • 2
1 Solution
 
GrahamSkanCommented:
You don't say why you don't simply 'Tile Windows Vertically' with only the two windows open and unminimised.
0
 
PioneerSolutionsAuthor Commented:
Hi Graham,
I am working with several windows and during debugging sessions I sometimes need to isolate these two windows. Moreover my question is simplified. Long term, I will tweak the exact sizes and positions, as needed.
Regards,
e
0
 
GrahamSkanCommented:
OK.
I was asking, because I believe that it requires the use of APIs and quite a lot of research. In fact I think that it is more of a project that a question, so if there were already a workaround...
0
 
PioneerSolutionsAuthor Commented:
I believe it requires the use of two API's FindWindow and MoveWindow. I am just not sure how to put it all together, including getting the handle (hwnd) of the Word window and VBE window. It may also require the use of CreateObject function and the use of Application.Caption. Again, I am not sure how to put it all together. But from my reading online these seem to be the keys to solving this. Anyways, don't bother researching it. I hope someone with VB experience will come across this question.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now