Software Applications Programming Errors and solutions.

To search subfolders and Add hyperlink for file from the top level folder using Macro code in Excel. You can take help from code below. Private Files As Dictionary Private StrFile As String Public Function FindFolder(strpath As String) As String Dim fs, f1, f2, FleCollection Set fs = CreateObject("scripting.filesystemobject&quot ;) Set f1 = fs.getfolder(strpath) Set f2 = f1.subfolders Set FleCollection = f1.Files For Each subfld In f2 FindFolder subfld.Path Next For Each fle In FleCollection Files.Add fle.Name, fle.Path Next End Function 'add below code before adding hyperlink If (Files Is Nothing) Then Set Files = New Dictionary End If 'Filename should contain Extension like "test.pdf" If Not ((Files.Exists(Filename))) Then 'replace c:\ with root folder of the file,if you are no sure about Root folder, You need to call it with all possible drives like "C:\" "D:\" etc

I got one good site which is Excellent Investment Calculator for diffierent purposes. You can visit following link. http://investmentyogi.com/Financialcalculators.aspx By this site you You can get following calculators Income Tax Calculator,Home Loan EMI,Double your money Calc,Systematic Investment Plan,Recurring Deposit Calc,Life Insurance Calculator,Fixed Deposit Calculator,SIP Investment calculator,Final return on monthly SIP,Annuity Calculator,Retirement Corpus,Save To Become Crorepati,CAGR Calculator,Insurance Calculator Future Value Calculator,Inflation Calculator,Interest Payable Calculator,Time To Become Crorepati Housing loan eligibility,Home Loan Refinance,Financial Health Calculator,Investment Planning Calculator etc.

This is a Macro code in excel to insert blank row on column change in excel. Dim rval As String, i As Long rval = Cells(1, 1): i = 2 Do Until Trim(Cells(i, 1) & "") = "" If Cells(i, 1) <> rval Then rval = Cells(i, 1) Rows(i).insert shift:=xlDown i = i + 1 End If i = i + 1 Loop End Sub

Machines can never be as intelligent as human beings, although it is just a matter of perspective! By the term intelligence, if you refers only the modelling of human behavior [weak AI],it might b possible with the help of a large computational power. But if u want to built the real intelligence [strong AI], the task is going to b tough. In 1980, John Searle introduced a famous thought experiment called Chinese room experiment. He argued that intelligence can never be attained with the blind manipulation of symbols, as suggested by "The physical symbol system hypothesis"[by Newell and Simon, 1976].The thought experiment is explained bellow. "Consider an 'intelligent machine”, which answers to questions asked in Chinese, back in Chinese. Then, given the algorithm of the machine, one who doesn't speak Chinese can also answer the Chinese qns, executing the algorithm line by line. But that don’t makes him know Chinese. Like this, the "intelligent" ma

Use the SUBST command to substitute a drive letter for a path in order to treat a virtual drive (a reserved area rather than an actual disk drive) as a physical drive i.e create a new drive for your Favourite Folder in MS-DOS Prompt. For e.g if you want to create a drive named Z for your Program files folder then u need to enter the following in your DOS mode : - subst z: "c:\program files" This will create a drive named Z in your My Computer so that you can directly access your program files contents from this Drive. You can also create a Separate drive for your separate folder for accessing data easily. For e.g Separate drive for your music folder etc.

In case of SSRS  in SharePoint Integrated mode. You may have report server in SharePoint integrated mode and the Reporting services running under domain account. which will be part of domain admin group as well.but when you try to connect to http:\\localhost\reportserver it may give following  error: Reporting Services Error -------------------------------------------------------------------------------- Report Server has encountered a SharePoint error. (rsSharePointError) Get Online Help User cannot be found. -------------------------------------------------------------------------------- SQL Server Reporting Services and in reporting service log it gives me following information w3wp!webserver!1!8/15/2007-13:40:01:: e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.SharePointException: Report Server has encountered a SharePoint error. ---> Microsoft.SharePoint.SPException: User cannot be found. at Microsoft.SharePoint.SPUserCollection.Get

Proclarity - ease of use; Dashboard and KPI capability; chart types etc., are better than in Microsoft. Also, Proclarity is something even Business users can use (we can create libraries as starting points and the business users can deploy onto a PAS server) SSRS - offers greater control over formatting, which sometimes can actually be quite frustrating because expectations from an SSRS report is also higher in terms of formatting detail. But SSRS cannot be used by business users; Also no dashboard or KPI capability within SSRS. printing capabilities SSRS have which proclarity doesn't have. In fact formatting in SSRS might be difficult to achieve but anyway its is better than Proclarity. The point where Proclarity is better is KPI and Dashboard reports. Once configured even SSRS reports are used by business users. Proclarity as one of my friends said is more of an analytic tool. Even the Ad-hoc report functionality of SSRS involves Report Builder is meant to be shared