gui

  1. E

    Can an XLSM GUI workbook opens its own instance when another instance exists?

    Can an XLSM GUI workbook opens its own instance when another instance exists? I've been researching this and found the link below here (at the forum) but I don't thinks this quite does what I hope I can do. The issue I think is that the macro will open an instance, but I still need to give a...
  2. M

    Window / GUI lookup

    Hello - How can I get a window or GUI lookup in Excel? Sheet1 will have the lookup windows - Sheet2 the data table Also, for the input of the lookup, it would be great if it could conduct a fuzzy search. For example, 0346 is the input of the search and the output = the barcode for item #...
  3. C

    Excel VBA with JDA. Anyone know how or if possible?

    So I am trying to figure out if there is a way to script from excel to run a report and extract the results from JDA. I know with other programs like SAP you can use GUI Scripting but can’t find much on JDA. Any advice would be greatly appreciated.
  4. T

    Can anyone recommend a product/software for creating a sophisticated user interface to an Excel worksheet?

    I would greatly appreciate any recommendations for a tool/software that can be used to create a sophisticated user interface to a complex Excel worksheet. Unfortunately, I do not believe that a Visual Basic interface would be of acceptable quality (look and feel) to the client for whom I need to...
  5. T

    Recommendation for tool to create a user interface to a complex Excel worksheet

    I would greatly appreciate any recommendations for a tool/software that can be used to create a sophisticated user interface to a complex Excel worksheet. Unfortunately, I do not believe that a Visual Basic interface would be of acceptable quality (look and feel) to the client for whom I need to...
  6. Y

    SAP script

    Hi, I'm new to the SAP GUI scripting and I'd like to understand some line of codes. Set SAPGUIAuto = GetObject("SAPGUI") 'Get the SAP GUI Scripting object Set SAPApp = SAPGUIAuto.GetScriptingEngine 'Get the currently running SAP GUI Set SAPCon = SAPApp.Children(0) 'Get the first system that...
  7. G

    Create a custom Userform Interface with Visual Studio

    Hi, I'm creating a project in Excel, programmed in VBA, but I've reached a limit of my understanding, so I thought I'd post for help. Essentially I'm trying to create one of these. In case the link breaks/ to make it relevant to other users: what I'm trying to create is a GUI with some slightly...
  8. P

    Creating Excel Applications

    After researching for a good reference on creating Excel based applications, I can only find the book referenced below (published 2009) - given the book is 6 years old, is anyone aware of a new edition or another book - at the advanced/professional level -- that is focused on creating Excel...
  9. L

    Seeking help from a VBScript guru

    Can someone post code for the following? <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> Seeking program (script) that would: · Open each Excel file (.xlsb) in a designated folder · Save each · Close each Note: Needs to work even as folder content change...
  10. B

    Full Screen GUI Grey Bar Issue

    Hello All, So I have some code located in ThisWorkbook: Sub ApplicationDisplay() Dim cbar As CommandBar With ActiveWindow .DisplayHorizontalScrollBar = False .DisplayVerticalScrollBar = False .DisplayWorkbookTabs = False .DisplayHeadings = False...
  11. B

    Search Database with a gui from a Noob

    Good Day Basicly waht I want to do is create a GUI interface on the first sheet of the workbook that will give me the option to enter a certain detail of the client(i.e. Clinet Name, Client Surname, Contract Number etc.) I already hav a sheet with all the detalis in rows with the coloms...
  12. C

    gui - advanced lookup

    ****** http-equiv="Content-Type" content="text/html; charset=utf-8">****** name="ProgId" content="Word.Document">****** name="Generator" content="Microsoft Word 11">****** name="Originator" content="Microsoft Word 11"><link rel="File-List"...

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top