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

Answer Question   |  March 11, 2011  6:01 AM
Excel 2007, Excel 2007 functions, Excel 2007 macros, Macros

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. [...]

Answer Question   |  February 2, 2011  5:44 AM
Excel 2007, Excel 2007 functions, Excel 2007 macros, VB script, VBA macro

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?

Answer Question   |  January 28, 2011  4:37 PM
Excel 2007, Excel 2007 functions, Excel 2007 macros, Excell 2007, Macros

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 [...]

Answer Question   |  January 26, 2011  4:31 PM
CSV, Excel 2007, Excel 2007 macros, Windows XP

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 “90_day_Late” (say it [...]

Answer Question   |  November 25, 2010  3:42 AM
Excel 2007, Excel 2007 functions, Excel 2007 macros, Excel functions, Excel macros

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

Answer Question   |  October 14, 2010  7:41 PM
Excel 2007, Excel 2007 macros, Excel macros, Office 2007, VBA, Visual Basic

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;" width="84">[/cOLIST] [col style="width: 62pt;" width="83">[/cOLIST] [col style="width: 48pt;" width="64">[/cOLIST] [col style="width: 66pt;" width="88">[/cOLIST] [...]

Answer Question   |  August 25, 2010  7:30 AM
excel, Excel 2007, Excel 2007 macros, Excel macros, Excel Tables

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 same [...]

Answer Question   |  December 1, 2010  7:47 PM
Application development, Excel 2007 macros, Excel Custom Views, Excel Toolbars

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 [...]

Answer Question   |  July 9, 2010  4:44 PM
Excel 2007 macros, Excel functions, Lotus Notes to Excel, Office 2007 deployment

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?

Answer Question   |  June 30, 2010  1:51 PM
Excel 2007, Excel 2007 macros, Excel functions, Excel VB code

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?

Answer Question   |  February 10, 2010  8:57 PM
Excel 2007, Excel 2007 macros

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 [...]

Answer Question   |  February 12, 2009  10:33 AM
Excel 2007, Excel 2007 macros, Microsoft Excel 2007

Unable to run macro in Microsoft Excel 2007
unable to run any macros stored in this workbook. macros stored in the personal file will run,

Answer Question   |  December 19, 2008  12:41 AM
Excel 2007, Excel 2007 macros, Excel macros, Microsoft Excel, Microsoft Excel 2007

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, [...]

Answer Question   |  October 23, 2008  4:19 PM
Excel 2007, Excel 2007 macros, Excel macros, Microsoft Excel