• Conditional Formatting – Excel 2007

    Greetings. I was on hiatus from this excellent forum for some time. Got involved in too many other tasks & was unable to free myself to devote time to this forum. Now, I am seeking help on how to extend Conditional Formatting rule. The scenario is this: I have a worksheet with about 200 rows. In...

    SbElectric2,540 pointsBadges:
  • Graphing Challenge in Excel 2007

    I am working on a project, and was wondering if there is a quicker/better/easier way to do it than what I have been doing. I have two sets of data - one for 2009 and one for 2010 - broken out by department (there are about 100 different departments with which I am working). The data sets contain...

    Mchel275 pointsBadges:
  • Add functioning checkbox or radio button in PowerPoint 2007

    I have a "form" developed in PPT that different people will have to complete to then turn it into a full presentation. One part requires them to select Yes or No for impacting something. I would like a drop down for this but, I don't know how to do VBA code. Can I do a checkbox or radio button...

    Smitstwins5 pointsBadges:
  • How can PDF be set so only one person can view at a time?

    How can a PDF be set up so it limits only one person in the file at a time?

    Mutti975 pointsBadges:
  • Excel 2007 macros

    In Excel 2007: How to make current time/date (static) populate active cell when command button is clicked?

    Mcvla5 pointsBadges:
  • iSeries accessibility to VB.NET, ASP 2.0/3.0 ,NET programmers in Visual Studio

    My shop does not have WebSphere but does have a sizeable VB.NET team using the MS Visual Studio. They need access to the iSeries files in DB2/UDB - real-time. We already thanks to me have a number of batch/DTS package type transfers. Do any of you know packages that can make the iSeries files...

    JohndeCoville0 pointsBadges:
  • Printing File Dump Path in Visual basic

    How do i write a macro for a PDF print file to be printed to a folder path?

    Bogsy10 pointsBadges:
  • View row labels as column headings when scrolling in Excel 2007

    Row 1 contains the column labels, when scrolling the A, B C column headings are replaced with the row names. It is not "freeze" situation.

    Onthemove5 pointsBadges:
  • Pulling information from one spreadsheet into another spreadsheet.

    We have two spreadsheets created and spreadsheet b has referenced totals from certain columns from spreadsheet a. The problem is that the spreadsheets are maintaned by 2 different people. And throughout the day spreadsheet a gets new information added to it, how can this information be brought into...

    Jacketfan5 pointsBadges:
  • Exchange in a cloud environment?

    I have a small 2 person business. Outlook is integral to us, my partner uses Office 10, I have Office 07. We have each purchased an new android phone. We would like to sync Outlook with our new phones regularly. We do not use a server in our business. Can I get Exchange in a cloud environment...

    Johnima5 pointsBadges:
  • How do I disable save/save as and control +s and f12 in excel 2007?

    I want o disable those and only allow save feature through the macro I established

    Errtu5 pointsBadges:
  • Operating DOS through excel(VB or macro).

    Cheers. I m new to IT.I wish 2 operate DOS through excel. For example , in DOS we write some command and then press enter, then dos displays the information concerned with that command. Is this possible to do this, i.e writing command in DOS and pressing enter jst by writing a programme in...

    Begginer65 pointsBadges:
  • auto print PDF from another server to AS400 printer

    In our network setup, we have a teamcenter server ( for engineering data) which contains a PDF file. We do 5250 scan shipping from our AS400. When a label is scanned, they want me to pull this PDF file ( from this other server ) and print it on a laser printer which is a network printer and an...

    Merts30 pointsBadges:
  • Using AS400 COBOL or CL Program to Call an Excel File and Pass Parameters Back and Forth from 400 to Excel Back to 400

    [html xmlns=""> I am beginning my investigation to figure out how to use either a 400/COBOL program or a CL program to call an excel spreadsheet that requires three parameters to a calculation and to return a value back to my 400/COBOL program of CL program so that I then can use that value in my...

    400Programmer185 pointsBadges:
  • Excel R1C1 referencing

    I have an excel spread sheet created via Crystal Reports export as a data only 2000-2003 excel (xls). Within this spread sheet are cells containing formulas with R1C1 referencing. When I open the spread sheet, the formulas are not calculated. I have changed cell referencing to R1C1 via the Office...

    BTod50 pointsBadges:
  • Matching data in Excel

    Hi, We have two sets of data in Excel that we need to match up and combine when they match. Spreadsheet 1 has two columns, A is a S/N and B is the page count. Spreadsheet 2 also has two columns, A is the S/N and column B is an ID number. We need to match the S/N from spreadsheet 1 with spreadsheet...

    Aslan5 pointsBadges:
  • We need to install 3 different versions of the same adobe suite on the same computer

    We need to install 3 different versions of the same adobe suite. Can this be done on a Windows 7 machine or will we need to run each in a separate virtual machine? Please advise.

    Karl Gechlik9,860 pointsBadges:
  • Adobe Reader can’t open downloaded VIP files

    When I try to open a download file I get this message: adobe reader could not open vip because it is either not a supported file type or because the file has been damaged (for example, it was sent as an e-mail attachment and wasn't correctly decoded. This has nothing to do with e-mail. Once I could...

    Dogwalker5 pointsBadges:
  • Excel date format

    I am trying to copy data from one of our systems into Excel. Everything copies into Excel except the dates. My source data date format is MMM DD, YYYY (example Jul 14, 2004). I have tried changing the Excel from general to text and also tried changing the date formats.

    Tamara5 pointsBadges:
  • Is there a 3rd party tool (or native option) for retrieving data from DB/2 into an Excel spreadsheet complete with pivot tables?

    Is there a 3rd party tool (or native option) for retrieving data from DB/2 into an Excel spreadsheet complete with pivot tables? This would likely be done via a web browser interface such as Joomlah.

    Restart15 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.

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

Following