how to use other excel file when using a vba tool

[emmr]

how i can use a vba tool and other excel file at a time? TIA

[Richard Buttrey]

Not quite sure exactly what you have in mind, but I generally set a workbook variable every time I open a new workbook file that I want to use.

e.g.
Dim wbTemp as Workbook

Set wbTemp = Application.GetOpenFilename(...blah...bla

Then you can easily refer stuff in the master workbook with
ThisWorkbook.

and in other workboooks

wbTemp.

[emmr]

if i use a userform in a excel then im unable to open other excel file. looking for that code which will allow me to use both at a time (userform in one workbook, and another workbook)

[Richard Buttrey]

Why are you unable to open another file from VBA in the first file? Have you tried and if so tell us what you've tried?

Please upload the workbooks. It is always easier to advise if we can see your request in its context.

Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.

To upload a file click the Go Advanced button at the foot of your post, look underneath the post area for the Manage Attachments section and take it from there.

[emmr]

in the attachment, its my vba tool, when i open it to use then i cant use other excel file, i dont know why ur not understanding this thing,.

[Richard Buttrey]

I'll put your rather abrupt tone and rudeness down to perhaps English not being your first language.

You were asked to upload both workbooks.
Pictures are rarely any use and in any case I've no idea how you use the form.


I'm not understanding it since you haven't bothered to tell me. So as well as uploading the workbook you'll need to tell us exactly how you fill the form in and what you expect to happen.

[emmr]

im sry that im failed to make it clear this to you
but tying again...
see the picture again, in taskbar there have two(02) excel open, one is my VBA tool(bkash center emp..) & another is Book1
i cant write anything in Book1, cant take screen short of Book1 when VBA tool is open, after closing the VBA tool i can write in Book1

[Kyle123]

You need to display the form modelessly, not modaly

[Richard Buttrey]

You haven't yet uploaded the two workbooks. And when (If ) you choose do so we need to understand the steps you take and how you input to, or select from the form...and other stuff.

There's no point in being enigmatic about all this. We need concrete stuff to work with.