Search results for query: *

Hello, I am using Cognos script Editor to save an excel report with format. I am accomplishing this by using SendKeys. However, I find that sometimes the use of Sendkeys does not copy over any existing occurences of the excel file I'd like to copy over. So I read somewhere in this forum that...

Good afternoon, I need assistance with a VB code that will copy a .txt file from one location to another. The catch is, however, that I need the copied .txt (that is, the new .txt file that copied into another location), to end with a time stamp. Here is an example of what I mean...

Hello, At the very end of my cognos script, I have a command which should open an excel file: Shell ("C:\Program files\Microsoft Office\Office10\excel.exe /Y Y:\Standard Reports\Acc dept\test.xls") The problem I am having is that it cannot read the file pathname 'Standard Reports'...

Hello, Does anyone know the question as to whether the Cognos script editor can run a batch file? If not, then can you tell me if there is Cognos Script Editor syntax that can open an excel file? Dalex

Hello, My code is below. I want to add to this code something that will remove any rows that have the value 0 (zero). Any thoughts will be much appreciated! Dalex Private Sub Workbook_Open() Application.EnableEvents = True Dim FileNum As Long, i As Long Dim y As Variant FileNum =...

Hello, Does anyone know of a way to save an .xls file with format using the Cognos script editor? I'm trying to automate a process where I click on a macro button developed through Cognos script editor to save an Impromptu report as either excel or text WITH FORMAT. Thank you, dalex

Hi, Is it possible to execute a specific macro depending on a file name? In other words, I have created macro1, macro2, and macro3, and would like for macro3 to run every time the file name abc.xls is opened. Any replies would be much appreciated. Please note that macro1, macro2 & macro3 are...

Hi, Is it possible to execute a specific macro depending on a file name? In other words, I have created macro1, macro2, and macro3, and would like for macro3 to run every time the file name abc.xls is opened. Any replies would be much appreciated. dalex

Hello, Is it possible to execute a batch file using VB Script editor? If so, I would like to know the code. Dalex

Hello, Can I get some assistance on creating a quick and simple batch file (is this even the correct group)? I am a first time creator of a batch file and am not finding the internet very resourceful. My goal is to do the following: 1) Open a program (SQLTalk) 2) Open a file 3) Run the file...

Hi, Can I get some assistance on creating a quick and simple batch file (is this even the correct group)? I am a first time creator of a batch file and am not finding the internet very resourceful. My goal is to do the following: 1) Open a program (SQLTalk) 2) Open a file 3) Run the file 4)...

I have a form where users enter an e-mail address for each new record. How can I link that to my Outlook e-mail program when clicked? Thanks, Dalex

I created a very simple Access 'Log" database. The objective is to log all calls that are placed to our software developers on an Access Form. FYI - Each log issue has a unique log number. I would like to learn how I can link backup documents to each issue. For example, if issue #...

Hello, I created a very simple Access 'Log" database. The objective is to log all calls that are placed to our software developers on an Access Form. FYI - Each log issue has a unique log number. I would like to learn how I can link backup documents to each issue. For example, if...

Hello, I have a very simple database with one table, and a form that feeds of the columns of that one table. I am trying to create a customer satisfaction log and would like to learn how I can create a lookup query on the form. For example, if I wanted to reference a record but do not have...

I would like to know how I can make Acess start with the biggest number each time a form is open. FYI - The form has a ticket number and some details. When the form opens each time, I want the record with the biggest ticket number to display first. Dalex17

Hello, I created a form within the VB screen of my Access database and called it UserForm1. The only object in that form is a picture of a progress bar. My question is: How do I link that progress bar to my save button which is on the form. I want that progress bar to execute each time I...

Regarding Microsoft Excel: I have a code (below) that clears the contents of cell B95 each time the workbook opens. Range("B95").ClearContents The problem I am having is that it only clears the cell of the one active worksheet that was last open; each time I re-open the workbook...

I am in need of a code that will allow a macro to run only when the conditon cell B92 equals cell F96 is met. I guess this would be a sort of "IF" statement that would say if cell B92 = F96, then run macro, else do not run (or something like that). Here is the catch however: the...

I've seen an ability with excel that hides (or removes from visibility) an excel workbook while a macro is running. The purpose is so that a user will not see the macro as it runs. FYI - I'm recording the macro by movements and not writing program language. Any step by step assistance would...