embedded

Don't know if this is possible, but here is what I would like to do. Right now I have a 20 Analysis Workbooks that contain detailed analysis and have 10-20 worksheets in each. I am going to create a "Dashboard Workbook" that pulls data in from all the analysis workbooks.There is a tab for each...

Hi, I have embedded a RefEdit control directly in a worksheet, but it doesn't seem to work. Essentially I would like the user to select a range, or ranges, so that the program can store the address in a linked cell. However, the control doesn't seem to take in the selected range. I have...

Hey Everyone I am new to the forum, as I just began a project that is going to be very long and Excel "heavy." I am sure to have plenty of questions regarding Excel, and will do my best to answer as many as I can as I go as well. My first question for the board is: Excel seems to only...

I have several Worksheets in a Workbook and each of them contains embedded Word objects. I am pulling data to the Worksheets from an Access table and have no problem loading up actual Excel cells. However, I want to be able to copy from the Access table directly into one of the Word objects...

I would like to be able to query the tables in the PowerPivot cache. My preference is to not have hidden worksheets or to create worksheets in vba to create temporary data and then delete the worksheet. I am using PowerPivot which pulls the data from SQL Server Express. The data has been...

Hi All, I have a code that opens an embedded excel thru VBA, saves it on a user-specified location, closes the embedded file. Then the saved file will be opened and edited, The problem that i'm facing is dat when i try to save the embedded sheet, excel crashes with no specified error. It simply...

Hi, I have a presentation that I need to put together in PPT, and I've built all the charts in Excel. The problem is that I need both the chart and the data to live solely in PowerPoint (and be editable) without linking back to the original Excel file. I'm trying to do this in either...

I have a question that has stumped me so far. Here is the scenario: I am dealing with a spreadsheet that has several tabs on it. In each tab, there are several word, powerpoint, and pdf <NOBR id=itxt_nobr_1_0 style="FONT-WEIGHT: normal; FONT-SIZE: 100%; COLOR: darkgreen">documents</NOBR> that...

Preamble: As with one of my previous posts, this has turned from a question into a tip, as I think I just found the answer while posting! (I'm using Excel 2003 today at home; but have not yet tested it on 2002, which I have at work). Scenario: I have a Worksheet with Autofilter enabled. It...

I am running a vlookup and need to restrict the search data to an exact match and exclude all other returns which may have an exact match but the text match is embedded within a larger text string. ie. looking for FRX in the following group: RB-FRX40 TTFRX FRX GH-FRX53 IT-FRX00 vlookup is...

I'm trying to sum the values in a column if 2 different conditions (in 2 other columns) are true (so I'm evaluating 3 columns total). For example, if I had a list of the prices of all the cars available at a dealership (each car listed on a different row), and I wanted to find the total cost...