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 |
- Selecting the first empty row
- Reorganizing rows into groups
- changing cell formula part of macro
- Excel add-in password prompt and Act!
- "Window Trails" showing with Dialogs
- Use ADO to add or update date in Access
- Change cell fill color from function
- mouse pointer question
- Looping a loop?
- NoFill range of cells
- Arrange a list in ComboBox
- Buttons won't work
- String array issues. Need help...
- ActiveCell.Address question
- sum if dates conditional
- Excel: how do I set page3 to be locked until page 1, 2 are solved
- Error:Can't find project or library
- Getting rid of extra space after cell contents?
- how do I rearrange a column into a series of columns?
- UserForm for each Worksheet
- How do you capture events?
- Should Be Easy
- What different between "sheets" and "worksheets"
- Add-In - OnAction Can't Find Macro & Subs Doesn't Affect Current Wkb
- Hyperlink target should equal parent
- Referencing previous worksheets in formula
- Excel VBA If statement question
- Create a Window without a Form ... !!!
- Help on combining declared variable and cell formula
- Help on combining declared variable and cell formula
- Protecting Specific Cells In Excel
- Create a subtotal if either of 2 chg
- How to use variables to define range
- application run problem?
- Have empty cell unless result of formula isn't value of "0"?
- Auto Fill
- Pivot Tables and Cells.Find
- Selection.End(xlToLeft).Select
- delete rows if value in column D is repeated
- Faster Way of looping through cells
- HOW TO ASSIGN 2 DIMENSION ARRAY VALUES FROM 2 COLUMNS?
- What have I done wrong with this Macro???
- How can I paste formulas only an not values
- Customized VBA Editor Format Save Location
- how to create sub menu items in Excel?
- Find out WHO has a file opened for editing
- Values assigned to variables staying in memory when procedure stop
- Use a keyboard button to run a macro
- Disable Shortcut Menus / Alt-F8
- value between min and max
- Charts not updating in 2002,2003 but working in 2000
- Make a Trial Date Macro ?
- my saveas macro date problem
- To clear apostrophes
- Macros in excel 2000
- Using EXCEL with .NET
- Trouble sorting data by cell value
- Ignore values in a particular row for Grand Total
- Two menus appears in commandbar(Cells)
- Indication outside an defined area
- Closing a spreadsheet?! Please HELP!
- Last Saved Date and Time
- numbers contain hyphens(norman jones)
- sideways sort
- detect and remove apostrophe
- Find function in VBA
- Run a .xla as a independent application
- is this vba code correct or is there a more simple way to do this ?
- keeping a toolbar attached to a workbook
- Formula Help Needed
- Macro to add a variable list
- +++Help me with a loop... I have no idea what code I need!
- VBA - Counting Characters in Cell
- Select cells based on named Range and a column heading
- an excel template to split costs on a group outing
- Code to get a Range RECTangle or PT
- add pages in a multipages programming error 217417418
- Macro to create chart
- Exclude blank cells from a range?
- run time error 1004 on protected worksheet when I try to run macro
- Do anyone know how to implement the function?
- mouse pointer as a hand
- Help with defining a Range
- Accessing the Desktop
- Does Range("A1,B2,C3,etc") have a max number of cells?
- Trouble with copy of xlSheetVeryHidden
- Control Break in Excel
- Refresh spreadsheet from database through ODBC
- saving sheet as new workbook
- I don'T know how to code in VBA
- Please HELP
- Control disabled
- Selection order problem with code for shapes connection
- Removing Empty Rows and selecting Specific Rows
- Copy Sheet Values to new WB
- scroll with wheel mouse
- #N/A - 2 options
- restrict scrolling
- What should my calculation settings be?
- Changing order of embedded charts
- setting print areas, and not printing 'hidden' cells
- Problems using Application.IgnoreRemoteReferences
- Rows & Cols - copy formulas in Col A to # rows in Col B
- Inserting a row in all sheets at the same time
- use Excel2000 as web interface to collect user input?
- Exporting xml problems
- IF Statement not Displaying FILLDOWN results Automatically
- Pass value from form to form
- How do I sum variable rows in a macro?
- How protect with password the access of a spreadsheet ?
- Emailing Workbooks
- Saving Excel file w/o any data
- How to add new sheet with certain name?
- Scrollbar
- Adding a new function to values in the status bar
- Update Code to work between 2 files
- GetObject Function On Text Files
- very hard deleting rows issue
- paste method of worksheet class failed
- XMLData\Mapping
- custom help files
- A MACRO ON SUBTOTAL
- WAV FILE
- Microsoft CDO 1.21 library
- Cell color
- worksheet saveas workbook
- Printing at certain times of a day
- Data Validation
- Macro: MonthName Function, runtime error 424
- Network Drives
- Array error
- Only a genius can help with this 7 Nested If that doesn't fill down
- problem assigning range returned by function, to combobox rowsource
- Currency Amounts
- Selecting and copying a dynamic range of cells
- Check spelling in a single cell AND spellchecking values only
- pass workbook name to sub
- matrixed table out of pivot
- How to find specific subfolders
- Saving Data for future use
- ToggleFormsDesign
- copy passbook data into new worksheet
- Filter Total
- Can I get a hyperlink to run a macro?
- Delete duplicate headings
- Copying ranges
- Macro to import data
- O componente ActiveX não foi registrado corretamente (Erro 336)
- open copy paste
- exit excel within vba
- how to insert a + sign permanently??
- Re: Help with returning a Range
- cells that start with "Slot"
- Help with returning a Range
- pls reply Patrick Molly
- second line
- BeforeSave Problem
- BeforeSave Event Question
- need macro for renaming bunch of excel files
- request code for right align and percentage
- Combo Boxes built with Control Toolbox on a Worksheet
- Converting Excel Worksheet to PDF using VBA
- Excel97: Show UserForm while running code?
- cell color adjustment using vba
- Launch Web Query from Macro
- Suspend Execution
- Paste Array into worksheet
- no way to import user form into vb6?
- Weekday() result differs from one computer to another ???
- Macro to copy text upon entry into cell
- For each next
- how to sum a complete colum on another sheet in VBA
- Can you use VBA forms in different applications (VB app and Excel)???
- How export all Names to another workbook?
- Concatinating cells
- VBA - VLookup ?
- Copy Data into new worksheet
- Retrieve the key (strings) in a Collection
- Macro to force Excel to close after a given timeframe of inactivit
- Excel XML - Formating Dates
- Reinstalled excel, macros broken
- numbers contain hyphens to dates
- How can enable and disable menuitems based on the type of sheet.
- If-then font bold language
- Excel Bug Moves Cmd Buttons When Print
- Error 13 with combobox
- How to use row and column number instead of "E1" designation?
- Code occurrences between rows
- [Help Needed] Custom Lookup Function
- macro that calculates average
- Pivot Table Refresh
- Compare 2 lists and merge
- generating a whole random # from a list
- Insert Quatation Mark "
- Row Conditional Formatting
- what is "\" standard for
- Web Page Printing
- command disabling
- Writing a macro to copy first cell down until next cell has data
- Error Handle
- Alternative to Copy and paste values in VBA
- Drop down - required field
- Tab name matches cell
- Cell strings as cells
- check active cell column
- Insert a number of rows based on a value in a cell on active row
- Changing Macro Security settings does not work
- Forms > Combo Box > Invalid Propery Error
- check if worksheet exists
- Deleting menu (xla)
- macro help for subtotal at top of column
- Find Match and count order
- RE: Regression
- no duplication please
- reporting based on spreadsheet data
- Using arrays to create Combobox items
- checking data
- Filtering a Date Range
- Not to display Macro list
- Application.Transpose and Range of dates/data
- Copying worksheet error
- Proportional Chart
- run-time error '1004': Application-defined or object-deifined error
- opening an excel page without the toolbars
- IF statement with formula
- Is there any way we cna clear everything..
- Excel Conditional Combo Box
- testing whether the ActiveCell is in a given range
- Cannot paste Toolfaces
- Macro help
- Is there any way we can clear everything..
- Advanced Filter - Unique Values
- Macro help?
- Re: Using a collection as a property
- Re: Automatically Send E-Mail
- FileName
- Finding values in hidden cells?
- Using a drop down list -- Autojump to first letter
- DropDown rephrased
- Send Mail - Code to test whether Lotus Notes / Outlook is used
- !! Can you do this !!
- Macro freezes up Excel
- Run a macro on exit
- Filter With VB Code
- using this forum...bookmarks? misc??
- Array for clearing checkboxes
- adding a formula in macro
- Macro Error 3
- Excel print area size
- troubles not bringing in the first row of a ado query to another spreadsheet...
- Help writting a macro
- Remove addin available from list
- Getting chart templates
- Goto Specific Textbox in Userform
- open as read only
- CLOSE ALL macro for XL2K (but with prompt to save for each file)?
- DropDown
- Help !! - Create files using VBA code
- Question of updates
- Copy range from loop
- References remembered
- References remembered
- Excel process doesn't close?
- How to display current row number in fixed cell?
- user form export
- Using an Array instead of a Vlookup to improve speed
- Snap Object to cell borders
- line charts - error in series should not plot (empty)
- Sudoku Program Help
- Control Array Help...
- Help With Forms
- Color of worksheet Tab
- On Error Resume Next ?
- Re: spellnumber twice
- On Error Resume Next
- Update Format of cells in multiple worksheets
- Undo Borders
- Macro creates additional datafiles when saving copies of workbook
- Is COM over? - what are my options?
- CSV File - Date Formats
- Combobox with a dynamic list
- Unusual Sharing Error???
- Unusual Sharing Error???
- Using "Find" in a macro
- Newbie - Input Form Question
- macro password
- lookup for repeated PN
- Question
- Select row by first cell's contents, then past in values.
- Looking up a country name and copying to column 2
- Runtime error with sheets.add
- Embedding Excel in IE and Firefox
- What is fastest for this? Small VBA or many worksheet formulas...?
- Code to show current hour minute and seconds in a cell
- Avoid Control Cell changing.
- Re: Migrating to Excel 2002
- Sorting Data before close in shared workbook?
- Thank you for sharing - VLOOKUP array
- Dynamic PageField Items
- Linking to an active cell
- Interpret HTML in excel worksheet
- How do I,implement a recurssive loop using Microsoft Excel ?
- Populating listbox based on two (or more) criteria
- combing cells with same data
- Help on Coumting Unique records
- Lables that Change with Names for Games...
- Write Line problem when writing simplified chinese characters
- adding & Subtracting date & time in VBA
- VB code for Moving Rows up and down
- auto Refresh MS Query SQL Server
- Replace characters from cell values
- used range between two cells...
- Dynamic Selection Find Function
- Newbie : Oracle to Excel Part 2. RDO or ADO?
- question about ClearContents
- a weird question
- LeadingZeros\CSV
- How to specify a tab character in excel vba...
- Cell Types
- displaying yy instead of yyyy
- Re: "Compile Error Can't find project or library."
- cell splitting
- Load UserForm1 on sheet tab selection
- Re: Phantom Of The Open workbook.
- Re: Using If and Validation to turn a cell on one way or another
- Re: how do i start excel and have it use a template automatically?
- Re: Save workbook needs to be added Please
- Question
- call a VBA function for data validation?
- Newbie : Oracle Data to Excel
- Number of elements in an array
- VBA to Adjust an Excel Chart Embedded into PPT while in SlideShow
- Populating Userform ComboBox with worksheet names in XL2003
- xl2003/vba and Acrobat 6.0
- Compare two sets of data
- Publishing to web..Macro issue
- lists without listbox
- Detect Value change of a Cell
- Transpose Function not Working with Long Array Elements
- InStr
- How do I restore the LookIn, LookAt, SearchOrder in FIND
- A rude awakening to STATIC variable
- opentext command
- Excel VBA Help Gripe
- Query from ms sql server question
- User Interface in VBA
- Autofilter - Applying changes
- copy from one workbook to another?
- Code to Delete Empty Rows in a Word Table
- How to Advance a For Next Loop prior to the Next Statement
- Compact
- there is any limitation for text field when using ADO +SQL
- thanks very much
- How to attach a code module to a group of workbooks?
- How to stop template worksheet visibility
- Define Page Setup for whole workbook
- Create Summary Sheet
- Checking for changes.
- Display message: Processing....
- Copy range from one wksheet to another
- color row based on table
- Copying Range Names and values from one tab to another
- Macro error 2
- Filecopy - Do you need to specify Destination Filename?
- there is any limitation for text field when using ADO +SQL
- How to set formula with cell reference with a variable
- Check for date
- Retrieving Exchange Rate Data from a Website
- Disabling the personal Workbook?
- Problems returning Collection object
- Can't set cell value with VBA
- intersection with linear range as true argument
- Run a MS Access Procedure from Excel
- OT -Google group support
- excel cell placement by cursor
- Copy range from one wksheet to another
- Apply LEN result to string?
- Table Intersection
- Deleting a sheet
- Calender problem
- optimization
- button with hyperlink properties
- Copy and paste from ie to excel using macro
- Insert a new row with data from previous row
- Strikethrough Red and Underline Blue Macro
- Protection property of the VBA project
- Re: macro_change font style
- dialog box for active cell task to speed repeditive task
- macro_change font style
- Please Help With Chart Code
- Splash screen
- Update VB refs on insert cells
- How do I embed a commandbutton from VisualBasic into Excel
- sayı biçimlendirme
- toggle box print if value is true
- Error 57
- how to using Function update cell value
- Optimising portfolios with solver?
- Formatting text of Forms.OptionButton (radio button)
- work with ADO or DAO
- update older workbook
- Run macro automatically when a cell in a dynamic range changes
- Copy conditional formatting
- formula for inserting rows
- Excel macro takes focus from other programs
- Help: VB Excel Problem
- League Ladder refinement of Sorting.
- Link problem with named range
- Add Next and Previous methods to CustomViews collection
- Update data at other sheet
- Daily Interest Calculator
- How to ascertain path of file in adjacent directory hierarchy
- VBE(Visual Basic Editor) Keep focus in VBE
- vba: Loop to load webpage
- Text to Columns
- Excel control layout
- Reading to a 1-D array...Error
- Why my selection is lost with MsgBox?
- send group emails
- Use same On Error twice
- vlookup question
- Excel Browser Hidden
- Lab Management Program
- Hide a series
- Code does a continous loop
- Tab name = Referenced Cell
- String concatenation
- Weird result
- Macro keyboard shortcuts
- Is there a way to do this on a worksheet?
- RefEdit control
- Microsoft Calendar Control French
- Delete Entire Row - Date
- RefEdit control
- Macro Help - Bolding info
- Regional options support for currency
- "one time" Link Cell
- Nesting Find and FindNext
- html form to update excel file on server.
- Copy range from one wksheet to another
- Macro help to move around spreadsheet
- Full path in taskbar
- Help: Nested If/And Function formula to VB code
- Excel's ODBC driver's field limit
- SheetSelectionChange Event find out previosly selected cell
- SheetChange event restore old value
- PivotTable CurrentPage
- difficulty with permutations, please help!
- Remove ThisWorkbook code via VBA
- Concatenation in VB
- get a list of sheet names onto a listbox on a form
- assining a varaible to the value in another sheet.
- automated print to pdf
- Form.Show problem
- Help with a Macro
- come on, somebody must know how to do this
- Re: Get macro to copy one row from excel to a text file. Possible?
- read data element from XML file
- VBA - averaging the difference of 2 arrays, ignoring blanks
- .find =< function
- Macro inside of Macro
- ComboBox to show a range
- Macro fails when not performing "step into"
- Looping with Hidden and Protected Sheets/Ranges
- How create a nonblank source for a verification list with a mix of filled & empty cells?
- Excel is RightToLeft?
- Missing Command Buttons
- Macros inside of Macros
- Capturing timed Data with RSLinx
- Anchor chart source data?
- Copy via code from a dynamic range using offeset
- Looping issue
- Use Excel as DCOM object
- Time Formating
- extract parameter VALUE form a user-defined function..
- Changing the comma for a semicolon when creating a CSV file
- Auto_Close() not running
- find a value
- select a range through last cell question
- Please help. I beg!!
- Download broken
- Command help
- How to give escape sequence in Excel string literals...
- Registered Type Libraries
- Insert SUM Formula using VBA (Range Varies)
- Hide/Unhide column based on cell value
- User proofing an entry
- Hide row loop
- Looking for an event
- Undo Acting Weird
- poulating multiple fields
- ExcelCharts with c#
- interfacing Excel to nonOffice application via DDE
- Find Text File Import Cell
- FORMAT CELLS
- Type mismatch on If rng.Value < "0" Then
- New Object - programm code
- Programming code to new object
- Protecting New File
- Displaying date/time!
- Counting cells with a specific range
- Auto filling using macros
- MERGE CELLS
- Pivot Table Events
- Excel Objects error in ASP pages
- Selection Data from a Range
- Checking for blank rows in database - with apologies to Norman Jon
- find specific data in row and select and copy entirerow
- Range Object Misunderstanding
- toggle button text colour
- Help needed to solve printing error
- how to display a found xml's and its bytes on its rows?
- Finding the last row in a sheet in a closed workbook.
- Help with a copy function
- logic problem: help needed
- Creating a new Excel chart type
- Chart option to suppress zero values??
- using excel with asp.net
- Read SourceData from Chart
- Excel Forms-Can i set the modal property?
- Security Signing of VBA Code
- edit certain hyperlink after a worksheet is protected
- how to get the formula shown in linked cell's names
- Password Setting
- How to get the name of a range i deternimed
- Negative Currency
- can I use WorksheetFunctions ON arrays from VBA??
- Show picture with transparencies in Image
- Changing Series Name
- Need help with complicated use of count background color of Cell
- run code on opening workbook and apply code to certain sheets
- Code to delete a Line in a another code
- Parsing a text file to a excel or word form
- Auto Open
- smart tag tutorial
- Looping Checkboxes on Worksheet
- How do you look for two distinct patterns (RegExp)
- Help in writing an Excel equation
- get subtotals results as a variable
- Combobox ctrl on worksheet
- Excel Form annoyance
- Progress Indicator
- Programmatically add shapes to a selection
- Stop Excel from updating external links when copying in VBA
- How to test if a DLL (library) exists
- Vlookup but also consider equal to or greater than a valu
- Header and Heading Problems
- Waiting...
- Multiple Lookups
- VBA output to text editor
- Variable problem
- smart & tidy code for many checkBox_Change()
- Two Feilds in a combo box
- code loops 1024 times not what i ask
- What is wrong with this?
- Newbie Q: What does "On error goto 0" mean?
- newbie question
- Select row (with offset) from VB formula result
- Gridline Question
- Identifying the selected Shape
- Export/Import Question
- if condition is true than send info to another work sheet
- VBA - Selecting Based on Criteria
- VBA - Set
- Loop Training: Password Finder
- Moving a Variant to Array
- Excel conditional formating
- Personal workbook opens and messes up workbooks(i)
- Send Keys
- Combo Box or List Box colour
- colorindex = xlnone on condition of month of year
- web query
- Test for first time a workbook is opened
- Automatic tab name change
- graph function
- Merged Cells Value
- sumproduct indirect
- Patse Rows from one Sheet to another with a Twist
- Unable to sum range variable
- Changing text size in option buttons on a userform
- Purge file of VBA code and macros.
- Dialogs SaveAs with different directory
- Concatenate
- how do i activate tabstop on excel?
- Making sure that cells within a row in a database aren't blank
- Don't display row if cell value is greater than zero
- Can't paste the second time around
- VBA to change Button Macro assignment
- Compare,copy and paste if true
- Scope of Subs?
- excel / word problem
- Showing criteria in custom filter
- Sort a multi column listbox in userform
- One Excel Form for All worksheets Lists
- Substring check within VBA
- VB simple Questions
- 2 small problems
- Vlookup and date format problem
- Worksheet menu bar
- Help with Count Function
- Repost Excel Server Problem
- How to change the font size of Validation List?
- Validation List - Word and Numeric Association
- Defined Names
- Reading RGB background color from cell
- Array Formulas. Hardest Question Ever. PLEASE HELP
- How to sum PNs/Quantities overmultiple worksheets
- Vlookup
- How to run an ADD IN using VBA
- Problems with For Each
- copy website to worksheet
- ADO / Excel & Access: User ID and Password
- Running Excel macros through DOS
- Invoke exclusive excel process on opening this file
- Msg Box - User Entry Validation
- Error when closing workbooks after running .net code
- Add to a cell if a row has a date and a column has a department
- Countif
- Macro Use Counter
- Combine Columns in Macro
- Combing and Adding Data in Multiple Rows (Macro Needed)
- Visual Basic Macro(VBA) for a password protected file?
- Checkcell macro problem XL97
- Get External Data Macro
- run time error '424' when I run this code
- can we get the cell address from the name.
- combobox
- Pop up warning message!
- # of letters in a string
- Macro to replace a VBA module?
- Iserror change cell color
- Group values and sum using loop
- Copy Row and row above to new sheet
- Problem when hitting an empty cell
- save sheet as "sheetname.txt"
- RefEdit updating Current Cell location
- Finding a string within a cell value
- worksheetfunction.vlookup error
- Combing and Adding Data in Multiple Rows
- moving to next worksheet
- VB backwards compatability
- Sumproduct Problem
- Delete from named range based on Combo Box selection
- Pivot Table - Trigger event on drill down
- unzipping files
- Reposting to get some answers......
- Passing Strucutres from VBA to DLL and back
- User Defined Function
- UsedRange Count for each column
- Date in VBA Code Printout
- macros or input box
- Error in Formula
- Error in Formula
- Incorrect Formual
- Workbook_BeforeClose change event not running correctly
- Qusetion about the function
- Help please with coding a macro
- Function which adds all green cells
- Need help importing a text file
- Checkbox macro
- Conditional Format? - color if cell is modified by user
- Send Email from Excel
- Printing Problems with Spreadsheet
- Using VB6.0, check if Excel / Specific Excel Programmes are open
- compile error problem
- Selection as String
- VBA to extract web data
- Get macro to copy one row from excel to a text file. Possible?
- RemoveLeadingSpace
- Online reference available for x-fering functions into VB?
- Copy table information and paste sorted based on specific field.
- SendKeys command to select an OptionButton
- Running updates reports automatically
- Registry Key for Macro Security Level?
- Find a specific text item and manipulate cells surrounding
- Really Easy But having a mental Blank
- csv file with special separator
- speed up printing job
- Sorting with variable number of sort fields
- Custome menu question
- Range Manupilation
- Macro Errors
- Get Stock Quotes Via Cell Look Up
- Conditional Formatting
- collect data from some files
- Macro Help!! 10 mins of your time need PLEASE!
- vbok caption
- chart help please
- Nesting Problems
- Running Excel with VBA on server and calculate
- Macro to call a file that has a auto open macro in the file itself
- code to add a name to the names collection and assign a reference
- How to check whether cell has #REF ! error?
- Help Needed w/ IF statement using dates
- Find keyword and insert hyperlink to cell
- vba webbrowser HELP!
- Application.GetOpenFilename vs Application.Dialogs(xlDialogsOpen)
- To Delete the specific rows when blank is found on column A
- Print to PDF Driver
- in Excel, how do I set up an alert popup when the file is opened?
- function need to return value and update one cell value
- macro for import of csv .txt file?
- ParseCellData\Copy
- Disable 3rd party macros at startup?
- calling all pro's!!! macro that can modify dates in odbc connection to mysql
- How to batch create / generate and print invoices from Excel data?
- How do I set up an APR calculation in Excel?
- Clear cells with #N/A
- What function in a formula will pull the text used in a Tab name?
- Query Refresh message box on opening
- Closing a workbook and printing a non-active page
- VB simple questions
- Automatically overwriting files
- Error inserting formulas into a range object
- formula
- macro only prints out first and last line of document
- excel chart export error runtime 1004
- how to move the pointer in a filtered selection
- Re: Formula Help Needed - Tracking Responses.xls (1/1)
- I want to use a oleDragDrop in an Excel VBA Userform
- VBA programs
- Range issue...
- Data Validation: items in one list relate to items in another
- Moving files between folders using VBA in Excel
- Macro - worksheets to new workbook
- replacing help
- Launching a macro by double-clicking on active cell
- copy heading to each row
- Toolbars not appearing
- Mod Function Returning Long
- Range manipulation
- temporarily disable on-load virus scan
- Arrays and cell values
- copy heading to row
- Create logical custom drop down list
- portable code...
- create detail from summary data
- Database maintenance and Database Administration?
- New project, not sure where to start
- should I use Excel or Access fo this?
- Where's the Documentation for the APIs?
- offset?
- goto function
- operator statements, shorting when reusing one of the statements?
- password protect
- Macro which inserts a column and cut and pastes data
- Macro which inserts a column and cut and pastes data
- Range as a database
- validation - how to show the second column
- Selecting the active row
- Basic Error Checking in Excel VB
- Turn filters on in multiple sheets
- Need help setting a range
- How do I merge multiple worksheets in excel ?
- PageSetup Class
- HorizontalAlignment Error in Excel 97
- Combo Boxes
- Calling in data from a selected cell
- Automatically update all worksheets
- Save failure after VBA macro
- Specify Start Location for GetOpenFileName box
- Evaluate and execute a string
- Enduring Variables
- find first cell not equal to current cell
- ADODB SQL help
- User name button access.
- custom function
- Looping until empty column
- Odd numbered Range Names ?
- Forms: Radio buttons
- Macro to apply several conditional formatting criteria
- prevent all addin loads on start?
- How to get custom dialog box when exiting Excel Spreadsheet
- Multiple Deliminators
- Orientation of Axis Lable in Pivot Chart
- using Text to columns in a macro
- ADO Internet Recordset Retrieval
- Macro to add cells from unknown number of files
- Accessing Property of Custom Type
- Deleting Menu
- exchanging X and Y in a plot
- How can I set Custom DOC Properties in Word from Excel
- Remove not required sheets
- Office Web Components 11 - Excel 2003
- work with two maps
- Protect current VBA Project?
- Help with an Indirect formula to reference sheet names
- Version Incompatibility
- Dynamic validation list
- VBA code to check if a custom chart exists
- Excell cuts string when copying
- Page breaks
- Webqueries and variables problem
- Formula Help Needed - Tracking Responses.xls (0/1)
- Need Help with marco and autofilter
- Filtering a database then copying visible cells based on CurrentRe
- How to past formulas without updating external links
- VBA form basics
- VBA form basics
- Open file, copy field and paste into an Excel doc! - Pl help ..
- Open file, Copy a column and paste this into a new Excel doc - Pl
- Fill down formulas without activating the sheet
- Copying named ranges from one sheet to another
- Challenge to pro's
- globally catching any error event?
- Carriage Return from HTML file
- Second window open as a sort of dialog
- time specific macros
- vba routine for sorting an array
- Macro syntax difficulties (long post)
- stop excel file opened as read only if already opened by another u
- Remove text from Comment and paste into cell
- Macros for Protect/Unprotect all sheets in a workbook
- Excel VBA to email a hyperlink from a textbox
- Conditional Message Box
- xla written in C#
- Intercepting Save and Exit menu command in Excel
- Delete Rows when Blanks are found in Column A:A
- button for changing language???
- addin and main menu disappears
- VB dll, Excell and matlab
- Inserting 10 rows after a specific row
- Pivot Tables & not printing blank rows (revisited)
- EXCEL+DATABASE_M3-LITE-Free
- Display formula in all worksheets
- como encuentro un valor de una tabla dinamica con buscarv?
- Data Entry Form
- MsgBox in Access Automate Excel
- Re: How to open comma delimeted files automatically
- Enable OLAP Pivot Table in Protected Excel 2003 Worksheet
- Can you schedule a workbook to open?
- Help pulling data from web page
- filesystemobject not defined??
- Capturing Unknown Subfolder Name
- Code fix need help please
- Looping through control
- Find&Replace text in Comments
- Loop through rows using a wildcard.
- Re: Pass switch to Main procedure
- Slow macro
- Attaching an Outlook Library programatically
- How to got the position of a cell/range in pixels (from the left-top corner) ?
- Getting data from web page
- Code to write out all lines of code
- Calling a cdecl DLL from VBA
- Run a stopwatch for time then execute code
- Msgbox in Excel from Access (Correct)
- Out of memory
- Msgbox in Excel from Access
- Convert "Month" to 1, 2, 3...12
- After Entry - Lock and Go to Certain Cell
- Re: my code is adding single quotes
- Using a timer
- change column width based on concatenated cells
- Re: my code is adding single quotes
- Protecting or Hiding VBa Code In a Workbook
- Re: Please help.. VLookup Macro
- Re: how to update a Batabase with data from another database
- square chart with excaclty defined dimensions
- Problem opening Excel file > 1 time with embedded Word objects
- can a macro imitate autofilter
- Saving File with information from Text Box
- invalid sheet name problems
- short cut keys work- run macro does not
- How do I run WMP as an ActiveX object from Excel-VBA
- Macro for creating a chart
- Functions not working in Excel 2000
- Delete a module
- For Next help? I can't figure this out.
- Removing rows via macro/VBS script
- Application.Undo failing with specific order of events
- Excel - Copy and append Data
- Need macro to updated column C's width on 1000+ workbooks.
- Working with and adding Menus?
- Jump to next line in box...
- Error Message: Serious Error
- Addin loads but functions don't work
- Can I create a add-in in Visual Basic.net Standard 2003?
- Require password to execute macro
- Formula to reference sheet number base on cell
- Find and Several Sheets
- Pull down menu in grid
- How to get formula type in VBA
- Re: square chart with excaclty defined dimensions
- Performance long/single comparison vs converting single to long
- Conditional Formating
- calling a macro
- Dynamic Range Offset causing problem with this code
- Event Listeners on a protected chart
- Automatic update of Financial Spreadsheets
- Did user Save?
- Alter data or start macro from a date formula
- First MsgBox. Need help
- Real Time Macro
- Is there a workbook open in Excel?
- "running" page
- Repost Excel Crashes on Workbook close!!
- VB macro - Nested Calls ( Parameter Passing )
- Can protect worksheet then workbook but not Protect and Share in code
- How To Run VB Macro from C/C++ exe
- Passing objects by value instead of by reference
- I cannot do the oopy paste command in multiple selections in the .
- Re: Please help.. VLookup Macro
- Date stamped comment box
- "Save As" VBA code errors
- Project is Unviewable
- selecting column down to variant cell
- Incorporating DATE into formula
- Push the button
- Data Valiation and Excel Data Forms
- Minimizing a workbook or worksheet
- Listbox data disappearing (from screen only)
- VLOOKUP in another workbook/Access database
- Paste code running extremely slowly...
- Excel to Access using VBA
- Msg Box Help
- Interactive web page
- Calculate Rating
- Using classes to store user credentials
- Converting Text to Values
- Code needed to print multiple workbooks
- Saving different files based upon data in particular column
- Userform and screen resolution
- VBA - Large Arrays
- Combine Two vba Lines(If Condition + Vlookup)
- Environment Variable
- extract filename from full path
- whats wrong with my macros
- Array in VBA
- Excel XP VBA Array formula
- Show and Hide Forms
- writing a formular into one cell of an excel sheet
- macro to save a values of a cell in a new sheet as a new row
- User Form
- Bizarre macro problem
- Excel and the web
- HOW DO YOU SET UP A CONTENTS PAGE OF EXCEL DATA
- Macro to copy filtered list to new workbook.
- Should we use VB.net or VB6 to create an add-in?
- MousePointer
- Worksheet names to variant arrays
- Crystal report loading problem
- Private Sub SendMessage ...
- Unhiding hidden rows in a worksheet
- General ?? regarding Macro or Module size in a spreadsheet
- Find and write
- TextToColumns Method - Delimited by Double Spaces
- Data From Excel Range To Existing Access Table
- Names Problems
- DIM problem
- Workbook Names
- Shell function and error trap
- VBA type mismatch error
- How can I include a " in my string?
- Enable OLAP Pivot Table in Protected Excel 2003 Worksheet
- runtime error '1004' object '_Global' failed
- Worksheets Names
- Calender Problem
- How to process selected rows
- Changed location of Add-In file--can't be found error
- Hide worksheets on Workbook_Open
- copying data from Powerpoint to Excel
- MultiColumn ComboBox
- How to lookup and sum multiple values based on multple columns
- Extract line and copy
- Change hyperlink address
- VBA equivalent of match
- using strDb to connect Excel to an FTP site w/password
- adding a cell to a cell keeping a running total please help
- Macro Help
- Run Excel Macro through Batch file
- combobox from forms toolbar
- How do I open a file from a Network drive using Excel VBA?
- Button on Chart
- Help with activex listbox control
- ActiveX Listbox Control
- Auto Fill Entries in a column
- Putting a formula in place one time for the entire spreadsheet
- Need VBA macro to return active cell address (R1C1)
- Make a macro run on rows/columns only if data is present?
- Shuffle the cells!
- Incorrect formula created
- Arrow right code?
- Concatenate with Underscore in formula
- trouble with advancedfilter of date column
- data find and add for summary
- how to code variable reference?
- Find in a loop
- Created another spread sheet if SSN is not match
- how do i write and implement "pop-up" help for a user defined func
- Retrieve Excel Cell Range into SAFEARRAY (VC++)
- Importing file handle name with pasted data
- Error trying to select a cell
- Computer Time Zone
- how to select current range
- file folder macro's
- excel - On hyperlink click find what cell or cell value is
- Changing icon
- Error Handling
- Excel crashes after closing workbook
vBulletin® v3.6.4, Copyright ©2000-2024, Jelsoft Enterprises Ltd.