-
- D&D
by YaelS
- 0 Replies
- Last post
by YaelS
- Hi, I need something like this:
http://www.codeproject.com/csharp/testemaildragdrop.asp
in vba + access..
any idies
-
- BUNDLING MS MONEY 07 TRIAL
by Steven777
- 1 Replies
- Last post
by MS ISV Buddy Team
- I'm interrested in bundling Microsoft Money 07 on our Welcome disk as a value added benifit to our business members. What is required to do so
-
- opc
by ksona
- 14 Replies
- Last post
by MartinBrasil
- I am trying to develop an opc - da client using .net technology. Have gone through the documents on opc and opc client and all, but am still not sure how to implement it, can someone give me a direction on how to start with it
-
- randomizing the contents of Excel cells
by Josh Ord-Hume
- 6 Replies
- Last post
by PYA_Ferro
- I am trying to create an Excel macro that will look at the contents of cells A1, B1 and C1 and 'randomize' their order. So, if the contents of A1, B1 and C1 are "1", "2" and "3" respectively, they might end up as " 2 ", " 3 ", " 1 " or " 1 ", " 3 ", " 2 " once the macro has been run. Any ideas gratefully rece
-
- TextBox height
by suznal
- 8 Replies
- Last post
by suznal
- Excel 2003 - TextBox
What would the code look like to have a text box maintain a specific width and a minimum height but increase in height as data is entered
-
- Can we turn off the smileys?
by Jon Peltier
- 4 Replies
- Last post
by Jon Peltier
- If someone posts an Excel range, like $a$1 : $b$2 without the spaces around the colon, the colon plus $ combination draws a stupid smiley, as in $a$1 b$2. This interferes with the message and looks so unprofessional. Is there any way to turn off smileys in this forum, as there are in other forums - Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical S
-
- Suppress Linked View Unique Record Popup
by Babbage
- 14 Replies
- Last post
by Babbage
- Hi there im linking a view on an ms sql server to my access database using VBA using DoCmd.TransferDatabase acLink, etc.etc. How ever, I can NOT get the `Select Unique record Identifier` pop up to stop coming up when the link is being made. I dont care about needing a unique identifier, its a read only record source. The only way ive found is using sendkeys command to cancel the popup - however th
-
- VBA Powerpoint - identifying textboxes by type
by Peter Caisse
- 3 Replies
- Last post
by Peter Caisse
- Hi everyone, I'm writing an add-in for Powerpoint 2003. I'd like to know how I can identify textboxes by type if such a thing exists. For example, when reading a TextFrame, how do I know if I'm reading the title textbox, the subtitle, or a the big textbox with bulleted points depending on the slide model I've found the Shapes.Title property, but that only gives me the title if it exists, not the v
-
- Counting words
by une
- 10 Replies
- Last post
by une
- Does there exist a predefined function that counts the number of words in a string
-
- Delayed execution?
by TKeune
- 1 Replies
- Last post
by TKeune
- I have a VBA application on an Excel workbook. I'm adding a new line to the spreadsheet by doing data entry through a form. In my initiating macro I initialize the form and connect the data fields of the form to their various positions in the current spreadsheet row. While doing that, I initialize two fields with default values, the first a Par #, the second with today's date. What I'm seeing is t
-
- Excel-Capture the sum of Highlighted Range
by Neil Tenbrook
- 3 Replies
- Last post
by Andy Pope
- I'm trying to capture the sum of a highlighted range in an Excel Marco without using a loop. After selecting a range, I can capture the cell count with the following command:
X = Range(Selection, Selection.End(xlDown)).Count
Wondering if there is way to the sum as well. Excel can show the sum highlighted range, so it seems I should be able to replecate in VB.
Thanks,
Ne
-
- Aproval of responses
by Togo162166
- 4 Replies
- Last post
by Jason Hardester - MSFT
- Hello,
I registered four responses to crash events on September 26th. They're status remains "In Progress" (the tooltip says "Response is awaiting aproval") ever since. When can I expect the responses to be treated
- T
-
- How can I disable a command button under certain condition?
by lyp_sj
- 3 Replies
- Last post
by lyp_sj
- Hello:
How can I disable a command button under some preliminary conditions, for example, if I want to click button 1, I have to observe the result from clicking button 2 Thanks so much!
B.regards/Yaping
-
- Extracting data from an Access 97 MDE file
by John Loo
- 0 Replies
- Last post
by John Loo
- Sorry if this is too basic, but I'm trying to find out if there is a way to extract the tables and data from an Access 97 MDE file.
I don't need the VBA code or forms, just the data. I have all of the passwords and ID strings for the users.
TIA
-
- SAP
by envi_ria
- 11 Replies
- Last post
by envi_ria
- HI
Does any one know what is the procedure and purpose of doing SAP.
What are the requiments, and how can I go about doing the training. What are the courses available for the same.
I am an IT trainer for the last 2 years would like to do SAP.
Supriya
-
- CreateWorkspace() call fails after installing Office(Excel) 2007 - using ODBC
by HedleySohn
- 3 Replies
- Last post
by HedleySohn
- We have a VBA component that we've used for a long time. Our users have recently begun to report that the component no longer runs once they install Office 2007.
We have always created an ODBC workspace as in the following:
DIM workODBC As DAO.Workspace
Set workODBC = CreateWorkspace("ODBCWorkspace", "Admin", "", dbUseODBC)
This call
-
- Need VBA code to find first positive data point & determine standard deviation of data set
by traj
- 0 Replies
- Last post
by traj
- Let me preface this by saying I am an absolute beginner at VBA.....
Basically, I have an Access table with 3 fields. The fields are: Item_Number, Date, Units_Sold.
For each item, there are 24 months worth of data.
The table is structured as follows:
Item # Date Units_Sold
01 2006-10 0
01 2006-11 0
-
- 2 Small Macro problems.
by GB Allan
- 6 Replies
- Last post
by GB Allan
- Hi all,
Problem 1:
I am trying to delete a sheet within a workbook, as part of macro. Here's the code:
Sub DeleteInstructions() ' ' DeleteInstructions Macro ' Macro recorded 3/13/2007 by Gary Beckwith '
' Sheets("INSTRUCTIONS").Select ActiveWindow.SelectedSheets.Delete Sheets("DATA").Select End Sub
When I run it, I get the prompt "Data may exist in the
-
- Strange recoeded code for pasting device independent bitmap
by Yaron Kohavi
- 3 Replies
- Last post
by Jon Peltier
- Hi,
When I record a macro which emulates the following menu selection: Edit, Paste Special, Device independent bitmap, I get the following code:
Sub Macro2()
'
' Macro2 Macro
' Macro recorded t12/03/2007 by yaronk
'
Selection.PasteAndFormat (wdPasteDefault)
End Sub
Sub PasteInde
Where in fact, it seems as if the code should hav
-
- Some questions about WER
by Nikolai Bochkarev
- 5 Replies
- Last post
by Jason Hardester - MSFT
- Hi!
I'm integrated WER support in my Delphi 7 Application and now get some results
1) I'm register winqual account
2) Integrate WERAPI support in my application (Delphi program has own exception processing)
3) Map my .exe and upload xml file
procedure TForm1.ApplicationEvents1Exception(Sender: TObject;E: Exception);
var eventType : PWideChar; begin
if
-
- I've received empower, but where are serial numbers???
by Ihor Bobak
- 6 Replies
- Last post
by orcmid
- Last year I ordered Action Pack - I received disks and serial numbers sticked on disk folders. This year I ordered Empower. I received many disks, many papers (license agreement and advertisement materials), but where are serial numbers I don't see them neither sticked on disk folders, nor among all papers. I cannot install Windows Vista... Can anyone give me a hint - where can I get my serial nu
-
- VBA String manipulation problem.
by OM
- 2 Replies
- Last post
by Andy Pope
- (i orignially posted this message in the vb forum... but was told to post in here instead.)
I'm trying to code for an Excel spreadsheet.
Very new to VBA.
I want to replace all comma characters with a newline character.
And then get rid of all whitespaces.
So far, I've got this:
Worksheets("Summary").Cells(i - 4, 1).Value = Trim(Replace(StrConv(Worksheets(&
-
- Make a New Hyperlink by the User
by Clarence j
- 2 Replies
- Last post
by Clarence j
- Yes I am Currently trying to make a Macro from a Button or a Cell for users to click on for them to make their on Hyperlink and Not go to the hyperlinked destination but rather put the Hyperlinked Destination Name in a Certian Cell
I will Give an Example
Making a Database of Students and Trying to allow users to upload Resumes to attach to each worksheet
The Resumes will Be Wo
-
- Excel Macro to Capture Live Webcam Image?
by Denis Ott
- 8 Replies
- Last post
by jo_turner
- I am attempting to write a macro which will access my USB connected camera, grab a picture, and paste it into an active cell.
I am able to do this manually by simply locating the cursor at a cell location, selecting "Insert - Picture - From Scanner or Camera", Selecting the Twain resource for my camera, Selecting Custom Insert, Selecting Take Picture... and viola, the active view from
-
- User-defined function appears to be preventing Worksheet_Change trigger?
by svaiskau
- 6 Replies
- Last post
by RonZ2
- I have the following user-defined function, which works independently (that is, it does what it is supposed to):
Function ActivityIndex(currentDate As Date, projectName As String _ , firstRow As Integer, lastRow As Integer)
Dim dateColumn As Integer dateColumn = (currentDate + 1) / 7 - 5575
Dim count As Integer count = 0
Dim i As Integer i = firstRow
Do While i <= lastRow If