Search results for query: *

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

Thanks, I'll give it a try.

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

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

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

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.

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

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?

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

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

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

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

When I copy the 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...

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

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.

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", _...

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

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

Not sure I'm understanding. I want the macro to select the array of sheets, copy those to a new workbook, name the new workbook, go back to the original workbook, select range B9:S58 on the first sheet of the group of sheets, copy that and paste the values in the same range on the sheets in the...

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