Recent content by crpjaviman

Thanks, Andy. I keep forgetting about working with forms. Let me try that and maybe I can work the .DLL out of the programming. Thanks, crpjaviman [rockband]

Hello, I have a progress bar in my Excel 2013 reports that has a .DLL file accompanying it and it works great for me. I tried to hand over to a co-worker and forgot to install the DLL file so it failed. Now I am trying to find a progress bar function that I don't have install something along...

Hi everyone, I have been looking for some code that will find an email in a specific folder, open the attachment into Excel 2013, and save the report in a specified folder on a drive. I think I can handle the saving file part but the opening the attachment is kicking my butt. I would like to...

Hello all, I've a break from the other project and want to continue my momentum on this project. Here is the basis: I have 7 reports that have certain info that I need to compile into a one page report per employee. The information includes DOH, supervisor, a few phone metrics, sales info...

Hello everyone, Sorry, I was diverted to another project. I will be back soon to continue the search or re-mod of this report. I like the idea of converting it all to Excel, maybe one report to do all of the pieces and full of VBA code. Thanks and talk soon. Thanks, crpjaviman [rockband]

Hi Skip, The reports originate in Excel, imported to Access, and end back in Excel. I use Access to do some of the heavy queries and sorting from multiple tables then back to Excel. I am taking over the reports from a previous analyst so I am just trying to keep it moving while I make...

That would be great, kray, but I've tried that and it doesn't record the Access actions. I've made sure the references for Access are added but to no progress. I would have to create a createobject mod for Access. Thoughts? Thanks, crpjaviman [rockband]

Hello all, I am getting back into VBA coding after a few years away and it's coming back slowly plus adapting to the new verbiage. I have a curious question: how can I convert the saved import tasks in Access 2013 into VBA code? I can manage the import process better if it's in code. If...

Hello everyone, I have a unique problem with my code in VBA in Access. I have created a database with a mod in Access '97 and it works perfectly. Here is a brief on the process: 1. Delete all tables 2. Import certain tables from a directory 3. Create crosstab and make-table queries thru...

Hi, I work at a company that has Lotus Notes 5.0.11 running on XP OS. I am trying to open, launch, or extract an attachment from within a Notes database to Excel or even to the Desktop as a file, doesn't matter. I have been able to get to the $File item but no further than that. I have put...

kwkranger I have used this vb code to find the first row of an item. This should be able to be modify for your use and increase speed. I could only find the code in one of my excel uses but can be converted to what ever you need. With ActiveSheet.Range("C:D") Set C =...

I have done what you are looking for in VB code. I have several workbooks with several worksheets that I need to update on a daily basis. Dim x, y As Integer For x = 1 To Workbooks.Count Workbooks(x).Activate For y = 1 To Worksheets.Count Worksheets(x).Activate MsgBox...

I found out what I was doing wrong. It is working now. Thanks for all of those that looked at this posting. Thanks, crpjaviman [rockband]

Hello all, It's been a while since my last thread. I am having a slight problem with my VB6 project. The following code works great on the first run. The form has checkboxes to choose different reports in any combination. The first time it runs, it runs great. Then, if I want to have a...

I don't want to sound stupid, but wouldn't it be easier to just add 7 days to the starting Wednesday and do a Format function to find out the month that it is in? For example: Dim startw, endingw As Date Dim wmonth As String startw = Me![StartWeds] endingw = startw + 7 wmonth =...