Recent content by fishax

Unfortunately it did not work (I did not try it via code, but I believe this would fail as well). It may be because of spaces in the values entered. Values are in the format as follows: {space}{space}35.34{space} or {space}{space}{space}2.84{space} or {space}345.67{space} If I re-enter the...

Hello, I have an Excel Sheet with what appears to be Numbers, but are actually Text. I need a way to convert these to Numbers using an automated formula or Macro. Can anyone point me in the right part what Excel has to be able to convert Text to Numbers?

I managed to get it working via vlookup, but I had an Email firing on WorkSheet Change Event, which now does not work since I am using Calculation (vlookup) to populate the Cells on Sheet 2 vs manual. Will have to think of something else to fire the email when condition is met on Sheet2.

Hello, I need some guidance to achieve the following. I need to copy value from Sheet1 to Sheet2, if an equal condition is met for one of the cells on both sheets. This illustrates what I need. Sheet 1 Cell A1 : X Cell A2 : Y Cell A3 : Z Sheet 2 Cell A1 : X Cell A2 : D What I need is for...

Thanks for the replies. I have managed to get somewhere. Currently I have the code running on manual press of a Button, but what I need to know is what Event to use when a cell or range of cells get updated (i.e as soon as I enter a value in a Cell...without having the need to Save..I would like...

Can I use the SendMail Method to Email WorkBook to be triggered by an EVENT? I was thinking of a periodic check process that sees that value A is greater than Value B in the appropriate Excel Cells. Not sure how this would be achieved, but just a preliminary thought of the approach. Are there...

Hi, Am a newbie and need some guidance. I would like to send an email via Outlook or Outlook Express, if Cell A1 value is greater than cell B1 in Excel. The email would have to contain the value of A1 and B1.

Not sure what you mean? If you have IIS WebServer installed on the Server where you have CP Manager and Reporter, you should be able to access it from any client. e.g. http://servername/cpmgr

Did not get a chance to test with TS. The production environment is working well and do not want touch it now. All I can tell you is that we do have TS running. We normally schedule the reports to run overnight to a pdf file, and we are seeing data. For that, you need a local Admin account, and...

I will confirm for you. One thing I do know that with Enterprise 2003 SP1, we were not able to connect to the CP Server, even though we followed instructions to configure DCOM to allow Anonymous and Everyone Access. Once we uninstalled SP1, the Reporter was able to connect fine (as seen in...

Yes, the System Log has to have the entry that you are connected. Sometimes you have to click on it couple of times for it to show up. Once the connection is established,on the CP Server itself, it creates an ODBC connection entry (under System DSN if I recall correctly). As soon as you hit...

Is your System Log showing that you are connected to CP Server when you run reporter?

Thanks spdrake for that. It was being installed remotely. I will try the Local Install. As mentioned, just created a local admin account, then for the Anonymous Account in IIS, I used this account for Web Default, then for the Reporter Service, used this account as well. Then connected and...

Just an update. I did get it working with Windows 2000 Advanced, SP3 as well as 2003 Enterprise Server. Scheduled a report to run overnight and save to a pdf file and worked fine after it ran (somehow the association between the WebServer+Call Pilot Server was established when the report got...

Are there any tools to trace problem?