1
  • How to connect to quick 3270 secure screen through VBA macro?

    Hi, I use the following code to connect to quick 3270 macro and it also connect to the screen. But when I run the macro for the first time it works, but does not work when I run the same macro for second time. If I restart the mainframe then the macro runs. Below is the code. Sub getdata() Set...

    Anirudha0075 pointsBadges:
  • How to collapse data in a Pivot Table in Excel 2007?

    I created a Pivot Table and its giving me a description with the different codes that fall under each I want to collapse all the descriptions so that the codes under each disappear and are summed up within each description I can do them one at a time but I have some many lines to collapse.

    Babyphat5 pointsBadges:
  • Updating Excel formulas

    I am using Excel 2007 on a Windows 7 system. Since I was upgraded to Windows 7, my formulas are not automatically updating when I copy and paste. My calculation settings are set to Automatic. Also, nothing happens when I press F9. The only way I can get the formula to provide the correct value is...

    mef310810 pointsBadges:
  • Is there a standard formula for counting highlighted cells in Excel 2007?

    Is there a formula for when you highlight some data cells, for use of simply counting rows, that Excel will give you the count of those cells as the answer on another sheet in the workbook- just by highlighting? But this is based on highlighting random cells in a column every day, never the same...

    Buddyboy12310 pointsBadges:
  • Adding “days” to a cell in Excel 2007

    I have a list of # of days' inventory for a product and wish to add "days" to each cell. For example, "29" would appear as "29 days", with the numerical value unchanged, so my formulas still work. How do I do this?

    Chirofriend5 pointsBadges:
  • Keep Text to Column format in Excel 2007

    We're wondering if there is a way to get Excel 2007 to remember the previous Text to Column settings. We are receiving reports in an email that we copy into Excel. We run the Text to Column>Delimited>Delimiters (Only Other = |)(Text Qualifier left as default = *)>Column Data Format...

    Littlejuanito7420 pointsBadges:
  • Excel 2007 ‘Edit Links’ Command deleting information

    I received a file from our corporate office. Some of the formulas in the workbook were referencing a location on a persons C:documents and settingsthatpersonmy documents. I wanted to change the reference to the existing file instead of the past months file it was looking at. I went into DataEdit...

    Hporiginal15 pointsBadges:
  • Create a macro in Excel 2007 to disable save

    I need to create a macro in Excel 2007 to disable save

    Basilmartin5 pointsBadges:
  • How to accept user input and display the value in Excel 2007 macros

    I Created an Excel macro that prompts the user to enter two cell numbers. I want to then display a msgbox back showing the cells that were entered. Problem. My msgbox shows the text in my message and instead of showing the values the user entered, it shows 'TRUE'. Any ideas?

    jkeri355 pointsBadges:
  • Deleting successive rows on Excel 2007

    Using VBA in a large timeline excel worksheet of 50000 rows. How can I automatically delete every 3 rows and leave the 4th row so I can reduce the number of rows to about 12,000.

    Debress5 pointsBadges:
  • Search for column header in Excel 2007

    I use a macro for a weekly report. In the macro i use "Column ("C:C").Select to select that column to filter out the zeros. Sometimes the information is in a different column when the data is downloaded, but the header of the column is still the same: "90_day_Late". How do i search for...

    Francino5 pointsBadges:
  • Problem creating during hyperlink recall with Excel 2007

    if am copying a folder in desk top that folder contains xl2007 sheets, in one of the sheet i was inserted some hyperlink for supporting folder.if am pasting this folder in desk top it may creating some problem means after opened the xls file am clicking the link that time file could not be found...

    Msn8525 pointsBadges:
  • Sending Excel 2007 spreadsheet without calculations

    I want to save a copy of my spreadsheet to send to someone, without them seeing my calculations. I need to convert the equation, save the answers as they appear in number format. I know there is an easy step but can't find the terms to search it properly. (Excel) Can someone please assist me?

    Matilda5 pointsBadges:
  • Unable to Refresh Pivot Table if Datasheet in Excel 2007 is not open.

    I have several Pivot Tables linked to several like spreadsheets, respectively.  When I refresh a Pivot, I get an error that excel is unable to open the file (that the table is linked to). If the file is open, I can refresh.  My problem is each spread sheets contain huge amounts of data. Is there...

    Skb195510 pointsBadges:
  • Excel 2007 what is the command for scrolling down your rows with still seeing the header row at the top

    I know this is so simple but what is the command for scrolling down through rows in Excel 2007 but still keeping the header (titles of the columns) in view. thanks so much!

    Buddyboy12310 pointsBadges:
  • Tracking active Excel 2007 table updates

    CAN I SEE THE ACTUAL CHANGES SOMEONE MAKES, ON A SECOND OPENING OF THE SAME WORKBOOK (SHEET) ON A DIFFERENT COMPUTER OR (DIFF MONITOR OF THE SAME USER). I WANT TO OPEN THE SAME WORKBOOK ON TWO DIFFERENT MONITORS (OR COMPUTERS) AND TRACK (SEE) THE CHANGES LIVE (OR NEAR LIVE) ON THE SECOND. THE...

    Tmore5 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:
  • 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:
  • 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:
  • 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:
1

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