I have searched all over the forums and haven't been able to find a post that addresses my specific issue.
I work in payroll outsourcing. I have a client I deal with and my co-workers have other clients. We are responsible for identifying when the clients are out of balance on their FICA filings. In order to do this we have SAP output a .dat(text) file. Formatting and analyzing this is a very LONG and monotonous task.
I am trying to develop a macro to do this that ANY coworker can use ANYTIME on ANY client file. The data format output from SAP is always the same. I have been successful in creating the macro using one of my files; however, based on this error it looks like I have to make everyone else use the same file name in order for the macro to run successfully. Keep in my mind, I do not know have any VB(or any other) coding experience, but I am a techie.
Here is the error: OLqQ9.png
Below is the code. The error occurs in the "ActiveWorkbook" section. I'm assuming it is because there is because each client will have a different tab name and file name than "582_03142012_AMOUNTS". Is there a way to make this generic so the file name or tab name do not affect the macro?
Thanks,
Craig
Bookmarks