Search results for query: *

I am able to produce reports in COGNOS 8 Report Studio but have a problem with the page footer not showing on every page. For pages where the data wrapped and caused the row height to expand, the page footer is pushed off the bottom of the page. I see the page footer information on every page...

I am not sure this question belong in this forum but will be happy to re-post if pointed to the right forum. I am trying to FTP a file from a specific folder on my PC with the following code: corpftp.corp.life.net (exit=255 resources\corpftpuser Password cd corpftp\cdf\vouchers get GL__*.*...

I have written a code to read the files in a folder that the user selects from browsing for a folder. I want to process all .xls files in the folder and used the 'DIR("*.xls",xlNormal)' directory search. It worked fine once and processed all the files but does not see the files when I run the...

I have the following code in a macro that works perfect on my machine and two other PC's. However, one client is having problems with the closing process. As the code stands, when we run the macro the Excel application closes down completely if no other workbooks are open or closes the related...

I have seen a ton of samples on looking up a table to return a value when there is a match but none on doing a lookup and matching two values then returning the third. (Or I am so confused, that I missed it) I am working on Excel 2000 (moving onto 2003 in two months) and need to do the...

I added a SaveAs statement in my VBA codes for Excel 2000 with a password assigned to the Password:= and WriteRespassword:= parameters and when I execute the macro I have no problem re-opening the workbook when prompted for the password. However, when other users run my macro and create this...

I developed a workbook with Excel 2000 that is password protected and runs with a lot of macro validation using VB codes. A user is trying to access this with MS Excel 2003 and every time she keys an input into any of the cell that they are allowed to enter data into, an annoying little box...

I am working with EXCEL 2000 and have created a userform to pop up so the user can select an account from a ComboBox. If no account is selected, I display a warning message letting the user know that an account is required. This warning dialog box is center screen and covers my original...

I signed my workbook with a digital signature using SELFCERT and it has worked fine for the last ten months. I am suddenly having problems with reopening the workbook after using it and saving it and can't figure out why. I did make changes to it; added a userform, macros to run each time a...

I have tried every trick I can come up with to change negative amounts on my spreadsheet to place the sign at the end of a number instead of at the beginning. Is there a way to do this using VB codes? I am working with Excel 2000. I was able to go from: -555.66 to 555.55) Don't know why...

Is there a way to warn a user that there are errors on a spreadsheet when trying to save it and then stop the save process? I would like to keep the spreadsheet from being saved until all required fields have valid data in them. I am working on Excel 2000.

I wrote a VB macro in Excel 2000 and have a major problem. I need to save the formatted Excel file in a folder that the person running the macro has no access to. Because of security issues at my company, I cannot allow the person running the macro and creating the data file, to have access to...

I have 30 TextBox items listed on a UserForm and would like to go thru each one before updating my database to make sure that a value was entered and if so, move that value to a work field. I named these boxes EntryNo1, EntryNo2, .... EntryNo30 and get them to work if I create a statement for...

I am new to SQL and would like some help on this issue. I have added a table to my SQL 2000 database and manually imported the data from an Excel spreadsheet into it. Whenever the data changes on the spreadsheet, I would like to be able to update this table from a job I would execute at my PC...

I have a Userform with a sub procedure call Userform_Initialize. I have a button on an Excel sheet with a sub procedure in Module1 assigned to it. This sub has one statement in in : Call Userform1.Userform_Initialize. When I click on this button, the procedure was called, all the...