Macro to select a range in Microsoft Excel and paste in Lotus Notes
HI ALL, I have created and Macro which sends a mail to many in that i need to upgrade as mentioned below Recipients Email Address STUDENT # GRADE COUNTRY 123@dd.com 000123 1ST GRADE United Kingdom 321@dd.com 000321 2D GRADE United Kingdom 213@dd.com 000213 3RD GRADE United Kingdom For each mail id it has to paste [...]
Answer Question
| February 16, 2009 11:27 AM
Lotus Notes, Lotus Notes email, Microsoft Excel, Microsoft Excel macros
HI ALL, I have created and Macro which sends a mail to many in that i need to upgrade as mentioned below Recipients Email Address STUDENT # GRADE COUNTRY 123@dd.com 000123 1ST GRADE United Kingdom 321@dd.com 000321 2D GRADE United Kingdom 213@dd.com 000213 3RD GRADE United Kingdom For each mail id it has to paste [...]
Answer Question
| February 16, 2009 11:27 AM
Lotus Notes, Lotus Notes email, Microsoft Excel, Microsoft Excel macros
Unable to import data using DSN file from SQL Server to Microsoft Excel or Access?
hi ALL, i have a strange situation, there is few people who is not able to load data from sql server using dsn file. I have used correct method, i have used odbc driver -sqlserver… i believe every thing should be fine. I have check the access permission for that user. that is not the [...]
Answer Question
| February 16, 2009 7:09 PM
Database connectivity, DSN connection, Microsoft Access, Microsoft Excel, SQL Server connectivity, SQL Server import/export
hi ALL, i have a strange situation, there is few people who is not able to load data from sql server using dsn file. I have used correct method, i have used odbc driver -sqlserver… i believe every thing should be fine. I have check the access permission for that user. that is not the [...]
Answer Question
| February 16, 2009 7:09 PM
Database connectivity, DSN connection, Microsoft Access, Microsoft Excel, SQL Server connectivity, SQL Server import/export
Microsoft Excel report generation from Oracle Forms 10g
what is the procedure or builtins used to generate a excel report from application server in oracle forms 10G.
Answer Question
| November 25, 2010 5:54 AM
Microsoft Excel, Oracle Forms & Reports Developer 10g, Oracle Forms 10g, Oracle interoperability, Oracle reporting
what is the procedure or builtins used to generate a excel report from application server in oracle forms 10G.
Answer Question
| November 25, 2010 5:54 AM
Microsoft Excel, Oracle Forms & Reports Developer 10g, Oracle Forms 10g, Oracle interoperability, Oracle reporting
How do I populate an SQL table created on the fly in RPGLE?
I am writing a report program where I create a table that is then converted to an Excel spreadsheet using SQL2JXL. I am able to dynamically create a table with Execute Immediate but I have been unable to populate it. The problem is the table name is stored in a variable within the program and [...]
Answer Question
| February 16, 2009 4:20 AM
Dynamic SQL, Microsoft Excel, RPG, RPGLE, RPGSQL, SQL, SQL2JXL
I am writing a report program where I create a table that is then converted to an Excel spreadsheet using SQL2JXL. I am able to dynamically create a table with Execute Immediate but I have been unable to populate it. The problem is the table name is stored in a variable within the program and [...]
Answer Question
| February 16, 2009 4:20 AM
Dynamic SQL, Microsoft Excel, RPG, RPGLE, RPGSQL, SQL, SQL2JXL
Excel question
I have made some forms to use as proposals to sent to customers. I want to be able to send these as a document and not a spreadsheet. I need the formulas in the spreadsheet however to complete the proposal on my end. The pages print ok but I don’t want to send an entire [...]
Answer Question
| February 16, 2009 6:25 PM
Excel 2003, Excel Forms, Microsoft Excel
I have made some forms to use as proposals to sent to customers. I want to be able to send these as a document and not a spreadsheet. I need the formulas in the spreadsheet however to complete the proposal on my end. The pages print ok but I don’t want to send an entire [...]
Answer Question
| February 16, 2009 6:25 PM
Excel 2003, Excel Forms, Microsoft Excel
Conditional Formatting Excel 2003
I have three columns, Column 1 = Start Date Column 2 = End Date Column 3 = Close Date I need to place a conditional format or and “IF” statement on columns 2 and 3. Stating if column 2 is after or 1 month from today’s date highlight in RED. And column 3 should state [...]
Answer Question
| February 20, 2009 5:26 PM
Conditional formatting, Excel 2003, Microsoft Excel
I have three columns, Column 1 = Start Date Column 2 = End Date Column 3 = Close Date I need to place a conditional format or and “IF” statement on columns 2 and 3. Stating if column 2 is after or 1 month from today’s date highlight in RED. And column 3 should state [...]
Answer Question
| February 20, 2009 5:26 PM
Conditional formatting, Excel 2003, Microsoft Excel
Predefine a named range for an exported SQL Server Reporting Services report
How can you predefine a named range for an SQL Server Reporting Services report exported to Excel? In particular, the named range must have a specific name, along with referring to a set of cells with specific columns for all rows rendered for the given table control. I am running SQL Server 2005 SP3 with [...]
Answer Question
| February 11, 2009 9:05 PM
Excel 2003, Microsoft Excel, Microsoft Excel 2003, SQL Server Reporting Services, SSRS
How can you predefine a named range for an SQL Server Reporting Services report exported to Excel? In particular, the named range must have a specific name, along with referring to a set of cells with specific columns for all rows rendered for the given table control. I am running SQL Server 2005 SP3 with [...]
Answer Question
| February 11, 2009 9:05 PM
Excel 2003, Microsoft Excel, Microsoft Excel 2003, SQL Server Reporting Services, SSRS
Excel 2007 – How do I ignore zero’s and #DIV/0! for a graph?
Excel 2007 – How do I ignore zero’s and #DIV/0! for a graph? example: you have data that looks something like this: week # 1 2 3 4 5 6 PTP% 10% 13% 0% 0% #DIV/0! 0 % Then graph the PTP% across from week 1 which is 10% to week 6 which is 0% [...]
Answer Question
| February 22, 2009 8:10 PM
Excel 2007, Excel Charts, Microsoft Excel, Microsoft Office
Excel 2007 – How do I ignore zero’s and #DIV/0! for a graph? example: you have data that looks something like this: week # 1 2 3 4 5 6 PTP% 10% 13% 0% 0% #DIV/0! 0 % Then graph the PTP% across from week 1 which is 10% to week 6 which is 0% [...]
Answer Question
| February 22, 2009 8:10 PM
Excel 2007, Excel Charts, Microsoft Excel, Microsoft Office
Conditional Formatting – Excel 2003
Hello, I would like to know how to setup a conditional format for the following example. Ex. Column 1: Company Column 2: Begin Date Column 3: End Date Column 4: Exceed Date if >3 (Calculates Column 2 & 3 in Days) Conditional Format for Column 4: if days exceeded 3 and “eguals the company in [...]
Answer Question
| February 10, 2009 8:20 PM
Conditional formatting, Excel 2003, Excel Formatting, Microsoft Excel
Hello, I would like to know how to setup a conditional format for the following example. Ex. Column 1: Company Column 2: Begin Date Column 3: End Date Column 4: Exceed Date if >3 (Calculates Column 2 & 3 in Days) Conditional Format for Column 4: if days exceeded 3 and “eguals the company in [...]
Answer Question
| February 10, 2009 8:20 PM
Conditional formatting, Excel 2003, Excel Formatting, Microsoft Excel
Excel Macro to password protect
I have this spread sheet that I want to be able to protect from distrubution when given to one person. Is there a way of writing in a macro that will ask for a new password that is in a hidden list at the end of say 30 days and if not entered in the [...]
Answer Question
| July 31, 2011 1:58 AM
Excel macros, Microsoft Excel, Microsoft Excel password protection
I have this spread sheet that I want to be able to protect from distrubution when given to one person. Is there a way of writing in a macro that will ask for a new password that is in a hidden list at the end of say 30 days and if not entered in the [...]
Answer Question
| July 31, 2011 1:58 AM
Excel macros, Microsoft Excel, Microsoft Excel password protection
How to track who amended a particular file
Hi, Is it possible to have a way to trace who updated a particular file (word or excel etc) in windows 2003 ? Can auditing AD objects solve this ? Thanks and regards, Leo
Answer Question
| February 18, 2009 9:31 AM
Active Directory, Microsoft Excel, Microsoft Word, Network administration, User monitoring, User tracking, Windows Server 2003
Hi, Is it possible to have a way to trace who updated a particular file (word or excel etc) in windows 2003 ? Can auditing AD objects solve this ? Thanks and regards, Leo
Answer Question
| February 18, 2009 9:31 AM
Active Directory, Microsoft Excel, Microsoft Word, Network administration, User monitoring, User tracking, Windows Server 2003
Microsoft Excel – I need to find rows that match a user entered entries and sum results of column b
I have a spread sheet that looks like this Project Well Hours Lewis 1 12 Lewis 2 3 Lewis 1 9 I want to find all the rows that match a user inputed name (in this case ‘Lewis’), then add the numbers in column c labeled ‘hours’, if the sum equals 24 then no problem, [...]
Answer Question
| February 10, 2009 10:28 PM
Duplicate records, Excel functions, Excel macros, Functions, Microsoft Excel, SUM function
I have a spread sheet that looks like this Project Well Hours Lewis 1 12 Lewis 2 3 Lewis 1 9 I want to find all the rows that match a user inputed name (in this case ‘Lewis’), then add the numbers in column c labeled ‘hours’, if the sum equals 24 then no problem, [...]
Answer Question
| February 10, 2009 10:28 PM
Duplicate records, Excel functions, Excel macros, Functions, Microsoft Excel, SUM function
Using Excel 2003: Adding days to a cell that contains both a text and numeric entry.
Can a formula be written that allows days to be added to a cell that contains both text and numeric information? For example, Cell A1 has NAME 1/3/09. I want to add 30 day increments to the 1/3/09 date in adjacent cells. Can it be done? If so. how? Thanks.
Answer Question
| February 5, 2009 7:37 PM
Excel 2003, Excel Formatting, Excel formulas, Microsoft Excel
Can a formula be written that allows days to be added to a cell that contains both text and numeric information? For example, Cell A1 has NAME 1/3/09. I want to add 30 day increments to the 1/3/09 date in adjacent cells. Can it be done? If so. how? Thanks.
Answer Question
| February 5, 2009 7:37 PM
Excel 2003, Excel Formatting, Excel formulas, Microsoft Excel
Excel 2003 – who has shared document open?
If person #1 is editting a workbook and person #2 tries to open it, person #2 will be notified that the document is in use and asked if they want to open it ‘read only’. Is there a way to identify ‘who’ has the document open?
Answer Question
| February 5, 2009 7:50 PM
Excel 2003, Microsoft Excel
If person #1 is editting a workbook and person #2 tries to open it, person #2 will be notified that the document is in use and asked if they want to open it ‘read only’. Is there a way to identify ‘who’ has the document open?
Answer Question
| February 5, 2009 7:50 PM
Excel 2003, Microsoft Excel
What permissions are necessary to allow an SSIS script to read an excel file in a SharePoint Library?
I am developing a datamart to feed Performance Point dashboards/scorecards. To deal with managers who do not have a database source, I will have them submit an excel 2003 file to a SharePoint document library (by email). the excel file will have a consistent format. I am developing an SSIS script that will run every [...]
Answer Question
| February 3, 2009 4:57 PM
BI, Business Intelligence, Data Connector, Excel 2003, Excel Services, Microsoft Excel, Performance Point, SharePoint, SharePoint permissions, SSIS, SSIS Sharepoint
I am developing a datamart to feed Performance Point dashboards/scorecards. To deal with managers who do not have a database source, I will have them submit an excel 2003 file to a SharePoint document library (by email). the excel file will have a consistent format. I am developing an SSIS script that will run every [...]
Answer Question
| February 3, 2009 4:57 PM
BI, Business Intelligence, Data Connector, Excel 2003, Excel Services, Microsoft Excel, Performance Point, SharePoint, SharePoint permissions, SSIS, SSIS Sharepoint
Automatically populate a form based on a match from another worksheet.
Ok, here goes… I have a very large talent management database that is housed in Excel. This database includes information on performance ratings, work history, education, etc. on every employee in the company. I also have a ‘Talent Profile’ form (also created in Excel) that I give to HR whenever they need to review an [...]
Answer Question
| February 25, 2009 6:18 PM
Excel Database, Excel Forms, Microsoft Excel
Ok, here goes… I have a very large talent management database that is housed in Excel. This database includes information on performance ratings, work history, education, etc. on every employee in the company. I also have a ‘Talent Profile’ form (also created in Excel) that I give to HR whenever they need to review an [...]
Answer Question
| February 25, 2009 6:18 PM
Excel Database, Excel Forms, Microsoft Excel
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
