Recent content by Dryheat

Ok, finally got it working. The link provided by mikron got me started in the right direction. But the sample code at that link didn't get me to the final solution. I finally ended up doing a google search for examples of "Runtime.getRuntime().exec()" and that landed me here: tutorialspoint...

Well I tried searching and again found nothing. Do to my lack of experience with Java the solution offered by: Might as well be written in greek. So if anyone has a solution that provides actual code I can copy and paste I would really appreciate it.

Thanks for the quick response. I used your reply to search google for code and found something that looks like it might work. If it does work I will post it to this thread later for others to use. While I am fairly accomplish VBA coder, Java has me completely baffled.

I searched and didn't find this answered in the forum yet. I am developing a Swing form in NetBeans. I need to add a button to my form and build an event that will open MS Access with a specified database file. I can add the button but I don't have a clue how to write the code for opening the...

Thanks again Skip. I just had a few minutes to copy this into my sample spread sheet and it works perfectly. You are awsome! Dry :-)

Awesome. Thanks Skip. I'll chew on this for a while and while and tailor it to my co-worker's workbook. Very grateful for you patience and knowledge. Thanks! Dry :-)

I just need to know how to do the sections on the sample. The live document has several sections and some more disimiler than the two I gave. It's irrelavant to show the entire document and I don't need someone to right the entire code for me. Just show how I might manage to deal with the two...

I'll try to explain. First this example from a co-worker who is trying to create a tool for his customer's to use for calculating their cost to install an air conditioner. The format on 'Cust Catalog' sheet is formatted to make it easy for the customer to use, instead of being easy to program...

Skip, that is exactly what I was looking for. I can get started with this. Now that I am at home I can upload that sample file so you can see what it looks like. There are many more sections in the live version but for now I have only included two. Check the attached file. Dry...

Not so simple. I wish it was. See catch number 2 from original post. To present a clear and easy to use document to the customer the data is grouped into multiple sections on the worksheet. Each section has it's own format and merged cells. If all the data could be arranged neatly into...

Event would be a control button, lets lable it 'Submit'. I really just need a staring point. Let say I have a function that runs when the submit button is pressed. The fuction needs to read all the cells defined as storing qty information and only if it finds a value in the qty cell it should...

Sorry, hit the submit button to soon. I was trying to upload a sample xls to answer number 2 and pressed the wrong button. I do not have access to upload the file from work so I will have to do it from home. The best answer I can give without showing you a file is there are merged cells all...

I have no code. Not even started. I have experience in coding MS Access but no Excel so I am not familiar with nagvagting cells to search for data or writing data to specific cells. 1. "Might there also be values in coluums B-D if there is no value in column A?" Yes but if there is no Qty...

I checked the FAQ's and could not think of a way to run a search for this topic. So if it's been covered aleady then please forgive me. 4 columns in Sheet1 contain a list of items. Col A is for QTY Col B is for Item Col C is for Description Col D is for Pric I would like to write code that...

I will try the system restore idea. It took place over a month ago so I'm not sure of the implications. For now I searched Yahoo and found another solution: stSql = "SELECT * FROM [Switchboard Items]" stSql = stSql & " WHERE [ItemNumber] > 0 AND [SwitchboardID]=" & Me![SwitchboardID] stSql =...