gui

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

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

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.

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

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

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

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

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

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

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

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

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