|
|
Browse by Tags
- .dbf
- .NET
- .wk4
- Tags:
- 2007
- access
- access 2007
- ACT! 9
- Active Report
- ActiveSheet.ChartObjects.Count
- Add same data / values to all worksheets in a directory - macro
- Add Time
- Adding 4th Sort Field
- Analysys Services
- Anlysis services
- AS2008
- asp.net
- attachments
- Author
- Automation
- autoupdate
- C#
- chart VBA
- Charts
- combobox
- Compare and choose which data to use in Excel
- Convert / Open lotus 123 (.wk4) files in Excel 2007
- count
- crash
- data filter
- Date Picker in Excel
- Default Start
- define names
- developer
- Document Properties
- equation
- essbase
- Excel
- excel 2002
- excel 2003
- excel formulas
- Excel Time Formula
- export
- external
- Filter
- Formula
- Formula Help
- function
- graph
- hang
- Hierarchical
- How does user of my template DELETE the code modules?
- How to get zip code from delimited file in SAS or excel 2007
- How to lpad with 0 in Excel spreadsheet in a column
- If "" is true
- import
- interactive
- linest
- link
- macro
- MDX
- Microsoft
- Microsoft office
- Microsoft Office 2007
- Office
- Office 2007
- olap
- Openrowset
- PowerPoint 2007
- read only
- Script
- shared
- signature
- Slow in Excel 2007
- sorting
- Sp1
- SQL 2005
- SQL 2005 to Excel 2007
- SSAS
- SSAS 2008
- Subject.
- Text files to Excel Spreadsheet (transpose data)
- Time Formula
- Title
- tmp files
- too long
- unprotect
- update
- Using a named set as dimension.
- Using VBA to Zip File Using PKZip Command Line
- VB
- vba
- vbscript
- Visual Studio
- Visual Studio Tools for the MS Office System
- vlookup
- VSTO
- Window Vista
- Word 2007
- xls
-
excel 2007
i need excel to flag or warn me when a % is below 100% in a column called profit is it possible -
Excel Time Formula
I have an excel Spreadsheet in MS Excel 2007, and I am in need of a formula. I have 2 parts of my formula, just need it to round up to the nearest 1/2 hour.I know it is possible, just don't know how. =IF(F6="out",A9-A6,0)roundup to.50 -
Text files to Excel Spreadsheet (transpose data)
Hello, I have several text files that are formatted like this: ppt_1988_001 9185.91666667 ppt_1988_002 9198.5 ppt_1988_003 9131.25 ppt_1988_004 7177.33333333 ppt_1988_005 9087.08333333 ppt_1988_006 9093.75 ppt_1988_007 7041.91666667 ppt_1988_008 7041.91666667 ppt_1988_009 7955.58333333 ppt_1988_010 10521... -
Convert / Open lotus 123 (.wk4) files in Excel 2007
I want to open lotus 123 files in Excel 2007, later on I will want to be use Excel 2010, but for now Excel 2007. I know that lotus 123 is NOT support in Excel 2007. But I have hundreds of lotus 123 files going back some time. I could run Office 2003, as it can import 123 files, but I don’t want to unless... -
How to lpad with 0 in Excel spreadsheet in a column
Hello Everyone, I have a database in Access 2007, and there are lot of tables in it. I am exporting a table data into Excel spreadsheet and saving it as abc.xls The same thing I have load in Oracle database, so I am converting it into .csv(comma seperated values) file and try to load into Oracle using... -
Using VBA to Zip File Using PKZip Command Line
I have a process that runs several macros (contained within a different workbook) on a workbook and saves the file. I'm having trouble trying to figure out how to zip the file with VBA using PKZip (my only zip option). Using command line the code (zips test1, test2 and test3.xls into zipfile.zip... -
Formula Help
I need help with a formula in the attached column (Cell B2). When I enter a postive number in Cell C2 it will change the indicator from red to green. I need help with a formula that will allow me to insert a postive, negative or zero and the indicator to change from red to green. However if it is blank... -
Adding 4th Sort Field
I'm needing to tweak codes that I found on the web that I've slightly changed to suit. The code allows for sorting a data range by double-clicking header cells. The original code allowed up to 3 sort keys -- which was sufficient until now. I'd like to expand it to allow 4 or maybe more sort... -
Date Picker in Excel
In Access 2007 I have set up the Date Picker which is very handy and easy to use to show the date, can I set up the same within excel to pick the dates from a calender -
Using a named set as dimension.
I used a named set in AS 2000 called R18. It contained all month members eg. 200806,200807....201001,201002. In a pivotable in Excel 2007 connected to the AS2000 cube you could see in under the Time dimension and just drag it out and put as rowheaders. It would then dynamicly change when todays date...