View Full Version : Excel Programming
Pages :
1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
9 |
10 |
11 |
12 |
13 |
14 |
15 |
16 |
17 |
18 |
19 |
20 |
21 |
22 |
23 |
24 |
25 |
26 |
27 |
28 |
29 |
30 |
31 |
32 |
33 |
34 |
35 |
36 |
37 |
38 |
39 |
40 |
41 |
42 |
43 |
44 |
45 |
46 |
47 |
48 |
49 |
50 |
51 |
52 |
53 |
54 |
55 |
56 |
57 |
58 |
59 |
60 |
61 |
62 |
63 |
64 |
65 |
66 |
67 |
68 |
69 |
70 |
71 |
72 |
73 |
74 |
75 |
76 |
77 |
78 |
79 |
80 |
81 |
82 |
83 |
84 |
85 |
86 |
87 |
88 |
89 |
90 |
91 |
92 |
93 |
94 |
95 |
96 |
97 |
98 |
99 |
100 |
101 |
102 |
103 |
104 |
105 |
106 |
107 |
108 |
109 |
110 |
111 |
112 |
113 |
114 |
115 |
116 |
117 |
118 |
119 |
120 |
121 |
122 |
123 |
124 |
125 |
126 |
127 |
128 |
129 |
130 |
131 |
132 |
133 |
134 |
135 |
136 |
137 |
138 |
139 |
140 |
141 |
142 |
143 |
144 |
145 |
146 |
147 |
148 |
149 |
150 |
151 |
152 |
153 |
154 |
155 |
156 |
157 |
158 |
[
159]
160 |
161 |
162 |
163 |
164 |
165 |
166 |
167 |
168 |
169 |
170 |
171 |
172 |
173 |
174 |
175 |
- Closing a word file?
- Calling a C++ DLL which returns a String
- Confirming existence of dependents
- Lookup a value based on two keys
- Blank rows appearing at top after sorting
- xlSheetVeryHidden issue
- Contracts....
- Excel - VBA Error
- Excel-VBA Error
- Modeless property
- Copy from User form to Sheet macro
- Cell Address
- Error accessing the system registry
- calling seriescollection by name
- Sort and Add Columns
- edit/find menu in a macro
- Macro forced to run by data?
- Endless Loop when using ComboBox1.BoundColumn = 2
- Range help
- VBA to create an Array of all Sheets in workbook
- How do I calculate percentage from seconds?
- Onkey Error
- runtime Control and code in VBA
- Mail Worksheet as (html) message body
- Problem with FIND
- Change the "Delete" key to "BackSpace"
- Another simple one!
- Change the "Delete" key to "BackSpace"
- office icon
- Excel to Access
- Database function / formula question
- Generic questions about variable scope the Initialize event
- Coloured Cells and Dates
- Problem with Data Validation not working
- Sum of Rows when columns are added
- Accumulating elapsed time
- VB user forms
- Set print area with code
- Conditional formating
- how to speed up excel workbook
- Banding - visible rows only?
- userform
- IF statement macro
- Passing Values Syntax
- Enforced entries code
- worksheet function to vba
- List Box properties
- Multipe sheet search
- Print Preview all pages at once
- Deleting Sheet without message box
- Calculation on array in VBA
- Dialog Query
- How to modify the comment pop-up behaviour.
- Combining Files
- Confirming existence of dependents
- How to find first and last cell in a Sheet with an entry
- linking cells (2)
- linking cells
- Urgent: How to use CheckBoxes in ListBox
- Screenupdating
- Determine the type of currency in a cell
- Excel VBA - Calculating average problem
- Need help to find the last row of data
- Forcing Integers into Textbox
- updating links when vlookup is used and..
- Cursor Tab Order
- Need a macro for selection and sort
- data transfer between VBA arrays
- I may have found (yet another) bug in Excel
- Application.Match with Times
- Application.Match with Times
- Macro help, again!
- Can this Macro be done?
- Printing only what can be seen
- Create custom function and add to the
- Importing/querying data from .mdb file into Excel
- Identifying Bottom-most Entry (And Other Questions)
- Quick VBA method for looking up data
- Need to combine first and last name from two columns
- Run a macro at startup
- Extracting email addresses from Outlook Contacts
- filename and path as constant
- ScreenUpdating Problem
- Cell A1 in Upper Left Corner
- Organizing words, willing to pay $ 100
- Program
- Cut Paste Undo Failed
- Code Run-time error '1004'
- Switching woorkbooks & and invoking a macro from within a macro
- XLA Unload problem
- Saving Workbook in Visual Basic Hides the Worksheet, Why
- How can I modify the color of a cell?
- Number Switch Code
- how do you loop through each worksheet?
- S1.Range("D65536").End(xlUp).Select
- Code using Format Function
- how can deactive cells to input data
- how can deactive cells to input data
- Visual Basic For Applications
- I lose my content of MSDN332.inf and msdn331.inf
- Lookups..
- Installation error Access add-ins
- VBA AVERAGE formula, ignoring zeros
- Automation error in win 98
- Multiple hyperlinks via macro?
- Position of Cell on Screen
- Compile error: type mismatch
- dynamic arrays in excel
- File Name List
- Password to get access to certain sheet
- Trouble with columns and for each
- Create and Link check box with autofilter and sum, average of filtered raws.
- Ignore formulas
- Get a value from a list (Database) aka DGet
- Fastest way to do this?
- Back Button Macro
- Deleting the spaces before and after a number in Excel 97
- Disabling Macros
- "Run-time error 91: Object variable or With block not set"
- MID macro
- How to upload the file to Yardi Program
- Need a Basic tutorial for Excel VBA
- Additional toolBox controls
- Protecting Multiple sheets with prompt for password to unprotect
- creating dynamic mirrored worksheets
- Numbering Add-in
- Excel 2003 Bug!!!
- Array <---> Range
- disable the worksheet read only temporaily in VBA
- show the working file
- Toggle text to be visible and not visible
- excel
- Icon change
- Writing Array Formulas in VBA
- Selection.Copy Destination:=
- VBA and Autofilters
- Simple Listbox question - how to remove items
- Error using "Calculate" function in VB
- VBA References List
- Problem pasting a row from a hidden sheet to the first free row on another visible sheet
- Macro to Force Response in Dialog Box
- Move Cell to Top/Left Position on Screen
- Excel Limitations
- Macro help, again!
- Array and Named Ranges
- Newbie : Help with sort via Excel code
- application.quit will not shut off application
- Linked table message in VBA
- Need a macro to delete selected rows
- Cell reference
- Arrays
- VB project protection
- Value of a cell in a range if color is yellow
- Text box
- Re: Closing the save changes box
- Rename active sheet
- Creating a macro to use the text import wizard
- code for having sub rows
- Help with conditional formatting and referencing workbooks...
- Formating column cells
- scrollbar control of a chart, live or not live
- Retaining Formats
- Automatic Sheet Name Read and Rename
- Advanced Programming
- Find, Offset, Enter Number
- Basic Macro help needed!
- Closing DOS window after shell command
- Toggle Text to be visible and Not visible
- Automatic word wrapping on the formula ... don't know its name
- Re: Run-time error '11' & Run-time error '1004'
- PERSONAL.xls is opening as active when Excel starts - why?
- Before workbook open
- How can I distribute Workbook with VBA code and library references to other computers
- Macro to quit excel and go back to original application
- FBI IS TORTURING ME - PLEASE HELP
- Seriously need help
- First Sheet,First column as template
- Getting rid of all negative numbers on a worksheet
- Installation error Access add-ins
- Add signature to files exported to Outlook
- ComboBox on worksheet-strange outcome
- Re: excel 97
- Tired of Excel's Interface limitations...??
- Hiding toolbars but keeping the Windows Menu Bar?
- Run-time error '11' & Run-time error '1004'
- Need help.
- Can you hide forms checkboxes
- Msg Box Qquestion
- Query OLEDB Provider for Excel file info?
- Pivot Tables
- Filling a cell with values from another worksheet
- Macro to save file
- VBA : VBA code for summation formula
- code to hide check boxes
- Locking other cells based on values in a cell.
- macro that closes excel application and open another app
- Search code
- Web Query Parameters
- Re:Macro to insert and delete rows
- Type Mismatch
- using SaveAs to save 'only' one sheet from one book to a new file
- Change directory for DOS window
- Select certain rows of sheet & delete the rest
- office web components error
- formula for avarage with a variable divider
- Macro to Rename Multiple Sheets
- External Database Lookup via ODBC
- Personal.XLS path problem
- Where to put code
- Identify Range Selected By User
- Re: web query
- Re: Closing the save changes box
- VBA problem -
- mutiple strings from a drop down menu
- Text file closure
- Where to put code
- Using FileSystemObject to get File
- Possible?
- xl Dialog
- Excel currency
- Transfering Acces Tabel to Excel with Visual Basics
- Change Autosum to use subtotal(9,....) ?
- Search for common data lines (loop)
- Multiple workbook recap
- Different Values & Printing.
- Sinple one.
- Trouble exporting chart to htm file - need help
- help with code
- password recovery
- Lookup Tables
- Macro to insert and delete rows
- Events in Excel for executing functions
- Visibilty cntd
- Auto_Open/Close Mods
- What's new in 2003?
- Running out of memory
- A Question for Ron de Bruin
- Multi line Select Query
- Visibility
- How to delete a row depending on a script
- vba function description visible in Formula palette ?
- Can I toggle this Code - to Stamp and to UnStamp?
- help with algorithm
- How to DISABLE THE CONTROL BREAK shortcut keys
- Coding help needed
- Search more than one result
- Pre-checking checkboxes in a dialog box
- accelerate in loop
- Newbee Q: How to make search field in excel sheet?
- message box while macro is running
- Why my cell format is not copied when I copied workbook?
- Using same code for Multiple cmd Controls
- Looking for some source code for navigation bars
- 3 conditions if else statement.
- how to add message box after a macro is completed
- date in color
- username and password for form excel vba macro
- Someone please Help!
- Multiple commands from single IF.
- unable to edit macro!!!
- Move a sheet
- macro disable and enable.
- How to Cancel a Save?
- Anywhere to see list of predefined functions available?
- Programing with a "Find"
- Help, Unable to start Excel
- Help with Run-time error
- Removing and replacing toolbars...
- Re: View the data in a cell on a userform
- Tracking changes made in cells
- Removing a user form with code
- Upper/Lower Bounds
- Upper and Lower Bounds and Rnd
- search value not formula with .Find
- Parsing data - variable length cells
- Help with the basics. Starting out.
- VBA-Graphic
- Run module ON OPEN event??
- Ascii file import round 3
- Still stuck with importing a delimitted file.
- Want to hide check boxes
- Delete empty rows in a worksheet
- Coping all cells with data.
- Change Cell Data of a Required Column
- Newbie needs help in VBA ;creating a click() function
- Compare items in 2 ranges
- Simple hiding columns with vba does not work with a checkbox
- Newbie needs help in VBA
- Macro Help / Question
- Subtotal using VBA
- Generating a list of all possible number/letter combinations
- Excel VBA - Graphics
- Normal Distrubtions with Upper/Lower Bounds
- Macro Dialog Box Help
- Copying Data onto sheets
- Rounding Logic Question
- MultiPage control: Easy question
- Where do digital signatures reside?
- Split query
- Access Report
- Excel 2003: Changing an XML Map
- Get…UCase or LCase ???
- Identifying Duplicates
- ascii file import round 2
- VBA with EXcel 2000 and series line colors
- Userforms and Print Preview
- Annoying prompt: ActiveX and app initialization
- Creating a PivotTable Report from an Another PivotTable Report
- continue to move data until all moved
- Identifying and deleting all but the first and last cells for certain date
- Looping thru files
- Excel VBA - Trying to change color of cell conditionally
- How do I have excel not to prompt user to disable or enable a micro
- Macro to hide formulae
- Get…UCase or LCase ???
- Going Bananas
- Calendar Control
- loop to name ranges
- Option Buttons
- Re: How To Get 1 Million Visitors
- Excel macro - Help with duplication validation macro
- SQL data access help required?
- FINDING LAST ROW OF THE DATA
- Using bold and normal font within one cell
- Simplify
- All open workbooks
- Creating an "update" button and using a macro to copy data from multiple sheets
- VBA Excel Function
- Alternate to Range.Find
- refering to option buttions
- Write new VBA code from within a MACRO
- reading variable "from" and "to" ZIP codes
- Get address of cell clicked
- Re: Unhiding rows in Excel 2003
- Re: Driectory changing
- Add spaces to end of field in save as PRN
- Hyperlink Macro-links to other excel files
- Macro to Start on a New Line Each Time
- Excel Embedded Links
- reverting to first page on exit
- Deploying a .NET add-in in Excel 2002
- Clearing shading before printing
- Changing from lower to upper case
- Removing duplicate entries
- Creating Specific Excel Formula Question.
- Date format on import
- Requiring Cells be Populated
- Reading the pin voltage fm RS232 port into excel by using VBA
- Converting Values
- How to find out if a button exists on a sheet
- PivotTable selection
- Problem with quitting Excel opened through automation
- Bad or Missing References
- why doesn't this work?
- Installing XLA on Win200 Server (Office XP Developer)
- method vbproject of object workbook fail
- Hyperlink
- Macro Error Message
- Macro Error Message
- Sum Filtered values
- Fixed Columns
- VBA created formulas won't autocalculate
- Toggle Text in a column to be visible or not visible
- Macro with in a formula
- need a loop
- Passing SQL Query Result Into A Variable
- Application.WorkSheetFunction.DafeDif (not DateDiff)
- Adding all the data to one sheet
- I can not find the msexcel.olb file for Office XP?
- Buttons Control Tip text
- Find First Cell In A Range
- Assign macro to button in EXCEL 2003
- Re: Other undocumented VBA changes?
- Function Definitions
- Passing Values to Function
- Excel Macro Help!
- Custom ToolBars
- Msg Box Question
- Inserting rows macro
- ODBC connection by udl
- Using classes defined in an add-in
- Copy without borders!!!!!!!!!
- Need a macro to run sort automatically
- Excel VBA- Get user input, search the for match, output to text file
- Help with Solver
- Opening Files based on list
- Comparing two times (HH:MM:SS)
- Pass string as Parameter in OpenText method
- Loop command in Macro
- Can we Pass String to FieldInfo Array to OpenText Method.
- Com with Word
- System asks to save when no changes made?
- Adding colour background to control
- Opening a text file for input
- Find Value in Array and report on Location
- Check for sheet name
- Error with Target.Name.Name in Worksheet_Change event
- High Tech Question ?
- VLOOKUP with a Boolean membership condition??
- Excel hangs when trying to open a file
- Copying workbook
- Macros to hide/protect formulae
- Replace Functions not working
- Import ascii file
- Question about scoping variables
- EXCEL FILESEARCH
- tickler for date + 180 days
- Query Sheet using a WHERE clause?
- Offset function with merged cells
- Export method question -- Spreadsheet ActiveX component on user form
- ActiveCell not recognized
- help with user form that won't go away
- Exceeding the limit of Nest IF's
- Comining lots of functions into one User defined function
- OptionButton type name?
- How to references objects that exist on local or network drives that aren't open.
- Cells().value is null but I can see data
- Protecting & unprotecting worksheets
- Calling functions from Excel worksheets and the Find function in XL '97
- auto fill columns
- Control on worksheet to display 2 col's of data
- close work book via macro
- ReDim Problem
- Command Prompt
- When to use .INI files
- Re: Using a macro to write modules
- Switch between workbooks
- Using a specific range to populate a list/combo box
- Re: Using a macro to write modules
- Copy value and fill blank spaces below it until new value is encountered?
- Open File with Links?
- App Close and File No Save
- Creating a dynamic list
- PivotTable selection
- Installation error Access add-ins
- Digital Signature
- Help with the Excel-object
- VBA DAO 3.6 Database - How to release resources on the PC after multiple Queries
- Macro to protect/hide formulae
- Using cell color as condition in equation
- Range of cells
- Tricky vba Raffle Ticket Problem?
- help with type mismatch error
- How to loop through all ranges in a worksheet
- Macro or VB HELP!
- VBA reference error
- formula for rounding
- Easy Q: Visual Basic and Excel
- buffer overflow
- VBA Code statistics
- Run code for multiple worksheets in a workbook & Column Formatting
- Retrieving data from Access via SQL/ODBC
- Trying to *simply* programmicly get a bmp file to be the plotarea backround
- Error trapping don't work
- Control on worksheet to display 2 col's of data
- Code Bug
- Macro to protect/hide formulae
- copying sheet with macro
- Excel VBA Calculate Problem
- SUMPRODUCT QUERY
- Creating a Data Entry Userform
- Saving template as non executable file
- Listing External Worksheet references to your sheet
- FileSystemObject CopyFile with UserID/Password
- New Workbook New Session
- reading/inserting variable dates within a macro
- How to trap the error message "Remote Data not accessible"?
- Find, Lookup, who knows???
- Sorting data based on validation cell
- ABS Excel Function
- excel sqr function vba
- .saveas and .close methods from Access
- Protecting and Unprotecting multiple sheets
- test
- Finding last number in cell
- cleaning up a field
- Creating a PivotTable in a Different Workbook
- xlDialogFormulaFind Dialog Box
- Emulate C/C++ struct in VBA?
- Excel database access
- Importing a Directory Listing from CD to Excel
- Text box on userform
- SumProduct function
- How to run a macro in word web page
- Bi-weekly date calculation
- Set No of Sheets in new workbook
- Excel and Dbase
- calculation in menu/tool bar using option buttons and pull-down menus
- Filename with current Date()
- Controlling Word from Excel
- Re: Filename with current Date()
- Week Numbers
- Modify duplicate code
- Printing non-adjacent areas on seperate sheets in one print job
- Combo Box Question
- Crash Using Watch Window XL2000
- Pivottable, month, sorting
- Concantenate using VBA?
- Copy Sheet - Paste Values
- Macros
- Cell identification in x,y coordinates
- Excel to Visio to Word
- Using datetime fields as parameters in a query...
- Help with formula please
- Picky/Choosy
- Message Box if cell value not in specific range
- searching for a null cell in a column
- Cell access
- color coding largest in a list
- EXCEL 97
- Counting using conditions
- excel windows 97
- Changing XL97 Application Icon
- Keep cell reference when picking up information from another database
- Testing for contiguous cells
- Keep cell reference when picking up information from another database
- Excel don't quit in ASP.net Code
- Excel Programming
- auto filter and auto fill
- replace doesn't
- Visual basic (combining wrkbks)
- User selection
- KeyPressed Event
- How to prevent pasting to every sheet in workbook
- Solver and VBA in the same model
- Slow Looping
- listbox problem
- How to wrap text in combo box?
- how to run a macro in word
- Same code, different line
- setting up excel for multiuser
- ADO and Excel versions
- Removal of spaces
- macro to export files but not replace an exsisting file name
- How to define a print range?
- select last cell in used range
- one macro calls the other
- Autorefreshing excell external data while opening from VBA code
- Solving Circular Reference Formulas
- Moving multiple row cells into one row
- Prevent entering duplicate cell data in a column
- Copy a range of data then E-Mail
- Rows and Columns View
- Rich Textbox not "trusted object" in Excel 2003
- Publish Excel Pivot Chart
- How do I deactivivate a workbook?
- Calling VBA function that is in another module
- RE: Selecting to end of column
- Passing a Range to a Function problem (still not working)
- Inserting Rows
- Excel 4 Macros in Excel 2000
- How to pass values from a userform to a standard module?
- question
- editing code with code
- vlookup problem
- Excel XP removes AS part of statement
- Apply password to multiple Excel Files?
- Formatting Codes for header and footer
- Creating a Range object in .Net
- Subscript out of range when adding worksheet
- Comparing text instead of values?
- Displaying all the states in a VBA combobox
- COM + Excel + Win2k3 Standard Version + IIS6
- CopyFromRecordset does nothing
- How to find lost macros?
- Module Names
- Displaying answers that are off screen
- How to prevent the MS Excel error dialog by errorhandling ?
- Cell Color Change
- Silly Question
- Using a Macro with the sheet protected.
- Input Box Cancel Button
- Changing one range on multiple sheets.
- Help me make a function dependent on current sheet?!?
- copyfromrecordset performance
- Information Positioning Problem
- Sorting Range Help
- string manipulation
- Macro security question
- automatically fill up a cell?
- help worksheet event code
- Automatically run a macro when opening an Excel file
- elapsed time in msgbox
- Need help with check box coding, urgent!!!
- combining data from two sources
- VBA code in multiple workbooks
- Screen Updating
- Need help with check box coding, urgent!!!
- Color of Cell Background
- finding the last row populated in an excel object
- Library references
- Passing a Range to a Function Problem
- Range Name Found??
- Printing To A Specified Printer
- Applescript Problem
- Using up, dwn, end, right, left in vb programming
- PASSING DATA FROM USER FORM TO EXCEL SPREADSHEET
- macro for conditional number formatting
- system error &H8000FFFF
- Change cell format programmatically
- Protecting Multiple Worksheets
- Subtotal and Total Columns
- Chip Pearson: A Question about RegServ32 and DLLs :)
- Importing fractions with proper format from CSV
- Finding referenced worksheets used in a worksheet
- Ckeckbox size
- Macro To Create Other Macros And Buttons
- Detect Password Protection on a Sheet
- Declaring as Object rather than Excel.Worksheet
- Saving using a path
- Macro to Finded Defined Names with #REF
- Combobox programming
- Password Protecting a Macro
- Interacting with Explorer
- excel vba interface with outlook (office 2000)
- Cell Protection fails with validation lists
- Postioning combo box
- More questions about variables and procedures...
- How do i change the format of a cell based on the condition of another cell in same row?
- How set column width using mso-... in style sheet ?
- Check Box Macro
- True - False
- Refresh label on user form with RefEdit
- VBA - AutoFilter - 'nonblank'
- Recording macro to activate other macros
- Progress bar in statusbar
- Lost toolbar
- Macro or VB Code
- Password request to run macro
- How do I drop an Open connection in Excel
- CSV (Comma Separated Values) delimiter ?
- auto filling relative worksheet references
- Compile Error in Hidden Module:
- combining data from two sources
- Sorting into Surname order (alphabetically ascending)
- Resetting Excel commandbars on close event
- Propogating errors after closing Workbook.
- problem with change from excel 97 to xp
- help !!!!.. Excel object not closing
- Insert row with macr
- Multiple excel windows
- How do I refresh a form in excel?
- Ctrl-v doesn't work after changing Application.DisplayFormulaBar
- ActiveX message XL2003
- Adding Code Module to Workbook
- Help! Please help with my code
- Run Excel add-in on client side
- Basic UserForm question - please help
- Total Line in Report
- change VBAProject References Library
- Search and Compare two Workbooks
- How do I display text in a (popup) window?
- Range Selection with Arrows Keys
- help !!! please... closing excel application using automation
- Autosaving Workbook
- <Pass the Torch> from a Closing Workbook
- <Pass the Torch> from a Closing Workbook
- application.caller
- AutoFilter Question
- Copy/Paste Function for multiple columns
- Loading a web page on a web browser control
- passing value with button to macros
- Determine File Type
- Autofilter across two workbooks?
- HELP!!! Beginner needs help with VBA coding
- Workbook Deactivate Event
- Chart title
- New Data Type - Latitude and Longitude Calculations
- excel - formula anb VBA
- create a user input form
- Copy/paste text in cells into a textbox
- How to step through top row of a Range object
- Monitoring application-level event problem
- I'm having some trouble with variables in Excel '97...
- Conditional data move syntax
- Does an open dialog box slow down or stop a Macro?
- COPY MACRO
- Class Module Scope
- Ampersand in front of font name
- MultiPage
- Class Modules
- loop command in Macro
- loop command in Macro
- Export PDF information into Microsoft Excel
- user's page doesn't show on screen unless a print preview is done?
- sub vs. function bhavior regarding 'Workbooks' obj. functions
- Excel automation "Error loading DLL"
- Excel VBA - Chart title problem
- OnChange Event for a Cell
- Copy a Sheet without physically opening the file
- Force Delete a Sheet
- How to verify the existence of a file with formulas in Excel 97?
- Excel and COM
- Changing data returned from an autofilter
- entering individual array formulas with vba
- Add a Column Range to an AutoDate Macro
- Possible to generate a GUID in Excel?
- Source data of a pivot table
- using variable as cell location
- ADO & semicolon delimited text file?
- Disable Add/Delete/Move Worksheets
- Last saved
- VLOOKUP Issue
- Excel Display Problem???
- Currency
- With ActiveSheet.QueryTables.Add
- Count of unique values in a filtered column using 'find'
- Re: Add-In - Component not correctly registered
- Scroll Bars in UserForms
- Functions in Statusbar Won't Display
- Excel Addin help!!!
- last Cell in a selection?
- Error Trapping
- Excel 2000 Find without select VBA
- Macro Button??
- SaveAs command when a file already exists?
- Run a macro in the active cell.
- Insert Rows Macro
- ActiveX Component Can't create object - Any Explainations?
- Selecting the first cell of a row
- Pivot Table Chart
- Variable in a VB Code
- Animationen
- System error &H8007007E (-2147024770). The specified module could not be found
- VBA insert messing up Vlookup and Match
- Text Box exit
- DAO Nomatch in office xp excel vba
- Seperatin data ffom one column into another column
- DDE equivalent in Excel 2003 / .NET ? (push technology)
- application is not getting closed through automation
- Workbooks in multiple running Excel applications
- Visible Property
- Run Time error '1004' when running Calculation method
- Selecting multiple columns
- ado connection string for excel 2002
- Excel 2002
- Shift-Control Arrow and RefEdit Control?
- Same macro in two files
- How to permanently delete a custom toolbar?
- Formula for regression
- Cancel in Save As and Open
- Time Calculations using VBA.
- Q. Pie Chart problem. Want to add series, from another worksheet.
- Modifying text in Chart Tips
- Excel file embedded in Word doc--limitations of work area
- Hide/Unhide sheets
- What is the hierarchy of code execution?
- How to supress a Save prompt?
- Excel 2000 to Excell 97 Vba Problem
- Vb Code not working
- How to retrieve the name of a picture within a worksheet?
- thanks TOM. How to run macros and make the workbooks invisible
- (Thanks alot TOM)How to run macros and make the workbooks invisible
- Copy from Column to Column
- Save As macro
- Adding code to worksheets
- Code Cleaner
- Tom Olgilvy Question
- formula for numeric order
- How to run macros and make the workbooks invisible
- DIM is what i am
- How to save each sheet as a separate excel-file
- Looping Macro to remove data where value is 0
- Userforms - Display result of a calculation in a textbox
- Stop Highlighting a Range
- vbYesNo
- Pasting the same Value into a Range of Cells
- sqr function in vba
- Next Blank Cell
- control element
- Creating a User Form to update a list
- CRLF in text box
- sophistication with graphs
- Protect Code
- How to view graphic files from excel?
- loopig in Macro Programming
- Online Tutorials about Macro
- Opening A Folder Using VB Code
- need to remove zero while joining two strings
- DateDiff("w") -- problem
- Identifying commandbar names in non-English versions of Excel
- Comparing Ranges in two worksheets
- How to tell : how many rows a merged Column run over ..
- MACRO TO UPDATE CHARTS !
- Macro Help
- HOW to run marco without displaying the workbooks
- Help::how to run macro without displaying workbooks..
- cell format
- Can't open an Excel document
- Auto Save
- how to run recorded macro without showing processing excel sheets
- Changing Thumbnail Pictures in a UserForm
- isempty
- DAO Late Binding?
- Disable Doubleclick for a range
- GetSetting & SaveSetting in Thin Client Environments
- 4 variables to one sheet, then back to original sheet with answer
- Frame Border Color
- Re: Re: vba date & data formatting problem
- Create Excel Worksheet in C# / VB
- print labels diff date on each
- Stubborn Link Data/Value Problem - Help Appreciated!
- How can I activate a combobox by keyboard strokes ?
- Excell 2003 - COM Add-in - Tools | Add-Ins
- Print if populated
- Restricting cells
- how can I insert jpeg file in the cell?
- Hide and show
- Using Solver in Browser
- excel file format specification
- For Tom Ogilvy re Copy Sheet Problem
- Form titlebar height
- Objects and Variables
- Browse function
- Paste a sheet as a link
- Scripting.FileSystemObject LAN
- Displaying Cells Comments
- Conditional copy & paste
- using outlook distribution list from excel vb
- UserForm TextBox Decimal Places
- Disable Doubleclick
- Re: entering data
- Chart Fill Effects
- Need help with a simple problem
- timing a recorded macro
- running macro at the background
- Compare and Append
- macro programming problem
- reference an ole image control's .Picture filename?
- VBA --- Corrupted xls file
- Gradebook and Individual Report
- Macro to Open and Compile Multiple Worksheets that are password protected
- Common Dialog Error ! (Please Help me ! urgently)
- worksheet name
- Extracting Data from External Source - Automatically
- Detecting open files
- Open Windows Explorer and select item
- Re: Window Animation
- Can you use an IF statement to launch a macro?
- relative position in macro
- How can I use data formatting in VB?
- How do I dedect a right click event?
- Send mail from vba with the outlook distribution list
- Macro to compare values and return exact matching value
- combining 2+ wkbks into 1. Code needs tweaking please
- Import IE/WE Favorites programmatically
- MsgBox
- bug in printing excel worksheet!
- data records in a table extracting
- tricky rand situation
- I need assistance please
- Crystal Ball CorrelationMatrix macro
- Error when printing to Acrobat
- Reference using Excel with VB.NET
- Autofilter and protection
- extend vlookup
- AutoScale on Charts
- Module
- Create a drop down calendar in a cell?
- Invisible/unfindable Comboboxes creating .emf file problem...
- Excel linked to Access
- Left Worksheet Function
- to add new usernames
- Re: need command
- Visual Basic HELP
- creating new workbook from single worksheet
- adding a line at the end of a macro to name the cell
- Differentiate between "" and Empty in array elements.
- Reading information from all workbooks in a folder...
- Close file
- Re: Width problem with Form
- RunAutoMacros does not work correctly from vbscript!
- copy all pagesetup settings?
- dot value
- Declaring a variable?
- import array text to row data in excel
- How to know the excel's constant
- Filter and Delete Picture
- problem with dates
- Autofilter
- Condition added to Sort Code
- Running Code looses focus to Outlook and stops
- Help please....
- Deleting every sheet in workbook after Worksheets(4)
- Averaging formula help, please.
- Data Entry Validation in Excel
- Macro to delete charts
- Escape for special characters in string
- Message to Tom Ogilvy regarding SelectionChange
- problem of asp to dll then to macro?
- Numerical Data vs Text
- SelectionChange - What am I doing wrong?
- VBA reference to Outlook
- printing
- Comparing two Cells - using Offset and compare - Stuck!!!!
- How do you change the default printer?
- Remove commas from Windows buffer
- opening or activating another workbook file
- Re: Window Animation
- Run Time Error, FormulaR1C1
- Disable Macro
- Sum up
- FormulaR1C1
- UserForm question
- WorksheetFunction
- FormulaR1C1
- Copy Sheet Problem
- pivot tables: multiple consolidation ranges
- rename folder o files with value from inside each wbk
- VBA - Put data in cells
- Macro to enter formula with text
- Windows XP freeze
- selecting multiple sheets
- negative value
- Excel sound alert problem
- Website about excel macro programming
- Sheet Protection
- Google Search 6.0
- un merging
- How can I copy the FORMULA in a cell to a different cell?
- numbers in words indian number system
- copy\paste with vba
- VLookup erro
- Function return a Date, wrong format
- Re: Error of ClearContents
- OUTLOOK from Excel
- Sheet code
- Looking ior the commnds for several things....
- Copy for Backup Purpose.
- Listview in Excel 97 vba.
- Fill column macro that stops
- Formatting a ComboBox selection
- How to create a macro to copy data from a column to a row in another worksheet?
- Making numbers display as currency in lables
- Listbox default
- Downloading data from a web page
- Prevent more than one check box select
- missing link
- VBA Code Printouts with PageBreaks
- Type Mismatch Error help understanding
- Urgent!! Combo boxes 2 spreadsheet?? Thx
- script for Jolly Giant
- Password Macro
- Renaming a standard module
- SaveCopyAs macro
- looping through range and deleting cell contents.
- How do I paste data to an variable row?
- Text problems
- data from combo box in userform to spreasheet???? URGENT!!
- Listbox Propery code
- Macros Problems
- Checkbox Macros
- Test message
- Conditional statements
- Show Macro list (tools->macro->macros)
- Macro Writing Help?
- How to by-pass password ?
- Changing color on a range of cells
- VBA Path Confusion between Appl and Personal.xls
- Access automation from Excel
- Loop macro for a Newbie
- DisplayStatusBar when DisplayFullScreen = TRUE
- Unselect data in a Listbox
- VBA has "lost" some datatypes
- Re: Protect All Sheets code not working
- Using the Back Button when viewing Excel through an Intranet Browser
- ASP to Excel
- Embedded option buttons
- selecting a range in vb
- Formula pasting is not working
- I Can't Get VBA to Work
- MS Excel 2000 - Data Delete Help Needed
- Re: File size problem: standard remedies not working.
- Toolbars
- Excel sound alert
- Pass an ADO recordset
- Better Use of Dim statement
- Rows ColorIndex
- Detecting Macro Code behind a sheet (2)
- Directing data to new worksheets
- Inefficient Space Removal
- pastespecial in vba
- Absolute references
- test
- Copy worksheets
- open word file?
- Looking for sample of VCR or Navigation buttons for use on UserForms
- Help - Run Macro on Calculate
- Generate powerpoint slides from excel automatically
- Running command button click event code
- compile error using Left() function
- Option Explicit Error
- a string object
- Desperate -Lookup function needed!
- Find errors
- Combo Box Item
- find & delete + fill to end code?
- Excel random sorting query
- Sortin Numbers as Text: How?
- ActiveSheet.Copy
vBulletin® v3.6.4, Copyright ©2000-2024, Jelsoft Enterprises Ltd.