How to export data from AS/400 in Excel
Hi everyone, I would like to know how to in a step by step process export date from AS/400 iseries into an Excel workbook. The purpose is to gather the data from AS/400, export it to Excel, then filter the data for specific info, then import that to another Excel workbook. A basic inventory report [...]
Answer Question
| March 27, 2009 2:02 PM
AS/400, Exporting AS/400 to Excel, iSeries Access, Microsoft Excel, ODBC
Hi everyone, I would like to know how to in a step by step process export date from AS/400 iseries into an Excel workbook. The purpose is to gather the data from AS/400, export it to Excel, then filter the data for specific info, then import that to another Excel workbook. A basic inventory report [...]
Answer Question
| March 27, 2009 2:02 PM
AS/400, Exporting AS/400 to Excel, iSeries Access, Microsoft Excel, ODBC
Paste from Microsoft Excel cells to Microsoft Access table successfully but…
When I perform a Paste Append into the table, the field I need that is a hyperlink is being truncated, thus link fails. How can I get the link to pates exactly as is from Excel?
Answer Question
| March 30, 2009 10:51 PM
Hyperlinks, Microsoft Access, Microsoft Access tables, Microsoft Excel
When I perform a Paste Append into the table, the field I need that is a hyperlink is being truncated, thus link fails. How can I get the link to pates exactly as is from Excel?
Answer Question
| March 30, 2009 10:51 PM
Hyperlinks, Microsoft Access, Microsoft Access tables, Microsoft Excel
Problems using VLOOKUP
I have an excel 2003 spreadsheet that contains a Volunteer Worksheet for the purpose of driving clients to doctors offices, and another Transportaion Worksheet that enters the dates and medical facilities to where clients will to be driven. I am utilizing a form, with a drop down list, to find a volunteer and another dropdown [...]
Answer Question
| April 2, 2009 2:56 PM
Excel 2003, Excel functions, Microsoft Excel, VLOOKUP, VLOOKUP function
I have an excel 2003 spreadsheet that contains a Volunteer Worksheet for the purpose of driving clients to doctors offices, and another Transportaion Worksheet that enters the dates and medical facilities to where clients will to be driven. I am utilizing a form, with a drop down list, to find a volunteer and another dropdown [...]
Answer Question
| April 2, 2009 2:56 PM
Excel 2003, Excel functions, Microsoft Excel, VLOOKUP, VLOOKUP function
How do I write this Microsoft Excel macro?
Hi, I’m trying to create a macro that will move rows in my spread sheet. I am working with orders that are keyed into excel, once the orders ship or are canceled; the rows are highlighted green or red. I want these shipped/canceled (green/red) rows to cut from the first page and paste into another [...]
Answer Question
| March 25, 2009 9:56 PM
Microsoft Excel, Microsoft Excel macros
Hi, I’m trying to create a macro that will move rows in my spread sheet. I am working with orders that are keyed into excel, once the orders ship or are canceled; the rows are highlighted green or red. I want these shipped/canceled (green/red) rows to cut from the first page and paste into another [...]
Answer Question
| March 25, 2009 9:56 PM
Microsoft Excel, Microsoft Excel macros
excel table to text flat
Hello, I am not an IT expert to start with! I have a series of tables in excel made of 3 dimensions. Two dimensions are vertical (indicator and country), one is horizontal (years). The different tables contain data for a variable number of years and for a variable number of countries and indicators, therefore each [...]
Answer Question
| March 20, 2009 5:33 PM
Excel macros, Excel Tables, Microsoft Excel
Hello, I am not an IT expert to start with! I have a series of tables in excel made of 3 dimensions. Two dimensions are vertical (indicator and country), one is horizontal (years). The different tables contain data for a variable number of years and for a variable number of countries and indicators, therefore each [...]
Answer Question
| March 20, 2009 5:33 PM
Excel macros, Excel Tables, Microsoft Excel
Using a drop down window in Excel to look up a List .. The names shown are so small it is difficult to read them
How can I get the Font larger in the drop down window in XL for say cells A1:A200
Answer Question
| March 20, 2009 10:18 AM
Excel 2007, Microsoft Excel, Microsoft Excel 2007
How can I get the Font larger in the drop down window in XL for say cells A1:A200
Answer Question
| March 20, 2009 10:18 AM
Excel 2007, Microsoft Excel, Microsoft Excel 2007
split column into column
I need to Split the single datetime column into separate date and time column in SSIS package and exprot the data into Excel Sheet. Can any one guide how to do it ? Thanks in advance.
Answer Question
| March 20, 2009 5:12 PM
Microsoft Excel, SQL Server 2005, SSIS
I need to Split the single datetime column into separate date and time column in SSIS package and exprot the data into Excel Sheet. Can any one guide how to do it ? Thanks in advance.
Answer Question
| March 20, 2009 5:12 PM
Microsoft Excel, SQL Server 2005, SSIS
SQL Export to Excel file column?
I need to create a SSIS Package in which the data is export to Excel file the problem is the date and time column in sql there is one column and i need to separate it into two column can any body help e i thid? thank in advance
Answer Question
| April 4, 2009 1:13 AM
Microsoft Excel, SQL Export to Excel, SSIS, SSIS 2005, SSIS Package 2005
I need to create a SSIS Package in which the data is export to Excel file the problem is the date and time column in sql there is one column and i need to separate it into two column can any body help e i thid? thank in advance
Answer Question
| April 4, 2009 1:13 AM
Microsoft Excel, SQL Export to Excel, SSIS, SSIS 2005, SSIS Package 2005
Excel macros – code does not execute
I have written the following macro. I do not really see it necessary to explain ehat it does, I only need help with a problem – for some reason it does not reach the code after the loop. It does everything exactly as I want it until and into the loop, but does not execute [...]
Answer Question
| March 16, 2009 10:47 AM
Excel macros, Microsoft Excel
I have written the following macro. I do not really see it necessary to explain ehat it does, I only need help with a problem – for some reason it does not reach the code after the loop. It does everything exactly as I want it until and into the loop, but does not execute [...]
Answer Question
| March 16, 2009 10:47 AM
Excel macros, Microsoft Excel
Office minimizes after right clicking
Whenever I right click while in Outlook, Word, or Excel the program minimizes to the system tray. Therefore, I cannot cut and paste, among all the other useful things. What is the cause and how do I regain control of the right mouse click?
Answer Question
| March 17, 2009 9:05 PM
Microsoft Excel, Microsoft Office, Microsoft Word, Outlook
Whenever I right click while in Outlook, Word, or Excel the program minimizes to the system tray. Therefore, I cannot cut and paste, among all the other useful things. What is the cause and how do I regain control of the right mouse click?
Answer Question
| March 17, 2009 9:05 PM
Microsoft Excel, Microsoft Office, Microsoft Word, Outlook
Problem with shortcut error messages
i was moving folders around in my documents when something i did ereased or moved some of my folders. the documents were excel spreadsheets with formulas. i ran a search and a couple of them came up but when I click on them i get the error message problem with shortcut the item ” ” [...]
Answer Question
| January 22, 2011 9:43 PM
Desktop, Desktop shortcut, Microsoft Excel, Windows desktop
i was moving folders around in my documents when something i did ereased or moved some of my folders. the documents were excel spreadsheets with formulas. i ran a search and a couple of them came up but when I click on them i get the error message problem with shortcut the item ” ” [...]
Answer Question
| January 22, 2011 9:43 PM
Desktop, Desktop shortcut, Microsoft Excel, Windows desktop
Excel Macro Help – .ThemeColor = xlThemeColorDark1
The spreadsheet I’m working on pulls data from an oracle database and automatically populates cells for which there is no data with “999999.” I am attempting to use an excel macro to essentially gray-out all cells that contain this value with the intention of saving users the time it takes to apply conditional formatting to [...]
Answer Question
| March 13, 2009 6:47 PM
Excel 2007, Excel macros, Microsoft Excel
The spreadsheet I’m working on pulls data from an oracle database and automatically populates cells for which there is no data with “999999.” I am attempting to use an excel macro to essentially gray-out all cells that contain this value with the intention of saving users the time it takes to apply conditional formatting to [...]
Answer Question
| March 13, 2009 6:47 PM
Excel 2007, Excel macros, Microsoft Excel
Group Policy Objects
i want to restrict users in my domain to protect their ms excle sheet. how can i do this
Answer Question
| March 10, 2009 10:20 AM
GPO, Group Policy, Group Policy Objects, Microsoft Excel
i want to restrict users in my domain to protect their ms excle sheet. how can i do this
Answer Question
| March 10, 2009 10:20 AM
GPO, Group Policy, Group Policy Objects, Microsoft Excel
Open XL file from ILE program
We have a process that converts a spooled file into a .CSV file and stores it in a folder on the IFS. The user then opens Excel and locates and opens the file for editing etc. Is there a way to open up the file in Excel for them after its transferred to the IFS? [...]
Answer Question
| March 11, 2009 8:00 PM
CSV, IFS, ILE, ILE Program, Microsoft Excel
We have a process that converts a spooled file into a .CSV file and stores it in a folder on the IFS. The user then opens Excel and locates and opens the file for editing etc. Is there a way to open up the file in Excel for them after its transferred to the IFS? [...]
Answer Question
| March 11, 2009 8:00 PM
CSV, IFS, ILE, ILE Program, Microsoft Excel
Excel 2002 Copy GetPivotDATA function
I have a number of different items that I need to extract from a pivot table. Can I copy the GETPIVOTDATA function? it seems to get stuck and return only the value from the first cell
Answer Question
| March 4, 2009 8:04 PM
Excel 2002, Excel functions, GetPivotData Function, Microsoft Excel, Pivot tables
I have a number of different items that I need to extract from a pivot table. Can I copy the GETPIVOTDATA function? it seems to get stuck and return only the value from the first cell
Answer Question
| March 4, 2009 8:04 PM
Excel 2002, Excel functions, GetPivotData Function, Microsoft Excel, Pivot tables
MS Access Tools References…
Cheers, Does anyone know where I can get a list of what a specific reference in Access can do. Specifically, I have VB.NET code that Imports System.Web.mail that I would like to use in my vba code. I have had luck with similar .NET code: I used the reference Microsoft Excel 12.0 Object Library instead [...]
Answer Question
| March 4, 2009 5:38 PM
.NET, Microsoft Access, Microsoft Excel, Microsoft Office, VB.NET, VBA
Cheers, Does anyone know where I can get a list of what a specific reference in Access can do. Specifically, I have VB.NET code that Imports System.Web.mail that I would like to use in my vba code. I have had luck with similar .NET code: I used the reference Microsoft Excel 12.0 Object Library instead [...]
Answer Question
| March 4, 2009 5:38 PM
.NET, Microsoft Access, Microsoft Excel, Microsoft Office, VB.NET, VBA
Excel 2003 – Conditional Formatting, please help a girl out :)
Hi, I am working with a tracking schedule for my job, and I am trying to impliment conidtional formatting into it, but some of it it just not working for me. I am working with Microsoft Excel 2003 and I was wondering if you could help me with my problem. Column B = Start Date [...]
Answer Question
| March 9, 2009 9:27 PM
Conditional Formtting, Excel 2003, Microsoft Excel
Hi, I am working with a tracking schedule for my job, and I am trying to impliment conidtional formatting into it, but some of it it just not working for me. I am working with Microsoft Excel 2003 and I was wondering if you could help me with my problem. Column B = Start Date [...]
Answer Question
| March 9, 2009 9:27 PM
Conditional Formtting, Excel 2003, Microsoft Excel
Microsoft Excel 2007 charts
I AM UNABLE TO USE CHART OPTION IN EXCEL 2007
Answer Question
| March 3, 2009 11:24 AM
Excel 2007, Microsoft Excel, Microsoft Excel 2007, Microsoft Excel 2007 charts
I AM UNABLE TO USE CHART OPTION IN EXCEL 2007
Answer Question
| March 3, 2009 11:24 AM
Excel 2007, Microsoft Excel, Microsoft Excel 2007, Microsoft Excel 2007 charts
Automated export/import between Microsoft Outlook 2003 and Microsoft Excel 2003
I need to keep track of my activities in a excelfile and am looking for a way in wich my appointments (in my Microsoft Outlook 2003 calendar) automaticly get imported in specifed fields of the Microsoft Excel file. This is part of a monthly report to account for my time, and how much time I [...]
Answer Question
| September 1, 2010 9:18 AM
Excel import/export, Microsoft Excel, Microsoft Excel 2003, Microsoft Excel 2003 import/export, Microsoft Outlook, Microsoft Outlook 2003, Microsoft Outlook 2003 import/export, Outlook, Outlook Import/Export
I need to keep track of my activities in a excelfile and am looking for a way in wich my appointments (in my Microsoft Outlook 2003 calendar) automaticly get imported in specifed fields of the Microsoft Excel file. This is part of a monthly report to account for my time, and how much time I [...]
Answer Question
| September 1, 2010 9:18 AM
Excel import/export, Microsoft Excel, Microsoft Excel 2003, Microsoft Excel 2003 import/export, Microsoft Outlook, Microsoft Outlook 2003, Microsoft Outlook 2003 import/export, Outlook, Outlook Import/Export
How to extract data to the various excel sheets in a CL.
Hi, I am new to the CL (Command Language) used by the as/400. I need to generate a spreadsheet of data from the as400. I would like to have all the data stored in one excel file instead of multiple excel files. Can someone show me how to use the various sheets in excel to [...]
Answer Question
| March 13, 2009 8:14 PM
CL programming, Microsoft Excel
Hi, I am new to the CL (Command Language) used by the as/400. I need to generate a spreadsheet of data from the as400. I would like to have all the data stored in one excel file instead of multiple excel files. Can someone show me how to use the various sheets in excel to [...]
Answer Question
| March 13, 2009 8:14 PM
CL programming, Microsoft Excel
