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...
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...
5 pts.
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
How can I get the Font larger in the drop down window in XL for say cells A1:A200
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.
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.
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
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
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 the code after the loop at...
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 the code after the loop at...
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?
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?
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 " " that this...
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 " " that this...
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...
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...
Group Policy Objects
i want to restrict users in my domain to protect their ms excle sheet. how can i do this
i want to restrict users in my domain to protect their ms excle sheet. how can i do this
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? Could you show me code examples...
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? Could you show me code examples...
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
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
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...
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...
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 Column C = Due Date...
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 Column C = Due Date...
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 spent...
View Answer
| Mar 3 2009 9:18 AM GMT
Microsoft Outlook 2003 import/export, Microsoft Excel 2003 import/export, Microsoft Outlook 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 spent...
View Answer
| Mar 3 2009 9:18 AM GMTMicrosoft Outlook 2003 import/export, Microsoft Excel 2003 import/export, Microsoft Outlook 2003
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 store the data and how...
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 store the data and how...
How can I find an Excel formula that helps me change text?
How can I find a formula that helps me change letters in typed words without the daunting task of retyping them again? For example, I typed (in a table) 100 words ending in -d, and I want the same words just without the -d or with -s instead. Or can I join letters to form different words? Copy and...
How can I find a formula that helps me change letters in typed words without the daunting task of retyping them again? For example, I typed (in a table) 100 words ending in -d, and I want the same words just without the -d or with -s instead. Or can I join letters to form different words? Copy and...
Excel 2003 - Conditional Formatting, please help me :)
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 Column C = Due Date...
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 Column C = Due Date...
Excel 2003 VBA drop down list and discontinuous ranges
I am attempting to populate a drop down list in excel using data validation and data contained in two discontinuous ranges. I have used the Union command in vba to create a named list which seems to correctly concatenate the two data ranges but when I validate the cell which is to contain the drop...
I am attempting to populate a drop down list in excel using data validation and data contained in two discontinuous ranges. I have used the Union command in vba to create a named list which seems to correctly concatenate the two data ranges but when I validate the cell which is to contain the drop...
Linking a checkbox to another checkbox - Excel 2003
In Excel 2003, I have a spreadsheet with multiple sheets (including a detailed page and summary page). Each sheet has about 20 subjects that contain YES / NO / N/A answer checkboxes. I need to be able to link corresponding summary and detailed checkbox's with each other. EXP: When you check the...
In Excel 2003, I have a spreadsheet with multiple sheets (including a detailed page and summary page). Each sheet has about 20 subjects that contain YES / NO / N/A answer checkboxes. I need to be able to link corresponding summary and detailed checkbox's with each other. EXP: When you check the...
