I have currently written a sub, written in VBA, that is called by the click of a button on an excel document. The sub takes data in the cells of the document and sends them to a web service. All of this works flawlessly when Visual Studio automates Excel. I am wondering if there is a way to save this excel file to where it does not ne...
Hi guys, I am currently exporting data from an excel import using excel interop. I've been fiddling with this for a few hours now, but can't get the export as I desire. I'm taking a range of 2 columns and about 1k rows from an excel doc, and simply want to add a comma to the end of each column, but because of the way that I'm looping t...
Folks, I'm performing array calculations that are taking a long time to complete. I'd like to optimize my formulas some more. All of the formulas are of the same nature - they perform some high-level function (Average, Slope, Min, Max) across a column of values. However, not all cells in a column are included in the array. I use mul...
kitco.com provides a realtime price quote for gold and other metals. I have a spreadsheet which makes calculations based on the price of gold and would like for this realtime value to automatically be updated on my excel sheet. I tried 'get external data' from a website but that didn't work. any ideas? EDIT ADDED: Kitco has a gadget cal...