Does Apache POI-XSSF support Excel 2007 runs under Java 1.4?
Hi Guys, Is Apache XSSF POI supports java 1.4 to upload the Excel 2007. Thankx.
Answer Question
| December 4, 2008 12:14 PM
Apache, Apache POI, Excel 2007, Java, Java 1.4, Microsoft Excel, Microsoft Excel 2007, POI-XSSF, Poor Obfuscation Implementation, XML SpreadSheet Format, XSSF
Hi Guys, Is Apache XSSF POI supports java 1.4 to upload the Excel 2007. Thankx.
Answer Question
| December 4, 2008 12:14 PM
Apache, Apache POI, Excel 2007, Java, Java 1.4, Microsoft Excel, Microsoft Excel 2007, POI-XSSF, Poor Obfuscation Implementation, XML SpreadSheet Format, XSSF
I am getting “compiler error in hidden module” error in Excel 2003 while running Macro
I am getting :”compiler error in hidden module ” error in EXCEL 2003 only while running MACRO. Actully this MACRO is running on some PCs & for some PCs it is showing that error. The installation of MS EXCEL 2003 is same on all PCs. Please help me ASAP. Thanks in advance !
Answer Question
| December 4, 2008 7:24 AM
Compile error in hidden module, Excel 2003, Excel 2003 macros, Excel macros, Microsoft Excel, Microsoft Excel 2003, Microsoft Excel error messages
I am getting :”compiler error in hidden module ” error in EXCEL 2003 only while running MACRO. Actully this MACRO is running on some PCs & for some PCs it is showing that error. The installation of MS EXCEL 2003 is same on all PCs. Please help me ASAP. Thanks in advance !
Answer Question
| December 4, 2008 7:24 AM
Compile error in hidden module, Excel 2003, Excel 2003 macros, Excel macros, Microsoft Excel, Microsoft Excel 2003, Microsoft Excel error messages
Complex Database Issue
I’ll try to be brief: I have excel files that are downloaded via ftp to a folder where I have my DB. each of the excel files is “roughly” the same headers, I want to import all of these files, filter out all but 3 columns and then filter out certain rows in each table [...]
Answer Question
| December 4, 2008 8:37 PM
Access 2003, Access Database, Database, FTP, Microsoft Access, Microsoft Excel, Sorting
I’ll try to be brief: I have excel files that are downloaded via ftp to a folder where I have my DB. each of the excel files is “roughly” the same headers, I want to import all of these files, filter out all but 3 columns and then filter out certain rows in each table [...]
Answer Question
| December 4, 2008 8:37 PM
Access 2003, Access Database, Database, FTP, Microsoft Access, Microsoft Excel, Sorting
Export multiple values from Notes to Domino
Hi, is it possible to export a Notes view that has a column with multiple values, separated by comma, to excel? Thanks for any helo. Michelle
Answer Question
| December 2, 2008 8:25 PM
Export, Lotus Notes, Lotus Notes to Excel, Microsoft Excel
Hi, is it possible to export a Notes view that has a column with multiple values, separated by comma, to excel? Thanks for any helo. Michelle
Answer Question
| December 2, 2008 8:25 PM
Export, Lotus Notes, Lotus Notes to Excel, Microsoft Excel
Search Excel Macro Help!
I do not know scripting and i really wish i did, any help would be greatly appreciated!I have an excel document that I need to search through for a list of words, when of the words from my list is found, i need the word it found to be put into a new column.
Answer Question
| March 17, 2009 3:24 PM
Excel macros, Microsoft Excel, VBA, Visual Basic for Applications
I do not know scripting and i really wish i did, any help would be greatly appreciated!I have an excel document that I need to search through for a list of words, when of the words from my list is found, i need the word it found to be put into a new column.
Answer Question
| March 17, 2009 3:24 PM
Excel macros, Microsoft Excel, VBA, Visual Basic for Applications
Use of the EXCEL formula function to copy data and insert an asterik on both ends of output.
Is there a method to use the formula function to copy the contents entered in one cell (A2)into cell B2 with the addition of an asterisk ‘*’ on both ends of the copied text? An example being – Enter ‘H123456′ in A2, with the output in B2 being ‘*H123456*’
Answer Question
| November 26, 2008 4:27 PM
Excel 2003, Excel formulas, Microsoft Excel
Is there a method to use the formula function to copy the contents entered in one cell (A2)into cell B2 with the addition of an asterisk ‘*’ on both ends of the copied text? An example being – Enter ‘H123456′ in A2, with the output in B2 being ‘*H123456*’
Answer Question
| November 26, 2008 4:27 PM
Excel 2003, Excel formulas, Microsoft Excel
How to call Microsoft Excel from Oracle Reports/Forms 6i
how to call excel from oracle report/forms 6i plz tell me the step by step process how can we do it my e-mailid is lightmobeen@yahoo.com if any one know the process plz send me mail sonsist of code,me very thankful to u for this
Answer Question
| November 21, 2010 10:55 AM
Excel import/export, Microsoft Excel, Microsoft Excel import/export, Oracle 6i, Oracle 6i import/export, Oracle developers, Oracle Forms, Oracle Forms 6i, Oracle import/export, Oracle Reports
how to call excel from oracle report/forms 6i plz tell me the step by step process how can we do it my e-mailid is lightmobeen@yahoo.com if any one know the process plz send me mail sonsist of code,me very thankful to u for this
Answer Question
| November 21, 2010 10:55 AM
Excel import/export, Microsoft Excel, Microsoft Excel import/export, Oracle 6i, Oracle 6i import/export, Oracle developers, Oracle Forms, Oracle Forms 6i, Oracle import/export, Oracle Reports
minor loss of fidelity but cant find data!
I have a large database saved in xls. 2003; I changed one column heading and got a message that reads: Compatibility Report for Thurs Brkfst Data Base.xls Run on 11/20/2008 16:50 The following features in this workbook are not supported by earlier versions of Excel. These features may be lost or degraded when you save [...]
Answer Question
| June 1, 2010 9:14 PM
Excel 2003, Excel Compatibility, Microsoft Excel
I have a large database saved in xls. 2003; I changed one column heading and got a message that reads: Compatibility Report for Thurs Brkfst Data Base.xls Run on 11/20/2008 16:50 The following features in this workbook are not supported by earlier versions of Excel. These features may be lost or degraded when you save [...]
Answer Question
| June 1, 2010 9:14 PM
Excel 2003, Excel Compatibility, Microsoft Excel
Executing DTSX from VB.NET 2003
We converted form SqlServer 2000 to 2005. We had dts packages which were used to import Excel data into the database. We re-created new dtsx packages to replace the old dts packages where they sit on a local drive. Our VB.NET 2003 application used to be able to run the old dts packages but we [...]
Answer Question
| December 16, 2008 8:26 PM
DTS, DTS packages, DTSX, Excel import/export, Microsoft Excel, SQL Server 2000, SQL Server 2005, SQL Server upgrades, VB.NET 2003
We converted form SqlServer 2000 to 2005. We had dts packages which were used to import Excel data into the database. We re-created new dtsx packages to replace the old dts packages where they sit on a local drive. Our VB.NET 2003 application used to be able to run the old dts packages but we [...]
Answer Question
| December 16, 2008 8:26 PM
DTS, DTS packages, DTSX, Excel import/export, Microsoft Excel, SQL Server 2000, SQL Server 2005, SQL Server upgrades, VB.NET 2003
import data from excel 2007 to iseries
how do you import data from excel 2007 to iseries
Answer Question
| November 28, 2008 3:54 PM
Excel 2007, Importing Excel 2007 to iSeries, iSeries, iSeries import/export, Microsoft Excel
how do you import data from excel 2007 to iseries
Answer Question
| November 28, 2008 3:54 PM
Excel 2007, Importing Excel 2007 to iSeries, iSeries, iSeries import/export, Microsoft Excel
How to upload data from Excel into SQL Server 2005
hi, Please tell me , how can i upload data from excel into SQL2005 thanks & regards Ambrish Srivastav
Answer Question
| November 25, 2008 12:59 PM
Microsoft Excel, Microsoft Excel import/export, SQL Server 2005 import/export, SQL Server import/export
hi, Please tell me , how can i upload data from excel into SQL2005 thanks & regards Ambrish Srivastav
Answer Question
| November 25, 2008 12:59 PM
Microsoft Excel, Microsoft Excel import/export, SQL Server 2005 import/export, SQL Server import/export
Deleting Excel Worksheets with macro
I am using excel 2000 and have workbook that uses macro to delete several worksheets and then save the workbook under a name in one of the cells. All works fine but for each worksheet a quiery pops up to ask if you want to delet this sheet. How do I delete sheets in the [...]
Answer Question
| December 31, 2008 12:38 AM
Excel 2000, Excel 2000 macros, Excel macros, Excel workbooks, Excel worksheets, Microsoft Excel, Microsoft Excel 2000, Microsoft Excel 2000 macros
I am using excel 2000 and have workbook that uses macro to delete several worksheets and then save the workbook under a name in one of the cells. All works fine but for each worksheet a quiery pops up to ask if you want to delet this sheet. How do I delete sheets in the [...]
Answer Question
| December 31, 2008 12:38 AM
Excel 2000, Excel 2000 macros, Excel macros, Excel workbooks, Excel worksheets, Microsoft Excel, Microsoft Excel 2000, Microsoft Excel 2000 macros
How do I read in the comma delimited files by SAS
How do I save an Excel File with 2 sheets into two comma delimited (.csv) files, first for the sheet tabbed “sheet 1″ and second for the sheet tabbed “sheet 2″? Also, how do I then read in the comma delimited files by SAS? *note: these are excel files that I am trying to read [...]
Answer Question
| February 9, 2010 5:36 PM
CSV, Delimited function, Microsoft Excel, SAS
How do I save an Excel File with 2 sheets into two comma delimited (.csv) files, first for the sheet tabbed “sheet 1″ and second for the sheet tabbed “sheet 2″? Also, how do I then read in the comma delimited files by SAS? *note: these are excel files that I am trying to read [...]
Answer Question
| February 9, 2010 5:36 PM
CSV, Delimited function, Microsoft Excel, SAS
Excel 2007 Crashes
I am using Excel 2007 working in a workbook that has forms for each census year. In the form I put the data for the family name that I am researching, these forms might be several hundred lines to several thousand lines each. Size of each census year may vary. There is quite a bit [...]
Answer Question
| December 5, 2008 2:57 PM
Excel 2007, Excel workbooks, Microsoft Excel
I am using Excel 2007 working in a workbook that has forms for each census year. In the form I put the data for the family name that I am researching, these forms might be several hundred lines to several thousand lines each. Size of each census year may vary. There is quite a bit [...]
Answer Question
| December 5, 2008 2:57 PM
Excel 2007, Excel workbooks, Microsoft Excel
How to paste data directly from Excel to PowerPoint graphic as data using Excel VBA
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 existing graph and [...]
Answer Question
| November 19, 2008 4:53 PM
Excel macros, Microsoft Excel, Microsoft PowerPoint, PowerPoint, VBA, Visual Basic for Applications
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 existing graph and [...]
Answer Question
| November 19, 2008 4:53 PM
Excel macros, Microsoft Excel, Microsoft PowerPoint, PowerPoint, VBA, Visual Basic for Applications
excel 2007
I am trying to use non-adjacent ranges to setup a clustered column with 3D visual effect option by pressing the ctrl key and selecting my ranges and every time I get the box saying one can’t use the chart with information selected, what am I doing wrong?
Answer Question
| November 20, 2008 9:48 PM
Excel 2007, Excel Charts, Microsoft Excel
I am trying to use non-adjacent ranges to setup a clustered column with 3D visual effect option by pressing the ctrl key and selecting my ranges and every time I get the box saying one can’t use the chart with information selected, what am I doing wrong?
Answer Question
| November 20, 2008 9:48 PM
Excel 2007, Excel Charts, Microsoft Excel
Excel 2007 – formula or macro to show value from one cell next to a given reference
Hope someone can help I am trying to work out a formula to place the value of a cell on a spreadsheet into a second sheet within the workbook using a reference in the column next to the cell with the value in it. EG – Sheet 1 has a cell with £500 in cell [...]
Answer Question
| November 18, 2008 3:26 PM
Excel 2007, Excel macros, Microsoft Excel
Hope someone can help I am trying to work out a formula to place the value of a cell on a spreadsheet into a second sheet within the workbook using a reference in the column next to the cell with the value in it. EG – Sheet 1 has a cell with £500 in cell [...]
Answer Question
| November 18, 2008 3:26 PM
Excel 2007, Excel macros, Microsoft Excel
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 16, 2008 5:05 PM
Excel macros, Microsoft Excel, Microsoft PowerPoint, PowerPoint, VBA, Visual Basic for Applications
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 16, 2008 5:05 PM
Excel macros, Microsoft Excel, Microsoft PowerPoint, PowerPoint, VBA, Visual Basic for Applications
new to macros – extracting data
Hello, I’m just learning how to use macros and have this fairly large project to do. It concerns extracting data from a schedule (timetable) with the courses, course code, name of tutor on it. I have managed to extract from a cell and have the following information come up in a message box(course code, course [...]
Answer Question
| November 25, 2008 5:52 PM
Excel macros, Macros, Microsoft Excel, VBA
Hello, I’m just learning how to use macros and have this fairly large project to do. It concerns extracting data from a schedule (timetable) with the courses, course code, name of tutor on it. I have managed to extract from a cell and have the following information come up in a message box(course code, course [...]
Answer Question
| November 25, 2008 5:52 PM
Excel macros, Macros, Microsoft Excel, VBA
How to send mail to multipie recipients from lotus using excel macro
Hi , I am using following code right now for sending mail from lotus using excel macro for single client its working fine Sub SendLotusNotesMail() Dim UserName As String Dim MailDbName As String Dim Maildb As Object Dim MailDoc As Object Dim AttachME As Object Dim Session1 As Object Dim EmbedObj1 As Object Dim recep [...]
Answer Question
| November 21, 2008 3:22 PM
Excel macros, Lotus Notes, Microsoft Excel
Hi , I am using following code right now for sending mail from lotus using excel macro for single client its working fine Sub SendLotusNotesMail() Dim UserName As String Dim MailDbName As String Dim Maildb As Object Dim MailDoc As Object Dim AttachME As Object Dim Session1 As Object Dim EmbedObj1 As Object Dim recep [...]
Answer Question
| November 21, 2008 3:22 PM
Excel macros, Lotus Notes, Microsoft Excel
