Help to debug VBA code for Excel 2007
I’m trying to have Excel look at the contents in Cell E (Account #2) and match it with A,B,C and extract to another sheet. B cell goes to 427,776 rows and E cell goes to 1,406. The end goal is to get the Salesforce ID & Company name lined up with the accounts in Account [...]
Answer Question
| October 1, 2012 2:59 PM
excel, VBA editor
I’m trying to have Excel look at the contents in Cell E (Account #2) and match it with A,B,C and extract to another sheet. B cell goes to 427,776 rows and E cell goes to 1,406. The end goal is to get the Salesforce ID & Company name lined up with the accounts in Account [...]
Answer Question
| October 1, 2012 2:59 PM
excel, VBA editor
Data and Variables in SPSS from Excel spreadsheet
have an Excel spreadsheet with responses to questions from a 49 question survey. At the top of the spreadsheet I listed each variable that the questions address. When I transfer this to the data page in SPSS, it lists the variables on the variable page with sequential letters after each variable – e.g. – invA, [...]
Answer Question
| February 28, 2012 2:00 PM
excel, SPSS 20.0, Variable code
have an Excel spreadsheet with responses to questions from a 49 question survey. At the top of the spreadsheet I listed each variable that the questions address. When I transfer this to the data page in SPSS, it lists the variables on the variable page with sequential letters after each variable – e.g. – invA, [...]
Answer Question
| February 28, 2012 2:00 PM
excel, SPSS 20.0, Variable code
extract data from as400 to excel
I have CL and DB files and i need to extract the data from the files to excel sheet by writing an program.How can i do that?
Answer Question
| March 17, 2012 8:17 AM
AS/400 File Extract, excel
I have CL and DB files and i need to extract the data from the files to excel sheet by writing an program.How can i do that?
Answer Question
| March 17, 2012 8:17 AM
AS/400 File Extract, excel
Download AS400 Physical File to Excel Using VBA
I am in the process of developing an Access database with the intention of using it to control the download of AS/400 physical files into Excel. I am fine developing the Access / Excel side of the data, however I ahve no experience with the AS/400 side of things. The access database will contain information [...]
Answer Question
| March 17, 2012 9:55 AM
Access, AS/400, excel, VBA
I am in the process of developing an Access database with the intention of using it to control the download of AS/400 physical files into Excel. I am fine developing the Access / Excel side of the data, however I ahve no experience with the AS/400 side of things. The access database will contain information [...]
Answer Question
| March 17, 2012 9:55 AM
Access, AS/400, excel, VBA
Append extra zero on the numeric field using Data Transfer Excel Add-in
My PC configration is MS Window 7 Professional (64-bit Traditional Chinese version), MS Office 2010 (32-bit Traditional Chinese version) and IBM Client Access V6R1M0 (64-bit English version). The problem is that the actual numeric value is 1,2 or 3 only in the physical file. After using the Data Transfer Excel Add-in function to download that [...]
Answer Question
| March 19, 2012 1:36 AM
DTF, excel, iSeries, Transfer Data From iSeries
My PC configration is MS Window 7 Professional (64-bit Traditional Chinese version), MS Office 2010 (32-bit Traditional Chinese version) and IBM Client Access V6R1M0 (64-bit English version). The problem is that the actual numeric value is 1,2 or 3 only in the physical file. After using the Data Transfer Excel Add-in function to download that [...]
Answer Question
| March 19, 2012 1:36 AM
DTF, excel, iSeries, Transfer Data From iSeries
Programming quiz – Excel, VB etc.
Recently heard an interesting quiz and thought it will be fun to see the solution done programmatically. The quiz is as follows: A person bought an old car with over 170,000 miles on it. The odometer is a digital device with 6 digits. The odometer shows only full digits – no decimals. One day as [...]
Answer Question
| March 31, 2012 4:33 AM
C, COBOL, excel, VB
Recently heard an interesting quiz and thought it will be fun to see the solution done programmatically. The quiz is as follows: A person bought an old car with over 170,000 miles on it. The odometer is a digital device with 6 digits. The odometer shows only full digits – no decimals. One day as [...]
Answer Question
| March 31, 2012 4:33 AM
C, COBOL, excel, VB
Problem with AS/400 data transfer to Excel
I have been downloading AS400 query files to Excel spreadsheets for many years using the Data Transfer utility in Client Access. There has never been any problem. Now suddenly all of the output data has started transferring to Excel as long hexadecimal strings and is unusable. I asked the IT folks if anything had changed [...]
Answer Question
| September 13, 2011 11:22 PM
AS/400 Data File, AS/400 data transfer, AS400 Hex Invalid data, Client Access, excel, Exporting AS/400 to Excel
I have been downloading AS400 query files to Excel spreadsheets for many years using the Data Transfer utility in Client Access. There has never been any problem. Now suddenly all of the output data has started transferring to Excel as long hexadecimal strings and is unusable. I asked the IT folks if anything had changed [...]
Answer Question
| September 13, 2011 11:22 PM
AS/400 Data File, AS/400 data transfer, AS400 Hex Invalid data, Client Access, excel, Exporting AS/400 to Excel
Can I use then Forms 6i DDE build-in package to generate 2010 EXCEL File?
Hi All, My company’ application is used Oracle FORMS 6i Solution,Client /Server environment to generated EXCEL file I coding the PL/SQL in the Oracle FORM , it’s succeed generated EXCEL file in MS office Excel 2007/2003/2000. Now I have problem in MS office Excel 2010 , It’s just open the Excel file but no data [...]
Answer Question
| May 25, 2011 8:41 AM
excel, Oracle Forms, Oracle Forms 6i, PL/SQL
Hi All, My company’ application is used Oracle FORMS 6i Solution,Client /Server environment to generated EXCEL file I coding the PL/SQL in the Oracle FORM , it’s succeed generated EXCEL file in MS office Excel 2007/2003/2000. Now I have problem in MS office Excel 2010 , It’s just open the Excel file but no data [...]
Answer Question
| May 25, 2011 8:41 AM
excel, Oracle Forms, Oracle Forms 6i, PL/SQL
Multiple users to one Excel document
What is the easiest way to share a spreadsheet between multiple users in Excel?If I am setup in a work group environment and need multiple users to use the same spreadsheet, I know you can do the “select Share Workbook under the Tools menu” but how does that affect saving edits for each user if [...]
Answer Question
| March 18, 2011 11:53 PM
excel, Excel.Application, Network applications management, Workgroup
What is the easiest way to share a spreadsheet between multiple users in Excel?If I am setup in a work group environment and need multiple users to use the same spreadsheet, I know you can do the “select Share Workbook under the Tools menu” but how does that affect saving edits for each user if [...]
Answer Question
| March 18, 2011 11:53 PM
excel, Excel.Application, Network applications management, Workgroup
Excel File from PL/SQL Procedure
Hi, I have an Oracle PL/SQL procedure that creates a csv file with output. I would like to create an Excel spreadsheet with multiple tabs, seperate information in each tab. Can you advise how I achive this in PL/SQL. Thanks Heather
Answer Question
| March 26, 2012 12:44 PM
excel, Oracle 10i, Oracle PL/SQL, PL/SQL
Hi, I have an Oracle PL/SQL procedure that creates a csv file with output. I would like to create an Excel spreadsheet with multiple tabs, seperate information in each tab. Can you advise how I achive this in PL/SQL. Thanks Heather
Answer Question
| March 26, 2012 12:44 PM
excel, Oracle 10i, Oracle PL/SQL, PL/SQL
Need help using excel to amend ibm reflections
Hi, I have been tasked with updating a database using IBM Reflections for 1600+ entries. I have been doing it by hand so far and have seen threads but never gotten enough info out of them. What I want to do, which I would do if it were two excel files, is update the database [...]
Answer Question
| February 24, 2011 4:39 PM
AS/400, excel, IBM Reflections
Hi, I have been tasked with updating a database using IBM Reflections for 1600+ entries. I have been doing it by hand so far and have seen threads but never gotten enough info out of them. What I want to do, which I would do if it were two excel files, is update the database [...]
Answer Question
| February 24, 2011 4:39 PM
AS/400, excel, IBM Reflections
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
| February 14, 2011 2:00 PM
excel, Excel Forms, Oracle Enterprise Edition, Oracle Forms 10g
what is the procedure or builtins used to generate a excel report from application server in oracle forms 10G.
Answer Question
| February 14, 2011 2:00 PM
excel, Excel Forms, Oracle Enterprise Edition, Oracle Forms 10g
how to use databases made in access or excel in sql
how to use databases made in access or excel in sql importing readymade databases in sql
Answer Question
| January 21, 2011 1:34 PM
Access, C#, excel, Import external data, SQL Server, SQL Server database
how to use databases made in access or excel in sql importing readymade databases in sql
Answer Question
| January 21, 2011 1:34 PM
Access, C#, excel, Import external data, SQL Server, SQL Server database
Reports to be pulled from iSeries
Hi. I have a query regarding pulling the report from i series, am working on I series when i pull the report into txt format in notepad,when i copy and paste it into excel it displays unwanted rows with blanks and some special characters and word like particulars would be splitted like parti cula rs [...]
Answer Question
| January 19, 2011 4:46 PM
excel, iSeries, iSeries administration
Hi. I have a query regarding pulling the report from i series, am working on I series when i pull the report into txt format in notepad,when i copy and paste it into excel it displays unwanted rows with blanks and some special characters and word like particulars would be splitted like parti cula rs [...]
Answer Question
| January 19, 2011 4:46 PM
excel, iSeries, iSeries administration
How can I retrieve an Excel file saved in Hotmail?
I opened an excel attachment in hotmail and started editing, i saved it continuously but when I closed excel and reopened the file was gone… i;m running office 2007 and win 7 64bit
Answer Question
| October 23, 2011 5:32 PM
excel, Excel functions, Hotmail, Windows, Windows 7 64-bit
I opened an excel attachment in hotmail and started editing, i saved it continuously but when I closed excel and reopened the file was gone… i;m running office 2007 and win 7 64bit
Answer Question
| October 23, 2011 5:32 PM
excel, Excel functions, Hotmail, Windows, Windows 7 64-bit
Excel: Hyperlink to Lotus notes with message field populated
Hello I have a spreadsheet which just has email addresses on it. When I click on them they open a new email in Lotus Notes. I want to know if there is a way to make it so that when I click on the hyperlink the message field is populated with a template letter which can be edited by [...]
Answer Question
| January 17, 2011 11:14 AM
excel, Excel worksheets, Lotus Notes, Lotus Notes interoperability
Hello I have a spreadsheet which just has email addresses on it. When I click on them they open a new email in Lotus Notes. I want to know if there is a way to make it so that when I click on the hyperlink the message field is populated with a template letter which can be edited by [...]
Answer Question
| January 17, 2011 11:14 AM
excel, Excel worksheets, Lotus Notes, Lotus Notes interoperability
Performance files to Excel
I know how to run performace tools on Iseries but how can I download the Iseries performance files into Excel and create a graph on the data? Thanks
Answer Question
| January 5, 2011 4:16 PM
excel, Excel Database, IBM 9406, iSeries performance, Performance management
I know how to run performace tools on Iseries but how can I download the Iseries performance files into Excel and create a graph on the data? Thanks
Answer Question
| January 5, 2011 4:16 PM
excel, Excel Database, IBM 9406, iSeries performance, Performance management
Lotus Notes 8.5 documents to Excel worksheet
Exporting documents to Excel worksheet. Going well, but need to have the Excel sheet open in landscape. What would be the commands for that? This works fine so far: currentprocess = “formatting the spreadsheet” wsheet.Name = viewname wsheet.Cells.Font.Size = 10 wsheet.Rows(“1:1″).RowHeight = 20 wsheet.Rows(“1:1″).Select wsheet.Rows(“1:1″).Font.Bold = True wsheet.Cells.EntireColumn.Autofit wsheet.Cells.WrapText = True wsheet.Columns(“A:A”).ColumnWidth = 6.14 wsheet.Columns(“B:B”).ColumnWidth [...]
Answer Question
| December 21, 2010 2:46 PM
excel, Excel worksheets, Lotus Notes 8.5, Lotus Notes Script
Exporting documents to Excel worksheet. Going well, but need to have the Excel sheet open in landscape. What would be the commands for that? This works fine so far: currentprocess = “formatting the spreadsheet” wsheet.Name = viewname wsheet.Cells.Font.Size = 10 wsheet.Rows(“1:1″).RowHeight = 20 wsheet.Rows(“1:1″).Select wsheet.Rows(“1:1″).Font.Bold = True wsheet.Cells.EntireColumn.Autofit wsheet.Cells.WrapText = True wsheet.Columns(“A:A”).ColumnWidth = 6.14 wsheet.Columns(“B:B”).ColumnWidth [...]
Answer Question
| December 21, 2010 2:46 PM
excel, Excel worksheets, Lotus Notes 8.5, Lotus Notes Script
Excel 2007 ‘Edit Links’ Command deleting information
I received a file from our corporate office. Some of the formulas in the workbook were referencing a location on a persons C:documents and settingsthatpersonmy documents. I wanted to change the reference to the existing file instead of the past months file it was looking at. I went into DataEdit Links highlighted the file I [...]
Answer Question
| March 11, 2011 5:58 PM
excel, Excel 2007, Excel 2007 functions, Excel 2007 workbooks, Outlook 2007
I received a file from our corporate office. Some of the formulas in the workbook were referencing a location on a persons C:documents and settingsthatpersonmy documents. I wanted to change the reference to the existing file instead of the past months file it was looking at. I went into DataEdit Links highlighted the file I [...]
Answer Question
| March 11, 2011 5:58 PM
excel, Excel 2007, Excel 2007 functions, Excel 2007 workbooks, Outlook 2007
Excel and Access integration and auto-population
Overall, I want to create a database that tracks defects for several sites and ouputs the information in a pivot table. Each site (7 in total) documents their internal defect data and sends it to me weekly. I then merge all of this data (have been doing so manually) into one spreadsheet to perform my analysis [...]
Answer Question
| December 7, 2010 2:52 PM
Acces, Access 2000, Access Database, excel, Excel 2010, Excel macros, Macros
Overall, I want to create a database that tracks defects for several sites and ouputs the information in a pivot table. Each site (7 in total) documents their internal defect data and sends it to me weekly. I then merge all of this data (have been doing so manually) into one spreadsheet to perform my analysis [...]
Answer Question
| December 7, 2010 2:52 PM
Acces, Access 2000, Access Database, excel, Excel 2010, Excel macros, Macros
