Combining data from two Excel sheets into a new sheet
Hi, I Have few leave detail excels wherein the leave details of each resource are present.I need help to create a macro wherein all months leave details will be clubbed together into a new excel for each resource.Kindly help me with the code or give me some ideas to do this since am very new [...]

Answer Question   |  November 14, 2008  5:26 AM
Excel macros, Microsoft Excel, VBA, Visual Basic for Applications

Excel to Lotus Notes Form
I have a Excel workbook with alpha numeric text in a group of cells. I try and copy the text from those cells directly from Excel into a Lotus Notes 7 form and find that I cannot because Notes is treating the paste as being an object and not text. The cells in Excel are [...]

Answer Question   |  December 17, 2008  2:14 AM
Excel import/export, Lotus Forms, Lotus Notes, Lotus Notes 7.x, Lotus Notes import/export, Microsoft Excel

How do I macro 20,000+ series of data?
The full s/s stretches to nearly 350,000 rows and consists of over 20,000 series of data, between 6 and 30 rows deep, in columns A:J. In column I of each series, on rows 3, 4 and 5 there are three numbers. The second number is to be subtracted from the first with the answer being [...]

Answer Question   |  June 25, 2009  9:57 PM
Excel macros, Microsoft Excel

find which excel spreadsheets contain macros
in a folder or drive how can I find which excel spreadsheets contain macros without opening every one individually?

Answer Question   |  November 17, 2008  5:21 PM
Excel macros, Macros, Microsoft Excel, VBScript

Converting spool file output to Excel in RPG without third-party software
I would like to know how to write an RPG program and have my spool file output be converted to an Excel file without using any 3rd-party software.

Answer Question   |  November 11, 2008  5:46 PM
AS/400 Spooled Files, Microsoft Excel, RPG

How to paste data directly from Excel to PowerPoint graphic as data
I’ve been trying to search for ways to copy data from a spreadsheet onto the datasheet of a graph in an open spreadsheet. I am unfamiliar with VBA code, but got it to copy and paste to the correct slide, but only as text. I have been unable to select the actual graph and paste [...]

Answer Question   |  November 18, 2008  11:46 AM
Excel macros, Microsoft Excel, Microsoft PowerPoint, PowerPoint, VBA, Visual Basic for Applications

Export from database to Excel and filter by DropDownList
please provide me with all information on how to export my data to an excel sheet and how to filter the data using a dropdownlist (asp.net)

Answer Question   |  November 11, 2008  11:33 AM
Active Server Pages, ASP.NET, Database import/export, DropDownList, Microsoft Excel, Microsoft Excel import/export

Excel 2000 Chart Won’t Automatically Update
My Excel 2000 chart won’t automatically update when I change the data in one/both of the columns in the attached spreadsheet. I have checked the automatic button under Tools/Option/Calculate, but it still does not work. The only way I can get it to work is if I go into the chart and change one of [...]

Answer Question   |  November 10, 2008  8:10 PM
Excel Charts, Microsoft Excel

AS/400 to Excel
Hi Someone, I am using FTP to send a data file fromthe iseries to the server as a .txt file usint put statement. Can anyone suggest how I would sent the file direct to an Excel spreadsheet, preferable to a pre-formatted sheet. Thanks.

Answer Question   |  November 13, 2008  4:00 AM
iSeries, iSeries FTP, iSeries import/export, Microsoft Excel, OS/400

Advice on buying new PC
I have a Pentium 4 & need to upgrade. I teach Microsoft, use graphics in my manuals, & use CorelDraw a lot. I also design huge Excel spreadsheets with lots of formulas and design databases in Access – what would be a good PC processor, ram, etc? I have been quoted on a system with [...]

Answer Question   |  November 8, 2008  1:50 PM
CorelDRAW, Hardware, Hardware configuration management, Microsoft Access, Microsoft Excel, Pentium

JDBC/ODBC to Excel 2007 getting Exception
Iam getting the SQLexception by trying to connect using JDBC/ODBC to Excel 2007 through Java. Any Guys can tell abt this problem. java.sql.SQLException: [Microsoft][ODBC Excel Driver] External table is not in the expected format. at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source) at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source) at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(Unknown Source) at sun.jdbc.odbc.JdbcOdbcConnection.initialize(Unknown Source) at sun.jdbc.odbc.JdbcOdbcDriver.connect(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) [...]

Answer Question   |  November 3, 2008  1:14 PM
Excel 2007, Java, JDBC, Microsoft Excel, ODBC, SQL Exception

To connect to Excel 2007 using free version API Java
Presently we are using JavaExcel(JXL) API to read/write from the Excel 2003. Now we have to update to Excel 2007. The problem was JXL is not supporting for the Excel 2007. The other API’s are in the Beta version. Guys any API’s are there to support Excel 2007 ……

Answer Question   |  November 3, 2008  1:00 PM
API, Excel 2003, Excel 2007, Excel RTD Function, Java, Java API, Java Excel API, Microsoft Excel, VBA, Visual Basic for Applications

PDF format file change to Excel
My friend got one PDF file and contain some table based data. How can we convert that file to excel format ?

Answer Question   |  September 26, 2011  6:13 AM
Data conversion, Excel import/export, File formats, Microsoft Excel, PDF, PDF to Excel

Copying a portion
how can a copy just the last character from one cell to another?

Answer Question   |  November 3, 2008  7:51 PM
Microsoft Excel, Spreadsheets

Importing email addresses from Excel
I have a list of email addresses and names in Excel that I would like to send an email using outlook. Is there an easy way to do this?

Answer Question   |  November 1, 2008  5:06 PM
Email management applications, Microsoft Excel, Outlook

New to macros
Hi, I’m just learning how to use macros and the first thing I’m trying to do is create a macro that will pull a character from a cell and place it in a new cell- for example “right(c10,1)”. My problem is I have a large list that I want to do this with but everytime [...]

Answer Question   |  October 31, 2008  2:48 PM
Excel macros, Macros, Microsoft Excel

excel file from rpg as400 printer file
I need to take an AS400 Printer file and create an Excel file.

Answer Question   |  September 13, 2010  7:32 PM
AS/400 Printer File, Microsoft Excel

Address Group List
What is the best way to take over 600 contact emails from excel and create a lotus notes address group to send emails to?

Answer Question   |  October 31, 2008  4:06 PM
Lotus Notes, Lotus Notes Address Group, Microsoft Excel

Import lotus notes view data from Excel
I need to import frequently data from some Lotus notes views into my Excel Sheets, I want to know if they are a macro or a vb script which could do that.

Answer Question   |  November 6, 2008  3:18 PM
Excel macros, Lotus Notes, Microsoft Excel

How would you calculate, using the spreadsheets statistical functions, the cheapest option at the fastest speed with the least downtime?
i have 5 tables each including speed, price, download limit, average downtime and the average uptime. i was asked by my teacher to calculate all these so i get one number, to find out which is the best value for money for someone to go for. i just need to know what do i calcute [...]

Answer Question   |  October 29, 2008  10:11 PM
Excel functions, Excel macros, Excel statistical functions, Microsoft Excel, Spreadsheets