PDA

View Full Version : Microsoft 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 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 [229] 230 231 232 233 234 235 236
  1. Comparing a value to an array
  2. Pivot Table or Table Summary Help Please!!
  3. Re: Macro to Print to a specific bin
  4. Creating a Sendmail message
  5. Question about user forms
  6. protect formulas
  7. Saving Registry variable to ini file
  8. Enabling a Embedded Control
  9. Excel.Application Instantiating Different Versions
  10. Excel 9 XML file open
  11. Re: Cell = cell value AND format
  12. Macro Security Error No Macro
  13. Forms
  14. selectign a range
  15. Re: UserForm Calculator
  16. OT: Product Support Services - Microsoft Security Bulletin - MS03-039
  17. Re: Need to detect cell shading
  18. Adding a row to a subtotalled range
  19. Re: Need to detect cell shading
  20. Re: Conditional Macros
  21. Programmable Web Query
  22. VB Code to Add Comments to Cells from Several Other Cells
  23. Re: Enabling a Embedded Control
  24. Hide Macros from Users
  25. Re: Cell = cell value AND format
  26. Pivot Table REFRESH Flaw -- Saves Old Data in Selection Area AFTER REFRESH
  27. CRUCIAL: Creating a Custom list 40,000+ lines????
  28. Re: Switching userfoms
  29. xlCoerce on multi-part xRef
  30. AdvancedFilter Criteria question
  31. Macro button
  32. Sequential numbering on a form
  33. Re: Recordset
  34. Re: Operating system
  35. Re: does a file exist?
  36. Re: Operating system
  37. Property Get with argument
  38. Re: Conditional Macros
  39. Pesky Ckeckboxes !
  40. Re: Calendar
  41. Application.GetOpenFileName
  42. file names
  43. Saving a file in a macro
  44. Dropping leading zeros in character fields.
  45. Re: find a cell, jump to next roll and clear all cells
  46. Write a function call into an Excel cell from VBA
  47. VBA Query
  48. Combo box
  49. File System Object
  50. Load a Userform
  51. overriding the print button and File/Print
  52. Selection of range
  53. Re: Thankyou
  54. Re: Sorting players of cards
  55. macro problems
  56. .dll problem
  57. Use of ROW() in array formula
  58. transpose/rearrange data
  59. Does formatting raise an event
  60. mscal.ocx
  61. Importing from MS Project -- problems with commas
  62. Re: Called macro runs twice in excel 2002
  63. Re: Simple conditional macro
  64. Re: StatusBar Msg?
  65. Lock cell in ASP
  66. Change to SQL of Pivot Table on shared data
  67. Re: AddIn
  68. Sending an Outlook e-mail due to a condition in a cell..
  69. screenupdating command ignored
  70. Re: VBProject events?
  71. Chart embedded in UserForm
  72. word table
  73. mot de passe (programmation)
  74. Re: New to Macros
  75. [Help!] CSV(s) --> xls
  76. MsgBox saying Excel is calculating
  77. Cannot Paste formula to cells via VB
  78. DV error message with a cell value
  79. Counting 2 Separate Columns With Unique Data
  80. Numeric data on forms
  81. Excel Programming
  82. searching for values in excel and copy them to another worksheet
  83. How much data could be entered and search trough
  84. Excel Programming.
  85. How to call SolverSolve portably for Excel XP and Excel 2000
  86. Probelm with Data formatting
  87. Password feature in command buttons
  88. How To Change rowhight or columnwith long measure?
  89. Re: Clearing the 'Recently used file list'
  90. FLOATING BOX
  91. VLookup error message while accessing range in closed workbook.
  92. Excel Programming in VB
  93. Limit input in a textbox
  94. Delete Pivot Table
  95. check if a worksheet exist - VBA
  96. Appending Excel file to an Access table
  97. property in objectplaza
  98. delete all EMPTY cells along each COLUMN
  99. Excel 2002 VBA App fails in Excel 2000 Environment
  100. xl97 and Worksheet_Change event ?
  101. what is the difference
  102. EXCEL As VS.NET Math Engine
  103. Re: PASSWORD PROTECTED FILE
  104. trapping keys when pressed by user
  105. trapping keys when pressed by user
  106. trapping keys when pressed by user
  107. trapping keys when pressed by user
  108. trapping keys when pressed by user
  109. Re: How to keep a Userform available while the user interacts with a spreadsheet
  110. How to detect an entire column/row delete event?
  111. VB app and Excel: Deployment options?
  112. Copying varying values down through rows
  113. VBA to save range as a HTML fife
  114. Re: how to enhance this macro (really short)
  115. Re: User defined function & formatting
  116. Turn Button On
  117. DLL - Using a DLL to update cells in excel
  118. editing text in contents of joined cells
  119. Re: Copy cell value from another worksheet
  120. Creating FileSystemObject
  121. Getting data from one spreadsheet to another
  122. Controlling Outlook from Excel Using VBA
  123. XL:2000 - VBA Sum Formula
  124. Re: How to get User input from Userform Text box
  125. Trying to add a row after the last value and count
  126. Re: Coding Assistance
  127. Over-Eager code is pasting 3 times
  128. Creating mail message with a button click
  129. unable to create embedded object on a userform
  130. What have I overlooked?
  131. MsgBox and User Input
  132. Passing Parameters through OnAction
  133. Reading a cell into an array
  134. Data I have Excel 2002 as part of Office XP Standard. I tried alidation, I think
  135. Re: Retaining text formatting in TextBox
  136. How to get Maximize and Minimize buttons on Userform
  137. Re: VBScript Automation of Excel Spreadsheet Sorting & Filtering
  138. formula in one cell needs to use a figure from another cell but it crashes
  139. Macro for Sorting
  140. Re: How stop the navigation to other cells?
  141. Re: temporary cell format event
  142. Re: testing if a sheet is protected
  143. Checking if a workbook is shared
  144. Maximum text length?
  145. Re: How stop the navigation to other cells?
  146. Pivot Tables - Refreshing with data??.....
  147. add a menu bar when document opens
  148. Re: Toggle ShortCut Key sequence
  149. Re: Deleting blank lines in a range
  150. Re: Excel macro
  151. whats wrong with my array?
  152. Re: Using Network folders
  153. Re: Deleting blank lines in a range
  154. adding items to combobox using "Tag" control to limit
  155. Validation against two criteria
  156. Re: A Problem with ethernetdirectory
  157. Re: Please help !
  158. Re: Excel macro
  159. Runtime error '327'
  160. Re: using mid and find
  161. Navigating cells in VBA
  162. ComboBox.Value To Range
  163. Retrieving Source Data From Pivot Table
  164. complex Cell
  165. How do I programmatically know the current cell's address
  166. Could one of you experts answer an easy question...
  167. Row number
  168. Re: error 1004 - metod Copy of class Range was failed
  169. Find button on worksheet
  170. Re: time serial number problem
  171. compare values between workbooks and copy values
  172. Excel Vba Books????
  173. Visual Studio Tools For Office(VSTO)
  174. Autoexecution of a Macro
  175. OWC10, XMLSS and Excel97?
  176. VBA Number Rounding
  177. Class and object persistence
  178. Changing Reference Dynamically
  179. SaveAs without name change
  180. Re: Dynamic DMax criteria in VBA
  181. Error Message
  182. Protect sheet with filter
  183. Problem with formula - Taking too long for calculation
  184. Disable commad bar options
  185. Protecting data rather than certain cells
  186. finding duplicate data in multiple spreadsheets
  187. format values in MsgBox?
  188. combobox
  189. Date Flag/Trigger
  190. Re: Excel Programming in VB
  191. Re: Get Object
  192. Print2PDF with "ChartTitle" as name
  193. How Is This Done
  194. Image in a header
  195. Excel Programming in VB
  196. Thanks stephen
  197. Allocate Files to Sheets and Build a Master Sheet which Summarises All Sheets
  198. Re: library not found?
  199. Re: SheetChange event starts before .calculate finished
  200. Number of days between dates (Calendar)
  201. Error
  202. generation of word file
  203. Writing "shapes" to disk file
  204. time limited add in
  205. MACRO Relative Reference
  206. Use Excel as Maath Engine for VS.NET
  207. Re: getting same save-on-close macro to work from different networklocations
  208. Not-so-simple Find task
  209. Re: Include html coding in Excel VBA
  210. Re: Excel references in another program
  211. Include html coding in Excel VBA
  212. Auto load macros
  213. Re: Excel references in another program
  214. setting formula property
  215. VB code to find the selected cell
  216. what's wrong with this sub procedures?
  217. activesheet - select rows
  218. auto copy
  219. Drawing toolbar appears when it shouldn't.
  220. Re: FormatZipCode
  221. Gurus: What's wrong with this code?
  222. text conversion in cells and setting color in rows.....(excel 97)
  223. Macros - How to tell if cells in a column are blank?
  224. Need code to protect worksheets - amount of worksheets varies
  225. Re: Sendkeys to run Find
  226. Re: Maximum file size
  227. 'Undefined Function' Error in Microsoft Query
  228. Defining a Variable
  229. How to get rid of macros
  230. No FUNCRES.XLA
  231. adding to an entire worksheet
  232. VBA forms
  233. Re: SheetChange event starts before .calculate finished
  234. Re: MsgBox does not halt execution of code
  235. Re: Pivot Table Question
  236. Re: Pivot Table Question
  237. sheet navigator
  238. MS Query Date
  239. Finding specific column values in a variable row
  240. Check no. of records have copied correctly
  241. Format of a textbox on a user form controled by a spinner
  242. Re: Hyperlinks open in new window
  243. How do I search thr'o column and put unique values in differnt sheet and sum corresponding values in
  244. Command button to search column
  245. Compile Error
  246. command line script for printing MS Excel 2000 document.
  247. Increasing Conditional Formatting
  248. Error 2042
  249. External Datasource Problem.
  250. text box displaying time?
  251. Compiler Error - Named Argument Not Found
  252. Re: accessing data from an array
  253. Disabling the enable/disable dialog box with Digital Signature
  254. How to loop through cells in macro
  255. multicolumn Listbox and textalignment
  256. Application-defined or object-defined error
  257. Data validation question
  258. Find a string in excel
  259. Hide the Excel screen
  260. PREVIEW IN USERORM
  261. Re: Application-defined or object-defined error
  262. Re: Dynamic Label for Controls
  263. How do I run a subroutine on a worksheet
  264. Pivot Table Data source
  265. Print 2 PDF with "ChartTitle".pdf as name....
  266. End of File Question
  267. Re: excel show #NAME? when use a addin function
  268. hide rows if cell=0
  269. Problem linking with SQL Server
  270. excel output to outlook?
  271. how change selection when msgbox dialog box on screen?
  272. Re: Protection
  273. Using a string to point to a form object?
  274. Running other applications from Excel VB
  275. Close and Exit Excel
  276. How turning off screenunpdating with the solver???
  277. find a cell, jump to next roll and clear all cells
  278. Automation Error: The Object Invoked Has Disconnected from Its Clients (Excel)
  279. Re: Problem linking with SQL Server
  280. Open Excel from access
  281. Automation Error: The Object Invoked Has Disconnected from Its Clients
  282. Dynamic DMax criteria in VBA
  283. Re: macros disabled
  284. Re: macros disabled
  285. Userform - CommandButton_Click question
  286. arranging charts and visible screen size
  287. Display Alerts
  288. Close or Exit application
  289. declaring an array of CheckBox's
  290. Re: Programmatically addressing worksheets - painfully stupid question
  291. Pocket Excel
  292. Re: Close and Exit Excel
  293. capture users Application.OnKey
  294. Problem with auto list members in VBA
  295. Total number of green cells
  296. Look Up
  297. Re: Opening an filling e-mail from excel
  298. specifing default folder with GetOpenFilename
  299. Error indicators in cells
  300. Re: !!! Newbie VBA question about array's and listbox !!!
  301. Re: Using VBA to get all my charts to be same size
  302. Re: Opening an filling e-mail from excel
  303. Re: AutoFilter Dropdowns Missing
  304. Combo Box Value
  305. Group dates by month
  306. Autoreplace.ReplicationList in Windows NT
  307. Running apps from inside excel
  308. Excel Macro error
  309. How to get back lost Menu
  310. Curious use of ByVal keyword in VBA event
  311. textsize on comments
  312. Conditional Formatting the whole column
  313. creating a spreadsheet
  314. Numbering sheets
  315. Pivot table
  316. Updating Pivot-Tables
  317. Re: CommandButton.Caption
  318. Userform
  319. Creating buttons using VBA
  320. Conceptual Problem with DAO/ADO Recordset
  321. Updating Word Excel Links
  322. copy / paste values for certain range
  323. Vlookup with multiple matches
  324. Count combinations
  325. Re: variable vlookup
  326. HTML coding in Excel VBA
  327. Porting 16-bit to 32-bit
  328. Re: What events can be captured in a Class Module?
  329. Individual point symbols?
  330. Incrementing cell references in a formula in steps
  331. Multiple instances of the same file being opened
  332. Still needing help with Matching Criteria
  333. Re: Code to edit directly in cells from userform
  334. Re: Run word document with api
  335. Re: Code to edit directly in cells from userform
  336. Tab name in a cell
  337. To print multiple selection and how to back VBA module pasword
  338. Re: HELP with spreadsheet matching
  339. Macro question: how to copy information from another workbook.
  340. listbox
  341. Re: Run word document with api
  342. Re: Neet to get range of newly added QueryTable
  343. Calculate top 100 values in non-consecutive rows
  344. 2000 vs 2002 xConstants
  345. Reference to add-in required in spreadsheet if the add-in uses a DLL?
  346. Re: VBA rookie question - listbox and GOTO
  347. Available printers in a dropdown-combolist?
  348. Having a hard time with listbox
  349. Code to color selected ws cells
  350. Highlighting or Selecting TextBox entry
  351. Combo box help
  352. Re: Macros to format selected item on a spreadsheet
  353. Get code from a corrupted workbook
  354. Error Indicators in Cells
  355. paste is too fast
  356. Can blank cells created using empty Double-Quotes not be empty??
  357. Removing Page Breaks.
  358. VBE takes two tries to hear me clearly...
  359. Re: Set Xvalues to an array of date, but the x-scale not correct
  360. Subscript Out of Range
  361. Re: Set Xvalues to an array of date, but the x-scale not correct
  362. save Y/N?
  363. Re: Inserting values
  364. Re: Inserting values
  365. Re: Problem with Keyboard scanner
  366. Add additional value to a cell
  367. Code for naming worksheet name range??
  368. Re: Box around selected range
  369. Re: CurrentRegion.copy maybe?
  370. listbox question
  371. mouse pointer
  372. Re: Track changes function in Excel
  373. Auto_Open not running when file opened normally
  374. Re: Reading a VBA constant value by an outsider macro?
  375. Re: export to wordpad*update can't use wordviewer
  376. Mail Merge With Excel Data
  377. Re: Swapping between sheets & using Find
  378. Re: Reading a VBA constant value by an outsider macro?
  379. Creating Event procedures from a macro
  380. Calling Add-in functions from VBA
  381. exporting to wordpad?
  382. Colourindex changes by changing cell value
  383. Text Box Set Focus Issue
  384. Re: Change user's data problem
  385. Code for positioning cursor in many sheets
  386. Properties - Workbook and Worksheet
  387. HELP! Button/Macro or Function has stopped working!
  388. Re: Excel 97 autocalc disables itself
  389. Re: How to convert DMS to Decimals of a Degree?
  390. Text Box on User Form Set Focus Issue
  391. Selecting first blank row
  392. Re: Named Ranges and VBA Add-ins
  393. Workbook_Open event not working
  394. Tracking Changes
  395. Prevent Tool bar buttons from displayinf
  396. Cell Comments question
  397. Verify starting cell for macro
  398. Can't scroll in code window
  399. Re: How to convert DMS to Decimals of a Degree?
  400. using a function in an addin in my vba code
  401. FileSystemObject And Excel
  402. Hidden? macros
  403. Re: Problem with macros assigned to toolbar buttons
  404. Last Date in Month
  405. Re: VBA for XL95, Workbook.open non XL-file
  406. Test if Auto Outline is True
  407. Re: row autofit
  408. Re: Automatically naming a worksheet tab with dates?
  409. Months between two dates
  410. Undo Redo Reset Buttons
  411. disabled macros
  412. Learning VBA
  413. Need advice and code help with working with *.dbf files in Excel 97
  414. How can I create this argument? For every 20 you get 2?
  415. Re: how msgbox from Word when ran from Excel?
  416. Web Folders -> Excel file -- asks for password again
  417. Hyperlink to a chart sheet...?
  418. Command Usage
  419. Chart source data
  420. Workbook Reference for Macros
  421. Method? Function? Operator? I dunno ):
  422. Re: add text to label (label from forms toolbar)
  423. Accessing Data from Closed Workbook
  424. Re: Solver isn't working...
  425. How do I create a button to reset ComboBoxs
  426. Trapping Double Click Short-Cuts?
  427. run code after cell contents change
  428. XP to 97 VBA error
  429. thanks
  430. Validating user input to a listbox
  431. Re: Time calculation based on filled information
  432. Can i Access XLL file(Excel97) in Excel XP
  433. Excel Questions for VB6
  434. condiionaly copy to another sheet
  435. Finding the sum of yes/no answers
  436. repost... Listbox
  437. Re: Macro to hide rows
  438. Re: Creating Collections 'on the fly'
  439. Excel VBA (DisplayFullscreen and the Windows Toolbar).
  440. Re: countdown timer in a cell (Tom)
  441. Returning Key Focus
  442. Re: Accessing Data from Closed Workbook
  443. Range of cell
  444. Re: selecting range
  445. macro crashes excell xp
  446. numbers as text?
  447. Help Internet Explorer Automation - How to run the script's ??
  448. Accessing custom document properties
  449. textbox.value doesn't create a number?
  450. Need VB script for telnet application
  451. findinf text in multiple excel files
  452. Re: Workbook_Open macro created in Excel 97 problems on MAC
  453. Re: opening files
  454. Re: opening files
  455. Save As... crashes Excel
  456. SetFocus problem
  457. Re: Unopened workbook values
  458. Re: OnAction
  459. Typing in a Combo Box
  460. Worksheet change
  461. sort blank cells first instead of last
  462. Shared Macro
  463. "Small" Multi-Dimensional Array Slow Writing To Cell
  464. Filecopy in vba macro
  465. Filecopy in vba macro
  466. column width
  467. Unopened workbook values
  468. Excel Combo Box Formatting problem
  469. Focus back from modeless userform to sheet
  470. Change mouse to "busy" pointer when I bring up a form
  471. Re: Writing a formula in code
  472. Re: starting an external program with a command line
  473. Taking Data of cell from worksheet to a userform window
  474. Re: starting an external program with a command line
  475. Checking 2 c if workbook exists
  476. Insert Row using Macro, Group By Date
  477. Adding Cost Codes
  478. Re: size of excel file
  479. ComboBox.ListWidth question
  480. Selecting Rows Programmatically
  481. Re: help with excel recipe book
  482. Need more CF capacity
  483. Re: macro for converting text file to excel
  484. Macro for formatting
  485. Re: Problem with Data Formatting
  486. Dates to months and calculating values for their months
  487. Converting Format to a "Data() As Byte"
  488. Re: macro for converting text file to excel
  489. numbering new sheets with the same number
  490. Run Macro if certain cell change
  491. error with "with statement"
  492. Loading Add-ins to a Protected Project
  493. Read Image From SQL Server n Export to Excel
  494. This Workbook or Worksheets for VBA
  495. File open dialog
  496. Worksheet_Change not working when using paste
  497. public variable
  498. How do I check if a user clicked the Print Cancel button
  499. Text on shapes
  500. Re: Excel 2000 Windows VBA vs. Mac Excel 2001 VBA
  501. Circular Error using MAX fnc
  502. web query
  503. Counting items in a listbox
  504. Re: Creating Data Validations
  505. Re: timer within a macro
  506. how do you hide a forms command button
  507. runtime error...
  508. Import - query table - retain trailing blanks in fields
  509. Re: Using Class, WithEvents and auto-instanciating
  510. strange behavior by ActiveX controls
  511. ReadOnly property of word document not returning proper value.
  512. UserForm_Initialize? How to update.
  513. Elapsed Time
  514. Re: Unload Me
  515. Re: #VALUE error in UDF again
  516. Newbie question on UserForm
  517. problems viewing excel over internet explorer
  518. Re: QUESTION
  519. Re: Repost: XL2000 Template Wizard - help needed to update database
  520. open excel workbook from template
  521. Re: Named Ranges and VBA Add-ins
  522. Re: Hide the principal screen
  523. Re: Checking if workbook open (where path is unknown)
  524. Using the Vlookup Function in VB Code
  525. Minimizing a user form
  526. VBA macro for xml conversion?
  527. IEEE-754 float to hex conversion macro?
  528. Validation of time in code
  529. NEWBIE: How can I do a "soft reference" in Excel/VBA?
  530. Testing to see if a sheet name exists
  531. TextBox Properties -- Don't move and size with cells
  532. resizing and aligning groups of ActiveX controls together
  533. Re: Named Ranges and VBA Add-ins
  534. Filter out one list of text in another list.
  535. Slow Draw with Excel VBA 2000
  536. Changing a formula on the worksheet
  537. Breaking link to another sheet
  538. Re: VB questions
  539. Returning ranges from xll
  540. Validation With Dependent Dynamic Ranges Lists
  541. Pass Strings > 255 Char
  542. Re: Multifile Code Error
  543. Re: Excel User Form Macros
  544. copying values
  545. Re: Macro InputBox with Drop-Down List?
  546. Re: Data mix and listing
  547. Re: Macro InputBox with Drop-Down List?
  548. Emailing with Attachment from Excel
  549. Re: Execute macros under Excel and Oulook XP
  550. Re: Values in a MultiColumn Listbox
  551. User defined worksheet functions
  552. VBA interactive commands
  553. Re: Set Focus in "Form" environment
  554. Re: Pause in execution
  555. listbox
  556. Rename a Range, programatically?
  557. Recording the last saved date of an external file in a cell
  558. Excel Macro To Convert XML File
  559. Maximum Size of Excel Forms?
  560. Printing an entire workbook from VB
  561. Re: Add in question/problem
  562. Wondering If Possible
  563. COPYING A LOOKUP CELL
  564. countdown timer in a cell
  565. Search and Replace text strings within Macros
  566. name of Workbook
  567. Retrieve data from e-mail attachment
  568. Re: Macro help urgent urgent
  569. [ODBC Excel Driver] Too few parameters. Expected 1.
  570. Re: Moving data to sheets
  571. Re: Suppressing messages
  572. Macro help urgent urgent
  573. Excel 2000 - Page break so group of rows not split (VBA?)
  574. Can anybody Share goof Pivot Table Examples?
  575. name of a sheet
  576. Programmatically open / edit vba-editor
  577. help with Or statement
  578. Worksheet change
  579. Fatal Error in creating worksheet
  580. Excel NewWorkbook event
  581. macros not enabling
  582. Macro - trailing blanks
  583. Help - 'finding' a quote mark (") ???
  584. Hide/Unhide Macro bug
  585. Check Box influencing other Check Boxes
  586. Re: Setting print area
  587. Re: if it is possible to add a combobox to a self-made function
  588. Advise required in relating two lists
  589. Re: Excel -> PDF
  590. Excel 2000 VBA: select filled cells for printing
  591. Spellcheck via VBA in excel?
  592. Re: Excel -> PDF
  593. Importing UTF-8 Encoded CSV Files. Problem
  594. TreeView: add more than one node to nodes collection
  595. Workbook, worksheet rename
  596. passing values from one sheet to another
  597. Referencing to controls on a worksheet
  598. Find/replace help
  599. default value for combo box
  600. Sorting Unions
  601. Sum of vlookups across all worksheets.
  602. code to strip back (from the right) a directory but not the file name
  603. ComboBox
  604. retrieve value in file (NO VBA)
  605. if it is possible to add a combobox to a self-made function .
  606. Re: Application to find Kilometres
  607. strange behaviour
  608. Additional ToolBox Controls
  609. formula to display dbaseIII columns/rows in Excel Cells
  610. Re: UserForm Loss Focus
  611. Re: size of excel file
  612. Regsvr32 return value
  613. Re: Autosum variable range in macro
  614. Auto Open
  615. copy to same column
  616. function to compute average without zeros
  617. Re: Determining if a Add-In has been loaded from XLSTART
  618. Not seeing integer
  619. Disable "File Not Found" dialog box
  620. multi users
  621. Determining if a Add-In has been loaded from XLSTART
  622. Re: Cann't use "Match" function inside VBA
  623. copy multiple cells
  624. opening file
  625. using a macro to define the contents of a cell as the save as name
  626. checking for errors in combobox's
  627. How to delete an Excel Macro from VBScript
  628. Re: Autosum variable range in macro
  629. Re: Autosum variable range in macro
  630. Re: Automatic Row Generation/Insertion
  631. Re: Database info in Word doc
  632. Cell Truncates to 255 characters in Macro
  633. date in listbox
  634. Macros/VBA
  635. FormatDate
  636. Protecting a portion of the Sheet
  637. filters
  638. size of multidimensional dynamic array
  639. Re: Check if a String is inside an Array
  640. Annoying delete empty rows question
  641. Excel 2002 and Access 97
  642. Paste columnwidths in Xl2k problem
  643. Complex conditional statements
  644. new to VBA...loop?
  645. delete multiple columns with one line?
  646. Embedding pictures in Excel
  647. Activate Non-Excel Window Through VBA
  648. Re: Jump to cell?
  649. Array
  650. Macros - call or launch from fromula
  651. How to exchage data with other programs?
  652. Passwords in EXCEL
  653. Worksheet_change
  654. Excel 2000 and SaveAs
  655. Re: Mass rename of worksheets/Workbooks
  656. Mass rename of worksheets/Workbooks
  657. ATTN: Alan Beban. Problem with ResizeArray
  658. Re: Check if a String is inside an Array
  659. Re: Mass rename of worksheets/Workbooks
  660. Conditional appearance of checkboxes in Excel
  661. Re: Can a MACRO prompt for the filename to open and/or save?
  662. Asking to Select a Range
  663. Execute macros under Excel and Oulook XP
  664. Looking up values
  665. Text returned as 0
  666. Pivot Table undocumented error
  667. Re: Debugging Server Existence code
  668. Convert True/False to checkboxes
  669. Re: tomorrow's date
  670. Conditional Formatting
  671. Sorting rows programmatically
  672. update one sheet with VBA from another sheet
  673. how can i save excel file
  674. Using an Alias for a range?
  675. Re: setting procedure attributes
  676. Re: Sum only numbers?!
  677. priority of short cut keys
  678. Using UDF in COM Addin as formula in worksheet
  679. Help with a list box please
  680. Week number when year changes
  681. Pivot table problem
  682. how to offset when it is a merged cell.
  683. Errors in The GantTool
  684. Re: Sum only numbers?!
  685. Re: functions available on toolbar
  686. Open all files in a directory
  687. Re: Excel File To update Automaticaly
  688. Re: Issue updating XLS using ADO
  689. Re: sending a workbook by email to multiple recipients
  690. Selection based on values in a cell
  691. Re: External File Data Import (F.A.O. Bernie)
  692. VBA function reading all cells as -4142
  693. Passing range as argument
  694. Count occurances based on certain data
  695. Attaching a JET database to an Excel Worksheet OR storing large binary data in a worksheet
  696. VBA to copy a worksheet to word as a picture
  697. Macro to insert new sheets and copy information.
  698. run a macro when clicking on "save as"
  699. Macros
  700. copying values from sheet to another
  701. Applying second filter and set print area
  702. Trap this Error
  703. macro to delete a sheet
  704. Stattic Variable
  705. Re: tomorrow's date
  706. Blank cells
  707. opening Excel report
  708. HELP! Code for Pivot Table
  709. VBA Help
  710. how to bring up a data form with VBA
  711. Copy last 13 items
  712. Re: Finding comments - help needed !
  713. Problem Importing Delimited Data from IE
  714. Date filter using now()
  715. adding text path via macro to activate hyperlink
  716. Save Macro w Suggested File Name
  717. application.dialogs(xlDialogSaveAs) AND CHDIR
  718. Epitaph for Excel, perhaps
  719. How to Find text in String?
  720. Problem copying worksheet containing code module
  721. Excel Automation Issue
  722. Re: Variant to String
  723. Enabling comments on a protected worksheet
  724. Question About Pivot Tables
  725. How to construct for best speed?
  726. Re: Print Excel Sheet PDF extension
  727. Formula... conditionnal format
  728. Re: Fonts
  729. Re: (Worksheet)Listbox1.additem = (Form)Listbox1.value ??
  730. LOOPS
  731. splash screen
  732. Re: why this code not working
  733. My post does not go through (twice)
  734. hyperlink to an Excel file
  735. Macro is giving me problems with sorting
  736. Formulas cause blank pages to print
  737. Runtime Error 1004 -- Application Defined or Object Defined Error
  738. macro to hide column based on header
  739. Interfacing OL2002 Cal and Excel Userforms
  740. What is a clean way of controlling Scroll bars when using filters with Userforms?
  741. Rebuild XL Worksheet Menu Bar
  742. Excel VB: Open/Save *.xls
  743. "Search Column for Last Numeric Value"
  744. A kind of what-if problem - Please help
  745. Re: Make a VBA function available
  746. FILE > Save As / FILE > Print greyed out in Excel
  747. Re: Run-time error '91':
  748. Further Help Req'd - Looping thru cells in named range
  749. VBA - Programmatically Change VBA Project Password
  750. Re: Improved printing of VBA code?