Export contacts info from Outlook 2007
Can someone suggest the easiest way to export my personal Contact information from Office Outlook 2007? I want to migrate my personal Contact information from office Outlook to my home computer. Early response will be much appreciated as I am leaving office from this Friday (1/30). Thank you.
Answer Question
| February 26, 2013 5:50 AM
Microsoft Excel, Outlook, Outlook 2007, Outlook 2007 contacts, Outlook 2007 import/export, Outlook contacts
Can someone suggest the easiest way to export my personal Contact information from Office Outlook 2007? I want to migrate my personal Contact information from office Outlook to my home computer. Early response will be much appreciated as I am leaving office from this Friday (1/30). Thank you.
Answer Question
| February 26, 2013 5:50 AM
Microsoft Excel, Outlook, Outlook 2007, Outlook 2007 contacts, Outlook 2007 import/export, Outlook contacts
can’t open ifs doc
I have an excell spread sheet on the IFS, I have a drive mapped. I can see the spreadsheet (it’s small). When I click on it to open it will sit there saying it’s downloading but then I get the error “Can’t Open File”. It has worked in the past this just started happening. Thanks
Answer Question
| January 29, 2009 9:43 PM
Excel error messages, IFS, Microsoft Excel, Reading from the IFS
I have an excell spread sheet on the IFS, I have a drive mapped. I can see the spreadsheet (it’s small). When I click on it to open it will sit there saying it’s downloading but then I get the error “Can’t Open File”. It has worked in the past this just started happening. Thanks
Answer Question
| January 29, 2009 9:43 PM
Excel error messages, IFS, Microsoft Excel, Reading from the IFS
Shortening the generation time for a SQL Server 2000 report
I have 516 different functions in SQL Server 2000 that are used for different calculations. These functions will operate on more than a thousand Microsoft Excel files. Each Excel file has 960 rows, and generating the report took over four hours. Is there a way to shorten this?
Answer Question
| January 27, 2009 7:43 PM
Microsoft Excel, SQL Server 2000, SQL Server performance, SQL Server Reports
I have 516 different functions in SQL Server 2000 that are used for different calculations. These functions will operate on more than a thousand Microsoft Excel files. Each Excel file has 960 rows, and generating the report took over four hours. Is there a way to shorten this?
Answer Question
| January 27, 2009 7:43 PM
Microsoft Excel, SQL Server 2000, SQL Server performance, SQL Server Reports
Pivot table error when sourcing data from Access
Pivot table error when sourcing data from Access reads: Invalid bracketing of name ‘mdb.’.
Answer Question
| January 23, 2009 3:56 PM
Microsoft Access, Microsoft Excel, Pivot Table Error Messages, Pivot tables
Pivot table error when sourcing data from Access reads: Invalid bracketing of name ‘mdb.’.
Answer Question
| January 23, 2009 3:56 PM
Microsoft Access, Microsoft Excel, Pivot Table Error Messages, Pivot tables
How do I enter a defined variable into a FormulaR1C1 statement?
I’ve defined the variable ‘Year’ as shown below, and I use it a number of times in my script. However, I’d like to use it in the “FormulaR1C1” command as well (shown below). How would I enter the syntax, so that it references my variable ‘Year’? Currently I’ve manually entered the year, as ‘2009’. ————————————— [...]
Answer Question
| January 22, 2009 5:49 PM
Excel formulas, FormulaR1C1, Microsoft Excel
I’ve defined the variable ‘Year’ as shown below, and I use it a number of times in my script. However, I’d like to use it in the “FormulaR1C1” command as well (shown below). How would I enter the syntax, so that it references my variable ‘Year’? Currently I’ve manually entered the year, as ‘2009’. ————————————— [...]
Answer Question
| January 22, 2009 5:49 PM
Excel formulas, FormulaR1C1, Microsoft Excel
How to export data from AS/400 into Microsoft Excel
Hi, Plse tell me ,what is the problem. I try to export data from As400 into Excle.I wrote a macro in the excle sheet.I run a progrme it gives error massege [‘Excel is not recognized as an internal or external command operable programe or batch file. thanks & best regards, Nadeeshani.
Answer Question
| January 26, 2009 7:58 AM
AS/400 administration, AS/400 error messages, AS/400 import/export, Microsoft Excel, Microsoft Excel import/export
Hi, Plse tell me ,what is the problem. I try to export data from As400 into Excle.I wrote a macro in the excle sheet.I run a progrme it gives error massege [‘Excel is not recognized as an internal or external command operable programe or batch file. thanks & best regards, Nadeeshani.
Answer Question
| January 26, 2009 7:58 AM
AS/400 administration, AS/400 error messages, AS/400 import/export, Microsoft Excel, Microsoft Excel import/export
Problem MS Queries Refresh in excel file located on client network
I am having a problem refreshing the Ms Queries in an excel file located on client network, when connected through vpn. It is showing an error window such as “ODBC Microsoft Access Driver Login Failed” Disk or network error.
Answer Question
| January 20, 2009 7:48 AM
Access query, Excel error messages, Microsoft Access, Microsoft Excel, MS Query, Ms Query Refresh, ODBC Microsoft Access Driver Login Failed
I am having a problem refreshing the Ms Queries in an excel file located on client network, when connected through vpn. It is showing an error window such as “ODBC Microsoft Access Driver Login Failed” Disk or network error.
Answer Question
| January 20, 2009 7:48 AM
Access query, Excel error messages, Microsoft Access, Microsoft Excel, MS Query, Ms Query Refresh, ODBC Microsoft Access Driver Login Failed
I need to up load an excel file to sql server db with vb
I need to upload a excell file to sql server. I made a Stored procedure with the openrowset but if i run de stored procedure works, but embebed in visual basic or in crystal repor an error appears.Somethig about serverliked or server trusted i don’t rememeber. does somebody an idea? thanks in advance
Answer Question
| January 22, 2009 6:52 PM
Crystal Reports, Importing Excel to SQL, Microsoft Excel, SQL Server stored procedures, Visual Basic
I need to upload a excell file to sql server. I made a Stored procedure with the openrowset but if i run de stored procedure works, but embebed in visual basic or in crystal repor an error appears.Somethig about serverliked or server trusted i don’t rememeber. does somebody an idea? thanks in advance
Answer Question
| January 22, 2009 6:52 PM
Crystal Reports, Importing Excel to SQL, Microsoft Excel, SQL Server stored procedures, Visual Basic
Problem in CCSID converting
I have a QM query that forms up a DB file. A physical file. A file that afterwards will be tranferred to the excel worksheet. All the source DB files (as well as all the records inside) that I use in the QM query are having the CCSID=297 (french). But the data itself stored in [...]
Answer Question
| January 22, 2009 5:09 AM
5250 session, AS/400, AS/400 import/export, CCSID, Change Physical File, CHGPF, Coded Character Set Identifier, DDS, iSeries Access for Windows, locale, Microsoft Excel, Physical File, QMQRY, Query Management Query, V5R3
I have a QM query that forms up a DB file. A physical file. A file that afterwards will be tranferred to the excel worksheet. All the source DB files (as well as all the records inside) that I use in the QM query are having the CCSID=297 (french). But the data itself stored in [...]
Answer Question
| January 22, 2009 5:09 AM
5250 session, AS/400, AS/400 import/export, CCSID, Change Physical File, CHGPF, Coded Character Set Identifier, DDS, iSeries Access for Windows, locale, Microsoft Excel, Physical File, QMQRY, Query Management Query, V5R3
Puzzle – Find the number?
This is not a question & I am not sure if this is a proper forum. So I will let the site moderator decide. I recently came across a nice quiz which, I think, supports/encourages developing programming skills. So … here is the puzzle. Find the lowest number with the following characteristics: When divided by [...]
Answer Question
| April 6, 2009 6:05 PM
COBOL, Microsoft Excel, Programming Languages, VB
This is not a question & I am not sure if this is a proper forum. So I will let the site moderator decide. I recently came across a nice quiz which, I think, supports/encourages developing programming skills. So … here is the puzzle. Find the lowest number with the following characteristics: When divided by [...]
Answer Question
| April 6, 2009 6:05 PM
COBOL, Microsoft Excel, Programming Languages, VB
How to export an AS/400 physical file to Microsoft Excel?
how to export as400 physical file to excel
Answer Question
| January 12, 2009 1:45 AM
AS/400 import/export, Microsoft Excel, Physical File
how to export as400 physical file to excel
Answer Question
| January 12, 2009 1:45 AM
AS/400 import/export, Microsoft Excel, Physical File
Microsoft Access 2007 Data Input & Report
I am given a Start date 1/3/09 and an end date 1/5/09. 3 days. I am given 1 of 4 Codes (I, C, V, O). How do I get Access to show one of the predetermined codes under a monthly calendar starting day 1 through 31? ie., Rec# Jan 1 2 3 4 5 6 [...]
Answer Question
| January 12, 2009 4:03 AM
Microsoft Access, Microsoft Access 2007, Microsoft Excel, Microsoft Excel 2007
I am given a Start date 1/3/09 and an end date 1/5/09. 3 days. I am given 1 of 4 Codes (I, C, V, O). How do I get Access to show one of the predetermined codes under a monthly calendar starting day 1 through 31? ie., Rec# Jan 1 2 3 4 5 6 [...]
Answer Question
| January 12, 2009 4:03 AM
Microsoft Access, Microsoft Access 2007, Microsoft Excel, Microsoft Excel 2007
Date format in Microsoft Excel 2002
In my program I pass values from VB to Excel for reporting. When I pass 03-01-2009 (3rd Jan 2009), in excel it shows as 01-03-2009. I have set short date format to dd-mm-yyyy, in control panel, regional settings. Also in excel, I set cell format through VB as … Exl.Range(“A1″).NumberFormat = “dd-mm-yyyy” and Exl.Range(Rng).NumberFormat = [...]
Answer Question
| January 9, 2009 11:51 AM
Excel 2002, Excel Cell Formats, Microsoft Excel, VB, VB 6, Visual Basic, Visual Basic 6
In my program I pass values from VB to Excel for reporting. When I pass 03-01-2009 (3rd Jan 2009), in excel it shows as 01-03-2009. I have set short date format to dd-mm-yyyy, in control panel, regional settings. Also in excel, I set cell format through VB as … Exl.Range(“A1″).NumberFormat = “dd-mm-yyyy” and Exl.Range(Rng).NumberFormat = [...]
Answer Question
| January 9, 2009 11:51 AM
Excel 2002, Excel Cell Formats, Microsoft Excel, VB, VB 6, Visual Basic, Visual Basic 6
Cell color coding
I am using a spreadsheet designed by someone else and it has some formatting gin place that when a date is entered if it is within a certain period the cell goes green if not red and so on. I need to add some columns and apply the same formatting however for some reason I [...]
Answer Question
| February 22, 2009 10:34 PM
Excel 2007, Excel Cell Formatting, Microsoft Excel
I am using a spreadsheet designed by someone else and it has some formatting gin place that when a date is entered if it is within a certain period the cell goes green if not red and so on. I need to add some columns and apply the same formatting however for some reason I [...]
Answer Question
| February 22, 2009 10:34 PM
Excel 2007, Excel Cell Formatting, Microsoft Excel
CL Program
Hello, I have these queries on a job schedule now and, I want to export them to excel using CL.. PGM RUNQRY MYENTRIES1 RUNQRY MYENTRIES2 COPYTOIMPF FROMFILE(MYLIB/MYFILE1) (MYLIB/FILE2) ENDPGM Where do I send these two file to? and can I run both queries this way? thanks,
Answer Question
| January 9, 2009 7:57 PM
AS/400 import/export, AS/400 queries, CL programming, Exporting AS/400 to Excel, Microsoft Excel, Microsoft Excel import/export
Hello, I have these queries on a job schedule now and, I want to export them to excel using CL.. PGM RUNQRY MYENTRIES1 RUNQRY MYENTRIES2 COPYTOIMPF FROMFILE(MYLIB/MYFILE1) (MYLIB/FILE2) ENDPGM Where do I send these two file to? and can I run both queries this way? thanks,
Answer Question
| January 9, 2009 7:57 PM
AS/400 import/export, AS/400 queries, CL programming, Exporting AS/400 to Excel, Microsoft Excel, Microsoft Excel import/export
I am unable to do my Import, when I run my macros I received two errors, running excel 2003
I Need some ones’ assistance with this error that I am getting in my excel spreadsheet: “compiler error in hidden module: ChroniclesExport ” This error is only when I’m running the MACRO’s function. The MACRO has been checked by other colleagues at my work and is running fine on some PCs & but it fails [...]
Answer Question
| March 13, 2009 5:54 PM
Excel 2000, Excel error messages, Excel macros, Microsoft Excel
I Need some ones’ assistance with this error that I am getting in my excel spreadsheet: “compiler error in hidden module: ChroniclesExport ” This error is only when I’m running the MACRO’s function. The MACRO has been checked by other colleagues at my work and is running fine on some PCs & but it fails [...]
Answer Question
| March 13, 2009 5:54 PM
Excel 2000, Excel error messages, Excel macros, Microsoft Excel
COUNTIF command using Excel and s comma-delimited file
I saved a comma-delimited file to my excel 2003 worksheet and had a problem using the countif command. It wouldn’t recognize the text info. For example, countif(xx:xx,”abc”), it wouldn’t recognize the abc cells. Can you help me?
Answer Question
| January 8, 2009 12:50 PM
Comma-delimited files, COUNTIF statement, Excel 2003, Microsoft Excel, Microsoft Excel 2003
I saved a comma-delimited file to my excel 2003 worksheet and had a problem using the countif command. It wouldn’t recognize the text info. For example, countif(xx:xx,”abc”), it wouldn’t recognize the abc cells. Can you help me?
Answer Question
| January 8, 2009 12:50 PM
Comma-delimited files, COUNTIF statement, Excel 2003, Microsoft Excel, Microsoft Excel 2003
AS400/iSeries Queries on a schedule
I have several queries that I run daily manually, I will like to know step by step how can I have my queries to run on a schedule using the SBMSCHJOB command, then I will like to export them to Excel or Access.
Answer Question
| January 8, 2009 12:22 AM
AS/400 import/export, Microsoft Access, Microsoft Excel, SBMSCHJOB, Submit Scheduled Job
I have several queries that I run daily manually, I will like to know step by step how can I have my queries to run on a schedule using the SBMSCHJOB command, then I will like to export them to Excel or Access.
Answer Question
| January 8, 2009 12:22 AM
AS/400 import/export, Microsoft Access, Microsoft Excel, SBMSCHJOB, Submit Scheduled Job
What is the difference between =+ and =?
Hi, I have a excel sheeting showing a formula as c1=+A1*B1. What does it mean? If I try with C1=A1*B1 the results are same. Then why do we need =+? pls help. Arun.K.S sarunmphil@gmail.com
Answer Question
| January 7, 2009 5:55 PM
Excel formulas, Microsoft Excel
Hi, I have a excel sheeting showing a formula as c1=+A1*B1. What does it mean? If I try with C1=A1*B1 the results are same. Then why do we need =+? pls help. Arun.K.S sarunmphil@gmail.com
Answer Question
| January 7, 2009 5:55 PM
Excel formulas, Microsoft Excel
CPYTOIMPF and EXCEL defaults
I have an issue when copying an AS400 file to the IFS. One field that is defined as 15 charachter and contains numeric data does not show up in .csv format correctly without reformatting the column to special. I also tried defining the field as numeric, and had the same result. Example of data displayed: [...]
Answer Question
| January 20, 2009 8:39 PM
CPYTOIMPF, CSV format, IFS, Microsoft Excel
I have an issue when copying an AS400 file to the IFS. One field that is defined as 15 charachter and contains numeric data does not show up in .csv format correctly without reformatting the column to special. I also tried defining the field as numeric, and had the same result. Example of data displayed: [...]
Answer Question
| January 20, 2009 8:39 PM
CPYTOIMPF, CSV format, IFS, Microsoft Excel
