java

I really need help with this one, as it's so tricky for me. i download files multiple times a day from an intranet company website, i don't know how to utilize VBA with Java to complete the process but below is my inspect element for the lines that i need to click on. 1) open the website 2)...

Hello, I've seen some options to use Python, Java and C# in Excel. Wondering if anyone has tried it and if they are considered "safe" to use. Saw this: Excel-DNA where I could build classes in C# and call them using the "=" inside cells in Excel. (Perhaps this is also possible with VBA?) Felt...

Is there any way to automate excel reports using Java, do I need to learn Java for this or is there any script or tool which can help me do that?

Hello Everyone, I a new to programming and learning Java. I am trying to package a Java Spring Boot application. When I use the command "mvnw package" I get the following error: /watchlist/WatchlistApplicationTests has been compiled by a more recent version of the Java Runtime (class file...

Hi, I am interested in a way to merge/copy sheets from multiple Excel files into a single Excel file. Some tool or script (python/java?) that will work in Unix and Windows systems, with/without MS Excel installed. While preserving existing cell format/style. Something equivalent to going over...

Does anyone know of a good Java Script forum thats as good as Mr.Excel? Ive got to start learning how to add some script to some pdfs and need help.

Hi I have 1000 of website links some of them are having Java scripted and some are not. i need a macro to identify all the java scripted links. thanks for help.

Hi Guys, I've been trying to auto certain processes and i'm trying to automatically login to a certain website. Below is my VBA code and the java script of the website. Until the line when its suppose to insert the userid and password, an error appeared. Appreciate any advise <form...

Hi, I have an excel column in which I have created java command (using formulas etc based on other columns). There are more than one cells in the columns with respective Java command. I want to run them in loop so that when Java command execute it will create some files for me. I just want to...

Hi ALl, I am trying to create most common cluster from a table containing people technical skills. For Eg: if I take Java, I want to know what are the most common skill combinations people posses along with Java. If you see the table below: <colgroup><col width="64" span="6"...

I'm getting my feet wet with objects and started reading Head First Design Patterns after reading http://www.cpearson.com/excel/Implements.aspx The sorting example showing the value of interfaces from cpearson.com worked, but trying to follow along in the first chapter of the design patterns...

How can I launch the following command line string from within Excel? start javaw -jar myprogram.jar" inputparamstring I found the following link to show some promise http://http://stackoverflow.com/questions/11343769/microsoft-excel-macro-to-run-java-program but had trouble getting it to...

I want to call a java program (Forecasting models like ARIMA & Neural Networks) in excel VBA Macro. Excel VBA Macro code for Exponential Smoothing is available and the code will run run first then the VBA code should invoke the java program and does other Forecasting models and then get entire...

Hello All! I'm a long-time reader, first time poster. I've always found answers to my questions but I have finally come up to an issue that isn't posted on the forums. What - I'm trying to automate via macros obtaining data housed online. I cannot get access to the raw data so I have to go...

As the titles says I am interested in finding a coding option to using the search/highlighting feature of IE. I am working with a heavily framed java database that I need to automate via VBA. I have tried the usual iframe/frame solutions to selecting text or clicking in textboxs, etc, but with...

Extract the information from column A and Column B from one excel document and create another excel document and copy each row in the first 4 columns while placing the cell values from column A in the new document path structure. Source: Document 1 Column A Column B dog <tbody> Column A...

:confused:Hi All, I have an excel document that's a very long list and i want to automate my process with extract certain information for my new document, but using java. I am also open to vb. So I have 5 columns with information that i will need to use to create this new excel sheet. See...

We received an Excel spreadsheet that is actually an XML document. Excel can open it a-ok however we need to consume it using: "jdbc:odbc:Driver={Microsoft Excel Driver (*.xls)};DBQ=" and when the program accesses this XML document it fails. Modifying the program is not a great option. However...

I am having an issue trying to locate the USername/Password with code to enter my text. The javascript login page is a small window that pops up but contains no source code. How Can i locate the fields to enter my text?:(

Need to click accept radio button then click submit button ? Accept Decline