I have VBA code in a workbook developed on Excel 2003.
When I open it in Excel 2007 and try to edit the code I get a prompt for a VBAProject Password, but no password was ever assigned. What is ...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 09/08/2007 Grade: B Views: 0
i want to make automation code (macro) that will send excel workbooks by e-mail (OUTLOOK 2007)
can someone help me with the code needed? and do i need to adjust something in the VBA options (to in...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
I have a pivot table that displays percentages. I am looking to add a field onto the end of the pivot table that takes the cell value and divides it by the column total, at the bottom. This is di...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Hi,
I am creating a basic user data capture spreadsheet in EXCEL 2007, and I have reserved the first column for "record numbers", which I use to uniquely identiy each record. This is useful fo...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
i have many reports that were built in excel 2003: manipulates data, making charts, sending mails etc'...
i want to upgrade my excel to 2007 to create new reports, but i'm affraid that the macro...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
hello,
i'm trying to run excel file with macro inside via a batch file. with the excel 2003 i did it via -> "run excel macro" an EXE file -> it was opening the excel -> and it was uploaded via bat...
http://www.experts-exchange.com/Software/Office_Productivity/Spreadsheets/Q_23051737.html
Hi Experts
I have a VBA macro which prints the current Excel sheet to PDF. I'm using Excel 2007 and Adobe Acrobat 8 Standard. This works OK. A window pops up where I give the file a name and ...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Using VBA in Excel 2007, the goal is to automate searching for a keyword, and then inserting a formula in column G in the row where the keyword is found (the formula is D#/F# for that same row).
...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_23072475.html
I'm formatting an Excel 2007 spreadsheet created dynamically by vba code in an Access 2007 database. The worksheet names change based on the user's selection, so formatting has to be done within t...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
I wish to set a variable from a cell value, and then use that to open the sheet.
All my sheet names are numbers, 1, 2, 3, 4, etc.
In my cell for example, I have the value 4, it should open the sh...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
