I have searched and searched for code that I can use in Excel (VBA) to connect to our Oracle Database. I have tried several examples and all have given me run-time errors. This is my latest versi...
http://www.experts-exchange.com/Database/Oracle/Q_23258521.html
...How do I use a vba excel macro to crate or update an access dB. The information to update the DB are in same text box into an Excel Sheet
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 08/31/2008 Rating: 7.7 Views: 0
Hi all,
I am under Excel 2003 (VBA of course).
I have a form with 7 labels named: Label7 to Label13.
I have a database with more than 7 rows in (2 cloumns).
What i'd like to do is for my fi...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/VB_Script/Q_23222631.ht...
Hi,
I have written a vba program to read a text file using filesystemobject to extract certain info.
Problem is the input is in a binary format so i have to copy the data and paste it into text f...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_23367780.html
Hi, I have a VBA script and it combines different values in a range to match the target value in a cell. For example if the target value is 10 then the macro will comibne the values in a range that...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
I have a workbook with several charts in it. Is there a global method to set all plot area backgrounds to white for example?
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Hi,
I would like VBA code to work behind a spreadsheet so that a dialog box appears when the user selects any cell between A7 and A300. I want the dialog box to ask for date and time and then ente...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
I need to create a few hundred format styles for an Excel application.
The styles are driven by various conditions, so the quickest way to create them is using a decision-tree structure in VBA. ...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 02/10/2008 Rating: 8.0 Views: 16
In Excel, what is the maximum number of non-contiguous range addresses that can be used with Range() and what is the maximum number of non-contiguous ranges that can be unified using Union()?
Ra...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 07/29/2008 Rating: 9.2 Views: 8
I need to 'interior color' an entire row range based on the current color of a cell that's colored as a result of a conditional format. I've tried capturing the colorindex of the cell but that's ...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 09/15/2008 Rating: 8.2 Views: 0