+ Reply to Thread
Results 1 to 9 of 9

how to use other excel file when using a vba tool

  1. #1
    Forum Contributor
    Join Date
    07-25-2019
    Location
    Dhaka, Bangladesh
    MS-Off Ver
    2016
    Posts
    200

    how to use other excel file when using a vba tool

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

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: how to use other excel file when using a vba tool

    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.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Forum Contributor
    Join Date
    07-25-2019
    Location
    Dhaka, Bangladesh
    MS-Off Ver
    2016
    Posts
    200

    Re: how to use other excel file when using a vba tool

    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)

  4. #4
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: how to use other excel file when using a vba tool

    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.

  5. #5
    Forum Contributor
    Join Date
    07-25-2019
    Location
    Dhaka, Bangladesh
    MS-Off Ver
    2016
    Posts
    200

    Re: how to use other excel file when using a vba tool

    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,.
    Attached Images Attached Images

  6. #6
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: how to use other excel file when using a vba tool

    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.

  7. #7
    Forum Contributor
    Join Date
    07-25-2019
    Location
    Dhaka, Bangladesh
    MS-Off Ver
    2016
    Posts
    200

    Re: how to use other excel file when using a vba tool

    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

  8. #8
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: how to use other excel file when using a vba tool

    You need to display the form modelessly, not modaly

  9. #9
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: how to use other excel file when using a vba tool

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Export Excel xlsx to delimeted csv file - diffing tool on git
    By jaryszek in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 03-21-2019, 05:39 AM
  2. Excel 2010 Add In - .xlam file - macro thro custom tool bar button
    By chetan.thakkar in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-04-2013, 10:58 AM
  3. Replies: 2
    Last Post: 01-22-2013, 11:37 AM
  4. Replies: 4
    Last Post: 10-28-2010, 12:16 PM
  5. [SOLVED] Using of Customized Tool Bar in another file
    By PSL in forum Excel General
    Replies: 1
    Last Post: 07-20-2006, 08:50 AM
  6. [SOLVED] Excel File Size Reduction Tool
    By Rima in forum Excel General
    Replies: 10
    Last Post: 06-28-2006, 12:00 PM
  7. Excel-What is update file tool?
    By taxoof in forum Excel General
    Replies: 0
    Last Post: 03-21-2005, 11:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1