• Multiple Names in Excel 2007

    I have a Excel sheet with hundreds of names and the same person may be repeated twice How do I create a formula so that I can like it to a new sheet and it only show a persons name one time?

    Maine325 pointsBadges:
  • VBA format a cell based on range contents

    I need to create a macro that goes in to a worksheet and looks at the contents of a range to see if it contains any number other than zero. If it does, I need it to turn a separate cell yellow. 'assign variables Dim rngSat As Range Dim rngSun As Range Dim wsOT As Worksheet Set wsOT = _...

    VbaNewb1315 pointsBadges:
  • Converting an Excel 2013 file to a flat file in notepad for SQL Server 2008 R2 export/Import Wizard

    I am a student. I have to convert an Excel 2013 spreadsheet with 7 tabs of different table information. I have to then import it from my host computer into SQL Server 2008 R2 which is located on my virtual machine. Please help me and if you need more information, then let me know. Thanks in advance!

    Ronnibelle5 pointsBadges:
  • Office 365 – migration kits

    Does anyone know what migration kits exist to help folks move to Office 365 from on-premises solutions. I'm wondering if Jeff Middleton from Small Business Server fame will have a kit to migrate to the cloud. Anyone heard?

    Harrybrelsford5 pointsBadges:
  • VBA copying a range from Excel and pasting to a text file

    Do you know how to copy from excel and paste to a text file using VBA?

    TBone555 pointsBadges:
  • Excel macros not working in password protected workbook

    Excel 2007 macros work perfectly in original workbook however when I save as and create a password to open the workbook, it opens OK but the macros don't work. The Excel options have the macros enabled but they are deactivated somehow.

    Yoka25 pointsBadges:
  • Outlook 2003 with Micro web mail

    Is it possible to use MO 2003 to open a Microsoft webmail? I.e. I use a CAC to logon to mail at work. And use the web mail to access the account while traveling. Can I use MO 2003 installed on my notebook to open the webmail? IF so, how?

    Longbo5 pointsBadges:
  • Retrieve PSD file format

    I saved my .PSD file as .PDF then suddenly I closed the PSD file then I opened it again it coming one file only my layers gone. Any suggestions on how to back my .psd file with the layers on the previous psd file?

    princedaniel1385 pointsBadges:
  • Powerpoint 2007 feature for printed handouts

    When delivering a presentation using PowerPoint 2007, you want to temporarily draw your audience's attention to a printed handout you have provided rather than having them focus on the screen. What PowerPoint feature can most help you accomplish this?

    Ksims265 pointsBadges:
  • Paste from Microsoft Excel cells to Microsoft Access table successfully but…

    When I perform a Paste Append into the table, the field I need that is a hyperlink is being truncated, thus link fails. How can I get the link to pates exactly as is from Excel?

    Lpjedpp5 pointsBadges:
  • Are there any tools available to recover a corrupted PowerPoint file?

    My wife had spent about a week putting one together and (luckily) when done presenting she wanted to save it and MOVED (not copied) it to a key drive (big mistake to trust the move). When she got home the file was corrupted and she cannot open it. Anyone know any possibilities to recover this?...

    lexterrinus5 pointsBadges:
  • Upload invoice numbers to the concerned PO in AS/400

    How to I upload invoice numbers to the concerned PO in AS/400?

    rajik45 pointsBadges:
  • Saving multiple emails in Outlook 2010

    We have upgraded from Office 2003 to 2010 and one of the features I used to have in 2003, with the adobe acrobat add on is to be able to select several email messages and convert them to PDF and save them to a file in our server. I cannot find a way to select multiple email messages and the 2010...

    Daniella5 pointsBadges:
  • Script to extract files information from FTP server

    Hi Wonder if you could help me with the following please. I would like to construct a script (in any language whichever it's easiest) which when run, it will log on to a ftp server using a generic account and password, then list the files in a specific folder that begins with the string "abc". The...

    Aiko2720 pointsBadges:
  • Search for duplicates in a collumn and delete the row on which it occurs

    Hi, I have a spreadsheet with list of identifiers in collumn 1, this is auto generated and due to the source info some of them duplicated, what I want to do is find the duplicates and remove the entire row they appear on. I know this is possible using clipboard and filters but I would rather avoid...

    Harleq20 pointsBadges:
  • Installed Lotus Sametime Connect 8.0 but Sametime trys to reinstall when Word starts

    Having installed sametime connect 8.0, I noticed that every time I launch Word it starts installing sametime again. Any ideas?

    Trisha8460 pointsBadges:
  • Linking Information in two seperate Workbooks

    I need to create a Workbook that has certain cells accessible for people to enter in their information and then have the ability to pick from a drop down list that will auto populate a name beside the job number chosen. I have managed to do this using V lookup however the main source Workbook opens...

    CleanEnergy5 pointsBadges:
  • Keyboard shortcuts for MS Word

    I am facing a problem with all the keyboard shortcuts involving the CTRL button. This happens only in MS Word while at the same time it works just fine in other MS Office applications. For example Ctrl+Z or Ctrl+X etc don't work in MS Word. How can I solve this problem? I am using MS Office 2007.

    Christossev10 pointsBadges:
  • PDF Mapping Program Email Activity Log in iSeries

    Using PDF Mapping program as the PDF User Program in a PSFCFG object. Modified program to write a log when an email with PDF attachment is created. Program is called from within PSFCFG twice each time - but I only need one record, anyone have any suggestions or has anyone resolved this problem in...

    Kdbwheels180 pointsBadges:
  • Outlook 2003 mail merge with Word 2007

    Can you use Word 2007 to mail merge with Outlook 2003?

    TP3335 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