Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Groves22
  • Content: Threads
  • Order by date
  1. Groves22

    New "Run-time error '1004'" out of nowhere!

    I run a weekly report each Friday. I was on vacation last week. When I try to run the macro, I get the error. This has worked for years, but now crashed for some reason. During my vacation, I was upgarded to MS Office 2007, could that be the issue? With PolicyD.Sheets(1)...
  2. Groves22

    Using VBA in Access...

    Hello... I am very new to Access VBA, VERY NEW. I do well with Excel so I have a little background, but Access is a different monster! I have 15-20 queries that I would like to auto run with a press of a button. I have (just a partial testing code): Sub Run_Queries() DoCmd.OpenQuery...
  3. Groves22

    Using VBA in Access...

    I have never coded in Access' VBA (just Excel). Is it possible to create a macro that will run all of the queries I have set up? If so, how? Some query names are: 01_PIF Counts, 01_V12 Disc & 01_V12 Unique Pol Thanks! Josh
  4. Groves22

    UserForm from 2003 to 2007

    I have two computers at my desk. 1 uses Excel 2003, the other uses 2007. I created a UserForm calendar using the following websites method. http://www.fontstuff.com/vba/vbatut07.htm When I try to run the macro that used this form in Excel 2007, the VBA is bombing out. I tried to follow the...
  5. Groves22

    VBA - Adding items to pre-made calendar

    Hello... I have a document that has 13 tabs; Names, Jan thru Dec. The name tab looks like: Name Dates in Jan Dates in Feb etc. John Doe 1,2,3 1,15 Jane Doe 15,16,17 And the Jan thru Dec tabs have blank calendars with dates in them. Each day...
  6. Groves22

    VBA Efficiency

    I run a report during the first week of the month. It captures data monthly, and rolls it to YTD. The file isn't too bad now, but I know at the end of the year, the Excel profiles will be about 500MB+ (which I actually shrunk from 1.2GB) I have some VBA that takes this file, and lumps a lot of...
  7. Groves22

    Finding text from another list

    This may be easy... or not, but I can't figure out what to do. I'm trying to format a list of addresses. They were given to me in 1 column, however, I had to break them out (using 'Text to Columns') each word to it's own column. So now the address ranges from 3 to 7 columns long, depending how...
  8. Groves22

    Excel VBA - Fine Tuning Help...

    I run a report monthly, which I just created the following macro to run for me. The code is making the computer/Excel hang up for longer than it would when doing it by hand. I assume it's the section listed below. Is there a better way to write some of this? Thanks! Dim t As Long With...
  9. Groves22

    Name Range in Excel

    I'm sure this is an easy fix, but I keep getting an error when I run the following code: With Sheets("Paste Area") .Cells(1, width + 3).Value = .Cells(2, width + 3).Value - .Cells(2, 21).Value .Cells(1, width + 3).Name.Add Name:="dist_to_unit_year" How to fix this? Thanks!
  10. Groves22

    Why am I getting an 'Overflow' error, now?

    Hello.. I started building a macro on Friday. I got to a certain point, and had to leave for the weekend. I tested up through the point, and everything worked fine. Now when I tested it this morning, I am getting an Overflow error in a step that worked fine on Friday. I have not changed...
  11. Groves22

    Save as, but leave original open

    Hey all... I am trying to save a file with a different name, but keep the original open. I guess the way it works now is: File 1 save as File 2. The open file is now File 2, while File 1 is still on the drive. Is there a way to get File 1 to save as File 2, with both File 1 and File 2 being...
  12. Groves22

    Macro Run-Time error

    Hey all... I ran and tested this macro on Friday, and everything worked fine. Now this morning when I run it, I get an error. The error messages the comes up is: Run-time error '1004': Application-defined or object-defined error and it shows up on this line: Sub Formulae_for_daily_summary()...
  13. Groves22

    Compile error

    Hey all... Why am I getting this error. I'm sure it has to do something with " and ', but I can't figure it out. Could someone look at this line and see if you can crack the code?! I get a Expected: end of statement error box TempR.Sheets(1).Cells(q, 18).Formula = "=VLOOKUP($E5 & "-BI",'G:\ACIC...
  14. Groves22

    Excel Question

    I wasn't quite sure where to ask this... so if it's not in the correct place, I'm sorry. I am trying to find the minimum number of a group of numbers, with several different gourps. It might be easier with an example: Key Number ACPA20096 74 ACPA20096 74 ACPA20127...
  15. Groves22

    Run-time error '1004'

    Why am I getting that error? I get when the code tries to execute the bolded line. TempR is the sheet showing on the screen when this code gets to that line... is that the issue, if so, how do I fix? TempR.Sheets(1).Range("E5", Range("E5").End(xlDown)).Copy...
  16. Groves22

    Add to each number in a cell

    Is there a way I can add to each unique number in a cell. For example: I have 00378 in a cell. Is there something I can do to add 5 to each number in that cell? The end result would be 55823. It's in a mod 10 format when adding. Thanks
  17. Groves22

    Creating HTML file in Word

    I am trying to create a Lotus Notes sig in MS Word. I type in the text I want, and save it as an HTML file and then designate that file for my sig. When I look at the file in the HTML, it looks like I want it too, but when it's in my email's sig, it looks like everything is spaced out.. i.e...
  18. Groves22

    Why am I getting this error?

    This is occuring in a For Loop. The loop will look at cell W5 through AB5 one by one. Here is what I got. I am omitting some code for space. I think I have included everything needed. Public rYear As String, rDay As String, rMonth As String, rCount As Integer, rAgency As String, rAgentN As...
  19. Groves22

    Can you have a dropdown pop-up box in Excel?

    I would like a dropdown box pop-up on the screen, that would allow a user to select from 5 or so options. Is that possible? I'm thinking it would be something like an InputBox, but you can choose which option, rather than type. If that is something Excel can do, and you know, can you please...
  20. Groves22

    Why does this error out?

    I have run this code before without problems, but now I am getting an error. Something about the object doesn't like the property. The bold text is when the error occurs. 'Open and set up data monthly sheet Workbooks.Open ("P:\STATE REVIEWS\OH\OH\New Product Set Up\Property\Profile...

Part and Inventory Search

Back
Top