- RE: How do i save as a textfile in a macro?
- VB code in excell
- Re: Test if application running?
- Instance of Wizard excel add-in
- Convert Excel into a CSV file automatically
- Sorting Excel object?
- Re: Determining Language Version of Excel
- find last row of data
- Can I set up a worksheet as read only for one user
- extracting certain text
- How To Pull Access Query into Excel (2003): Reposting
- Re: how to average this?
- Re: Works if I single step
- RE: hide columns based on header macro
- numeric value
- LOOKING AT THE FIRST PART OF A CELL
- RE: Activecell Offset
- Change Caption of Forms Command Button
- Auotomating "Sort" in Excel
- Help with Find
- set variable once
- clearing memory /clipboard
- Log File CleanUp
- How can I compare a list of strings, allowing positive matching b.
- Re: Array element
- worksheet function?
- Force standard chart size
- End Of File - For use in Formulas
- Reference to IE - but none found?
- Write the result of a formula only once then lock it
- message property
- Mail merge does not show leading zero in Zip Code
- Excel Code
- Re: Array element
- HELP - Have two lists and #1 needs #2's contents subtracted from it
- Driving me nuts! Row Height, Cell Width
- Dynamic ComboBox
- cell addresses selection for chart source
- Create a Named Range in Excel with VBA
- find (exact match) ?
- setting up multiple timekeepers with multiple rates by period?
- linking 3 rows into one
- Can't resolve external reference on Excel 2000
- How do I hide a shell command called from VBA in Excel
- reformat contact data
- multipage tabs off?
- Macro to append onto and then sort a pre-existing list
- Unable to set the active cell from within a VBA procedure
- Using one subform to control another subform
- Updating records by status based on a formula.
- Importing from Outlook
- Importing from Outlook
- Switch from Office 2000 to Office 2003 error
- VB code to make Excel open in a specific worksheet
- E-Mailing Execl via Outlook Express
- the sum of cells of many sheets
- User Tools in Excel 2002 vs Excel 2000
- help need on VBA code
- Selecting rows
- open password protected Excel doc
- Recognizing a whole number instead of a decimal
- Copy cells with certain info
- Copying a cell one at a time
- Populate 2-column ListBox with 2 non-contiguous columns
- autofill same number to end of file
- Re: How do i save as a textfile in a macro?
- Problem copying a range to a different workbook
- Re: Help to adapt AutoFitMergedCellRowHeight routine to Target with 2 ormore rows
- Re: Excel Version in which file was created
- Re: Not filtering by date
- Identifying the Active Fill Color
- Dynamic Arrays
- Want Excel Hyperlinks to reuse browser window
- Directory listing manipulation
- How do I export excel data to an html file?
- Delaying until Recalcu code is done.
- How to action on Open Sheet
- "Clone" cell formats between sheets?
- Closing excel with a macro
- Array problem
- How can read object order by useing writing?
- DisplayAlerts = False fails
- sum by currency
- Setting chart series XValues in foreign language
- Compile error: Can't find project or library
- help on deleting several rows at once
- Move text after delete
- Inserting a function
- How to create Excel, Access and dbf output files from DataSet usin
- UserInterfaceOnly on startup
- #Name
- Excel Macro to edit and delete one character in a cell
- Summing
- Coding to show first _weekday_ prior to a date, when date calculation happens to fall on weekend?
- Userform for data pull
- UserForm Value
- Code to Save HTML table as xls file on click
- Mail Rounting, Need help quick!! I'm under the gun on this.
- Pivot table with form elements
- Macro
- Recorded Macro to Set page breaks generates error.
- Excel/Lotus Notes
- Querytable refreshing on a protected spreadsheet
- Problem exporting as csv file
- Form development question
- Calling a Private Sub
- password protect vba code
- Linking workbooks
- Syntax for Range Reference
- [Newbie question] Returning an array from a function
- Cell Hyperlink - text, screen tip & link from other cells
- how do I subtract 2 date fields to get number of days elapsed?
- Advances one Record when I tab...
- Adding tool tip to worksheet button
- Variable Manipulation
- If Then Statement
- how can I open a password protected document through vb?
- VBA Code for essbase Zoom-In
- Found Files
- FINDING LAST CELL IN A CALCUALTION
- Can't assign a textbox to object
- Can't assign a textbox to object
- How do I total data in a single column and then chart off of that
- Error when running macro
- verifying data type
- Contents of an array
- using RANGE object in multiple-area range
- Links using XLODBC.XLA not working after upgrade to 2003
- Workbook_Open() will not run
- Save sht as text file - problem
- Subroutine works but can it be improved?
- Running a macro on mulitple files
- Re: Get VSTO code to run on every launch of Excel
- TODAY'S DATE PLUS "BUSINESS" DAYS
- How do I register Grid32.ocx
- Using Solver with VB6 Excel Object
- printing selected sheets
- excel macro inconsistency
- running-total formulas written from one spreadsheet to another
- Turning a Macro into an add-in for Excel?
- Delete LOCAL named ranges
- Worksheets, Ranges & Unknowns
- VLOOKUP cannot find numeric values
- How to source data from multiple worksheets in a PivotTable?
- Please help
- Combo Box
- Multiple firing of macro from ListBox
- Code Module to Add In
- budget template, screen printer
- Filter between dates
- Business Budget - screen Printing
- Delete row depending on size of Characters in cell
- Formula
- Excel taskbar
- How do i find the last entry in a column where every cell is not .
- A problem when use create excel file using Microsoft excel ODBC dr
- Stop on variable
- No duplicates
- Storing various data in .ID property
- Find the occurrences of the particular word and appear one time
- Excel Calculation Issue
- Unique lists
- Creating a recordset over a range
- Get the properties from a closed file
- macro ...if command, I suppose...
- List Formula Macro Needs Enhancement
- Copy data from excel into a web page.
- Add Checkbox programatically to form
- Debug VBA
- User input formula variable
- Selecting Multiple Cells
- How do I print hyperlinked files when selected from a check box?
- Copy worksheets without any code
- Bring forward conditional formatted characteristics
- stuck on division
- Personal Macro Workbook
- XBRL in Excel 2003
- how can i turn functions written in VBA into an addin?
- Excel Export Script
- trying to populate a variable from a combo box
- Switch() causes strange ADO result
- Excel 97 shared file
- "Pick from list"
- Protect certain cells
- Error Invalid Qualifier
- Format
- VLookup Recalculating Every Time - Help
- Importing to Excel from an Outlook Form
- Compiler Error
- Check if form is open
- Update Links Popup
- Personal XLA not appearing on Worksheet Menu bar after Excel Start
- Programmatic addition of form elements relative to a cell
- Collection methods
- Change Cell automaticaly
- Data Validation Range Question
- Odd problem with charts... narrow!
- Compile error?
- Compile error?
- userform
- How do I set up a macro using relative cell reference?
- lock cells
- MkDir and Save As
- date
- Listing Sheets
- percent increase
- merging worksheets onto one
- Need help with Treeview control ??
- How can I prevent users from deleting an Excel toolbar from a work
- ComboBox properties---need to recognize comma's in numgers
- Is it possible to validate date in Visual Basic Editor? If so how.
- Wrong reference showing up as missing
- Listbox Selection
- Writing a conditional formula to Search with number ranges
- protect embeded object
- Excel query object
- Are Excel Macros Adversely Affected by inserting an Object in a ce
- Error Setting Excel's Application.Left Property
- Searching for text or numbers in textbox
- Calendar
- printing pictures in excel with VB
- Delete "Cut" row on move...?
- Cursor Movement vs. Range Reference
- get cell.address question
- Trap a find error
- How to select range of cells
- Application.Match Type mismatch error
- fatal error
- Copying ThisWorkBook Events
- Find first cell in column's used range
- Solver32.dll missing
- When to use screenupdating?
- Re: Hide a sequence of rows
- "If Not.." crashes
- Use a variabel
- Dynamic naming of worksheets
- automatic copy and paste from sheet to sheet in a workbook
- Excel page breaks
- Inconsistent error
- Returning true if a number fits between a range
- Re: Excel Problem
- Bulk-Delete All Custom Commandbars
- Excel Problem
- Sort More than 3 criteria
- Listboxes on worksheets
- Eliminate Case-Sensitivity in Search
- Re: Determining Language Version of Excel
- IF Functions for Text in Excel 2000
- Can this be done
- Newbie at mixing ADO and Excel
- Macro to combine cells
- Need help similar to a histogram
- Auto update function in VBA?
- Getting data from sheet stored on LAN
- update independent column on pivot table
- Populate combobox
- Compare Size of 2 files
- Validation List Box Locked
- SaveAs Concatenation
- WorkSheet Present
- Count function for two specific items in vba
- Highlighting the active row
- VBA excel programming
- Dynamically Assign Objects to Form Objects.
- common functions:where to put them?
- password userform
- Solver
- Code Repeats Itself And Goes To Wrong Focus
- ActiveSheet.Paste error in XP
- Debugging Aid
- Characters bad when exporting asp.net datagrid to excel
- VBA simple one..
- public sub
- analyzing poll data
- Access 2000: Print Database name in Report footer
- How do I turn off macros when programmatically opening a workbook.
- Simple Thing
- Opening 4 files with 1 button?
- Web Query running in backg. -how to know when data retrieval compl
- return used letters in a range function - an example
- VB Code Remains In Memory
- I cannot use Assign macro in Excel. Could before but not now. A.
- Checkbox - Center Horizontally and Vertically
- SaveAs and Hidden Workbooks
- Filters on Data Validation
- Two Questions?
- Background task
- How do i wrap text in a merged cell in excell?
- HOW TO send data to another program and get back results in Excel?
- ADODB Recordset Function
- How do I add a reference to an object library using VBA?
- S Curves
- How to use Subtotal in VBA
- Macro to generate new graph with variable range
- Macro Secret Key Code/
- Option buttons in Excel to perform formulas in a several Absolute.
- Prevent Column adjustments?
- VBA WorksheetFunction problem
- Make this paste_into_word code flexible to unknown office/word version >97?
- Can someone give me a simple macro to sort a column?
- getting the sheet names present in a work book????
- No zero in a cell
- refresh application.caption
- Running excel as an application
- Points measurement problem
- Web Query to database
- Excel XP: How to make a reference to a library persistent
- PageBreak Problems
- How do I make toggling shortcut keys for superscript and subscript?
- How can I default to Paste Special?
- Check Boxes?
- Between dates table lookup.
- Declaring variables (Long, String, Integer) and interpretation spe
- Error Handling with Web Queries
- Summarising data
- Type mismatch?
- Does Workbook need to be open to copy to..from vba
- Whorksheet Calculate Event Q
- Button doesn't work
- how to use the divisibility condition in excel with 'if' statemen.
- recording macro to paste a copied ws formula
- Move cursor down, skipping hidden rows
- Help with if statement
- Looping
- Problem with Dynamically Writing Event Procedure
- run time error 1004 naming a sheet
- How to convert SumProduct function in VBA code ?
- Set Print Area
- Re: Searching an Entire Workbook
- Capturing deletion of a row
- Run-Time Error
- VBA array - find largest element
- Clearing Form
- MACRO TO SELECT A PARTICULAR SHEET!
- Activating Custom Menu
- QueryTable OLE DB with Parameter
- wildcards in tab. names
- Sum of value in cell range between 500,000 to 1,000,000
- Line numbers
- Teaching VBA programming
- Need assist with setting cell values from an addin subroutine
- CXomparing Job Numbers
- Transform xsl file to xml file programmatically
- VBA auto filter question
- Workbooks within a Folder - B-Lists
- Changing color in palette
- Forgotten Password
- setting an excel file to read-only
- Problem with code
- Late Binding to Outlook from Excel: Outlook modifies email body
- Code line not calculating correctly
- Unable to Run Code on Specific workbook
- Calculate Individual Sheets
- Web query for pictures and maps
- Changing Workbook Property
- Last Workbook in A Folder
- Locating Latest Workbook
- OPening worksheet
- Saving the activecell range for later use
- Menu updates, Administrator VS limited account
- weird saving of a document with macros resulting with macros being transfered to the copy
- Macro & Passing a range
- Clear comments in a selection
- Turn Off Pivot Table Autosort
- Invalid qualifier
- Widening the Name Box
- Activate Menu Items
- Please help me on this....
- how to run other program's macro in excel?
- capture data from multiple sheets and add to the bottom of existin
- Strange window behavior
- Problem caused by Googels personal index software!
- Read about excel - word integration?
- Code Wont Work
- Extra projects in VBA editor?
- Find Excel path
- getting back to excel
- Get a workbook to import data when openeing and export when closi.
- Excel 2003 bug? VBA custom menu disappearing
- How to Kill Excel application process
- Autofilter Properties
- need help controlling IE from Excel...
- Picture
- Selecting AutoFilter Rows
- how to stop program in a big loop?
- Determine application language in Excel 97
- Inserting Cell Contents into a header
- Creating & Naming a New Worksheet
- Excel object - save as csv from Word?
- Move an object not using increment property
- Custom Toolbar
- Command Bar with Number in Name
- Formulas
- populating data from excel into access
- Formula Help Again
- Monitoring Changes
- Excel instance not shutting down
- Return an array of values from a function
- Read image from excel file
- Drop Down boxes
- Scripting Excel - EXCEL.EXE refuses to leave task manager after .Quit and =Nothing?
- Custom button, code placement
- Floating Toolbars
- splitting worksheet into multiple workbooks
- MSComm locking up Excel
- External Links Problem
- Storing text in an array
- Add Macros to Someone Else's Personal.xls
- Replacing Named Range Names By Cell References in Formulas
- User Form
- access from vba
- FIFO: Share calculation in VBA?
- ?thisworkbook.VBComponents(5).Type returns 2
- Sheet Code Module: copying code to
- Put a button in a cell
- complie error
- Database ready
- Populate selected Cell with variable
- Excel closing event of a specific file
- Values from another workbook
- How to clear a form from the screen
- Date in an excel form
- this is about excel programing
- Macros not running
- disable listitem
- need help controlling IE from Excel...
- controling Internet Explorer from Excel...
- finding the first blank cell and then executing rest of macro
- How to "bypass" run-time error '91'????
- How do I log everytime an excel workbook is opened?
- how do I log events
- Web Queries - bypassing "no connection / data available" messages.
- how to lmport a text file and save it as an excel file using vb s.
- Command button on a protected worksheet
- Not equal to?
- Populate and refresh
- Listbox column headings
- How to ungroup a set of controls?
- Sum active range
- Looking for eloquent solution: Determine of any control on a page of multipage has been altered (userform)
- Multiple Users
- macro attached to workbook: to be sent to other users
- Open event to call procedure ONLY on Monday
- Intersection?
- Exiting Design Mode
- Returning checked Nodes from Treeview form control
- Closing Other Workbooks
- Subscript out of Range Q
- please need help : collecting data from different places.
- Copying over Rows Once
- re-organising a table of data
- Cell Reference to a location
- Using Multiple User Forms to pass info from one to the other
- Will their be a fix for KB 818808 ?
- Default Page Breaks
- Double prompting of an over-write confirmation when saving a fileof the same name
- Run-time error 1004
- Print Orientation Toggle
- link from one workbook to another workbook
- please help with FORMULAS
- ActiveWorkbook.SendMail Security Warning
- How do I save to the desktop across OS's?
- Saving to the desktop w/ VBA
- How to create a dropdown list of dates with validation?
- usings contains in var check
- General question about using "worksheet" when select from the VBA Editor?
- combobox events
- Code Still Does Not Work
- how can one obtain the current selected cell value
- newbie questions
- Problem
- Ensuring a cell is copied in text format
- CurDir
- Random number generation from a set of non-sequencial values
- Speed up performance for very big array
- Range object
- Excel and VB6
- Macro: If
- Programmatically switch off "Variable declaration reqiured" in VBE?
- How to build dialogue boxes into macros
- using default excel screens
- Error after last object in the array when looping For...each
- Listing of Face Id's...
- Add and rename a worksheet
- How to avoid re-initialisation when Unloading form
- avoiding VBEopen when using CreateEventProc
- Dynamic Named Range count
- How do I open Access database from Excel
- Running of a Macro when Workbook is opened
- Changes btw worksheets
- Printing worksheet excluding rows with formulas
- macro to add additional lines
- List box Setup from Varying 1d Array
- Hiding Cells
- How to play a MIDI
- Help with Loop / Array / Ranges
- How to setup a program to print on lower bin tray
- Borders/Inserting Lines
- Print selective pages - only if the pages's Rows.Hidden = False"
- How select/define cells with FIND method (maybe together with SpecialCells)
- Create Database
- Cannot use .IsBroken property of a Reference object - error 48
- How do I use a for/next loop to preform the same actions to every.
- csv for filetype property of filesearch object
- Excel 97 to Latest Excel. Repair ?
- restriction
- Web query - when does error occur so I can trap it?
- For..Next loop error
- Borders/Inserting Line
- .filesearch trouble
- How to use FileConverters?
- How to bypass "Enter Parameter Value" via macros
- Question for T.Ogilvy
- Find two values and select data in between
- window size
- Re: Links using XLODBC.XLA not working after upgrade to 2003
- Macro Delays
- I need a macro that will delete every other row in excel.
- What does the "Paste Special Dropdown" popup menu do?
- Inserting items into the Paste Special Dialog box
- CONDITIONAL FORMULA
- protection
- Create a search Field within a worksheet to search command buttons
- Tom Ogilvy or somebody else, please help
- sumproduct problem
- problems with XML XSL and Excel 2003
- tick boxes on userforms
- selecting current row information and transfering it.
- Max Value within filtered range
- Automatically lock cells and hide formulas
- set last used for getting directory
- dynamically create userform
- Subscript out of range
- Sheet Protect
- Code Does Not Work
- Headings in a Listbox
- Hide Cells
- How does one get the PivotTable report info that feeds another PivotTable report?
- "Subscript out of range Runtime Error 9"
- Loop Through Highlighted Range
- Type mismatch
- olap cube (pivot table)
- How to Find MAX value with depedency
- Creating an Object on a Multipage
- How to track two values and work with the data in between?
- Problem with VBA "Find" operation
- %SYSTEMROOT%/Temp variable
- Props to Tom O.
- EXCEL textbook for self study
- FileDialog problem
- Copying rows of data based on a value in a cell.
- How do i assure a pull down list begins at the top of the range?
- importing a tab delimited file
- ? To Tom Ogilvy or others on VBA Listbox
- Cell not refresh probably.....
- saving a macro
- Keeping text together
- Need Macro to Find Column Heading -- if none, then insert new column
- Data validation: using Custom, NOT List, to get non-blank cells
- Re: Grouping and outline
- Sheet naming
- 7 Digits Only
- Move up text
- variable row count 2
- Referencing Shapes
- Faster AutoFilter?
- Detecting active customview
- Application Events / App_WorkbookOpen
- setfocus
- Auto Filter
- HOw to create Excel user
- Format date in footer to propercase?
- it's going to blow!
- Formatting Issue - Zero's not being displayed
- Links
- Excel marco upgrade
- Range as variable No.2
- hide negative values from a formula
- PivotTable-Fields Page
- Special Character
- Extracting the Month from the Date in other cell
- Transfering Declared value through procedures
- validating 4 values programatically
- Database Question
- VBA.NET
- Opening/Closing a lot of groupings via VBA
- Define Range based on cell color
- Open a Word document problem
- Detect Workbook Name when using GetOpenFileName
- Colour number...
- Re: SendMail only one sheet, not entire workbook
- Re: SendMail only one sheet, not entire workbook
- Re: Block REMarks in VBA?
- Generating HTML from Excel 2002...tabs broken?
- "Unable to set the ..." in Excel 97
- Re: Radio Buttons
- Run-time error 429 after installing Office XP SP-3
- Re: Active Printer Application
- Range use on page
- Re: Dynamic Named Range repeat on different worksheet
- Function returns Range --> error 91
- HELP PLEASE
- VBA for XL OSX
- null value cell
- Macro - Insert&Label Column, if the labeled column doesn't exist
- Change value of each cell in selected range by percentage
- Debug.Print in a WITH procedure?
- Selecting Cells using dialog box
- Decimal separators in formulas
- XL RTD server
- Date Formatting Woes
- Sumproduct Question
- Printing a .pdf file
- Subtotal & #n/a problem
- Extracting the column letter and row number
- Making a PDF-file
- Excel upgrade to 2002
- cant find project or library
- Cell value while typing
- savecopyas issues
- Syntax for "intersection of this col & this range"?
- Store ranges in arrays, and build third array based on IF test?
- Excel VBA keywords
- Dynamic Arrays as arguments
- Why doesn't this work ??
- How to create pop menu in macro ?
- formula in cells causing printing issue
- Determining which template created workbook
- Error 2015
- Defining Dynamic Ranges in Macro
- using a password to in connection with macro protectio
- Importing text files
- Re: Block REMarks in VBA?
- Giving focus to a particular sheet
- lookup in a range then vlookup from the found value onwards
- #NAME? when using custom defined function
- Event in a add-in called verytime a file is opened
- Printing to File using PrintOut
- Inserting A Row Macro
- Web Query: Username and Password.
- Dropdown box
- Problem with Find function in VBA
- Opening Multiple Workbooks from a macro with a twist
- Pivot Items
- Add data to a text file
- Accéder à Excel en réseau
- Last Cell Scroll Bar Problem
- Finding text in a string
- Trivial: Mouse scroller doesn't work for VB 2002, but on different PC with 97 it does...
- How can I set up EXCEL to show number without 3 last digits?
- Check Boxes / Option Buttons....
- OLEObjects
- How to make R1C1 nomenclature work with SUM() in a cell ?
- BeforeRightClick - XL2K on XP_Home
- RE: Q: Best way to take data from VBA into graphs without writing data
- SpreadsheetML <ss:Data> using spaces and cr/lf
- SpreadsheetML - auto row height
- SpreadsheetML <Data>... question
- how to stop program with loop by click "Cancel" button
- Programming colors on a pie chart.
- Validation
- Select text in textbox
- Conditional Formatting Range
- Radio Buttons Locked
- Links to Docs with Passwords... program in?
- Variable Range Reference
- Subtotal for each column problem
- shortcut of macro
- Dates in Header
- linking excel and word files with vb code
- Pivot Cache Memory
- How would I select output to a file or Debug?
- Event to call before a opened workbook is recalculated
- Force no save on workbook exit
- turn off the " replace file?" question when saving excel files
- Name Macro
- Freezing the data in a column and moving the calculations to the next column
- radio button on protected worksheet
- Need help Cleaning up Code
- Name parsing formula..
- Installed add-in promts for a massege??
- command button
- Excel have a currency convertion tool linked to a live cur conver.
- New to VBS and MSSql
- Re: Excel 2002 - Commandbar.protection = msoBarNoCustomize
- Setting Onaction for File > Save on Menu bar using item or index numbers
- Sending keystrokes to Citrix ICA Client
- OLEObjects .. again
- Using Jet to read excel file returns blank for last cell - sometim
- How do I set up a user friendly inventory system using Excel as b.
- How to sort ListBox or Array?
- Check Box Font Size
- Making blocks of text comments
- Use ADO to retrieve data from Access Parameter Query
- Hyperlinks.Delete erases cell formatting
- create a prompt box to perform a function?
- Setting Printer Options Programmatically
- When to code in sheet or userform modules and when to use modules
- How can I make a 3D model in exel that will move according to exe.
- Finding last Date Report
- Formatting Text
- Advice for VBA functions using arrays
- VB6 DLL addin trouble
- Two instance of same VBAProject....
- pay bill online
- go to vlookup location
- attaching toolbars to files
- Continuation of the listbox question
- Merge two lists
- Using Advanced Filter through Macro
- Force worksheet to NOT save
- Ranges
- Question on application.screenupdating
- Excel Monthly Work Schedule
- Selecting Workbooks
- blueprints
- How to get my code to loop
- worksheet menu bar
- VBA Array Formula
- excel linked documents password hold in code
- Application.Displayalerts = value (is not working for me)
- rearranging data
- Excel 2000 very unstable as a development environment
- Does Excel do "just-in-time" compilation?
- Excel 2003 VBA - setting "iteration" upon loading
- User Forms - Formating fields
- Limit search range then loop thru' each cell...a bit stuck...
- Text
- How to call Macro(using ExecuteExcel4Macro) for a particular workbook
- cut off part of cell entry
- Collection
- Flip Cells
- active window
- "compile error in hidden module: ThisWorkbook" for Excel 2002 - pls check this code !
- automate a function
- Data Validation
- Looping Problem . . .Argh!
- If (starts with ', then delete the ')
- Application.screenUpdating = False
- To to check whether a string is a valid reference
- Certificates and Pvkimprt.exe
- Code Execution has been interrupted message
- Ordering graphs
- Controling Acrobat PDFs
- Finding Last Date Report
- To access built-in templates: Software Solutions and Busines...
- Last Row Variable
- find replace macro
- Returning Flags from Solver used in VBA
- Code to run on worksheet selection change