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"...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top