Recent content by JazzyLee

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...

You are right ... I am even more confused than before. However, after reading your suggestion, I will attempt to write a VB Function that will search the directory for any file with a create date of today, copy that file into a designated file name (append all subsequent files sent in the same...

Amiel, OS on the PC would be Windows XP, Servers are running Windows 2000 and 2003 (depending on which one we use) and the Mainframe is Zos Version 1.6 and running FTP CS Vir6 from the Mainframe. I currently have FTP jobs that are set up to pull a specific file in from the PC and write it to a...

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__*.*...

Thanks for the quick response ... I am meeting my deadline on this project. I used the suggestion from PHV to add the path to the file name (strPath_I & "\" & iFile.Name) and it is working like a charm. I also went back to my old DIR codes and cleaned it up using the subroutine from...

Combo, This is the code for the second method. I imagine the DIR method would be resolved if I can figure out why this is happening. I get an error on the Workbooks.Open line that says: "'GAAP1100.xls' could not be found. Check the spelling of the file name, and verify that the file location...

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...

Thanks! I'll build on this. It's a BIG start and a whole lot more than I would have come up with on my own.

dokR, How did you get this to work? I have the same problem. Mind sharing your codes? Thanks much!

I have not stepped thru this code in a debug mode on my user's machine but I did on mine (where it works, of course) and the names on both variables are showing up OK. I think I will try to put a break point at the close routine on her machine and then step thru to check the name. I will post...

I thought it might have to do with the individual settings in her Excel but couldn't find anything relevant to this problem. This may work if I only knew where this option is so I can turn it off. I looked under Tools/Options but didn't find where to change the setting. Can you please point...

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...

Zathras, I cannot express my appreciation (and elation) in getting this to work. "Mega Thanks" for the code. I would have never figured this out and it works perfectly. I guess I can pack up and go home now. The rest of the code in this macro will be easy after this challenge.

I would much prefer to run this with the INVALID_CC_LIST workbook unopened but if I comment out this statement Workbooks.Open (INVALID_CC_PATH + INVALID_CC_LIST) I get a "subscript out of range" error on the next line. I tried substituting a combination e.g: Set wkbCCList =...

The data is sorted in the same order your sample is (column A then column B) and you are right on target with the process. I just don't know how to refer to the Invalid_CC_List workbook while going down the row of data in my active sheet. What would the code in the Function be like to return...