Search results for query: *

Hello, I use this function to open an existing Excel workbook, clear the contents and paste new data. This has been working great for the most part. The problem is the "ClearContents" is erasing all of my data and formulas and I would like to start at a specific range. Can I specify the range...

Hello, I use this function to open an existing Excel workbook, clear the contents and paste new data. This has been working great for the most part. The problem is the "ClearContents" is erasing all of my data and formulas and I would like to start at a specific range. Can I specify the range...

Hello, My Access (2003) PivotTable results do not export to Excel. Do I not have something set in my Options? I can create the PivotTable from a query, but when I click on the "Export to Microsoft Access Excel" button it exports the first field and I have to drag the rest of the fields to the...

Hi, How can I automate the results of an Access (2003)PivotTable and export the results to a particular spreadsheet? Much appreciated.

Hello, How can I truncate the last 3 characters in a query? I only need the first 4 characters in the following field. ALPAB02 ALPAB03 ALPAB04 BKCAB01 BKCAB02 Thanks.

Hello, I import HTML data into my Access table, but the data is Imported with the HMTL tags. How can I setup an sql query or some other method to find and replace these annoying tags? [SAMPLE] <div><font color="#ff0000">3/10:&nbsp; Working on a solution to resolve the migration...

Hello, is it possible to recall an email in Outlook 2003 after it has been sent? Thanks.

Hello, I would like to remove all numbers before the dash "-" using a query. For example, I have a field that has "036-WONUM" and I would like to output just "WONUM" and remove th numbers and dash in front of the word. What criteria can I use to get my results? Appreciate your help. Thanks.

Hello, How can I query two tables with exact data? I want to output matching data from two tables.

Hello, What function would I use to compare data? I have two tabs, tab1 and tab2 in a workbook. In tab1 I have a list of work order numbers 100 thru 200 and in tab2 I have identical information with work order number 100 thru 300. I would like to extract the duplicate work order numbers...

Hello, Can someone tell me how to remove HTML code from a table? I download data from an HTML site that imports directly into my Access database. The problem is there are HTML code that is imported with the data into my Memo field (see below). I would like to remove the imbedded HTML code...

Hello, Does anyone know how to use the macro recoder in PL/SQL Developer? I can run the recorder to record a macro, but I do not know where to find the macro I recorded. I would like to use this tool like Excel if possible. Thanks.

Hello, I have absolutely no knowledge of Pearl, but I have 5 pearl scripts that were created to populate an Excel spreadsheet. I currently open the pearl scrips (which opens in DOS) and hit enter twice. The scrip executes and closes. I have to do this 5 times with 5 different pearl scripts...

Hello, Is it possible to compress an Excel workbook like an Access database?

Hello, I inherited a report that is compiled and emailed daily. I have to copy this dashboard table from Word and paste it as a “Picture (Enhanced Metafile)” format so that I can email this dashboard picture. On the bottom of the copied dashboard, I have a status section that are bullet...

Hello, I would like to attach a file under the "Subject" field when sending a new email. How can I do this or is it possible? My attachments are currently placed in the body of my email, where ever my cursor is the document is attached. I am using Windows XP, Microsoft Outlook 2003 and...

Hello, How can I do a custom filter on (Blank)cells? I would like to filter data that is less than 20 (I know how to do this), and equal to blank cells. I cannot get the blank cells. Help!

Hello, How can I change a preformatted value in an Excel spreadsheet from "#N/A" to "n/a"? I inherited a spreadsheet that I have to populated daily and my results are pulling from this lookup [=VLOOKUP(B8,Order!$A$2:Order!AI17:BP243,34,FALSE)]. If the value is in the lookup sheet then it is...

Hello, I would like to place a parameter of "Enter Date" in my query criteria. If I add "[Enter Date:]" I am prompted to enter a date. This is fine, but how can I modify the criteria for this output <#8/23/2007#? I need to see all records prior to 8/23/2007. Thanks.

Hello, Can someone tell me how to switch views between tabs in Excel? I use the Alt+Tab keys to switch between open applications, and I desperately need a shortcut method to switch between tabs in an Excel spreadsheet. Thanks for assisting.