java

  1. M

    VBA to open website and download a file

    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)...
  2. FilleFrella44

    C#, Python, Java in Excel

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

    How to Automate Excel Reports Using Java?

    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?
  4. A

    Spring Boot Application Runtime Error

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

    Copying sheets from different files into a single 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...
  6. B

    Best Java Script Help Forum

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

    Macro 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.
  8. I

    Inserting user ID and password

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

    Running Java jar file from excel

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

    Creating Graphical clusters of most common combintions

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

    how to do examples from Head First Design Patterns, a Java book, in VBA?

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

    How to Launch Java Windows Application from within Excel VBA?

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

    How to call a Java program in excel VBA Macro

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

    External Data Link - decode Java??

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

    Finding text word in IE with the use of the "ctrl-F" feature, but with code. Also, finding highlighted text.

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

    Creating custom path using excel cell values

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

    Read and write from excel sheet to another excel sheet using java or vb

    :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...
  18. S

    XML Spreadsheet document.

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

    No Source Code// Login Window Help

    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?:(
  20. N

    Click this Radio Button NewBie

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

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
Back
Top