Microsoft Excel Programming

Instances of Excel don't release
Instances of Excel don't release
Instances of Excel don't release
Send Access Data to Excel - Please ignore my other post. Newsreader went berserk
MapPoint Question
Error 430, Class does not support Automation, Windows 2000 sp4.
Excel table macro
moving to cell Y if cell X has value Z.
Re: Count number of prints.
Strange thing with this formula written by VBA
Upcoming Support Webcasts
Problems generating an html link based on worksheet values
Problems generating an html link based on worksheet values - SOLN
xlfCaller
Chart Date Label Problem - Is this a bug in Excel?
Re: I need to determine a cell range based on a blank cell
Linking To Excel Graphs
Prompt
Re: Count number of prints.
[Excel XP] Orientation of cells etc.
Question: OPEN return status
Question: Macro overloading, passing variable number of arguments
Question: Cell formula or macro to write result of one cell to another cell
Re: Excel: Deleting Macros and Functions
Time based macro
Re: Excel Add-in path in UNC format
Re: User defined functions - text for formula palette
Add PivotItems to PivotTable / Enabling - Disabling PivotItems
Re: Combobox Click event triggered when copying worksheet
Re: Extracting Access data
Re: Before Send
Can we write VBA code to set all column/row's size back to default size?
Re: Accessing the VBA project object model
adding changing number of days
Re: Why compile the VBA code?
Ah, I think...
LoadPicture Pathname or no Pathname
Re: Iterating through row cells on column Match, help please.
Ah, I think...
Re: Screen is flashing when VBA adding objects into Excel sheet?
Before Send
Re: Ah, I think...
Re: declare a two dimenssion array
Re: Associating one array with another
Re: Ah, I think...
Re: Opening an AutoExecute Macro Workbook from an AutoExecute Macro Workbook
GetSaveAsFilename method
Re: Cell contents changing colors
Re: Mouse
Excel Addins
Auto Fill Program needed to get maps from internet onto excel
Re: Check mark boxes in Excel 2002
Re: dates in userforms
Re: Why my data not saved ?
Re: Can we write VBA code to set all column/row's size back to default size?
Simulating the Format Painter, Selection.Select, and taking focus
Lotus 1-2-3 macro
Re: Com addins
Delete without losing references?
Re: dates in userforms
Hidden sheets becoming visible after saving from Browser
Excel is very slow to load/save the spreadsheet
Eliminating rows of data in excel spreadsheet that have blank cell in row A and data in row B - E
Sorting ListBox results or transposing ListBox values to other cells for sorting
For Next Looping (custom variables)
Excel ADO Connectstring parameters
Device I/O Error
Undo, Redo, Repeat and Validation
DateDiff problem
Sizing windows automatically
Re: Deactive Copy and Paste
Re: Inputbox method using type:=8 - How to Cancel?
Digital Certificate creation error using makecert
Deactive Copy and Paste
automatic updating cell
formatting in macro works on one computer
Re: Exporting Data.....
SUMIF function
Re: Macro Using Named Cell
Unprotect method run-time error
executing code when a module opens
Re: Macro Using Named Cell
Can I have a loop to open a set of workbooks get some data, close it one a time.
Detect if file is open
Getting the full path when from a File Open Dialog Box
Re: Excel VB and Lotus Notes Address Book
Use one column to identify values in adjacent column.
Re: .Visible Property
Name of workbook
Macros
Re: Single Sheet - Calculate Manually
mortgage amortization
Re: Inputbox method using type:=8 - How to Cancel?
C Add-In clashes with VBA?
Re: really dumb find question
Certain methods do not work
Datedif, Workday etc.
cannot open and can not delete files
Re: Single Sheet - Calculate Manually
date conversion from m/d/yyyy to yyyymmdd
subtract time from now()
Copy and Paste lost
RE: Automate differente excel versions + VBA protection
Re: Save As Dialog
Row to column data move base on row
Re: Running sheet from another sheet ... and back
ugh! Match/Index problem
An ODBC question
Default excel Template
Re: system variable representing subroutine name?
Re: Copy and Paste Lost
Re: Why doesn't "Workbook.Range("myrange").value" work?
Problems executing Excel VBA code in Microsoft Office 2003
Concatenate Text to create Formula
SQL with no headers
Looping through Text boxes
How to run VBA macro when the workbook is open?
Re: More efficient code
Re: Setting up a date and time stamp in a cell
Re: Formula for autodating
Cannot insert Activex boxes
Re: CSV Format in non-English OS
Sorting Odd & Even Numbers In Excel
Re: Time based macro
Re: Serial I/O
Re: AutoFilter Dropdown Boxes Missing
Re: AutoFilter Dropdown Boxes Missing
Clock Timer/ Date Function
Re: How to make a running XL app the active desktop window using VBAcode.
String operations in VBA for "Substituite"?
Active X Control
macro selecting datalabel
grid lines covered up
Re: Passing a Password to a VBA Procedure
inexperienced header entry automation resizing/scaling issue(s)
Re: Mods to macro
Re: calling word
Re: Copying a Excel Chart into Word
Re: Protecting a VBA project
Re : MS Excel’s Offset Property
Re: Protecting a VBA project
32,767 Significant Digits of Precision, with Number Formatting
Save As Dialog
Defining Ranges
Conditional Formatting
Select Range problem
Re: How to become an excel MVP?
Hide all toolbars auto_open
Time active Macro
dialogboxes
Re: Excel2000 VB Help Problem!
Variables in command lines
Can these codes be summarized?
Displaying progress on UserForm
Mass update in Excel based on values in different sheets
Subtotaling items from a list
halting macro
halting macro
Code for moving textbox
Reading a named range
"Less than or equal to" symbol in a UserForm
Saving Excel to web site
A save question:
Multipage
RollOver buttons in UserForms (A solution)
Showing Excel Sheet in IE
Excel+Not Enough Memory..
run-time error 1004
Re: excel symbols
Re: Opening text files using macro
Re: CountIf
Tracing into a Function
excel symbols
Opening Excel 2002 VBA Editor
Detecting Worksheet change
easy way to test if a Named Range exists
Moving Text Boxes
compatability isssue
Maintaining row position in a loop
Error Reports
Re: macro to send an email from excel
Re: Find functions
help with *.xlw file please!
Auto numbering
Re: Formula or code
Removing Lines Identified by Autofilter
Re: DDE Command to Format Cell
ADO connection not always enabled
Re: compatibility issues foreign versions
Re: VPageBreaks in excel.
vba tutoial
Average/Sumproduct Array
Using Microsoft query through Excel
VBA code for Excel 2000, IF procedures and listboxes
Need Before_Save code
The expanding XLS spreadsheet
Open another Office app from Excel
Formula or code
Parsing Data From HTML Source into Excel using VBA
Re: Formula on cells
moving macros to disc.
list of accounts
VBA Code to FIND
MsgBox
list box
print current sheet
Re: Substitute comma in csv file
excel 2000 - manipulate two applications
Re: CountIf
Re: Still trying to move a text box
Re: Excel 2002 RTD - GetNewValues and RestartServers
How to code event for dynamically generated checkboxes
formula returns formula
Help: Copying Visible Cells only to Visible cells!
JScript to move Excel Worksheet
Calling HTML Source code from within VBA for Excel
Re: Auto numbering
Fill Color? Background Color?
Making VB PasteSpecial method to work the same as Excels Application
output of associated arrays
check if worksheet exists
adding uniform footers
scan for repeating values and then delete
Macro Prompt
Pausing code execution
Delete Rows with letter #VALUE in cell J
Re: How to apply a function across a range of cells
Deployment question
Re: Workbooks.Open fails after upgrade to XL2000 from XL97
Re: How to disable 'Update alert' when open a spreadsheet has link to other XLS
m/d/yyyy h:mm date conversion to yyyymmdd ???
variables for file names
How to disable 'Update alert' when open a spreadsheet has link to other XLS
Calling the Solver via a subroutine
Chart automation problems!
Where can I find other arguments & desc to the Workbooks.open("myfile.xls") cmd?
Re: DDE Command to Format Cell
Automation Procedure with Worksheet_Activate
How to disable 'Update alert' when open a spreadsheet has link to other XLS
customize a calculated field in a Pivot table
Re: Inputbox method using type:=8 - How to Cancel?
Extracting text
Can this be done?
update and store new high values
Protecting a worksheet from veiwing but not from importing in data
Re: Simple Question
Re: Opening CSV files and #NAME? error in certain cells
Eliminating Prompts
Comma in TextBox Problem (Spanish)
Unknown where is the problem on the Runtime error - Automation error
How to get the position of a cell in Excel named range?
Re: How to get the position of a cell in Excel named range?
Re: Question about toolbars ...
Automated copying & pasting from multiple sources
Re: copying duplicate entries
Re: Simple Question
Re: UDF Array function
Re: On opening an excel file
recalc question
Writing multilines to a text file without closing
Text Format
How to get data from Access Database in Intranet
Can these codes be summarized?
Find paragraphs in word and export to Excel
Can you identify the maximum value in an array?
Importing a sheet?
A peculiar problem
Compile error ...
Averages
listbox
Re: How to get the position of a cell in Excel named range?
Modifying the cell dependies
programming a link
Using the same variable in separate userform modules
Re: A peculiar problem
Programming links
Change font to red and bold
Page breaks in Sheet for copy via OLE?
File Copy Routine
Re: Pivot Tables not using all memory
can i send an email or warning from excel
Connectiong to an Excel Workbook with MSDASQL provider
Importing from SQL changes date format
Unprotect Worksheet
PageSetup slow
to modify cells from a function
updating Access table with Excel data
Printing .pdf from within Excel
combining sumproduct and average
help with sql in excel
Custom Calculations in Subtotal
Validation ?
MATCH, LOOKUP, or ???
Linking to other VB apps
problem with tables in excel
Procedure Too Large problems
Re: Hidden Worksheet Error
UpdateLink Method
Re: Linking to other VB apps
Dialogsheets
Simple conditional formula
Can't open a file
Getting rid of Outlook warnings from excel macro
xlDialogSendMail
Re: how to define target frame names for the hyperlinks in Excel
Re: Cond form formula
Does MS Query have an object model
Re: Cond form formula
ChangeLink xlExcelLinks
Counta anomaly
Restrict Find to one column
Worksheet Button Callbacks
Excel Macro Strings
Application.Run question
ISERROR formula in VBA not working for me
Re: List the Macros that can be executed from Tools-Macros
Re: Switching to other apps while running macros in excel 97
Cell Formatting
concatenation of cells
Find File and Open
lookup lastmonth
Unusual Operation of a User Defined Function
Populating Textbox in UserForm
Populating Pageheaders Using Vertical Lookups
Import VBA Code
Re: Looping through each directory
rate formula
Excel Add-in
Re: Excel / VBA
Setting Font properties in Code clears Undo list
Re: Looping through each directory
Excel-VBA and FlexLM
Re: Hiding Links
Re: Hiding Links
What's this? (Application.Run)
Common Dialog Box
Macro Emailing Challenging Problem
Re: "Substr" command in Query
Re: Problem importing using MS Query
prevent second copy from opening
Appending/Updating records
Re: prevent second copy from opening
Re: Closing Excel Completely
Re: SaveAs "subscript out of range" error (COM -> SOAP)
Re: Closing Excel Completely
Re: Closing Excel Completely
Re: Consolidating multiple files using a row column range
Newbie question about iteration technique?
Trend function in VB
Link Excel range to PowerPoint Application text box
How to set global constants and get path of spreadsh ?
optionbuttons
Closing Excel Completely
Adding a category to the Function Wizard
Email one page of information on the same sheet
Please somebody help me...
Re: combining sumproduct and average
Object doesn't support this property or method
MOD function
Re: WScript object not found (???)
Put a timer on a MsgBox?
Hide Slide Bar?
Distributing code
Preventing Duplicates using VBA (code)
Listing files in directories.
Activiating and Selecting Excel Cells in VB.NET
Re: Help coding userform
Creating a drop down window
O.T. Copy Protection
Re: Search Methods
Re: Opened File
programming outlook 2000 from excel
Re: Opened File
Handout of Excel Object's Properties and Methods
Re: Expiry Date for further updates into Sheet
Re: Excel / VBA
Re: SaveAs "subscript out of range" error (COM -> SOAP)
Need HELP to modify code (need more automation)
Macro to rename all worksheets with cell value in each sheet
Excel data to Access
Open Searched File
Re: Macro to list all Formulas in WB?
Re: VBA button click need help. Need LEN help.
Re: VBA button click need help. Need LEN help.
Re: Code to display dialog for unhiding sheets
Code to display dialog for unhiding sheets
Re: Looping through each directory
Data Box
Help with If Not Intersect
VB question...
Header - only on first page
macro for e-mailing excel file using outlook
Is there a "cell change" event?
Re: sort for variables
OLE Excel data handling from VB
Email question
Re: Unicode StrConv/Substitute routine...
Re: Formula help please
Formula help please
Mismatch!?
Logitech's newest mouse scroll fails in VBE code pane
Re: Detect more info when workbook does not ack right.
Re: Formula help please
preserving type library references when distributing macros
mortgage amortization formula
Re: Help with sheet protection
contouring
re-enable macros
CopyFolder
webbrowser control tab navigation
Excel / VBA
enormous file size - VLOOKUP function?
Re: Using Excel to change colours of bars in PPT charts
Using VBA, subtotal a column only if there is more than one qualifier
sendkeys
Code for Page Footer Font Size
Directory checking
Date bug
Re: Finding the last row of chart....
Help understanding the following VBA code......
Re: Referencing Named Range in Other Sheet
Check for duplicate entries
Upper & Lowercase
Getting the coordinates/ size of a bar chart element
Listbox lists
Making Hyperlinks Unavailable
Automating printing to PDF
printing comments
Get External Data, Import Text File, File name problem
Re: Repeat Action
Userform with template class module problem
comments
Re: Using a variable with .LookIn
setting ctl to array of checkboxes yields type mismatch error.
Recreating the Windows file tree.....
Animated clips
Re: Re enable events
Re: "Can't Show Modally" - Run-Time Error '400' Problem
msgbox prompt when user selects data from combo box
can not open and can not delete excel files
Re: creating a commandbarbutton with a custom bitmap
unticking option buttons
Stop Problem
UDF, Type it or use Insert Function
Thanks - creating a commandbarbutton with a custom bitmap
Re: Windows
Reply to Tom
Protection UserInterfaceOnly reading Hidden Formulas
Landscape print with Letter paging
Menubars
Cell data format in an e-mail
lock one cell when data in another
retrieve data from SQL server and populate excel sheet
SaveAs method
Excell HTML Conversion Needs Refresh to Correct Format
Pivottable date parameters ...
viewing VBA behind existing pivot table
Close Browser window with VBA
Re: vba
Can MS EXCEL remove duplicates and separate by color coded items ?
Re: UK Tax NI and Payslip checker
Keeping macros neat
How do I find which cell called a function?
passing data from one sheet to another
Re: Using Named Cell References that aren't present yet.
Re: Sorting a 2-dimensional array
Re: Determine maximum length of a page
Re: oRange.Interior.Color
Controlling two different printer trays
DATEDIF
column header click
Randomize the order of the contents of an array
Re: Small programming task in Excel VBA
help whit hyperlink
opening webpage in excel
Re: Small programming task in Excel VBA
Direct manipulation of TextBox
any site for examples or direct help about userform
Selecting Cells
Re: Newbie Seeks VLOOKUP help
Re: Round error on home comp
HELP sending email from Excel
Help with some sheet code
Setting up a Month Array
Re: Help with copying please.
Image Variable
vba date XL2000
Checking Military Dates
Don Selecting cells
Re: count pagenumbers?
Reply to Tom
help with VBA code re comparing cells and generating message with detailed info
Re: Need help with decimal places
Adding leading zeros to a calculated value
Excel cannot save my digital signature
Re: compiling multple worksheets
Conditional Summing Cell Range
Re: run Excel on schedule
Splitting data in a cell
Re: Create help for user-defined function
As Addins load question
Re: Listbox lists
Controlling Font Name in a personnal Commandbar
Behaviour of "Replace"
lock-out rows from scrolling
Code to Email with UNC in subject line
Re: VBA & Solver Memory Usage
Summing cells based on run-time criteria
How to copy rows using fontcolor as bookmark?
Need VBA Routine
Maybe an array ?
Re: logging excel events?
Slight adjustment needed for Macro
Re: Excel 2003: XML Validation upon editing ?
Re: creating a chart in a form
How do I Clean up this formula?
Re: Sorting Odds & Evens
determine page number in Word document
Re: capture shift-double-click
Macro to send mail to email id mentioned in a particular column
Offset Formula
Re: Expiry Date for further updates into Sheet
cannot close workbook
Re: Add new sheet and Name it
SelectionChange code always available
Re: How to open another Excel spreadsheet to copy data into current spreadsheet ?
using excel 5 dialogsheet in excel 2000
Copy worksheet from multiple files in one DIR to another DIR & rename
Re: Sorting Odds & Evens
Re: Why doesn't this function return TRUE?
Problem using XNPV from VBA
Problem using XNPV from VBA
copying blank cell
functions
How to import more than one text file into Excel ?
worksheet_change vs. calculate, and worksheet_change not running
Re: Email using universal naming convention
Re: worksheet_change vs. calculate, and worksheet_change not running
Re: access 97 to excel 97: execute macro automation
Re: VBA Hyperlink Question
PrintForm Problem!!
Macro To Update Data Table On DDE Link Change
sorting
Object required confusion
Re: COUNTIF FORMULA
Re: Sorting Odds & Evens
Recalculating Cells error (and more)
Re: add separator bar to right-click menu
Error Msg: 'No Cells were found'
FileSystemObject to get last 10 lines of text file.
Conditional formatting
Nested Find problem
Copying an array variable to a sheet
Placing an array on the active sheet
Calculation for Dates
Selective protection of charts: permit only BeforeDoubleClick ?
ARRAYS
Error Msg: Permission to use object denied
User-Defined function not working
Re: access 97 to excel 97: execute macro automation
Header problem!
Delete characters in cell
Declaring Global Variables
Combo Box causes system resources error
Dates and Arrays Driving Me Nuts - Help!!!
Re: Combo Box causes system resources error
check if range containing values
VBA Project Security
Re: Checking the result of a formula
Checking the result of a formula
ChangeLink command
sql results in excel
Deleting multiple columns slowdown
Re: Checking the result of a formula
Menu toolbars
How to get the PivotCell object??
Re: Disable Menu and command buttons
macros for other applications
Re: Create Command Button from Code
Excl 97
Dynamic Row Selection
A problem to solve, a little help
Mandatory Cells
Re: saving macros to a common folder for all users
Turning off System Messages
Re: Multiple IFs
saving macros to a common folder for all users
Finding first Null value in range?
How to check if the Excel VBE is opened within Excel?
see the full comment on a cell
Move a "picture" object
Re: Macro for Pivot Table - Apply to multiple workbooks
VB Project
Hidden Command Buttons
Multiple IFs
Cell properties
saving excel table as text file
Adding figures in excel if text is a certain colour
Bugs using combobox 2-fmstyledropdownlist
Running a macro from a desktop icon shortcut
Adapt an array routine or a better way?
Clearing a merged cell
HELP - Communicating between C++ and VBA
Disable Worksheet change event
Lot Of Code
Lists and masks
Help with Inputbox Function
Lookup table in addin
Worksheet/workbook protection property?
Size and location of chart
Using a variable as a row reference?
User-Defined Function Unusual Operation, Again
Re: Can't set manual HPageBreaks
Re: Convert Excel to text
formating a cell with a conditional if statement
Re: can i insert a picture
Help Evaluating Cell Values and Changing Colors
Re: SetLinkOnData help?
Find First and Last Row Number in Column
String length of Inputbox user input.
Deleting a file using VB
Re: Active Cell plus number of Rows
Re: Active Cell plus number of Rows
How to print Worddocuments with Excel VBA
Custom defined formula
User Input File Name
how to declare a class module
Re: Application.ScreenUpdating = False
Excel Addin with drop-down menu
Invisible Range Names
Hide command button on worksheet
Histogram parameters VBA
sort multi-dimensional array on numeric data?
Automatically Generate a unique file name...
Picture in Web Page (saving to disk)
Re: user form controls
Declaring Dynamic Multi-dimensional Array
User Interface
Re: Excel changes file modified date when opening my add-in
Row Number
Simple problem refering to variable in For ... Next loop ...
Detecting Calculation State
Re: Display on cell
Manipulating a spreadsheet opened in IE using VBA
Re: Setting zoom for all worksheet pages
Setting zoom for all worksheet pages
Strange problem - extremely slow application.
VBA Advise
Blank Rows at end of Worksheet
Data validation with the Select Case statement
problem with user form
need help with simple syntax error
Row Deletion Using Text Trigger?
Re: Accessing the Desktop
Time Stamp
Macro Error
Value is not displayed on the screen
Re: Accessing the Desktop
Copy Method of Workseet Class Failed
Translating spreadsheet formula to VBA
Automated Print in Macro?
Is something wrong with the code
Re: Automated Print in Macro?
COUNTIF criteria
sql results in excel
Question: Range().Select for more than one row?
Modeless form for user interaction
Custom checkbox
Dropwdowns not working in Excel XP
Right function disappeared
Re: Registry
OnAction
Re: changing setting of tool box
Copy range of many files in directory.
Re: Auto Path in Footer
Re: Automatically incrementing invoice number from template?
Auto Path in Footer
Delete row and Excel locks up
Re: Setting zoom for all worksheet pages
IF then formula
Data Validation
Can't terminate the excel instance from VB
Pivot table
Event macro
Count # of Times Sub Executes
Filtering on Formulas (makes messy sheets)
Outline and hide feature
different places to put excel code?
Replace in VBA Excel
Zero records in Filter
Control Bar
Re: Registry
Re: Can't set manual HPageBreaks
Re: Need Macro to Copy Visible Cells to New Sheet
Re: Need Macro to Copy Visible Cells to New Sheet
VBA Code for Links to Excel workbooks
Code for Links from Excel to Access
vb simple formula
Re: How to tell whether a cell contains a formula?
Naming Chart
Extracting PDF report into Excel
Re: How to tell whether a cell contains a formula?
Excel on a Form
resetting worksheet properties
Events for cell deletion
VBA for Dialog Box
Re: Naming Chart
List box initialization
Re: window minimize
Re: List box initialization
Code for existing links
Events for workbook close
CUT And PASTE
Re: Frustrated with Factorials
Unable to set the Locked Property of the Range Class
Displaying Last Editor's Name
Get.document(50)
Re: The Find Method
Making menu item changes temporary
Code Text Into Chart Lines?
Open Microsoft Word and get Page count.
Re: An Excel environment started from a VB script .vbs file.
Load Vb Functions
Can't find project
Event - RaiseEvents Within Class Modules
Link code
Format text
MultiPage UserForm
Re: shape grouping text
Re: retreiving number of e-mails from public folder in Outlook
Having problem getting date into format: yyyy/mm/dd
Changing PivotCache SQL Database
Page Header with Fit to 1 page wide
Modify Find Code
Re: Email using universal naming convention
Locked/Protect in Workbook_open not working in X2002
Changing font color based on the values
excel.exe error with query
out of memory error
Print Landscape AND Portrait Orientation in ONE Worksheet
VBA Question
5.6 Scripting
Re: Print Landscape AND Portrait Orientation in ONE Worksheet
Camera_Toy_Videogame_Laptop_sale
Location of Help File and SQLDMO
VB code for printing one page at a time
Re : Excel event handler Worksheet_SelectionChange
Returning single/multiple values from array function
Old button code not working in Excel2002
Importing data from the web