Search results for query: *

I am having a problem with VB script in an Excel spreadsheet that is calling a stored procedure. The stored procedure I am calling is used by other spreadsheets and has a sorting method that I want to override. I don't want to change the stored procedure, but just change the sort order in the...

Hello. I have a spreadsheet that has a "stoplight" display which is essentially 3 small circles colored red, yellow and green. Each circle is in its own cell. Is it possible to put these shapes into a drop down list so that when the user selects one of them, a predetermined cell is filled...

I hope this isn't a stupid question, but here goes. If I know the index number of a column, how do I retrieve in VBA the alphabetic column header name? Example: Column 47 of the spreadsheet is "AU". The formulas I need to modify on a worksheet use the format: "=SUM('Master sheet v2.0'!AR14)"...

The code below returns a run-time error 1004 on the Publish method. I don't know what VB is complaining about. Thanks in advance for your help. Set objRange = ActiveSheet.Range("A1:Q33") objcoord = objRange.Address Set objPublish = ActiveWorkbook.PublishObjects.Add (xlSourceRange...

Is there any way in VBA Excel 2002 to use the "Republish: Sheet" feature when saving the active worksheet as an "html" formatted file? The online help for the "SaveAs" doesn't show this feature as available. Any suggestions? Thanks in advance.

I have a user who has created a spreadsheet used for data entry. He has placed some "VLookup" formulas in several of the input cells to create drop down picklists. However, when a user enters and saves a new value that is not in the picklist, the "VLookup" formula is lost and overwritten by...

I've done a forum search, but none of the topics seems to have a solution that works. I simply need to set the ".columnwidth" property of a spreadsheet to a certain width. I tried "autofit" (which is preferable to me)that also didn't seem to work. Here is what I am doing in VBA...

I have a very frustrating problem with my PC. Several times a day, NAV 2005 pops up a warning dialog box saying that it has detected a trojan horse in file "C:\System Volume...\A0037442.exe" Trouble is, this file does not exist on my hard drive, and there are no references to it in my...

Hello. I am getting the "1004" error when I try to copy an active worksheet to a new one I just created. Any ideas on what I am doing wrong? Thanks! Dim objNewWS As Excel.Worksheet If chkSheet = True Then Set objNewWS = Worksheets.Add objNewWS.Move ...

I have written a VB 6.0 (SP6) application that allows the user to view Cognos reports without having to go through the Impromptu Administrator application. It runs fine on my development machine (of course). I created an install package using the package and deployment wizard, and when I...

I have a VB 6.0 app that is writing a cookie to the C:\Documents and Settings\UserID\Cookies directory. The cookie I am writing is recognized by the web application that I launch from a VB form which has an IE window on it. However, if my application is run on another PC and the cookie is...

I am using the INET control with VB 6.0 under Windows XP Pro. When I access my FTP server which is on our LAN, and try to GET a file to my local C: drive, I get an "Access Denied" error on my local C: drive. This also happens when I open a DOS window and use the FTP utility to log into the...

I have written some VB 6.0 code which runs under Windows XP Pro that seems to be having some trouble. On MSDN, I found some code which should allow be to create a process that executes an Oracle TNSPING from a command line. Then the code should read the output of the created process and stip...

Hello: I have an emissions report that prints out emissions data to the precision of 2 decimal places. However, certain emissions are very small, so if a pollutant has an emissions amount of < 0.01, then I need to change the number field's formatting. I need 6 decimal places of precision and...

I have a Cognos catalog that I have added 3 new tables to. These tables have the exact same layout as 3 exsitng tables in the database, but contain older, archived data. What I would like to do, is to point some existing Cognos Impromptu reports to these 3 new tables without re-writing the...

Is there a tool or process that will facilitate converting Cognos Impromptu 7.0 reports to Crystal Reports 7.0 or higher? Or, is this a &quot;write a new Crystal Report from scratch&quot; exercise? The reports that will be converted will be accessed through Crystal Enterprise. Thanks in...

I think I already know the answer to this, but is there any possible way to make a list frame on an Impromptu 7.0 report expand to fit the size of the records returned by the query? Currently, if the query for the list frame returns more records than will fit the size of the list frame, the...

I have a question about excluding certain rows from an average in impromptu 7.0. I have a column of values like this: Tons Stump $ Stump $/Ton 100 1000 10 200 2000 10 300 0 0 <-- I want to exclude this row 400 0 0 <-- I want to exclude this...

Hi: I have created a VB 6.0 program that that uses the Cognos &quot;OpenCatalog&quot; and &quot;Open Report&quot; objects to open and run an existing report in Cognos 7.0. I want to distribute this application. What Cognos DLL's do I need to distribute with my app so that a user can generate...