Excel

coloring rows “if” true

I have a profit & loss spreadsheet that I use to input expected expenses and then log the invoices when they are paid and I always highlight the row when I input the invoice number and invoice amount. Is there a way I can use conditional formatting or a function to automatically color the row if...

Answer Question   |  May 16 2008   8:17 PM GMT   |  asked by Tstychalski
Excel 2003, Conditional expressions, Microsoft Excel

After exporting charts from SQL Server Reporting Services to MS Excel, images appear poor

I have a problem with my charts. After exporting from SQL Server Reporting Services to Excel, my charts look "ugly.” Quality is low, images are blurry, etc. Is it possible to change settings somewhere?

View Answer   |  May 14 2008   3:14 AM GMT   |  asked by SQL Server Ask the Experts
SQL Server Reporting Services, settings, Excel

Overwrite previous record with VBA code

I am doing a training exercise. All works OK as per the notes with a new record being added when the OK button is clicked. Now I want a script that overwrites the previous record and not to add a new record / row on pressing OK. Pls help with code

Answer Question   |  May 13 2008   1:28 PM GMT   |  asked by Battler
Excel, VBA, Excel macros

Problem in Data Downlod from SAP to Msoffice 2007

Problem in Data Downlod from SAP to Msoffice 2007. If i use data export option from SAP to Excel 2007 a blank xls sheet open but no SAP data apear in sheet.

Answer Question   |  May 8 2008   6:49 AM GMT   |  asked by Mkamil
SAP, SAP Import/Export, Microsoft Office

Search for duplicates in a collumn and delete the row on which it occurs

Hi,I have a spreadsheet with list of identifiers in collumn 1, this is auto generated and due to the source info some of them duplicated, what I want to do is find the duplicates and remove the entire row they appear on.I know this is possible using clipboard and filters but I would rather avoid...

View Answer   |  May 6 2008   1:47 PM GMT   |  asked by Harleq
Excel, Excel formula, Excel function

how can i limit the data size while entering to the database ?

how can i limit the data size while entering to the database from Excel sheet using vb6?

View Answer   |  May 2 2008   10:43 AM GMT   |  asked by Shwetha
VB6, Visual Basic, Microsoft Excel

Retreiving data from within square brackets, there may be more than one in each cell (spreadsheet owner refuses to change it grrrr)

I have a spreadsheet with a column containing data in the following format Column GRow 1 [1T40131A] [GB50131A] [GB50131B] [GB50131C] [1T50131D]Row 2 [1T400133]Row 3 [303640]*VFRow 4 [240700]*RNI would like to create a UDF that will retrieve the data within the...

View Answer   |  May 2 2008   8:51 AM GMT   |  asked by Harleq
Excel, Excel formula, Excel function

Problems oprning Excel File

I have been working with an Excel 2003 workbook since January 2008 and from last week began having difficulty opening the file. Whenever I attempt to open it, I get an error window with the following messages shown in bold below:[Excel found unreadable content in 'filename.xls'. Do you want to...

View Answer   |  May 1 2008   8:53 PM GMT   |  asked by EB
Excel, Excel 2003, Microsoft Office

Working with Excel in ActiveX DLL

I have a OCX file that is registered on client's PC and called from ASP to perform the Excel manipulation (copy charts and paste into PPT). I tried to register the OCX on server and called using <Object> tag, did not work, still looking for the OCX on the client. Created a new DLL file...

Answer Question   |  Apr 25 2008   5:59 PM GMT   |  asked by Dfree
DLL, OCX, VB

Lotus Notes External Table Look Up

My company uses LN 6.5 and I am trying to design a database with multiple tables. I have been told that there is a function that allows you to look to an external table, such as in Excel, to view data. The data modifications take place in Excel, but are viewed in the database. How would I...

Answer Question   |  Apr 24 2008   3:16 PM GMT   |  asked by Kj7100
Lotus Notes 6.x, Lotus Notes database, Microsoft Excel

How to save a document as current date ?

I'm using VBA in excel 2000 to create a macro that saves out a spreadsheet with today's current date. I cannot figure out the code that will achieve this function. Help Please

View Answer   |  Apr 22 2008   7:15 PM GMT   |  asked by Data Mgt
Microsoft Excel, VBA, Excel

Is it possible to find out the name of an excel worksheet

I need to import details from Excel but the worksheet names are not always what is expected. Is there a way to determine the worksheet name using sql?Query used to import where sheet name = dataSELECT * INTO tmp_test2 FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel...

View Answer   |  Apr 17 2008   3:52 PM GMT   |  asked by Smf
Excel, SQL, Microsoft Excel

Combo box and VBA

The two possible selections in an Excel combobox: Debt & Common Stock. Let's say that the combobox resides in cell B3.If Debt is selected from the box- I want the following fields to show up two rows below the combobox, all in the same column: Issue Date, Maturity Date, Interest, Seniority, Use of...

Answer Question   |  Apr 16 2008   10:18 PM GMT   |  asked by Nkd
ComboBox, Excel, VBA

Add to Excel spreadsheet from System i

I want to add data from a DB2 file to an Excel template that has a header row and totals certain columns without overwriting the header row or the totals.

View Answer   |  Apr 10 2008   2:41 PM GMT   |  asked by Ljjk122
Excel, DB2 Everyplace, System i

Excel-Macro Help

I'm creating a spreadsheet for a business (for my uni work) and i need to create a booking form and from that be able to save the customers information. I've created the booking form, and created a button to save the customer information, using a macro for it to save. The problem is when the...

View Answer   |  Apr 6 2008   3:02 PM GMT   |  asked by Forresterdanielle88
Excel, VBA, Excel macros

specify the read only attribute in my Perl code so i don’t have to click on read only

I have created a perl script that read from an excel file that is located on our windows server, the goal is to automate the perl script to run once a week and read the first 5 columns of the row that matches the current date and then write the data to a .txt file. A bash script will then open that...

View Answer   |  Apr 1 2008   8:38 PM GMT   |  asked by Guylevy
Win32::OLE, Excel, Perl

Deactivate Transfer Data To iSeries in EXCEL

How do I deactivate the Transfer data To iseries link in EXCEL but still the Transfer Data From iSeries ACTIVE in Excel

View Answer   |  Mar 27 2008   7:11 PM GMT   |  asked by ESands
iSeries database, Microsoft Excel, Excel

Exporting Exchange 2003 public folder calendar into Excel and then into a personel calendar.

I need to export public folder calendar data into excel and them into a personal folder.

Answer Question   |  Mar 27 2008   6:23 PM GMT   |  asked by Dre
Exchange 2003, Excel, Public folders

Validation in Excel

Can a cell have a validation rule from a list and also have the ability to free type in that cell? This is in Excel 2003.

View Answer   |  Mar 27 2008   4:15 PM GMT   |  asked by Mart802
Excel, Validation, free type

How to change config to download all fields to Excel than Inbox

Using menu path Plant AnalysisExportTransfer to XXL in MCBA to download all switch drill down fields but currently am brought to SBWP. How do I change it to allow down load to Excel?

Answer Question   |  Mar 26 2008   9:27 AM GMT   |  asked by Janwong
MCBA, Excel, SAP MM