1
  • Unable to run macro in Microsoft Excel 2007

    I'm unable to run any macros stored in this workbook but macros stored in the personal file will run. What should I do?

    Rich6245 pointsBadges:
  • 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:
  • 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:
  • Excel 2007 – creating a graph from CSV data with a macro

    I want to create a macro that will take a CSV file and remove the same columns each time. BUT the number of rows can vary.  Can I create a macro that will create a grapgh ? The problem is, like i said before, the number of rows can vary each time but the number of columns is consistant.

    jkeri355 pointsBadges:
  • Existing macros attached to custom toolbar buttons

    I have an Excel spreadsheet that contains several macros that are attached to custom buttons on a custom toolbar. When I open this spreadsheet in Excel 2007 none of the macros are attached to the buttons, how can I attach these macros to the correct buttons. Can I have this toolbar showing at the...

    Tad9575 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:
  • Excel 2007 macros

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

    Mcvla5 pointsBadges:
  • Proper Excel 2007 macros to identify table

    dear sir/madam i have a table such as the left table and want to extract a table like the right one please give me the proper macro. best regards. hamid [table style="border-collapse: collapse; width: 300pt;" border="0" cellpadding="0" cellspacing="0" width="400"> [col style="width: 63pt;"...

    Hamidirani575 pointsBadges:
  • I am looking for a source of macro commands for excel 2007.

    I am looking for a source of macro commands for excel 2007. Having used Lotus I am used to writing my macro's using a command type format. Upgrade to Windows office has put Excel 2007 on my system and I am not able to understand the help function. Books I have obtained have been no assistance as...

    Leafs15 pointsBadges:
  • I wish to have my macro copy a cell from a tab, then go to another tab and search specifically for the value of the initial cell.

    Hi.  I wish to have my macro copy a cell from a tab, then go to another tab and search specifically for the value of the initial cell.  i.e. the VB code should allow the "Cells.Find(What:=) to be VARIABLE based on what is pasted.  Any suggestions?

    ThomasRichardJohnson5 pointsBadges:
  • Macro permission in 2007

    As occurs in Excel 2003, I would like to have a dialogue box prompt me when I open a spdsht regarding whether I want the macros enabled.  I have not found that option yet.  Any suggestions?

    Sfe5 pointsBadges:
  • Adding standard text to multiple cells in Excel 2007

    Hi, I have a list of about 800 products that I sell ( flags). Most of the flags are 150cm x 90cm in size and I would like to add this text to a chosen amount of cells for example: Grenada 150cm x 90cm Marshall-Islands Maurutania Palau Rhodesia Salomon Islands Trinidad und Tobago West Sahara Is it...

    Wereldvlaggen5 pointsBadges:
  • Is there a macro to transfer a row of data from top to bottom row of range ??

    I use excel 2007. I have a s/s encompassing over 350,000 rows. Data consists of a series of ranges from columns A:N and rows varying in number between 3 and 30. There are two blank lines between each range of data. Each range is (with exception) numerically ordered down column H (e.g, 1, 2, 3,...

    Colwyn25 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