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. preserving type library references when distributing macros
  2. Re: Formula help please
  3. Re: Detect more info when workbook does not ack right.
  4. Logitech's newest mouse scroll fails in VBE code pane
  5. Mismatch!?
  6. Formula help please
  7. Re: Formula help please
  8. Re: Unicode StrConv/Substitute routine...
  9. Email question
  10. OLE Excel data handling from VB
  11. Re: sort for variables
  12. Is there a "cell change" event?
  13. macro for e-mailing excel file using outlook
  14. Header - only on first page
  15. VB question...
  16. Help with If Not Intersect
  17. Data Box
  18. Re: Looping through each directory
  19. Code to display dialog for unhiding sheets
  20. Re: Code to display dialog for unhiding sheets
  21. Re: VBA button click need help. Need LEN help.
  22. Re: VBA button click need help. Need LEN help.
  23. Re: Macro to list all Formulas in WB?
  24. Open Searched File
  25. Excel data to Access
  26. Macro to rename all worksheets with cell value in each sheet
  27. Need HELP to modify code (need more automation)
  28. Re: SaveAs "subscript out of range" error (COM -> SOAP)
  29. Re: Excel / VBA
  30. Re: Expiry Date for further updates into Sheet
  31. Handout of Excel Object's Properties and Methods
  32. Re: Opened File
  33. programming outlook 2000 from excel
  34. Re: Opened File
  35. Re: Search Methods
  36. O.T. Copy Protection
  37. Creating a drop down window
  38. Re: Help coding userform
  39. Activiating and Selecting Excel Cells in VB.NET
  40. Listing files in directories.
  41. Preventing Duplicates using VBA (code)
  42. Distributing code
  43. Hide Slide Bar?
  44. Put a timer on a MsgBox?
  45. Re: WScript object not found (???)
  46. MOD function
  47. Object doesn't support this property or method
  48. Re: combining sumproduct and average
  49. Please somebody help me...
  50. Email one page of information on the same sheet
  51. Adding a category to the Function Wizard
  52. Closing Excel Completely
  53. optionbuttons
  54. How to set global constants and get path of spreadsh ?
  55. Link Excel range to PowerPoint Application text box
  56. Trend function in VB
  57. Newbie question about iteration technique?
  58. Re: Consolidating multiple files using a row column range
  59. Re: Closing Excel Completely
  60. Re: Closing Excel Completely
  61. Re: SaveAs "subscript out of range" error (COM -> SOAP)
  62. Re: Closing Excel Completely
  63. Re: prevent second copy from opening
  64. Appending/Updating records
  65. prevent second copy from opening
  66. Re: Problem importing using MS Query
  67. Re: "Substr" command in Query
  68. Macro Emailing Challenging Problem
  69. Common Dialog Box
  70. What's this? (Application.Run)
  71. Re: Hiding Links
  72. Re: Hiding Links
  73. Excel-VBA and FlexLM
  74. Re: Looping through each directory
  75. Setting Font properties in Code clears Undo list
  76. Re: Excel / VBA
  77. Excel Add-in
  78. rate formula
  79. Re: Looping through each directory
  80. Import VBA Code
  81. Populating Pageheaders Using Vertical Lookups
  82. Populating Textbox in UserForm
  83. Unusual Operation of a User Defined Function
  84. lookup lastmonth
  85. Find File and Open
  86. concatenation of cells
  87. Cell Formatting
  88. Re: Switching to other apps while running macros in excel 97
  89. Re: List the Macros that can be executed from Tools-Macros
  90. ISERROR formula in VBA not working for me
  91. Application.Run question
  92. Excel Macro Strings
  93. Worksheet Button Callbacks
  94. Restrict Find to one column
  95. Counta anomaly
  96. ChangeLink xlExcelLinks
  97. Re: Cond form formula
  98. Does MS Query have an object model
  99. Re: Cond form formula
  100. Re: how to define target frame names for the hyperlinks in Excel
  101. xlDialogSendMail
  102. Getting rid of Outlook warnings from excel macro
  103. Can't open a file
  104. Simple conditional formula
  105. Dialogsheets
  106. Re: Linking to other VB apps
  107. UpdateLink Method
  108. Re: Hidden Worksheet Error
  109. Procedure Too Large problems
  110. problem with tables in excel
  111. Linking to other VB apps
  112. MATCH, LOOKUP, or ???
  113. Validation ?
  114. Custom Calculations in Subtotal
  115. help with sql in excel
  116. combining sumproduct and average
  117. Printing .pdf from within Excel
  118. updating Access table with Excel data
  119. to modify cells from a function
  120. PageSetup slow
  121. Unprotect Worksheet
  122. Importing from SQL changes date format
  123. Connectiong to an Excel Workbook with MSDASQL provider
  124. can i send an email or warning from excel
  125. Re: Pivot Tables not using all memory
  126. File Copy Routine
  127. Page breaks in Sheet for copy via OLE?
  128. Change font to red and bold
  129. Programming links
  130. Re: A peculiar problem
  131. Using the same variable in separate userform modules
  132. programming a link
  133. Modifying the cell dependies
  134. Re: How to get the position of a cell in Excel named range?
  135. listbox
  136. Averages
  137. Compile error ...
  138. A peculiar problem
  139. Importing a sheet?
  140. Can you identify the maximum value in an array?
  141. Find paragraphs in word and export to Excel
  142. Can these codes be summarized?
  143. How to get data from Access Database in Intranet
  144. Text Format
  145. Writing multilines to a text file without closing
  146. recalc question
  147. Re: On opening an excel file
  148. Re: UDF Array function
  149. Re: Simple Question
  150. Re: copying duplicate entries
  151. Automated copying & pasting from multiple sources
  152. Re: Question about toolbars ...
  153. Re: How to get the position of a cell in Excel named range?
  154. How to get the position of a cell in Excel named range?
  155. Unknown where is the problem on the Runtime error - Automation error
  156. Comma in TextBox Problem (Spanish)
  157. Eliminating Prompts
  158. Re: Opening CSV files and #NAME? error in certain cells
  159. Re: Simple Question
  160. Protecting a worksheet from veiwing but not from importing in data
  161. update and store new high values
  162. Can this be done?
  163. Extracting text
  164. Re: Inputbox method using type:=8 - How to Cancel?
  165. customize a calculated field in a Pivot table
  166. How to disable 'Update alert' when open a spreadsheet has link to other XLS
  167. Automation Procedure with Worksheet_Activate
  168. Re: DDE Command to Format Cell
  169. Where can I find other arguments & desc to the Workbooks.open("myfile.xls") cmd?
  170. Chart automation problems!
  171. Calling the Solver via a subroutine
  172. How to disable 'Update alert' when open a spreadsheet has link to other XLS
  173. variables for file names
  174. m/d/yyyy h:mm date conversion to yyyymmdd ???
  175. Re: How to disable 'Update alert' when open a spreadsheet has link to other XLS
  176. Re: Workbooks.Open fails after upgrade to XL2000 from XL97
  177. Deployment question
  178. Re: How to apply a function across a range of cells
  179. Delete Rows with letter #VALUE in cell J
  180. Pausing code execution
  181. Macro Prompt
  182. scan for repeating values and then delete
  183. adding uniform footers
  184. check if worksheet exists
  185. output of associated arrays
  186. Making VB PasteSpecial method to work the same as Excels Application
  187. Fill Color? Background Color?
  188. Re: Auto numbering
  189. Calling HTML Source code from within VBA for Excel
  190. JScript to move Excel Worksheet
  191. Help: Copying Visible Cells only to Visible cells!
  192. formula returns formula
  193. How to code event for dynamically generated checkboxes
  194. Re: Excel 2002 RTD - GetNewValues and RestartServers
  195. Re: Still trying to move a text box
  196. Re: CountIf
  197. excel 2000 - manipulate two applications
  198. Re: Substitute comma in csv file
  199. print current sheet
  200. list box
  201. MsgBox
  202. VBA Code to FIND
  203. list of accounts
  204. moving macros to disc.
  205. Re: Formula on cells
  206. Parsing Data From HTML Source into Excel using VBA
  207. Formula or code
  208. Open another Office app from Excel
  209. The expanding XLS spreadsheet
  210. Need Before_Save code
  211. VBA code for Excel 2000, IF procedures and listboxes
  212. Using Microsoft query through Excel
  213. Average/Sumproduct Array
  214. vba tutoial
  215. Re: VPageBreaks in excel.
  216. Re: compatibility issues foreign versions
  217. ADO connection not always enabled
  218. Re: DDE Command to Format Cell
  219. Removing Lines Identified by Autofilter
  220. Re: Formula or code
  221. Auto numbering
  222. help with *.xlw file please!
  223. Re: Find functions
  224. Re: macro to send an email from excel
  225. Error Reports
  226. Maintaining row position in a loop
  227. compatability isssue
  228. Moving Text Boxes
  229. easy way to test if a Named Range exists
  230. Detecting Worksheet change
  231. Opening Excel 2002 VBA Editor
  232. excel symbols
  233. Tracing into a Function
  234. Re: CountIf
  235. Re: Opening text files using macro
  236. Re: excel symbols
  237. run-time error 1004
  238. Excel+Not Enough Memory..
  239. Showing Excel Sheet in IE
  240. RollOver buttons in UserForms (A solution)
  241. Multipage
  242. A save question:
  243. Saving Excel to web site
  244. "Less than or equal to" symbol in a UserForm
  245. Reading a named range
  246. Code for moving textbox
  247. halting macro
  248. halting macro
  249. Subtotaling items from a list
  250. Mass update in Excel based on values in different sheets
  251. Displaying progress on UserForm
  252. Can these codes be summarized?
  253. Variables in command lines
  254. Re: Excel2000 VB Help Problem!
  255. dialogboxes
  256. Time active Macro
  257. Hide all toolbars auto_open
  258. Re: How to become an excel MVP?
  259. Select Range problem
  260. Conditional Formatting
  261. Defining Ranges
  262. Save As Dialog
  263. 32,767 Significant Digits of Precision, with Number Formatting
  264. Re: Protecting a VBA project
  265. Re : MS Excel’s Offset Property
  266. Re: Protecting a VBA project
  267. Re: Copying a Excel Chart into Word
  268. Re: calling word
  269. Re: Mods to macro
  270. inexperienced header entry automation resizing/scaling issue(s)
  271. Re: Passing a Password to a VBA Procedure
  272. grid lines covered up
  273. macro selecting datalabel
  274. Active X Control
  275. String operations in VBA for "Substituite"?
  276. Re: How to make a running XL app the active desktop window using VBAcode.
  277. Clock Timer/ Date Function
  278. Re: AutoFilter Dropdown Boxes Missing
  279. Re: AutoFilter Dropdown Boxes Missing
  280. Re: Serial I/O
  281. Re: Time based macro
  282. Sorting Odd & Even Numbers In Excel
  283. Re: CSV Format in non-English OS
  284. Cannot insert Activex boxes
  285. Re: Formula for autodating
  286. Re: Setting up a date and time stamp in a cell
  287. Re: More efficient code
  288. How to run VBA macro when the workbook is open?
  289. Looping through Text boxes
  290. SQL with no headers
  291. Concatenate Text to create Formula
  292. Problems executing Excel VBA code in Microsoft Office 2003
  293. Re: Why doesn't "Workbook.Range("myrange").value" work?
  294. Re: Copy and Paste Lost
  295. Re: system variable representing subroutine name?
  296. Default excel Template
  297. An ODBC question
  298. ugh! Match/Index problem
  299. Re: Running sheet from another sheet ... and back
  300. Row to column data move base on row
  301. Re: Save As Dialog
  302. RE: Automate differente excel versions + VBA protection
  303. Copy and Paste lost
  304. subtract time from now()
  305. date conversion from m/d/yyyy to yyyymmdd
  306. Re: Single Sheet - Calculate Manually
  307. cannot open and can not delete files
  308. Datedif, Workday etc.
  309. Certain methods do not work
  310. Re: really dumb find question
  311. C Add-In clashes with VBA?
  312. Re: Inputbox method using type:=8 - How to Cancel?
  313. mortgage amortization
  314. Re: Single Sheet - Calculate Manually
  315. Macros
  316. Name of workbook
  317. Re: .Visible Property
  318. Use one column to identify values in adjacent column.
  319. Re: Excel VB and Lotus Notes Address Book
  320. Getting the full path when from a File Open Dialog Box
  321. Detect if file is open
  322. Can I have a loop to open a set of workbooks get some data, close it one a time.
  323. Re: Macro Using Named Cell
  324. executing code when a module opens
  325. Unprotect method run-time error
  326. Re: Macro Using Named Cell
  327. SUMIF function
  328. Re: Exporting Data.....
  329. formatting in macro works on one computer
  330. automatic updating cell
  331. Deactive Copy and Paste
  332. Digital Certificate creation error using makecert
  333. Re: Inputbox method using type:=8 - How to Cancel?
  334. Re: Deactive Copy and Paste
  335. Sizing windows automatically
  336. DateDiff problem
  337. Undo, Redo, Repeat and Validation
  338. Device I/O Error
  339. Excel ADO Connectstring parameters
  340. For Next Looping (custom variables)
  341. Sorting ListBox results or transposing ListBox values to other cells for sorting
  342. Eliminating rows of data in excel spreadsheet that have blank cell in row A and data in row B - E
  343. Excel is very slow to load/save the spreadsheet
  344. Hidden sheets becoming visible after saving from Browser
  345. Re: dates in userforms
  346. Delete without losing references?
  347. Re: Com addins
  348. Lotus 1-2-3 macro
  349. Simulating the Format Painter, Selection.Select, and taking focus
  350. Re: Can we write VBA code to set all column/row's size back to default size?
  351. Re: Why my data not saved ?
  352. Re: dates in userforms
  353. Re: Check mark boxes in Excel 2002
  354. Auto Fill Program needed to get maps from internet onto excel
  355. Excel Addins
  356. Re: Mouse
  357. Re: Cell contents changing colors
  358. GetSaveAsFilename method
  359. Re: Opening an AutoExecute Macro Workbook from an AutoExecute Macro Workbook
  360. Re: Ah, I think...
  361. Re: Associating one array with another
  362. Re: declare a two dimenssion array
  363. Re: Ah, I think...
  364. Before Send
  365. Re: Screen is flashing when VBA adding objects into Excel sheet?
  366. Ah, I think...
  367. Re: Iterating through row cells on column Match, help please.
  368. LoadPicture Pathname or no Pathname
  369. Ah, I think...
  370. Re: Why compile the VBA code?
  371. adding changing number of days
  372. Re: Accessing the VBA project object model
  373. Can we write VBA code to set all column/row's size back to default size?
  374. Re: Before Send
  375. Re: Extracting Access data
  376. Re: Combobox Click event triggered when copying worksheet
  377. Add PivotItems to PivotTable / Enabling - Disabling PivotItems
  378. Re: User defined functions - text for formula palette
  379. Re: Excel Add-in path in UNC format
  380. Time based macro
  381. Re: Excel: Deleting Macros and Functions
  382. Question: Cell formula or macro to write result of one cell to another cell
  383. Question: Macro overloading, passing variable number of arguments
  384. Question: OPEN return status
  385. [Excel XP] Orientation of cells etc.
  386. Re: Count number of prints.
  387. Prompt
  388. Linking To Excel Graphs
  389. Re: I need to determine a cell range based on a blank cell
  390. Chart Date Label Problem - Is this a bug in Excel?
  391. xlfCaller
  392. Problems generating an html link based on worksheet values - SOLN
  393. Problems generating an html link based on worksheet values
  394. Upcoming Support Webcasts
  395. Strange thing with this formula written by VBA
  396. Re: Count number of prints.
  397. moving to cell Y if cell X has value Z.
  398. Excel table macro
  399. Error 430, Class does not support Automation, Windows 2000 sp4.
  400. MapPoint Question
  401. Send Access Data to Excel - Please ignore my other post. Newsreader went berserk
  402. Instances of Excel don't release
  403. Instances of Excel don't release
  404. Instances of Excel don't release