Why is my app so slow when writing from VB to Excel
What I use: An app where following procedure has to be run approx 100.000 times… it takes 5 minutes! It should go faster. Question=how? Dim Record as string Dim oExcel As Microsoft.Office.Interop.Excel.Application Dim EXCBook As Object, Range as object oExcel = New Microsoft.Office.Interop.Excel.Application EXCBook = oExcel.Workbooks.Open(TxtFolder.Text & “FBL.xlt”) Record = strLine & vbTab & strSort [...]
Answer Question
| November 19, 2012 2:37 PM
Microsoft Excel, Visual Basic
What I use: An app where following procedure has to be run approx 100.000 times… it takes 5 minutes! It should go faster. Question=how? Dim Record as string Dim oExcel As Microsoft.Office.Interop.Excel.Application Dim EXCBook As Object, Range as object oExcel = New Microsoft.Office.Interop.Excel.Application EXCBook = oExcel.Workbooks.Open(TxtFolder.Text & “FBL.xlt”) Record = strLine & vbTab & strSort [...]
Answer Question
| November 19, 2012 2:37 PM
Microsoft Excel, Visual Basic
Login for Tiger Ed
If I forgot my screen name and password for the Tiger Ed. Is there a way I can reset it or find out what it was?
Answer Question
| November 19, 2012 1:51 PM
Login, Login password
If I forgot my screen name and password for the Tiger Ed. Is there a way I can reset it or find out what it was?
Answer Question
| November 19, 2012 1:51 PM
Login, Login password
Encryption in PHP
How do I encrypt the URL in PHP?
Answer Question
| November 19, 2012 12:51 PM
PHP, PHP Coding
How do I encrypt the URL in PHP?
Answer Question
| November 19, 2012 12:51 PM
PHP, PHP Coding
About PHP code
I created a code for login. When the user name and password is correct, it redirects to another page. The problem is when a user logs in, the redirected page’s URL is seen. I don’t want the redirected page’s URL to be visible to users. What can I do? Please help.
Answer Question
| November 19, 2012 12:30 PM
PHP, PHP Coding
I created a code for login. When the user name and password is correct, it redirects to another page. The problem is when a user logs in, the redirected page’s URL is seen. I don’t want the redirected page’s URL to be visible to users. What can I do? Please help.
Answer Question
| November 19, 2012 12:30 PM
PHP, PHP Coding
SQL query
I have 3 columns: development no,city, status for stamp (this column is set by 0,1,2). I want to write a query that specifies percentage of stamps per city; for example percentage of stamps with 1 in city x, percentage of stamps with 2 in city x, percentage of stamps with 1 in city y….and so [...]
Answer Question
| November 18, 2012 10:36 AM
SQL 2008, SQL Server 2008
I have 3 columns: development no,city, status for stamp (this column is set by 0,1,2). I want to write a query that specifies percentage of stamps per city; for example percentage of stamps with 1 in city x, percentage of stamps with 2 in city x, percentage of stamps with 1 in city y….and so [...]
Answer Question
| November 18, 2012 10:36 AM
SQL 2008, SQL Server 2008
CPYF
Is there any way to create a new physical file(say PF2) with same structure/fields as in a logical file(say LF1, whose physical file is PF1). One way is to use CPYF to create PF2 from LF1 but I dont wan’t any data to be copied from LF1 to PF2 (dont want to use clrpfm after [...]
Answer Question
| November 17, 2012 7:47 PM
AS400 Command, CPYF, DB2
Is there any way to create a new physical file(say PF2) with same structure/fields as in a logical file(say LF1, whose physical file is PF1). One way is to use CPYF to create PF2 from LF1 but I dont wan’t any data to be copied from LF1 to PF2 (dont want to use clrpfm after [...]
Answer Question
| November 17, 2012 7:47 PM
AS400 Command, CPYF, DB2
How to access Exchange Server live
I have installed Exchange Server 2003 on a server which has a private IP like 192.168.1.4 now I want to access this server outside the domain which I created with a public IP 182.180.76.46 and access live and send and receive mails from other domains.
Answer Question
| November 19, 2012 6:34 PM
Exchange 2003, Exchange Server 2003
I have installed Exchange Server 2003 on a server which has a private IP like 192.168.1.4 now I want to access this server outside the domain which I created with a public IP 182.180.76.46 and access live and send and receive mails from other domains.
Answer Question
| November 19, 2012 6:34 PM
Exchange 2003, Exchange Server 2003
Communication Engineer career and certification options
I have got two bachelor of science degrees: in electrical engineering and computer science, from a university in africa. I have experience in public telephone switch (such as DMS 100 from Nortel, AXE-0 from Ericsson) and PABX (Alcatel OmniPCX 4400). What do you advise me I need to do to get employment opportunities and advance [...]
Answer Question
| November 17, 2012 7:08 AM
Career and training options
I have got two bachelor of science degrees: in electrical engineering and computer science, from a university in africa. I have experience in public telephone switch (such as DMS 100 from Nortel, AXE-0 from Ericsson) and PABX (Alcatel OmniPCX 4400). What do you advise me I need to do to get employment opportunities and advance [...]
Answer Question
| November 17, 2012 7:08 AM
Career and training options
Software
What is software? Why we use? Why it necessary to be update?
Answer Question
| November 19, 2012 4:41 AM
Software, Software development
What is software? Why we use? Why it necessary to be update?
Answer Question
| November 19, 2012 4:41 AM
Software, Software development
Microsoft Excel
Gents: Could you please assist me in the below case: 1-I have 2 Excel sheet on my PC (Excel A is extracted on a daily basis from I Series by using data transfer while Excel B is the target one). 2- Excel B (target) has a special header and colors and contains 4 columns and [...]
Answer Question
| November 19, 2012 12:47 AM
Microsoft Excel, microsoft excel functions
Gents: Could you please assist me in the below case: 1-I have 2 Excel sheet on my PC (Excel A is extracted on a daily basis from I Series by using data transfer while Excel B is the target one). 2- Excel B (target) has a special header and colors and contains 4 columns and [...]
Answer Question
| November 19, 2012 12:47 AM
Microsoft Excel, microsoft excel functions
Table setup
I am creating my first database. It will hold quote, job write up and invoicing information. We currently have two spreadsheets. One Spreadsheet is for quotes. It has the following info: QUOTES Date – Quote # – Customer – Cust Quote # – Part # – Part Name – Quote Due Date – Qty – [...]
Answer Question
| November 19, 2012 11:39 PM
Microsoft Access, Microsoft Access spreadsheet
I am creating my first database. It will hold quote, job write up and invoicing information. We currently have two spreadsheets. One Spreadsheet is for quotes. It has the following info: QUOTES Date – Quote # – Customer – Cust Quote # – Part # – Part Name – Quote Due Date – Qty – [...]
Answer Question
| November 19, 2012 11:39 PM
Microsoft Access, Microsoft Access spreadsheet
Find and Replace
I have a spread sheet where I need to replace the space between each word with a hyphen. Since find & replace does not recognize space, is there another way to do this?
Answer Question
| November 19, 2012 11:30 PM
Microsoft Excel 2010, microsoft excel functions
I have a spread sheet where I need to replace the space between each word with a hyphen. Since find & replace does not recognize space, is there another way to do this?
Answer Question
| November 19, 2012 11:30 PM
Microsoft Excel 2010, microsoft excel functions
Tax entity
What is the Tax Entity Field used for in the F0006?
Answer Question
| November 19, 2012 11:00 PM
JDE 9.0, JDE fields
What is the Tax Entity Field used for in the F0006?
Answer Question
| November 19, 2012 11:00 PM
JDE 9.0, JDE fields
How to convert QF file to Word document?
How do I convert QF file to Word 2010?
Answer Question
| November 19, 2012 10:02 PM
Microsoft Word 2010, QF File
How do I convert QF file to Word 2010?
Answer Question
| November 19, 2012 10:02 PM
Microsoft Word 2010, QF File
Lotus Code Needed
I’m trying to complete an @If statement to compare two fields in Input Validation. Field One: SL_1 (Values only can be 0 to 24) Field Two: D_1 (Values only can be 0 or 1) Current Code: @If((@ToNumber(D_1) > 1); @Failure(“Sunday needs to be a 0 or 1″);@Success) Additional Code Needed: If SL_1 = 0; D_1 [...]
Answer Question
| November 16, 2012 7:56 PM
Lotus Notes 8.1, Lotus Notes Fields
I’m trying to complete an @If statement to compare two fields in Input Validation. Field One: SL_1 (Values only can be 0 to 24) Field Two: D_1 (Values only can be 0 or 1) Current Code: @If((@ToNumber(D_1) > 1); @Failure(“Sunday needs to be a 0 or 1″);@Success) Additional Code Needed: If SL_1 = 0; D_1 [...]
Answer Question
| November 16, 2012 7:56 PM
Lotus Notes 8.1, Lotus Notes Fields
Link for Windows Server 2008 interview questions
Forward link where I get more knowledge for the Windows 2008 Server.
Answer Question
| November 16, 2012 5:08 PM
Windows Server 2008
Forward link where I get more knowledge for the Windows 2008 Server.
Answer Question
| November 16, 2012 5:08 PM
Windows Server 2008
Parameter Manipulation – Turning ‘abc’ type string into a number
I have the following code being used in a parameter: SELECT OU1.OU_CODE AS PROCESS_LEVEL , RTRIM(OU1.OU_CODE) || ‘ – ‘ || AD1.DEPARTMENT_NAME AS Description FROM ODS_OWNER.POSITION_ASSIGNMENTS PE1 JOIN ODS_OWNER.ADMIN_DEPARTMENTS AD1 ON PE1.DEPARTMENT_ID = AD1.DEPARTMENT_ID JOIN ODS_OWNER.ORGANIZATIONAL_UNITS OU1 ON AD1.OU_CODE = OU1.OU_CODE WHERE PE1.POSITION_LEVEL = 1 AND COALESCE(PE1.END_DATE, CAST(’01/JAN/1753′ AS DATE)) = CAST(’01/JAN/1753′ AS DATE) –PE1.END_DATE [...]
Answer Question
| November 16, 2012 4:17 PM
Microsoft Visual Studio, ORA
I have the following code being used in a parameter: SELECT OU1.OU_CODE AS PROCESS_LEVEL , RTRIM(OU1.OU_CODE) || ‘ – ‘ || AD1.DEPARTMENT_NAME AS Description FROM ODS_OWNER.POSITION_ASSIGNMENTS PE1 JOIN ODS_OWNER.ADMIN_DEPARTMENTS AD1 ON PE1.DEPARTMENT_ID = AD1.DEPARTMENT_ID JOIN ODS_OWNER.ORGANIZATIONAL_UNITS OU1 ON AD1.OU_CODE = OU1.OU_CODE WHERE PE1.POSITION_LEVEL = 1 AND COALESCE(PE1.END_DATE, CAST(’01/JAN/1753′ AS DATE)) = CAST(’01/JAN/1753′ AS DATE) –PE1.END_DATE [...]
Answer Question
| November 16, 2012 4:17 PM
Microsoft Visual Studio, ORA
VFP sub-menu pops to left in Windows 7
I have a VFP 9 application running on Windows 7. The problem is that all sub-menus appear to left of the parent menu? If I run the application on XP, the menus work correctly. I applied SP2 (10/16/2007) and it did not resolve this issue. Any suggests would be appreciated.
Answer Question
| November 16, 2012 3:14 PM
Menu, VFP9, Windows 7
I have a VFP 9 application running on Windows 7. The problem is that all sub-menus appear to left of the parent menu? If I run the application on XP, the menus work correctly. I applied SP2 (10/16/2007) and it did not resolve this issue. Any suggests would be appreciated.
Answer Question
| November 16, 2012 3:14 PM
Menu, VFP9, Windows 7
Debug
How to debug an SQL Stored Procedure?
Answer Question
| November 16, 2012 1:14 PM
SQL, SQL procedure
How to debug an SQL Stored Procedure?
Answer Question
| November 16, 2012 1:14 PM
SQL, SQL procedure
Calculate Duration for Annual Leave
Hi, I have Lotus Notes application which is for Leave applying. I have calculate duration function to calculate duration of leave when user put Date from to Date to. This function did not calculate Saturday and Sunday as working day even the user put Saturday and Sunday in their leave. But the problem is some [...]
Answer Question
| November 16, 2012 12:40 PM
Lotus Notes, Lotus Notes Application
Hi, I have Lotus Notes application which is for Leave applying. I have calculate duration function to calculate duration of leave when user put Date from to Date to. This function did not calculate Saturday and Sunday as working day even the user put Saturday and Sunday in their leave. But the problem is some [...]
Answer Question
| November 16, 2012 12:40 PM
Lotus Notes, Lotus Notes Application
