Microsoft Excel Programming

Update Data Field in Pivot Table with Dynamic Excel Range
BOHICA needs more help
TOM you made my day...
Need Help closing excel and documents
Simple Macro
Is there a way to make Excel file an executable?
Icon/Toolbar auto view
For MVPs: How to replicate the SheetPivotTableUpdate Event in XL 2000
Re: how do i test for the existence of a range name
Accessing worksheet cells from VBA macro?
filter gives no output, no copying necessary of current.region
Excel VBA saving cells/rows as csv file???
Add new Worksheet after filling first 256 columns
Conditional
Replace in Excel 97
AutoFilter _FilterDatabase Rowsource Listbox
Pivot Table Question
MultiPage problem
New Question, old thread
Add_months function problem
Vlookup in book which will change.
Is this slow code?
How to send a self installing .xla within a .xls workbook application
Lil Simpler
Setting ComboBox Value
worksheet error checking
hot keys
Userform not working
Copy values between files.
combo box not updating
Macro
Check for text within cells and make bold
Left justify across cells with word-wrap without merge
Help Needed Badly!
Define name in macro
format text string for SeriesCollection.Name property
Re: pagesetup 1004 error
if column I is blank, then puts an "a" in column A.
How to change xls format to text?
Extract Rows By Date - Follow Up
hit counter question
y won't this work??
multiple results search
Help with VBA
Directory "Locked" when selecting multiple files using GetOpenFilename
Help with creating a VBA
Crashes when I delete Control
auto insert copy of worksheet
Userform Titlebar Color
msg box and or sheet events
thanks
another won't work for you fine people
Run time error - Adding Workshet
EXCEL dollar sign BUG?
dir
Is it possible to activate a txt document in excel code?
replacing value by formula
Apparently Empty Cell--with formula inside
Can any body help?
Addressing cells without selecting
Path/File access error: '.\VB??.tmp'
how to keep the button visible always in the screen, thanks
Minimal I need in a server for creating xls files with c++ automation
Hiding Cells Automatically
Copy detail into subtotal line
Excel database query returns only 2 columns
Get Max & Min from a chart series
click buttons to do, re-click to un-do
textbox on form
Running total using macro
Highlight Data points on chart
ErrNum = -2147467259
Help with a macro please
how do you disable a button?
using protection (but allowing a combobox to still work)
Detect if conditional format is true
How to save an Excel range into an Access Database
Disabling circular reference
VLookup, Max??? Newbie
Input #n
Preventing a workbook from being copied
Simple to those in the know
Re: Column Headers
Counting blanks in a string
Re: Counting Columns in Dynamic Range
How to use ADO.NET in Excel 2000 VBA dev?
Re: Release files from memory??
Re: Matching and auto highlight matched cell answers with colours
Extracting data with delimiters
Re: Unwanted Total in Pivot Table row field
x = textbox1.value (somethings wrong)
Debug ActiveX object
Active user form
Re: Combine two udfs into an array
Re: add-ins
Microsoft Excel and OLE action
Re: Separating first and last names
freeze pane command usage
Re: Setting Source Range For Chart
Re: VBA String manipulation
Re: Save As
Re: VBA String manipulation
Do I use MATCH to do this?
Only getting first 256 characters of text box
Percentages
Re: Hyperlink window problem
Re: on cell enter..
Formatting copied dates
Cell Formula to run VBA code
Re: VB Code to Click Yes Outlook Security
more row deleting
Unwanted "Total" in Data Field in Pivot Table
Comparing Across Worksheets
How do i compare values from two sheet and copy & paste if values match?
Conditional Formatting in VBA
Help: selecting part of an array
Re: text in cell too long? run-time error
Re: Clear data from clipboard using VBA
Re: Possible to know who has called a function ?
Re: refresh in pivottable
copy/paste
Re: refresh in pivottable
out of the ordinary question
Time format problem
Re: Position cursor in multiple worksheets
Re: autofilter range count
Clicking Cancel on an Inputbox
Ftp
Bit Masking
Office 97 VBA Help and Windows XP Home
Re: Macro: stop recording toolbar
move formulas to a different column
VBA Application.FileSearch
Worksheet function & SpecialCells(xlCellTypeVisible)?
MsgBox Justification
Excel 2000 /2002 library problems
Chart on a user form
Copy 2 items to next sheet
Re: Release files from memory??
Re: 2 things
IF FUNCTION
Label plotted on graph area
Re: Finding Number Of Days in a month
Don't plot non-values on a chart
Macros on Excel Custom Toolbars.
Re: Exporting Data from Access
Inserting a row in sheet A should Insert a row in sheet B, removing a row in Sheet A should remove the corresponding row in sheet B
Auto Line insert
Recalculating Excel Sheets with activated autofilter
Code to compress files in XP
Re: Adding Range to Worksheet Names Collection
Re: Numerical Integration Code
Hide row when cell is emtpy
reset drop-down menus with macro
how to know if a xla is 'loaded'
Macro to get from excel into Access
how to save pictures in excel as gif or jpg
V.B selecting ranges for naming
FWD: Taste this important patch from the MS Corp.
Re: Problem with named range as VBA macro parameter
Very visual basic
How can I detect abrupt changes in my data
2 ranges into one
AutoFiltering problem
Collection Function
Business contact organization
IF wokkbook1 is open, open workbook2 Loop
handling data in arrays? getting a bit knotted
Finding The Next Monday From a Date
Macro to delete specific rows
Difficult concatenate No 2
Command/option/spin button - no control menu available
Re: Release files from memory??
Mail merge error
How to subtract some rows from a range
I hope I ask this correctly
Re: How to Refresh with VBA(SQL) created Pivot
Control which option is visible in Combo boxes
Delete Columns
link worksheets
Re: Problem with named range as VBA macro parameter
publically defined command bar variable problem
Making Semi-Colon Delimited Fields
How to get the available printers list in a macro
question about office web components in excel,
disabling the "view code" tab - sheet protection?
Restricting Access to VB Code (xl98)
new to VBA...Winsock DataArrival event not getting fired.
Re: Zip codes in mail merges
Add-in with custom Face
Strange code showing up in Immediate Window
Limiting the size of a worksheet
Formula to lookup info in a table
sending data to an MS-SQL dbase
Excel
Invalid Data error
Get workbook version
Automate a macro based on the value of a cell? (call Sub)
Transpose dynamic range
Re: Suggest a wayout
Re: Generate letter
Re: Generate letter
FileFormat Macro Problem
Problem: Residual query data? Closing external connection?
Links w address function.
Suggest a wayout
Rich Textbox
Any way to update links tru VBA code?
Format Cell for All Cap Text
Formula to lookup info in a table - part 2
Counting Data Field within a Pivot Table
Copy worksheets into new file
Alarm Sound Function Not Working_Any DDE Gurus??
Cell reference
Open With...
Excel VBA 3D Ranges
Re: creating a database and database query
Exporting To Excel With ASP - Number Problem
cmd button, send form via email
VBA Calc
How to control the zoom between two pages
Re: new guy with a conceptual question
Print page
Unable cut in workbook
freeze pane command usage (clarified)
Putting path and filename in a macro
How to record macro to work on selected column/row?
Auto_open and environ variable error cannot find library
If search criteria is not found, then goto Repeat?
Group Box Border
Dynamic filename
Matrix Functions
Macro to load an add-in
Changing filtered cells
On Error Resume Next TROUBLE
Bob Phillips
Protection
Select the next row after xldown range
Clipboard question
On Error reset?
Read only lock on rows
Vlookup, table array is referenced in another cell
Using VBA to perform a process each row
How to call a sub from different file
Autofilter with VBA for Catalog?
Chart dimensions and mouse xy
Userform control
Re: poping up a box with choices?
overworking code, infinite running
Using VSTools for Addin-Programming
Auto filling a select # of rows
Difficult macro to calculate and format data
Re: If AskToUpdateLink = False
debug -
Returning Cell Refrences/range Refrences
Automatically substituting missing data
delete dupes in column
Table Data on Chart.
UserForm Change Of Height
Set Focus
Root of Sum
How to disable VIEW CODE in the tab of a workbook
Question on Input Boxes and Auto-Filter
Date field conversion
Cell is a Member of a range or Not
Force Enable Macros
Re: Error : Invalid Data
Sensitivity Analysis
Replace data with new data
Using "Atan" in VBA
Using Access forms as menu system in Excel
Combobox source
Import data from mysql
Excel VBA - Userform Texbox/Scrollbar problem
Can open a worksheet but cannot edit or save
Excel VBA - Userform combox problem
excel vba - userform list source in other workbook
person's height format
Code execution skips Application.Run statement
Data Grouping when Worksheets Protected
FormulaArray with existing cell
Time Calculation
Trying to Sort and Subtotal with Vbscript in Excel
Auto date or comment entry
Macros go slower than a turtle in mud
Application.wait & Blinking Connector
Select delimiter in .txt creation
Reciprocal range?
Combo Box help!
Tabstrip control
usedrange doesn't show the right value
Can any body help?
SaveAs problems
password protection
Would an Add-in work?
How do I add a File Open box to this script???
Identifying duplicates/unique values
removing early duplicates
data info on a form
Type Mismatch
Hiding macros
Dynamic Listing
0 stock
Can the screen resolution be changed within VBA?
Hiding A Sheet Command Button With VBA
Delete Duplicate Rows, Summing the Qty
Import data from mysql on a web server
Hyperlink help for a Newbie
Variant Array with String Values - Type Mismatch
Displaying the column letter
Number Formatting with string variables
Sum Crossreference
Match Code
Code Modification
Word Art Object properties in VBA
Copy and Paste
Merging two workbooks
Selecting and pasting to an empty cell
Programmatically Adding Controls (Macro) eg Button on A SpreadSheet
HTML and realtime webservices used with Excel
Excel VBA - Multi sheet filtering/querying(?) & combo box woes
Visible Sheet Showing When Hidden
EnableSelection = xlUnlockedCells
some repetitive job need vba HELP!!
Aspect ratio of a Comment image
VBA: count sevens
Copying rows
Type mismatch error
Copying Formula In Rows With Increment...
Sorting after ShowDataForm
Call procedures from a procedure
Application FaceID?
Text Boxes in a User Form
Frank Kabel (Automate macro)
How to ID the value of a character in a string
How to remove textbox with copy a sheet to a file
Auto showing a text
Converting Text box
The last nail...
Is there a way to use keyboard "enter" or "tab" to leave a combobox?
OpenTextFile Method fails
Excel Buttons Disappear
Outlook opening Excel?
The BACKGROUND COLOR OF THE COMMAND BUTTON FACES RESET TO THE DEFAULT COLOR
Macro
Cannot manually add items to an Excel Form ListBox control
About Average and Stdev code in VBA-waiting for your help online.
Grading Help
Can you Modify the preset stock query
European/American Date Problem
code for cell change not working
Auto shading. Is it possible
adding scroll bar to a chart
numbers in a chart
barcode printing
Call and Empty Cells
"Blank" cell is not blank
looping thru sheets for printing.
Excel Setting problem ? ? ?
RE: Code Modification
RE: Code Modification
Using FreezePanes property in VB 6.0
Bill Gates speaks about Real Life
RefEdit
How do i format a text box in excel user form
textbox
Drawing graphics in a worksheet - returning the mouse position.
Is it Easy ?
Auto Backup
ActiveX component can't create an object
Counting number of blank cells until value found in cell
Convert column letter to numbers
Changing static code to dynamic
Update Foxpro (DB4) File
System-wide macro program
Tiny URL
Runing Access Module Code From Excel
edit cell under conditions
Lock cell after data entry - Is it possible?
Reduce excel to small size on screen at startup - How
Is there any Excel marco can get key input while the marco is running?
problem about microsoft office web components in VBA (Excel)
Creating Excel file from VB
Ideas into Practice
Fetching value for other workbook
Automate macro revisited (Frank & Co)
WorksheetFunction.Forecast how to use it
Date Functions
check if the contents of a cell is a time?
How to use Graphics/Objects in a formula
Excel modifying files when opening
auto updating a pivotchart?
Windows.Activate question
Microsoft Query prompt
Pivot table and VBA
Find record starting with ... macro
Functions to return 2 values
Flagging and Displaying Data
Getting the RGB color of a chart line
Help me Dr TOM...
Back to the brick wall!!
Tom Ogilvy Help Me...
Help with Clipboard Error
Help with Clipboard Error
Excel crash when start up from a workbook
Controlling "control buttons"
Copying data based on cell value
open files with knowed names
Proper Case
runtime error
Update links function
VBA bewbie need help
Code to Arrange Remaining Windows after Closing One?
more than one IF statement for a cell?
Multi Column List Box ???
Can you access a system variable from a excel spreadsheet
Can VB count the number of lines in a text file . . . .
Copy Add-In Worksheet to Client Worksheet EXCLUDING VBA Code
Calendar Control Incompatibility
Newbie question....
Dialog Box Macro
You r a god
Linking an Access table/query to Excel.
Macro or Visual Basic for Reformatting Data
24 hour conversion?
Counting Macro, adding a less then statement
setting OnAction macro names for form controls from a VBA macro
Question on overall approach to an Excel macro
help: removing duplicative items in listbox
Please recommend a method
Visible Cells
Re: Case Statement for corresponding columns
ActiveSheet.Paste error in Excel 2003
Re: Case Statement for corresponding columns
Chart element dimensions!
Chart Macro
Progress Bar Strategy
Running a routine upon opening the file
Filtered Data Validation list (maybe VBA)
Re: Tools/Reference dialog
Worksheet Change Event problem
Question for Tom O
One last thing
removing hyperlinks
Delete Empty rows ....Except when
Check interior colorindex of a cell - with a twist
Excel Hang
Newbie - Macro Help
Why Creating object failed even I set a reference to this object?
Store Value to use later in the code
Excel column width in XML
Storring global data in Excel
Paste Values Macro
Making Cells Balance??
Refresh Formula Cells
Turn off Autocalculate in VBE/VBScript
validations list
CountIf in VBA
Trouble searching a Word document from Excel
Saving large text field in a cell; making it pop-up
replace characters by numbers
Macro to change tab name to date from a cell ref
Breakpoint will not stop Excel function
Re: Breakpoint will not stop Excel function
Updating vb.6 to vb.net
Re: Populating a dropdown list with an Array
formula help
Creating a button and assigning macro
Pressing Enter on Control to Refresh
Copying Data to another sheet
conditional removal of last chr of string?
Moving around on a userform
added functionality
Return Cell(row_pos, col_pos)
Creating a Copy worksheet error when renaming it
Go back to previously viewing worksheet using macro
Multiple 'Connector' Overlapping
Display Number of Additional Open Excel Windows in a Cell
Excel Macro Difference Between Mac and PC
Clear Cells
binding spreadsheet columns to form text boxes.
Does anyone use Excel 2000? Please help me!
alias for workbook
Questions about formating....
Using msoutl.olb
late binding in VBA
Can we change the colour of the freeze panes,by default its black
help w/ find me
Code efficiency & Adding a row.
Use na() function in code?
active sheet
RE: Value Of Macro
Need Help adding a TextBox thru VBA
Challenging Question - to find 3 points radius and centre
Command button to go back to a sheet
Converting text to values
Copy/move several Worksheets
Delete a large number of Names from a workbook
Copy to another workbook
Excel VBA - Linking 2 Combo Boxes
Continue after Compile-error in other workbook
autoupdating a pivottable (but only when theres enough data to make the table)
pivotchart probs - losing graph colours and how to remove "place series fields here"
long proccess
2nd Excel Instanation
File Open problem in Excel 2000
Macro: Finding matching and updating output data
Make code available as a function
URGENT HELP
Web sites to get currency exchange rates & upload it automatically
IF function for transferring info between worksheets
How to download a HTML table from a Web site into Excel
Excel VB to send selected range as html email attachment
AutoSum Syntax
Show Detail of Pivot Table
Look data in another sheet
help with formula/program?
Populate ListBox from filtered list
Save a file without Macro in it
Replace in sheet vs workbook
OLE and powerpoint
Combo Box Listfillrange
Help with simple code
Just email file
Analysis Tookpak usage in script
How can I "empty" an Array(1 to 500, 1 To 6)
Re: hiding rows and column headers
How to edit content in a textbox
Do not select sheet and clear contents of copied cells
How to contact Microsoft about article in MSKB
Working with ADO Recordsets.
Dates Calc
Help with This code!!!
Passing variable back up to Main Sub
Desperatly need help - customised forms
Making Textbox act like a cell???
opening multiple files
Real world Excel examples.
Close all commandbars except one
how to consume webservice xml in Excel 2000?
Starting up a dialogue box
button
column number of non-selected cells
RE: Adding 4 business days to a specified date
Help required for Inefficient nested loop
Controlling Excel from another application
Insert row macro
Compile error with Unload frmSelectSupplier
Re: Sum programmatically
Deleting Rows
Paste Special and Transpose range
Various conditions met - Count
=OPEN("Records",,,,"password")
Importing SQL tables dynamically into Excel
MSNStockQuotes add-in
Code Help????
Deleting rows based on cell is empty
Data Validation in VBA
Protect the Sheet Name
Aligning data within Excel
Array limit
Dget Function
Copy Paste Values
Delete row IF left character is in list
Excel Save Time
Freeform object: snaps to grid
Write to text file
Re: Get Worksheet Name RunTime
Access Pivottable wizard with Access VBA
Excel/Word VBA
Prevent update links
Insert Row, Copy Format/Formulas
Excel C++ Automation Add-In UDF returning VT_ERROR variant
Match Code
Sharing A Workbook
Running a macro in PowerPoint via Excel?
clear and remove all ranges and names
Userform Textbox Shortcut Menu
Creating Print ( )
Open Save As Dialog in Code
How to wait and check for user input?
command to clear the Intermediate Window ?
Out of memory message
Get rid of controltiptext in Treeview
Determine Users Login ID & set cell value based on a changed cell
RE: Get Worksheet Name RunTime
code dosen't work
DDE command reference
Enable file -> properties in protected workbook
Set Value of Cell from function
See if cell is in a range
Grade Help
Basic syntax ?
Time Keep in excel sheet
Importing text file into worksheet
Convert betwen two cells
Please help need to Close(visible=false) All Command bars except Standard
Using Formulas in VBA Macro
Extended HTML tags for use in Excel 2000
Custom Programming
Service Pack 3 for MS Office XP
Delete matching value along with other cells
finding the last row in a worksheet
Encryption in VBA
Finding Blank Cells in a worksheet
storing account numbers
Opening excel files from EXcel-VBA macro
Office SP3
Passing keystrokes
User Defined Functions
Copy sheets error 1004 with some regional settings
Error with Application.ReplaceFormat.NumberFormat
Validation & control mayhem
Export chart to gif without border gives a white line under and right on gif
VBA: Input Boxes
Error Handling
skip popup window
Method failure as a symptom of a wrong reference?
Excel VBA code for MS Query
Hiding unused cells
Check a file exists?
how to add a togglebutton to commandbar
Sorting over Outlines
Dynamically set print area
Excel 2003
UsedRange
hyperlink bookmarking?
Summary
opening file causes Excel crash or hangs machine
Statistics
Building dynamic variable names
Adding documention to a user defined function
Edit cell and activate userForm
Getting position of datapoint in stacked column chart
GetSaveAsFilename
Visual Basic Code
Closing an inactive workbook
Error handler kiks in every time.
Excel VBA - delay function?
'Can not shift objects off sheet' error
OptionButton - how to determine state
Saving from a template
How do I prevent my Template from being over-written?
MAC address formatting
Match and Delete
Do Loop
Macro delete rows
Textbox property change via code - help required
Error in loading DLL
VBA Toolbox opens in Excel
Bizarre Excel error
Using Filter, but with additional criteria
Open a VBA file from a Macro
loop through range to print
Visual Basic Question
Code to reformat pivot chart
How do I set print area dynemically
Re: Autosize a comment
RE: Visual Basic Code
Code for addition
Set Variable Equal to Specific Sheet
Assign a name to worksheet tabs by code
obtaining values from a web page
Delete certain rows
RE: Visual Basic Code
Changing Row when Cell Changes
RE: OptionButton - how to determine state
naming problem
Checkboxes
Find method
Paste link from a file with more than 250 columns
VB script to count files in a directory
Excel 2000 Solver AddIn: Model Load & Reset Have Excessive Delay
Re: Sum programmatically
Re: Naming Tabs
Create new row and copy
What is a UDF and how do you use them. .
Re: Controlling the font of a comment
Dynamic Ranges
Multiple copy cells downwards
Save as macro
Error in Loading DLL - repost
Checkboxes
MSQuery or New Database Query dialog via VBA
Microsoft Rich TextBox Control
RE: Strange Treeview error
Mass Emailing from Excel Through Outlook w/vba
Looping
How do I cahnge this code to give a drill through on the same sheet but just next to the current cell
If white, add 1 to total!
If white, add 1 to total!
Can't Refresh PivotTable
Nested Arrays - I think
XP Macros not compatible with all platforms
Please help with SQL Query Question using EXCEL & VBA
Re: Excel Crashing
VBA to work with existing IE window/url
Group of Excel Pages
Prgrammatically save a file to a specific folder on a network drive
Return row # and Column # of a name reference?
Using CountIf based on AND criteria from two columns
Toggle
Macros in Excel97/2000
macro to adjust files in directory....
locate a value from file1 in file2
Multiple Conditions problem
Need VBA-code with a custom userform using the find method with both findnext and findprevious
Automatically retrieving estimates
VBA Code
Change Date to Just Month
Microsoft Masked edit control
CountIf where criteria is Less Than...
Private Sub Workbook_Open()
Currency formulas in Excel
I'd like to create a MAXIF function
excel to ps to pdf...
Need someone to look at my code and expain
Place Name of Sheet in Variable for Use
Pivot Tables
How to generate characters in code?
activeX combo on worksheet GPF with Keydown event
Stopping calc of a pivot table during build
Newbie: simple combo box
Buttons
new challenge for all the gurus?
how to retrieve list of users sharing a workbook
open multiple spreadsheets with a password
Controls disappear in Excel 2003
copy cell name
Bogus combo change events
PartNumbers compare and re-list
Choosing an access table with VBA code
Load Add-in's Without Using Add-in Manager
Cell Comparison giving a result
How to read keyboard buffer while macro is endless looping. Please see sample below.
deleteing charts using "wildcard"
Currency formulas used in Excel
Import .txt files
conting pork
Newbie - IF / THEN and Conditional Formatting Help
Help with email macro
Toggle hide macro
Save As Webpage
TRIM leading zero in strings
conditional summing and deleting
help on linking different worksheets into one
copy info to another sheet with out amending it
how to get the Range dimension?
Response to my toggle hide question
My toggle hide question