Microsoft Excel Programming

How to highlight cell match todays date
Positioning Data / Form dialogue box
Visible property on Worksheets
Network printers, how?
Text Import Wizard
Moving Chart Objects
A Word Problem...
Return all page ranges in an array? (Repost - Tom?)
access-->excel-->access
Sheet to Workbook
VBA Code needed to start different public sub
re-entering userform
Excel-Web Queries
Customized Menu Macro with Argument invoked twice
v.basic misc programming ?
Delete Sheets
Slow VBA, Can someone please look at it?
run macros on a protected sheet?
extracting matching data
Refresh Pivot after Creating (VBA and SQL)
Help on writing a code to copy and amend lines
Adding Validation (drop down)
formatting
Importing from MS Access
Re: Hash (MD5) in Excel
Add column to left of "hotspot"
What 's wrong with the coding? -- about using outlook to send attachment in excel
change caption font color at runtime
Setting width and height
Getting HyperLinked Cell to Appear at the Top of the Screen
choosing from a list in VB
Pivotfields.CurrentPage
Error -2147417851 '"The server threw an exception"
Excel VBA-use variable in active cell formula problem
Disabling Events
TrailingSpaces
Excel 2002 and startup
Open a Word Document
Trigger macro to run when picture is deleted
Select Case Information Needed
easy problem
Re: Calculation involving Time format
Copying cells
Enter pressed in Textbox
Use of Drop Down -- A New Beez question
Re: extract with criteria
File Browse Box
UserForm Question
Excel VBA .NET?
Command bar Defaults
Re: Just a tip I have picked-up
Import table into new sheet
Re: cell reference in formula
Reselect cell after macro
Is variable an integer?
Re: cell reference in formula
How do I: prevent user from scolling down and right?
Re: cell reference in formula
RTD UpdateNotify()
Re: cell reference in formula
Parsing out text entries in a text box
Numbers to words conversion Euros Spanish
Excel XP XML macro security warning
Worksheet Controls
Run Excel Report on Server w/out human interaction
Subscript out of range
Re: Help! Calling hidden sheets?
Re: Excel - Calc current age of a person
Automatic creation of an overview using several workbooks
Re: Help! Calling hidden sheets?
Re: Excel - Calc current age of a person
Excel VBA-How do I increment columns in VBA?
Re: Help! Calling hidden sheets?
Macro skipping blank cell
Re: assign number value
Re: Hyperlink to execute macro.
Popup Menus
excel column only numbers
Indirect function - relative reference
Changing caption text and hiding buttons
change background color of row until condition is met
Re: assign number value
Color Index and RGB Color
Simple copy paste question
Icon change
Button Error - Save at location
Need help With Code:
How to add line at today's date in chart
Filtered data selection using vba
Excel Validation / Dropdown list Problem
Stutter in AdvancedFilter Unique Results?
Re: Hash (MD5) in Excel
Excel VBA-How do I increment columns in VBA?
=IF in VBA
fast way to make reports from a database
autoselection in a pivot table
Applying Macro to all workbooks...
Open two text file in Excel
Delete Selected Rows
open file
DDE Argument exchange with Word
combo box
Missing library?
Can Not Find declared dll
Largest value in a range
GUI
VBA Array Population with a Single Line of Code
Extract 1st word and in capitals
GetOpenFilename
Please Help me
RE: Copy with criteria
"Harlan Grove's resizing code",
writing on cells
Open workbook without update all linked information
Saving a Favorite from code
Help With Runaway Calculation
Drawdown Analysis
save file name with Chinese/Asian
Time Clock
"Assign Macro" is gone from menu
Summary of all worksheets
Excel VBA - Problems using Protect/Unprotect a worksheet
Change date format
Code works 1st time then Type Mismatch when checking for not blank cells
Resizing an image file
Counting blank cells
Application::DisplayAlerts not working
Error trap with object variable problem
Virus in my Immediate window?
In theory Excel vba work out a roster by itself
Adding to a named range on another worksheet
Using a listbox effectivly
Reading from ini file
Customize CommandBars (disappear and reappear)
Excel 2000 drillthrough
email
Q: is this continually looping?
Create CommandBar in xl95 code - possible?
Help!
Formula Palette
Number Validation
How to activate a file when the filename is represented by a string variable
Sort data
Fourier analysis
TIME values
Refresh a PivotTable using VBA (SQL generated Pivot)
Protect Workbook
Can I rename a directory using a macro
CreateObject("Excel.Application") -> Access denied
Closing workbook
rows().value
XML / XSL security problem
How to connect to Informix database using ADO???
Problem with Format statement
XL97 - Apply colour to Pivot tables
VBA Forms
Excel VBA-How to open several delmited files & SaveAs Excel files
Excel VBA - Searching long words
Running Code on Each Sheet in an Excel Workbook
Keep multiple sheets in synch
Sending Email Notification of a completed VBA process
Excel Headers
Using Countdown in Status Bar to Play Sound
format +44785656656 as text
Hiding all Toolbars
How to specify a range in Excel macro
Re: How do I create a combobox???
Adobe using VB
MultiPage control
Formatting userform textbox - help required
Sorting lists of Named Ranges
Excel VBA - select firsty 30 characters of a cell
Debug.Print
Rounding Based on Value
Clipboard
Linked ListBoxes
Different passwords to separate ranges in excel 2000
All cells not calculating
Excel 2003 and Macros from Excel 2000
Re: Custom sheet protection
Making an active cell the first one to appear on the spreadsheet
selecting workbook/worksheet from browse button
Public/Procedure Variable
Delete names in workbook
Help Again with data comparison
Loading an Excel file
Attaching text to button
Turning off circular reference warning
excel--->access
Making a macro with random placement.
ListBox
Worksheet protection order
Macros
Consolidate User Input
Search List of Data
Buttons
Worksheet name
Copy to windows clipboard
Why this simple macro doesn't work?
Invoke Outlook Express SendMail From Excel VBA
Events for Controls in a Multipage Control
Creating Password
Sorting Columns using VBA
Printing during select times
entirerow.delete multiple text conditions
Menu Items and Disable/Enable in Excel 2003
How to pull in 2 different rows and compare them
Q: References: upgraded office, library changed causing errors
Help!!!!
Data Transfer
Sending text from a Text box to a sheet
How to set up an automatic SUMIF function
Question about IIF in SQL query
Import data, calculate, export data
Keeping multiple sheets synchronized
Protected Workbook Opens Restored
Repost: Smart Hyperlink
Workbooks in use
Using a form to input data into a schedule
Excel VBA - Worksheet Coding Help
Create button with addin/reference macro in another file
Save in location button
matching and formatting...need help!
Printing -
Conditional Formatting help...
Merge and Sum Tables
Finding a Linked Cell
Making a function available in all sheets
Spreadsheet object
sub directories again
User-preference Customizations in Personal.xls
PlotArea.Interior.Color ... all white
NESTED IF
Charting Weirdness and VBA
add ocx reference at runtime and programatically
Disable "cancel" button
Excel VBA - WorkBook Coding Help
two... two... two questions in one!
Convert Ecel 97 VB to Excel 2000
Re: Graph Chart Custom Types (Tubes)
pasting a web page onto a worksheet
Inserting iserror into a range of cells
Group Names Change Upon Paste, Kills Code.
Filenames in macros
Auto Freeze Frame
HELP!! Macro suddenly not working
Edit a userform
Controlling Text Loading
Auto Hide
Excel formulas efficiency
ColorIndex
Help Transposing Data from Row To Column
Filename and creation timestamp in 2-column combobox
vc++ automation: opening chart as chart window and setting scale
Edit Text in Button
Identify strange character
Code to clear sheet
Detect event if excel is in edit mode.
Pass parameter to a form and then open it?
Add another range
Workbook_Open Event
Excel VBA - User form caption problem
to join more workbooks in one
Amend open Workbook code
Formula within formula
formula for stock quote
Need continuously running macro when conditions are met
Naming Cells
Using ActiveWindow.PointsToScreenPixelsY
Array Functions
find letter vrs number
TimeSerial
compare mulitple fiels... then, order the files by header... then, save
Need macro to work in 2000 and 2002 versions
Making a auto website login script
An Excel question
Help becomes disabled
Corrupt Excel File, I'm Toast! I'm beggin here...
Code to go to last row (next blank row)
Macro to paste data into next blank row
SaveCopyAs
extracting numerics from literal strings
How do i create a new worksheet
auto sorting
Remove vertical scrollbar from spreadsheet in VBA code?
Command buttons
Re: FAST, RELIABLE, LEGAL MONEY MAKING OPPORTUNITY
Making cells readonly
Worksheet labels
RE: WorkBook_Open Event
text boxes
VB in Excell
Send Email from Excel - but only to people in range
questions regarding chart format.
forming Ticker-Tape in Status Bar after running web Query
Excel cursor
adding a description for an UDF and its parameters(!)
Login Help!!!
CSV formatted text file to Excel
Selection.count isnt working
Worksheet_Change sub does not trigger a called macro
Prempt Disable Macros option
Filter Rows
save as an UTF-8 file
Newbie needs direction
add new named sheet
Email 1 Cell w/VBA
How to convert multiple values from single cell to an array
Sound Code
funcres.xla
DOS Messaging
Help with Analysis
Pivot table from a pivot table
Do I Need Licence to Develop Excel Tools for Sale?
Searching the formula result
Output to CSV
returning ranges offset from argument range function call
The 'clear' instruction in VBA
Named Ranges
Pop Up Window
import text wizard...
Data Validation
A macro for the today's date...not the current date
Is there a way to apply a sliding percentage?
Saving an IE Favorite from an Excel macro
Switching between Worksheets
CountBlank in calculation
highest value in a Row, that begins with "21" or "28"
Selecting a range without referring to specific cells
InitializeComponent() errors, Setting values in another form
Creating a sheet at set times
Deleting Hyphens or Dashes from multiple cells without deleting the remaining content
pop up boxes
Importing Text File
Autofill
Auto-delete the workbook on expiry
Lost my macros...
Different Kind of Progress Bar...
Passing parameters between functions
Dynamically pasting function from Visual Basic to Excel cell
Begin Search at specific cell
FOLLOWHYPERLINK - Posting Over 1000 Characters.. can I?
Macro to clear content and put back a formula
Working with quotes
selecting values
Before Double Click Event
Chart.Export max pixel size?
urgent, on excel programming
Suspend/resume running of a macro
Running a VBA by ASP
How do I change a macro to call a sheet from another workbook
Re: How do I change a macro to call a sheet from another workbook
What is the formula to convert a whole column of date to text?
how to set password to protect worksheet under excel?
Automatically Closing a worksheet after 10 mins
send text
Redim 2D Array Subscript Out Of Range Error
Display Excel Sheet in VB6
"Modeless" Message Boxes?
Alignment problems
Mouse-move flicker, modeless form & shape selected
Appending Imported Text Files
hyperlink
Excel VBA - Opening a workbook to a specific sheet every time
Static Time Entry
need help getting combobox to open a file
Login Information
Macros and User Defined Data Strucures
Save on change
column format as text
Re: excel--->access
VBA Help - Running a macro when closing print preview
How to Refresh with VBA(SQL) created Pivot
Auto-Size and Position Pictures with a Macro ?
Excel generation and PageSetup.CenterHeader
working on 2 different worksheets....arrays?
select printer
list of network computers
Userform Combobox to choose date
what does .Find return
Left Function in code
Office2003: Handle events for web charting component
Assigning a sub to a specific keybordkey
Using the Find function with the What referencing a Range/Cell Value
Picking Teams
creating formulas in XL
Emailing multiple receipiants
Import Wizard
Calling variable from user form
BeforeSave workbook event
Excel clearing clipboard
Editing Queries in Excel 2000
VBA Problem - Print Preview
Parsing paramters
GetOpenFilename
Naming a Range
Bizzare issue with matrix calculations
Fill a Memo field
GetOpenFileName
Select column at run-time
Disable Cancel button
Re: Toolbars and menu items have gone
Re: How to skip in a macro
removing symbols from numbers
removing symbols from numbers
WRQ Reflexion
eliminating quotation marks when writing to a text file
Re: eliminating quotation marks when writing to a text file
How to store organization wide macros?
query criteria for timestamp
Save Workbook using List Box Data
Adding a new column/field
Conditional formatting across worksheets?
Change names of files in a folder to match names in Excel Column
VBA-How to insert vba code file in a project using coding rather than manual import
Summing data
How to add new type of "External Data" in excel
controls on worksheet
Subscipt out of Range
error: reopening will cause any changes you made to be discarded
Range from highlighted area
Turn off pasting in range of cells
Submit new data
disallow edit in used rows on save
looking to simplify a recorded macro with code
VBA Button to switch worksheet(s)
No Charts will refresh in a Workbook
need help with filtering a list
MS Query
Control ToolBox Showing Maps?
Renaming the Worksheet through VBA
Compile-time Error Handler
Set focus on graphic inserted in worksheet
Assigning a formula to a Cell
Window Options
macro to move contents of directory
Can't start outlook from Excel
GUI like the file chooser
Activex dll files
Streamline PivotTable creation code
force macro
List boxes in MSExcel2000
Finding duplicate value in another workbook
help!!!
countif color count
data from userform into worksheet cells
question about worksheet protection using userinterfaceonly:=true
lookup cell location
Checkbox value X instead of check
Convert numbers to text
Excel95 Floppy Save problem
Lock a cell when a given cell contains data
Accessing password-protected Excel wkbk from VB
Opening help file with context number
Moving through a data entry form
Progress Bar
Save As UI
DDE to Query AS400 DB
Get File Properties
ATPVBAEN.XLA!Random Call in Macro
Re: Time Errors
Notifying notify users on how to lower security
combo box
help...
Running a macro before saving file
hWnd of UserForm
Back Door to VBA?
displaying the outlook address book in excel
Update Closed Workbook w/ ADO
Please Help!
How to color characters REG, GREEN, YELLOW in the same cell?
Number of occurances of the larges value in an array?
macro help with print lables
Help with code that checks if a sheet exists
urgent, how to lock entire column upon load?
ThisWorkbook.Path
clear pattern but not gridlines
Saving worksheet to .doc file
Combo Box Events - Self-Referencing
help with msgbox
Sheet protection assistance.
hide sheet? uncheck sheet tabs? or ???
re:clear pattern not gridlines
Excel column as datasource
"Automation Error"
Indirect versus Offset
how to disable form buttons using macro?
Replace worksheet name with a variable
Creating multiple pivot tables from same cache
Command Button Picture
Hiding Parts of Excel
is it possible to run a macro automatically?
Re: TEXT(Cell1,"MMMM YYYY") to work in all locale.
Colour Macro
Personal.xls
Create seperate xls files with names based on cell text
double names in a list
automate graph-data
title in graphic
ADO - how to run proc returning a record
Code to automatically overwrite?
biff 2 clipboard
Application.Caller
XL97: colouring Pivot tables
What is the maximum number of files that a directory can contain on Windows XP?
Hiding Named Ranges
too many different cell formats problem
Date formatting
Assigning worksheet to worksheet variable
Copy worksheet from Active workbook into all other open workbooks
Creating Global excel macros
Date formatting a text box
Add In - How to start and use it
Yahoo quotes error in Excel
Working with multiple sheets
how to control word from excel
Single Selection ListBoxes
look ups
Excel VB / Formula Problem
arrow key problem
macro/combo interchange
VBA protection and 'save as'
VBA problem - text boxes
Unsupported object or method...
Printing Excel in Landscape mode...
Find images in a Excel document.. How !!
Showing a .PDF From Excel Button Using VBA
Open event
Help with IsEmpty
excel-access
Programming Excel to export to Access
Output from a userform finding the right column. column
User forms & worksheet help!
Custom Fucntion
Select an array of cells and paste to separate worksheet - 2nd post - 1st didn't work!!
Importing data
Trying to move a BLOCK of data using 'OFFSET'
Copy Files from a folder to new location
Problem changing open file from R/0 to R/W
Run macro in different workbooks
passing parameters from command line
file transfer
macro to subtract columns and put result in new column
something_like_transpose
any suggestions welcomed
Paste Special will work from kbd but not as a macro!!! Suggestions please!
Validation List Definition Fails for Some Regional Settings
Adding an artificial watermark to Excel sheet
Date of Last Update Automatically?
Remove rows where value = 0
Address Subroutine Name from within Sub
Chart via Combo Box
Creating a summary
Re: TEXT(Cell1,"MMMM YYYY") to work in all locale.
automating email (CC:)
Copy - Paste
any suggestions welcomed
Blank import
Need help with adjusting width of VBA-created toolbars
Question to a VBA Wizard!?
Activate Workbook
Prime Numbers?
Dele rows
Re: How To: Make cell reference the sheet name
Multi-worksheet finds
Finding the largest value
Var
Uaing VBA to query macro security level
Re: How To: Make cell reference the sheet name
Blocking cells
changing the name of a file
Dialogue Box
average and stdev
Collection Class problems
comparing a value to a list
Refusal of Excel to recognization Worksheet name
RE: Checkbox value
"Licensing" utility for protecting my Excel code
Setting scroll area for multiple pages
emailing workbooks
Macro to move selected cell contents to a specific column on same row
List Box and Quick selecton of item in drop down
Running Totals
Save Location - Date Format
Combining Msg Box and Data
Making Excel Ignore invalid references
Can't Update Cells from a Function?
SetFocus to first textbox on userform upon Userform1.Show
Defining Custom Colors
VBA-Select several ranges using variables
ComboBox with an editable function
Path
External dll
Join string with variable name to get variable value
Macro to mark double numbers in another colour.
Generate a Modulus Sequence
Auto Clear Cells
Undefined unction when using VLOOKUP
Hidden name
Re: Macro assigning help PLEASE
Hiding Toolbars Question
UserForm_Layout event - Excel97
Vlookup with tableLookup is external workbook
Macro Ran in Excel 97 but in XP. What Needs Changing
Unable to get VLOOKUP property
how to put tab character into textbox?
Get sheet name given a cell
Maximum character input in a cell
emailing from excel
EXCEL PIVOT TABLES DETECTING EVENTS
Making a connection: shape clicked and cell it lies over.
Listing Temporary Internet Files
Need Help with macro code modification
how to select every third row
Assist in converting Lotus Macro to Excel?
Values in words
Chart Series Question
Calculating Dates in VBA
Repost:I accidentally posted this in the general excel forum. Date Logic
Zoom on selection
Drag and drop onto cells?
runtime error 1004
Changeing a graph
SelectionChange Event
Another problem with changeing a graph
Problems with Excel 97 and XP
Getting a function to return a formated Range string
Matrix inverse
Excel2000 VBA - Workbook size increases abnormally.
keeping code in .dll library
Listbox with Bound Columns
copy files from one dir to another
format painter
Chart Identification Problems
Empty listbox
MANAGING MACROS
Set focus on command button
Pull data in a new colour
Listbox control
change value in a cell if other cell is changed
csv example
adjusting Y-axis
TEXT(Cell1,"MMMM YYYY") to work in all locale.
"Dumb copy"
Create (or find) a complete object tree for excel
XL97: where are my favourite MVP's ?
Is file opened?
Sharing
Comparing negative number
making macro run faster?
Excel automation
Maximize Excel
ForEach procedure adding values
Checking and Updating
Mail Merge
Comparing Excel Workbooks
Using chartspace in a user form
Macro
Concatenate Function
calculate
Getting File property info with code?
Keep the Enable Refresh option (VBA, SQL)
Calendar Macro
Locked cells
Macro to unprotect workbook
Help with Arrays & Ranges in VBA
Macro to load on open
VBA/ActiveX ComboBox autosize bug - Selection of value multiple times shrinks text.
Re: ActiveX registering problem with VBA
Filecopy and UNC-pathname
Add value to existing cell value
How to read active Excel celll value by external vb application?
Excel VBA-
create a "check" macro
Set a PivotCache as the results of a query
Re: ActiveX registering problem with VBA
Customizing Toolbar
Cell check
Excel VBA-Change chart range to variable
Recordset in Excel
Sace and close
"ghost" link
Copy/Paste to all Worksheets
How can I make a simple database.
Macros
VBA Functions
Getting rid of Prompts in a macro
eomonth funciton in VBA
Mortgage amortization Template
IF AND in VBA
Pivot Table value in category renamed but the old value is still there
Expot to Access
Summarizing several item values in one cell
Converting Lotus 123 macros to Excel - Sort by Due Date
Converting Lotus 123 macro to Excel - copy/move data to worksheet
Using Round function on French and US Win2k
SaveCopyAs cannot access opened file?
SQL query to ODBC
Linking ComboBoxes through VBA
Customised charting and data lookup
listbox with checkbox or radiobutton groups
"Subscript of range" error
Recognizating worksheet name
Diverting output to another workbook?
Excel Object Library Reference
Linking to an external referance with a variable file name?
How to reference unsaved workbook in functions????
How do I set focus
run time error 91 all of a sudden
Moving and parsing data - Copy & Paste problems
Conditional Formatting
Filling a Combo Box with VBA
Autonumbering
How do I set values from a userform
Resizing comment boxes
srf
Compact Excel Spreadsheet
pivot table single column
Determine last row then sort
pastespecial on a worksheet question
ComboBox RowSource --- can I use a userform OWC10 spreadsheet range?
Code to print w/out cell shading
Clearing Cell Contents
Deactivate Formula
HELP!
Use Checkbox Value or Public Variable?
split cell content
Cannot Record a Macro or Edit VBA
ListBox question
Macro to save excel XP spreadsheet to excel 97 spreadsheet format
testing whether a character is a letter or number
Re: Getting rid of "extraneous" data (rows)
Userfrom code in written in Excel 2000 running in Excel 97
Re: Function name not recognized
Wacky form
Range problem
Complicated Table
Automating import of a certain type of 'txt' file
Find Unique Entries
Default Filepath question... How to???
Conditional Formatting limitations...
Please help, file name issue
How Can I Check Multiple Ranges?
ShowDataForm Initialization
Renaming tabs
Re: Adding 4 business days to a specified date
Re: Using qry from excel to update tables in a db2 database
Determining the group a picture or textbox is a member of
Beyond a wholesome discipline, be gentle with yourself.
Not Hiding Columns