Lotus Notes External Table Look Up
My company uses LN 6.5 and I am trying to design a database with multiple tables. I have been told that there is a function that allows you to look to an external table, such as in Excel, to view data. The data modifications take place in Excel, but are viewed in the database. How [...]
Answer Question
| April 24, 2008 3:16 PM
Lotus Notes 6.x, Lotus Notes Database, Microsoft Excel
My company uses LN 6.5 and I am trying to design a database with multiple tables. I have been told that there is a function that allows you to look to an external table, such as in Excel, to view data. The data modifications take place in Excel, but are viewed in the database. How [...]
Answer Question
| April 24, 2008 3:16 PM
Lotus Notes 6.x, Lotus Notes Database, Microsoft Excel
How to save a document as current date ?
I’m using VBA in excel 2000 to create a macro that saves out a spreadsheet with today’s current date. I cannot figure out the code that will achieve this function. Help Please
Answer Question
| April 22, 2008 7:15 PM
Excel 2000, Excel macros, Microsoft Excel, VBA, Visual Basic for Applications
I’m using VBA in excel 2000 to create a macro that saves out a spreadsheet with today’s current date. I cannot figure out the code that will achieve this function. Help Please
Answer Question
| April 22, 2008 7:15 PM
Excel 2000, Excel macros, Microsoft Excel, VBA, Visual Basic for Applications
Is it possible to find out the name of an excel worksheet
I need to import details from Excel but the worksheet names are not always what is expected. Is there a way to determine the worksheet name using sql? Query used to import where sheet name = data SELECT * INTO tmp_test2 FROM OPENROWSET(‘Microsoft.Jet.OLEDB.4.0′, ‘Excel 8.0;Database=c:datatest2.xls’, ‘SELECT * FROM [data$]‘) Thanks
Answer Question
| April 19, 2008 3:52 PM
Microsoft Excel, SQL
I need to import details from Excel but the worksheet names are not always what is expected. Is there a way to determine the worksheet name using sql? Query used to import where sheet name = data SELECT * INTO tmp_test2 FROM OPENROWSET(‘Microsoft.Jet.OLEDB.4.0′, ‘Excel 8.0;Database=c:datatest2.xls’, ‘SELECT * FROM [data$]‘) Thanks
Answer Question
| April 19, 2008 3:52 PM
Microsoft Excel, SQL
import the data from iseries to excel sheet
i read some instruction of Thierry Schmitz using timestamp. i am very much interested on this. please provide me any example of this. i am posting the process also. I prefer the following solution, working on request from the user : 1) the main excel sheet shows Timestamp of both Available DB from I5 and [...]
Answer Question
| April 18, 2008 6:32 AM
AS/400, iSeries, Microsoft Excel
i read some instruction of Thierry Schmitz using timestamp. i am very much interested on this. please provide me any example of this. i am posting the process also. I prefer the following solution, working on request from the user : 1) the main excel sheet shows Timestamp of both Available DB from I5 and [...]
Answer Question
| April 18, 2008 6:32 AM
AS/400, iSeries, Microsoft Excel
Combo box and VBA
The two possible selections in an Excel combobox: Debt & Common Stock. Let’s say that the combobox resides in cell B3. If Debt is selected from the box- I want the following fields to show up two rows below the combobox, all in the same column: Issue Date, Maturity Date, Interest, Seniority, Use of Proceeds. [...]
Answer Question
| April 17, 2008 10:18 PM
ComboBox, Microsoft Excel, VBA, Visual Basic for Applications
The two possible selections in an Excel combobox: Debt & Common Stock. Let’s say that the combobox resides in cell B3. If Debt is selected from the box- I want the following fields to show up two rows below the combobox, all in the same column: Issue Date, Maturity Date, Interest, Seniority, Use of Proceeds. [...]
Answer Question
| April 17, 2008 10:18 PM
ComboBox, Microsoft Excel, VBA, Visual Basic for Applications
Add to Excel spreadsheet from System i
I want to add data from a DB2 file to an Excel template that has a header row and totals certain columns without overwriting the header row or the totals.
Answer Question
| April 16, 2008 2:41 PM
DB2 Everyplace, Microsoft Excel, System i
I want to add data from a DB2 file to an Excel template that has a header row and totals certain columns without overwriting the header row or the totals.
Answer Question
| April 16, 2008 2:41 PM
DB2 Everyplace, Microsoft Excel, System i
Excel-Macro Help
I’m creating a spreadsheet for a business (for my uni work) and i need to create a booking form and from that be able to save the customers information. I’ve created the booking form, and created a button to save the customer information, using a macro for it to save. The problem is when the [...]
Answer Question
| April 7, 2008 3:02 PM
Excel macros, Microsoft Excel, VBA
I’m creating a spreadsheet for a business (for my uni work) and i need to create a booking form and from that be able to save the customers information. I’ve created the booking form, and created a button to save the customer information, using a macro for it to save. The problem is when the [...]
Answer Question
| April 7, 2008 3:02 PM
Excel macros, Microsoft Excel, VBA
easy way to automate uploading data from a word document to a spreadsheet?
I have a spreadsheet to verify datafields for. This needs to test for example state all the valid entries. I do not want to save off a spreadsheet form of the template i am testing one for each data value I need to test. Is there an easy way to create many spreadsheets off of [...]
Answer Question
| June 2, 2008 3:01 PM
Excel macros, Microsoft Excel, Microsoft Word, VBA, Visual Basic for Applications
I have a spreadsheet to verify datafields for. This needs to test for example state all the valid entries. I do not want to save off a spreadsheet form of the template i am testing one for each data value I need to test. Is there an easy way to create many spreadsheets off of [...]
Answer Question
| June 2, 2008 3:01 PM
Excel macros, Microsoft Excel, Microsoft Word, VBA, Visual Basic for Applications
adding text to function results
I am using a count function to create a total number (COUNTA(A1-A400) I want to add some test to display with the results so it reads 350 units. I have tried to nest the TEXT command but get an error
Answer Question
| April 2, 2008 3:34 PM
COUNTA, Microsoft Excel, Spreadsheets, TEXT
I am using a count function to create a total number (COUNTA(A1-A400) I want to add some test to display with the results so it reads 350 units. I have tried to nest the TEXT command but get an error
Answer Question
| April 2, 2008 3:34 PM
COUNTA, Microsoft Excel, Spreadsheets, TEXT
specify the read only attribute in my Perl code so i don’t have to click on read only
I have created a perl script that read from an excel file that is located on our windows server, the goal is to automate the perl script to run once a week and read the first 5 columns of the row that matches the current date and then write the data to a .txt file. [...]
Answer Question
| April 1, 2008 8:38 PM
Microsoft Excel, Perl, Win32::OLE
I have created a perl script that read from an excel file that is located on our windows server, the goal is to automate the perl script to run once a week and read the first 5 columns of the row that matches the current date and then write the data to a .txt file. [...]
Answer Question
| April 1, 2008 8:38 PM
Microsoft Excel, Perl, Win32::OLE
Deactivate Transfer Data To iSeries in EXCEL
How do I deactivate the Transfer data To iseries link in EXCEL but still the Transfer Data From iSeries ACTIVE in Excel
Answer Question
| April 1, 2008 7:11 PM
iSeries database, Microsoft Excel
How do I deactivate the Transfer data To iseries link in EXCEL but still the Transfer Data From iSeries ACTIVE in Excel
Answer Question
| April 1, 2008 7:11 PM
iSeries database, Microsoft Excel
Exporting Exchange 2003 public folder calendar into Excel and then into a personel calendar.
I need to export public folder calendar data into excel and them into a personal folder.
Answer Question
| November 25, 2008 6:23 PM
Exchange 2003, Microsoft Excel, Public folders
I need to export public folder calendar data into excel and them into a personal folder.
Answer Question
| November 25, 2008 6:23 PM
Exchange 2003, Microsoft Excel, Public folders
Validation in Excel
Can a cell have a validation rule from a list and also have the ability to free type in that cell? This is in Excel 2003.
Answer Question
| May 17, 2008 4:15 PM
Excel 2003, free type, Microsoft Excel, Validation
Can a cell have a validation rule from a list and also have the ability to free type in that cell? This is in Excel 2003.
Answer Question
| May 17, 2008 4:15 PM
Excel 2003, free type, Microsoft Excel, Validation
Switching custom views in Excel when filtering
I have a very large spreadsheet that I navigate using custom views. I change views using macros because I have a couple of other commands that I want executed as well. I also commonly filter the rows of the spreadsheet. However, when I switch views, the filter is turned off, and I would like it [...]
Answer Question
| March 29, 2008 3:13 PM
Excel 2003, Excel macros, Microsoft Excel, VBA
I have a very large spreadsheet that I navigate using custom views. I change views using macros because I have a couple of other commands that I want executed as well. I also commonly filter the rows of the spreadsheet. However, when I switch views, the filter is turned off, and I would like it [...]
Answer Question
| March 29, 2008 3:13 PM
Excel 2003, Excel macros, Microsoft Excel, VBA
How to change config to download all fields to Excel than Inbox
Using menu path Plant AnalysisExportTransfer to XXL in MCBA to download all switch drill down fields but currently am brought to SBWP. How do I change it to allow down load to Excel?
Answer Question
| March 26, 2008 9:27 AM
MCBA, Microsoft Excel, SAP MM, SAP Transaction Codes
Using menu path Plant AnalysisExportTransfer to XXL in MCBA to download all switch drill down fields but currently am brought to SBWP. How do I change it to allow down load to Excel?
Answer Question
| March 26, 2008 9:27 AM
MCBA, Microsoft Excel, SAP MM, SAP Transaction Codes
How to add another row header to Excel Report using Visual Basic
HI, I want to add another row and column header to a Excel Report using Visual Basic..
Answer Question
| March 11, 2008 11:07 AM
Microsoft Excel, Visual Basic
HI, I want to add another row and column header to a Excel Report using Visual Basic..
Answer Question
| March 11, 2008 11:07 AM
Microsoft Excel, Visual Basic
How to search particular data in range of data and everytime save it in a cell
How to search particular data in range of data and everytime save it in a cell in Excel using VB code
Answer Question
| March 29, 2008 8:45 AM
Microsoft Excel, VBA, Visual Basic
How to search particular data in range of data and everytime save it in a cell in Excel using VB code
Answer Question
| March 29, 2008 8:45 AM
Microsoft Excel, VBA, Visual Basic
Shading on Click and Drag
When I click and drag to paint a range of cells, the shading doesn’t show up. Is there a way to change my preferences and darken the shading?
Answer Question
| March 5, 2008 10:48 PM
Microsoft Excel
When I click and drag to paint a range of cells, the shading doesn’t show up. Is there a way to change my preferences and darken the shading?
Answer Question
| March 5, 2008 10:48 PM
Microsoft Excel
Change date format
I have a date field stored in the i5 as yymmdd that I would like to change to mmddyy when exported to Excel. If I just re-format the cell, Excel treats the number as a Julian date and mis-corrects the date. The other issue is that Excel drops the leading 0 so everything in this [...]
Answer Question
| April 7, 2010 2:26 PM
AS/400, i5, Microsoft Excel
I have a date field stored in the i5 as yymmdd that I would like to change to mmddyy when exported to Excel. If I just re-format the cell, Excel treats the number as a Julian date and mis-corrects the date. The other issue is that Excel drops the leading 0 so everything in this [...]
Answer Question
| April 7, 2010 2:26 PM
AS/400, i5, Microsoft Excel
Shift Differential
How can I write a formula for shift differential if 06:00-14:00 is normal working, 14:00-22:00 is $1.00 more an hour and 22:00-06:00 is .90 more an hour? (A5 Work Hours ) (B5-Sunday start) (C5- Sunday End) (D5- Monday Start) (E5- Monday End) etc. Thanks you to any one that can help.
Answer Question
| February 22, 2008 2:11 AM
Excel 2003, Microsoft Excel
How can I write a formula for shift differential if 06:00-14:00 is normal working, 14:00-22:00 is $1.00 more an hour and 22:00-06:00 is .90 more an hour? (A5 Work Hours ) (B5-Sunday start) (C5- Sunday End) (D5- Monday Start) (E5- Monday End) etc. Thanks you to any one that can help.
Answer Question
| February 22, 2008 2:11 AM
Excel 2003, Microsoft Excel
