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 Rhinorhino 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: mpm32
  • Order by date
  1. mpm32

    Automating Outlook Message Saves

    Hi, I am trying to save outlook messages to a network drive. The messages are in a shared mailbox folder, not my main outlook account. I have found a script and I have set up a rule for it to run from. It runs fine but only on a selected message or a group. I would like it to run when the new...
  2. mpm32

    Code running slow or not at all

    Thanks, I'll give it a try.
  3. mpm32

    Code running slow or not at all

    Hi, I have a module that runs when a user clicks a button on a form. They have to choose a begin date and end date to run a report. Lately they have been getting an error "The command or action 'OutputTo' isn't available now. When I run the report it works for me. They run the DB off of...
  4. mpm32

    Stacked bar chart with a marker

    Two questions; I have a stacked bar chart - all the bars add up to 1. The chart shows the percentage of a task completed in pass 1, pass 2 and the remaining percentage left to complete the task. I would like to add a marker (a diamond) at a goal percentage for each bar. I have done something...
  5. mpm32

    Cell ref from a named range

    I have a named range. The cell in this range holds the cell reference of the last open cell in a list of data on another sheet. When I try to call that reference from the named range in my code, I get an error. This works; Sheets("Summary").Select Range("B3:O3").Select Selection.Copy...
  6. mpm32

    Connecting to Access DB through Citrix

    Hmm, I thought about that but in this case, the users are accessing the DB from India which is why we're using Citrix. Not sure why they're having issues with multiple users accessing the DB at the same time. I have several other DB's on Citrix that do not have any issues.
  7. mpm32

    Connecting to Access DB through Citrix

    I've got a database the people connect to through Citrix. They've been having issues connecting more than one user at a time. I've done some reading and it suggested splitting the database will help with this issue. I've tried to do that but when the users try to access the tables in the DB...
  8. mpm32

    VBA to call the current workbook

    Thanks Skip. So you would suggest that if I need to do this process a number of times for different groups of sheets, I should create a module for each and then create a module that calls each of them?
  9. mpm32

    VBA to call the current workbook

    OK, I figured it out! This works; Dim wbNEW As Workbook, dte As Date Sheets(Array("7210544.T", "7210528.T", "7210521.T", "3410800.T", "8xxxxxx.T", _ "TotalARBilling.T")).Copy dte = ThisWorkbook.Sheets("Tools").Range("RptDte") Set wbNEW = ActiveWorkbook...
  10. mpm32

    VBA to call the current workbook

    dte = Range("RptDte") returns Run-time error '1004': Method 'Range' of object '_Global' failed. I tried dte = ThisWorkbook.Sheets(1).Range("RptDte") returns Run-time error '1004': Application-defined or object-defined error I then thought I needed to use Set so I tried Set dte =...
  11. mpm32

    VBA to call the current workbook

    Thanks, still getting Type mismatch with the named range. In the immediate window I get this for the range; ? Range("RptDte") 1/31/2011 I tried removing the brackets and using quotes "RptDte" and I get a runtime error, script out of range. Argh.... Sub ARsheetCreation() ' ' ARsheetCreation...
  12. mpm32

    VBA to call the current workbook

    Ok, this works nicely. However, I can not get it to use the value in the named range RptDte. I still get a type mismatch error. I have tried formatting the cell RptDate as Date, Text, General, mm-mmm, Number, nothing works. In the watch window I get; Watch : : dte = [RptDte] : <Out of...
  13. mpm32

    VBA to call the current workbook

    ...sheets into the new book, I have numerous cells that use this formula (which you helped me with) - =SUMPRODUCT((INDIRECT($A$3&"!$D$5:$O$5")<=$A$7)*(INDIRECT($A$3&"!D11:O11"))) I get #REF errors on the pasted sheets. I also want to eliminate the formulas on the pasted sheets. Is there a way...
  14. mpm32

    VBA to call the current workbook

    Thanks for the watch window tip. I was able to determine some things. Dim wbNEW As Workbook, dte As Date I think the as date is causing the type mismatch error. I tried As Variant and it works when I put a value into the dte= line. When I try to change to this dte = [RptDte] I get a type...
  15. mpm32

    VBA to call the current workbook

    Yes, I named it RptDte in the Name Box, when I check it, the cell comes up as RptDte in the name box. I also checked the cell reference in the define name form.
  16. mpm32

    VBA to call the current workbook

    Getting a type mismatch error 13 now. I made sure that the cell that RptDte is stored is formatted as text but I still get the error. ARsheetCreation Macro ' ' Dim wbNEW As Workbook, dte As Date Sheets(Array("7210544.T", "7210528.T", "7210521.T", "3410800.T", "8xxxxxx.T", _...
  17. mpm32

    VBA to call the current workbook

    Still getting a compile error; Dim wbNEW As Workbook, dte As Date Sheets(Array("7210544.T", "7210528.T", "7210521.T", "3410800.T", "8xxxxxx.T", _ "TotalARBilling.T")).Copy dte = [RptDte] Set wbNEW = ActiveWorkbook wbNEW.SaveAs(Filename:="C:\AR " & dte &...
  18. mpm32

    VBA to call the current workbook

    ThisWorkbook.Worksheets("7210544.T").Range("B9:S58").Copy Right?
  19. mpm32

    VBA to call the current workbook

    ...new workbook. As a large portion of cells on my sheets use this formula (which you helped me with) - =SUMPRODUCT((INDIRECT($A$3&"!$D$5:$O$5")<=$A$7)*(INDIRECT($A$3&"!D11:O11"))) I get #REF errors on the pasted sheets. Maybe there's a way to select the array of sheets and paste the formats...
  20. mpm32

    VBA to call the current workbook

    The sheet(s) would be; Sheets(Array("7210544.T", "7210528.T", "7210521.T", "3410800.T", "8xxxxxx.T", _ "TotalARBilling.T"))

Part and Inventory Search

Back
Top