• What are the basic parameters needed to assist an automation tool?

    My concern is what are the basic key parameters to be considered for assisting an automation tool. In my company we are automating database (MySQL - Queries) part using 1st approach: Using stored procedures. 2nd approach: Using Excel VBA Macros.  For that we need to assist some basic parameters...

    VijayVardhan5 pointsBadges:
  • Excel has file big size

    Hello, I have an .xls files I open with Excel 2007 every day. It is approximately 200 rows x 60 columns. Each day we create a copy of this file, and in the new copy, change the numeric value of 20 cells. No new columns or rows are added, there are no graphics/charts/etc. There is only one sheet. 10...

    RossHutton15 pointsBadges:
  • Zero keeps disappearing in my Excel spreadsheet column

    So I'm adding some of my personal information into an Excel 2007 workbook and I've noticed that when I put in a number count that starts with zero, it automatically disappears. Here's an example: 012345678 changes to 12345678 What do I have to do keep the zero as entered and not disappear.

    ITKE413,550 pointsBadges:
  • Hide connection/query settings in Excel

    I have created some Excel spreadsheets that use an external connection and MS query to download data into the SS. (No VBA involved). I would like to hide the query and connection information from users, or make it inaccessible. I want to avoid users making changes to the connection and/or query...

    azohawk1,925 pointsBadges:
  • Find interest rate on loan using VLOOKUP in Excel

    I need to find the interest rate on a loan using vlookup in excel, selling price $250,000 on a 20 year loan.

    1101jones20 pointsBadges:
  • Conditional Excel Formatting based on top values in a range

    I am looking to create conditional formatting based on the top n values in a range. Values in c1 to l1 (10 values). I want the number of values to change so want to base it on the value in cell b1 rather than simply using the top 6 conditional formatting so that I do not need to keep changing the...

    kerry7715 pointsBadges:
  • Auto populating cells in Excel based on time

    So I am given times of the day and I need to match the shift with the time so I was wondering if there was a macro that would make this easy. For example, between 07:00 and 15:00 is shift 1 and 15:00 to 23:00 is shift two and the other period is shift 3. I'm sure that there is a loop for this but...

    zbehnen15 pointsBadges:
  • Loading image into MySQL database from Excel file

    I have an excel file that contains an image in the first col. When I save it to an csv format, the excel program creates two images ( 1 small, 1 large) for each line in the excel file. How do I load both the file data and the large image into my mysql database?

    Wlm49hv5 pointsBadges:
  • How to open CDB files

    I have a large CDB file of car part numbers. I need to open it and convert it to Excel.

    leseding5 pointsBadges:
  • Linking Data in sequential Excel spreadsheets without having to open all of them

    How can I link data in sequential Excel spreadsheets without having to open all of them?

    rcollie5 pointsBadges:
  • Best way to create a flat file

    Is there a format I can buy or can I convert an Excel spreadsheet into a flat text file?

    CJSDOYLE5 pointsBadges:
  • Excel pivot chart drill down

    Hello, The aim is to click a slice on a pie pivot chart, that will show another pie pivot chart, NOT data. Is this possible with Excel, again I want to click a slice on a pie pivot chart, that then leads to another pie pivot chart. Preferably go 3 or 4 levels down. Thank you.

    Michael9995 pointsBadges:
  • Problem with AS/400 data transfer to Excel

    I have been downloading AS400 query files to Excel spreadsheets for many years using the Data Transfer utility in Client Access. There has never been any problem. Now suddenly all of the output data has started transferring to Excel as long hexadecimal strings and is unusable. I asked the IT folks...

    JDK55 pointsBadges:
  • Connect Oracle database from Microsoft Excel application

    Is it possible for me to connect to an Oracle database from a Microsoft Excel application without a DNS? I tried to do it already but it keeps giving me an error saying: The driver was not found. What should I do here? What driver am I supposed to use?

    ITKE413,550 pointsBadges:
  • Export SAP reports to Excel

    I have an issue with SAP Reports. I am usually exporting mass data from the system, and my company doesn't allow to have a external system to help for that for security issues. Is there any way I may do to export these reports faster to Excel.

    KarimHosny5 pointsBadges:
  • Excel cannot open the file ‘file.xlsx’ because the file format

    Every now and then, when I try opening an Excel file, I get a message saying that "Excel cannot open the file 'file.xlsx' because the file format or the file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file.

    weinmagaul5 pointsBadges:
  • How to IBM Genius iSeries application connect to Excel VBA

    How to IBM iSeries Access for Windows connect to Excel VBA or can enter data using VBA code?

    Vijay19915 pointsBadges:
  • Best way to run a program in Microsoft Excel or Access

    Good day, I would like to find out what is the best way to run a 'program' in Microsoft Excel or Access (at the moment, I am used to Excel only but I'm willing to learn about Access if that's what it takes) that will allow me to type in one or two letters and it produces a word in the particular...

    asphaltanimal5 pointsBadges:
  • Restrict users from editing in Excel header

    In my Excel worksheet, I currently have a fixed number of columns. All of these columns has a header name. Can I restrict different users from entering anything in those header cells? Thanks so much.

    ITKE413,550 pointsBadges:
  • T-code S_ALR_87013611

    If I look the SAP id of my office mate, the code S_ALR_87013611 was in the excel format. How can I do this in my SAP ID. Thanks!

    eiseljaneenriquez5 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following