Recent content by dmuroff

Hi, In Excel 2003 I was able to move a data point on a chart and it would automatically update the data set. I would click on the data point and the cursor would change to *up and down arrows*. I haven't been able to achieve the same function in Excel 2007. Has it been removed? Altered? Any...

That did the trick! Sheets(Array("Sheet1", "Sheet2", "Sheet3", "Sheet4")).Select Sheets("Sheet1").Activate Sheets(Array("Sheet1", "Sheet2", "Sheet3", "Sheet4")).Copy Sheets(Array("Sheet1", "Sheet2", "Sheet3", "Sheet4")).Select Sheets("Sheet1").Activate Selection.Copy...

ExportAsFixedFormat does indeed work! ActiveWorkbook.ExportAsFixedFormat xlTypePDF, directory One more thing: Is it possible to use with on just the selected worksheets? i.e. something like this: Sheets(Array("Sheet1", "Sheet2", "Sheet3", "Sheet4")).Select Sheets("Sheet1").Activate...

I'm looking to find the VBA code required to save as PDF in Excel 2007 using the Microsoft add-in. I've been able to acheive this in Access like this: DoCmd.OutputTo acOutputReport, "ReportName", acFormatPDF, Directory Does Excel 2007 have a File format simliar to "acFormatPDF"? I've tried...

Thank you Remou and dhookom! I created two separate queries with average sales by region and state then added them to the record source of the query. In the sorting/grouping list I created a sort by region right above the group by region and a sort by state right above the group by state...

Hi, I have a report in Access 2007 which I'd like to sort ascending by field generated within the report for average sales. The report is grouped by Region and then by State. The sort is going A to Z for Region and then by State like this: Midwest Illinois 74 Indiana...

Hi, I have a report 30 page report within Access. I would like to be able to automatically save each page to an individual PDF, MDI or any other commonly known viewer not having to do each one separately. Any help would be greatly appreciated. Dan

Works like a charm! Thank you PHV!

Hi, I am trying to copy and pastespecial (values) a range of cells through VBA from one workbook to another. Here is my code thus far: Private Sub copypastedata() storeno = 20 While storeno <= 20 open2007currentstore = DLookup("location", "storelocation", "store=" & storeno)...

I have a database in SQL server with multiple tables and 1 VERY large table with over 1 million records. When I try to run a query in Access it gives me a time out error. This only happens with this table. All the rest of them can open fine. A couple weeks ago I added some indexes to the table...

Text and HTML have the same issue...I havev Norton anti virus 2003 with all the updated virus definitions. I was thinking that could be the problem but apparently not. Is there a point to run a windows repair? I know that other problems can arise when running the repair. I would reformat but...

My apologies.

I have no checked. But it still doesn't explain why the email addresses and subject are messed up as well.

Yep, Western European. It doesn't happen with all emails. Only some but I can't pinpoint which ones. The amount of characters that it should be does not correspond to the amount of messed up characters. For example, if the subject is 'test' it will be shown as '?u?V?_?$ftJ??'

When I recieve some emails in Outlook the message seems to be corrupt. The same thing happens when I send emails. The receipiant gets strange characters like this...