• Updating in realtime with MS Word and Excel

    There are 1500 people checking in to a motel for a yearly convention. I am in charge of registration and as I mark person/people who checked in, I want four other laptops that are online with same OS and same Excel or Word (office 2007) loaded on page. I want all four computers to update reg. as I...

    justme5710 pointsBadges:
  • Number formats

    I pasted a bank statement into Excel but I can't successfully do any calculations. Can you help?

    commercial5 pointsBadges:
  • Populate an Excel drop down list from ASP.NET using VB.NET

    How do you populate an Excel spreadsheet that contains drop down list using ASP.NET with VB.NET code behind. I can easily populate or update the cells by name because the headers are not on the first row but when I am trying to populate a cell that has a drop down list attached to it, even though I...

    oneHundred5 pointsBadges:
  • How to get weekly chart updates

    In Excel macros I would like to change a reference cell incrementally each time I do a button click. How would I do that? For example start out referencing cell b6 then one button click reference cell b7 and so on as often as I push the button it would increase the cell reference to the next...

    ResearchRat5 pointsBadges:
  • Export contacts info from Outlook 2007

    Can someone suggest the easiest way to export my personal Contact information from Office Outlook 2007? I want to migrate my personal Contact information from office Outlook to my home computer. Early response will be much appreciated as I am leaving office from this Friday (1/30). Thank you.

    SbElectric2,540 pointsBadges:
  • Excel lookup and totals

    Find specified values in one column, and total vaues in other columns of the specified value.

    tcmichigan10 pointsBadges:
  • Drop down menu’s in PDFs saved from Excel files

    Is there any straightforward way to save an Excel file as a PDF while retaining the functionality of the drop down menus? I have a few drop downs that I've added to an excel file and I want to save this file as a PDF to the point that I can open the PDF and change the drop down menus. Can this be...

    Duester5 pointsBadges:
  • Objects embedded in Excel

    I placed an object (PDF) in an Excel spreadsheet. When I go to minimize the row or filter the row/column's the objects do not move. How do I get it so it stays within that row?

    Chinavarepn5 pointsBadges:
  • How can I copy/paste a table from Excel to Lotus Notes

    Hi all, I've been reading some posts about my question over the internet but didn't find any accurate answer. Here's the problem: When I click a button in Excel, i need the table from a certain "Range" to copy/paste in the body of an e-mail that will send itself automatically. Now, I know how to...

    Selut22225 pointsBadges:
  • Excel conditional formula

    Hi all, I can write a basic conditional formula such as =IF(A1="23", "OK", "NOT OK"), but I want to add a supplementary condition ... For example if A1 is 23 and B1is 24 then the cell will display OK or NOT OK as appropriate... both conditions need to be met. TIA, John

    Johnaldo160 pointsBadges:
  • Option buttons in Excel

    Trying to create a checklist with multiple line items each having a "yes" or "no" response.

    Susan85 pointsBadges:
  • Excel

    All of a sudden when I open a number of Excel docs, I don't see the list on the bottom of the page to click and retrieve. I have to go back up to open and then open them from there.

    Mrboop10 pointsBadges:
  • CHR file

    My software exports file into CHR format. I can mail you the attachment. I want to convert the same into excel format.

    vishamber19645 pointsBadges:
  • Automatic resizing of images through mail merge in Publisher 2010

    Hi, I am new to the whole world of mail merge and trying to help our charity administrator with a wee problem she has, but have become rather stuck myself! We are trying to produce a high volume of child profiles for a child sponsorship program we administer. In the past all information has been...

    signposter5 pointsBadges:
  • DTF to Excel in Batch file

    I have a Batch file (run from icon on desktop) that is running an IBM DTF to and Excel spreadsheet (file type: ASCII TEXT, translate data: ASCII) and then I use start excel.exe and it opens my spreadsheet with the data. PROBLEM: How can I format the spreadsheet with headers and column fonts and...

    Slmutone10 pointsBadges:
  • Excel Menu Bar disappeared

    How do I get the Excel Menu Bar back. I add it through the VB Editor, but once I closed and relaunched Excel, the menu bar disappeared again. I was told to search for *.xlb file, but could not find any! Please help.

    Furaha5 pointsBadges:
  • MS Excel Macro imput

    How to pause Macro execution for input of e.g. a Range to go to after resume?

    akeeckerwall5 pointsBadges:
  • MAX of Alpha numeric range of fields

    How can I get the MAX value of an alphanumeric range of fields in Excel? i.e. a column with values like S020, S045, S102

    KarenKS25 pointsBadges:
  • Microsoft Excel

    Gents: Could you please assist me in the below case: 1-I have 2 Excel sheet on my PC (Excel A is extracted on a daily basis from I Series by using data transfer while Excel B is the target one). 2- Excel B (target) has a special header and colors and contains 4 columns and 20 rows with zeros amount...

    Senior1systemanalyst260 pointsBadges:
  • Why is my app so slow when writing from VB to Excel

    What I use: An app where following procedure has to be run approx 100.000 times... it takes 5 minutes! It should go faster. Question=how? Dim Record as string Dim oExcel As Microsoft.Office.Interop.Excel.Application Dim EXCBook As Object, Range as object oExcel = New...

    abc1234520 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following