|
|
Browse by Tags
- 2000
- 2002
- 2003
- 2007
- access
- Access 2003
- Access 2007
- add
- another
- array
- autocad
- box
- cell
- cells
- change
- chart
- clear
- clipboard
- code
- column
- control
- copy
- create
- database
- delete
- document
- error
- event
- Excel
- excel 2003
- Excel 2007
- file
- find
- folder
- form
- forms
- Formula
- from
- function
- get
- import
- input
- insert
- line
- listbox
- lotus
- macro
- Macros
- merge
- Microsoft
- Microsoft Access
- Microsoft Excel
- microsoft office
- ms
- MS Access
- ms Excel
- Multiple
- mysql
- name
- notes
- Number
- Office
- open
- outlook
- page
- picture
- powerpoint
- query
- range
- recordset
- reference
- replace
- report
- Script
- Search
- select
- sheet
- spreadsheet
- sql
- string
- subform
- table
- text
- type
- update
- userform
- using
- value
- variable
- vb
- Visio
- Visual Basic
- vlookup
- word
- Word 2007
- workbook
- worksheet
-
Syntax Error Choose File from List
I am importing data from a Word file into Access. I want the user to be able to select the file name to imprt off of a list of files that show up in the set folder. I am getting an error on this line: strFilter = ahtAddFilterItem(strFilter, _ "Word Files (*.doc)", "*.doc") Here is... -
Prompt for Data Input on Import of File
I have an Access where I import Word data into a table. One of the key fields [MatterID] is not present in the Word file, but the user knows what the data is. On import, I want to prompt the user to fill-in the [MatterID], and have this data put into the table, with the rest of the Word data. This is... -
AutoCAD 2010 VBA, load block reference to VBA
Hello, I am writing VBA creating three TextBox in the form. I am trying to read the attributes in "block reference". The purpose of the program is to get the information of the block reference in this editing graphic. So assuming there is a graphic already opened in AutoCAD and there is information... -
Testing a range of cells to see if one or more of them contain any word in a specified list
This is a followup to EEQ: http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_26234936.html#a32913399 How would I modify Barry's code below so that it looked for a match in any one of these four cells: N2, M2, O2, and P2? Thanks, John Code Snippet: 1: =IF... -
Find Maximum
1: MValue = Large((Abs(rValue), Abs(lValue), Abs(dValue), Abs(uValue)),1) Hope you get the idea. I want to find the maximum of four (abs)values (r,l,d,u Value) and have that equal MValue. They are all integers. -
Problem with passing string to function
All, I'm having trouble passing a string to a module. Basic setup. I have a form that pop up with a series of check boxes. The user inidicates which ones they want an initiates a proceedure. The proceedure tests which check boxes the user ticked and forms a string of the corresponding query names... -
Remove Outlook contact using redemption
I looking for code where I can go through my Outlook contact list and delete a bunch of contacts based on some criteria. Let's say I wanted to delete everyone in my contact list who works for a certain company. How would I do this? Note:I have a licensed copy of redemption and would like a solution... -
Adding a designated value line to a standard chart
I have a standard chart with a range of percentages that usually run from 97% to 100%, but sometimes as low as 87 or 88%. So the y-axis scale minimum is set at 0.85 with a major unit of 0.05 to kep it uncluttered. However the company is contracted to perform at 99.5% so I would like to have a red line... -
Printing spelling errors to a new document
Dear Experts: below macro prints all spelling errors in the active document to a new document. The spelling errors are listed as follows (Example): Page 1 / doccuments Page 1 / presenttation Page 2 / ocurance etc. Could somebody please help me to rewrite the code with the following requirements: The... -
VBA - Open multiple workbooks and copy sheet to new workbook
Hey all, I have been assigned a new project that will require a little VBA, and my VBA skills are very elementary. I have 100 files (Book1.xls through Book100.xls) All files reside in C:\Temp I need to open each workbook, copy Sheet1, paste to next available Sheet# in Summary.xls, close the workbook...