Excel Programming [Archive] - Page 175

Appending/Updating records
prevent second copy from opening
Re: Problem importing using MS Query
Re: "Substr" command in Query
Macro Emailing Challenging Problem
Common Dialog Box
What's this? (Application.Run)
Re: Hiding Links
Re: Hiding Links
Excel-VBA and FlexLM
Re: Looping through each directory
Setting Font properties in Code clears Undo list
Re: Excel / VBA
Excel Add-in
rate formula
Re: Looping through each directory
Import VBA Code
Populating Pageheaders Using Vertical Lookups
Populating Textbox in UserForm
Unusual Operation of a User Defined Function
lookup lastmonth
Find File and Open
concatenation of cells
Cell Formatting
Re: Switching to other apps while running macros in excel 97
Re: List the Macros that can be executed from Tools-Macros
ISERROR formula in VBA not working for me
Application.Run question
Excel Macro Strings
Worksheet Button Callbacks
Restrict Find to one column
Counta anomaly
ChangeLink xlExcelLinks
Re: Cond form formula
Does MS Query have an object model
Re: Cond form formula
Re: how to define target frame names for the hyperlinks in Excel
xlDialogSendMail
Getting rid of Outlook warnings from excel macro
Can't open a file
Simple conditional formula
Dialogsheets
Re: Linking to other VB apps
UpdateLink Method
Re: Hidden Worksheet Error
Procedure Too Large problems
problem with tables in excel
Linking to other VB apps
MATCH, LOOKUP, or ???
Validation ?
Custom Calculations in Subtotal
help with sql in excel
combining sumproduct and average
Printing .pdf from within Excel
updating Access table with Excel data
to modify cells from a function
PageSetup slow
Unprotect Worksheet
Importing from SQL changes date format
Connectiong to an Excel Workbook with MSDASQL provider
can i send an email or warning from excel
Re: Pivot Tables not using all memory
File Copy Routine
Page breaks in Sheet for copy via OLE?
Change font to red and bold
Programming links
Re: A peculiar problem
Using the same variable in separate userform modules
programming a link
Modifying the cell dependies
Re: How to get the position of a cell in Excel named range?
listbox
Averages
Compile error ...
A peculiar problem
Importing a sheet?
Can you identify the maximum value in an array?
Find paragraphs in word and export to Excel
Can these codes be summarized?
How to get data from Access Database in Intranet
Text Format
Writing multilines to a text file without closing
recalc question
Re: On opening an excel file
Re: UDF Array function
Re: Simple Question
Re: copying duplicate entries
Automated copying & pasting from multiple sources
Re: Question about toolbars ...
Re: How to get the position of a cell in Excel named range?
How to get the position of a cell in Excel named range?
Unknown where is the problem on the Runtime error - Automation error
Comma in TextBox Problem (Spanish)
Eliminating Prompts
Re: Opening CSV files and #NAME? error in certain cells
Re: Simple Question
Protecting a worksheet from veiwing but not from importing in data
update and store new high values
Can this be done?
Extracting text
Re: Inputbox method using type:=8 - How to Cancel?
customize a calculated field in a Pivot table
How to disable 'Update alert' when open a spreadsheet has link to other XLS
Automation Procedure with Worksheet_Activate
Re: DDE Command to Format Cell
Where can I find other arguments & desc to the Workbooks.open("myfile.xls") cmd?
Chart automation problems!
Calling the Solver via a subroutine
How to disable 'Update alert' when open a spreadsheet has link to other XLS
variables for file names
m/d/yyyy h:mm date conversion to yyyymmdd ???
Re: How to disable 'Update alert' when open a spreadsheet has link to other XLS
Re: Workbooks.Open fails after upgrade to XL2000 from XL97
Deployment question
Re: How to apply a function across a range of cells
Delete Rows with letter #VALUE in cell J
Pausing code execution
Macro Prompt
scan for repeating values and then delete
adding uniform footers
check if worksheet exists
output of associated arrays
Making VB PasteSpecial method to work the same as Excels Application
Fill Color? Background Color?
Re: Auto numbering
Calling HTML Source code from within VBA for Excel
JScript to move Excel Worksheet
Help: Copying Visible Cells only to Visible cells!
formula returns formula
How to code event for dynamically generated checkboxes
Re: Excel 2002 RTD - GetNewValues and RestartServers
Re: CountIf
excel 2000 - manipulate two applications
Re: Substitute comma in csv file
print current sheet
list box
MsgBox
VBA Code to FIND
list of accounts
moving macros to disc.
Re: Formula on cells
Parsing Data From HTML Source into Excel using VBA
Formula or code
Open another Office app from Excel
The expanding XLS spreadsheet
Need Before_Save code
VBA code for Excel 2000, IF procedures and listboxes
Using Microsoft query through Excel
Average/Sumproduct Array
vba tutoial
Re: VPageBreaks in excel.
Re: compatibility issues foreign versions
ADO connection not always enabled
Re: DDE Command to Format Cell
Removing Lines Identified by Autofilter
Re: Formula or code
Auto numbering
help with *.xlw file please!
Re: Find functions
Re: macro to send an email from excel
Error Reports
Maintaining row position in a loop
Moving Text Boxes
easy way to test if a Named Range exists
Detecting Worksheet change
Opening Excel 2002 VBA Editor
excel symbols
Tracing into a Function
Re: CountIf
Re: Opening text files using macro
Re: excel symbols
Excel+Not Enough Memory..
Showing Excel Sheet in IE
RollOver buttons in UserForms (A solution)
Multipage
A save question:
Saving Excel to web site
"Less than or equal to" symbol in a UserForm
Reading a named range
Code for moving textbox
halting macro
halting macro
Subtotaling items from a list
Mass update in Excel based on values in different sheets
Displaying progress on UserForm
Can these codes be summarized?
Variables in command lines
Re: Excel2000 VB Help Problem!
dialogboxes
Time active Macro
Hide all toolbars auto_open
Re: How to become an excel MVP?
Select Range problem
Conditional Formatting
Defining Ranges
Save As Dialog
32,767 Significant Digits of Precision, with Number Formatting
Re: Protecting a VBA project
Re : MS Excel’s Offset Property
Re: Protecting a VBA project
Re: Copying a Excel Chart into Word
Re: calling word
Re: Mods to macro
inexperienced header entry automation resizing/scaling issue(s)
Re: Passing a Password to a VBA Procedure
grid lines covered up
macro selecting datalabel
Active X Control
String operations in VBA for "Substituite"?
Re: How to make a running XL app the active desktop window using VBAcode.
Clock Timer/ Date Function
Re: AutoFilter Dropdown Boxes Missing
Re: AutoFilter Dropdown Boxes Missing
Re: Serial I/O
Re: Time based macro
Sorting Odd & Even Numbers In Excel
Re: CSV Format in non-English OS
Cannot insert Activex boxes
Re: Formula for autodating
Re: Setting up a date and time stamp in a cell
Re: More efficient code
How to run VBA macro when the workbook is open?
Looping through Text boxes
SQL with no headers
Concatenate Text to create Formula
Problems executing Excel VBA code in Microsoft Office 2003
Re: Why doesn't "Workbook.Range("myrange").value" work?
Re: Copy and Paste Lost
Re: system variable representing subroutine name?
Default excel Template
An ODBC question
ugh! Match/Index problem
Re: Running sheet from another sheet ... and back
Row to column data move base on row
Re: Save As Dialog
RE: Automate differente excel versions + VBA protection
Copy and Paste lost
subtract time from now()
date conversion from m/d/yyyy to yyyymmdd
Re: Single Sheet - Calculate Manually
cannot open and can not delete files
Datedif, Workday etc.
Certain methods do not work
Re: really dumb find question
C Add-In clashes with VBA?
Re: Inputbox method using type:=8 - How to Cancel?
mortgage amortization
Re: Single Sheet - Calculate Manually
Macros
Name of workbook
Re: .Visible Property
Use one column to identify values in adjacent column.
Re: Excel VB and Lotus Notes Address Book
Getting the full path when from a File Open Dialog Box
Detect if file is open
Can I have a loop to open a set of workbooks get some data, close it one a time.
Re: Macro Using Named Cell
executing code when a module opens
Unprotect method run-time error
Re: Macro Using Named Cell
SUMIF function
Re: Exporting Data.....
formatting in macro works on one computer
automatic updating cell
Deactive Copy and Paste
Digital Certificate creation error using makecert
Re: Inputbox method using type:=8 - How to Cancel?
Sizing windows automatically
DateDiff problem
Undo, Redo, Repeat and Validation
Device I/O Error
Excel ADO Connectstring parameters
For Next Looping (custom variables)
Sorting ListBox results or transposing ListBox values to other cells for sorting
Eliminating rows of data in excel spreadsheet that have blank cell in row A and data in row B - E
Excel is very slow to load/save the spreadsheet
Hidden sheets becoming visible after saving from Browser
Re: dates in userforms
Delete without losing references?
Lotus 1-2-3 macro
Simulating the Format Painter, Selection.Select, and taking focus
Re: Can we write VBA code to set all column/row's size back to default size?
Re: dates in userforms
Re: Check mark boxes in Excel 2002
Auto Fill Program needed to get maps from internet onto excel
Excel Addins
Re: Mouse
Re: Cell contents changing colors
GetSaveAsFilename method
Re: Opening an AutoExecute Macro Workbook from an AutoExecute Macro Workbook
Re: Ah, I think...
Re: Associating one array with another
Re: declare a two dimenssion array
Re: Ah, I think...
Before Send
Re: Screen is flashing when VBA adding objects into Excel sheet?
Ah, I think...
Re: Iterating through row cells on column Match, help please.
LoadPicture Pathname or no Pathname
Ah, I think...
adding changing number of days
Re: Accessing the VBA project object model
Can we write VBA code to set all column/row's size back to default size?
Re: Before Send
Re: Extracting Access data
Re: Combobox Click event triggered when copying worksheet
Add PivotItems to PivotTable / Enabling - Disabling PivotItems
Re: User defined functions - text for formula palette
Re: Excel Add-in path in UNC format
Time based macro
Re: Excel: Deleting Macros and Functions
Question: Cell formula or macro to write result of one cell to another cell
Question: Macro overloading, passing variable number of arguments
Question: OPEN return status
[Excel XP] Orientation of cells etc.
Re: Count number of prints.
Prompt
Linking To Excel Graphs
Re: I need to determine a cell range based on a blank cell
Chart Date Label Problem - Is this a bug in Excel?
xlfCaller
Problems generating an html link based on worksheet values - SOLN
Problems generating an html link based on worksheet values
Strange thing with this formula written by VBA
Re: Count number of prints.
moving to cell Y if cell X has value Z.
Excel table macro
No Subject
No Subject