-
- MS Office Word 2007
by Zoee
- 1 Replies
- Last post
by MS ISV Buddy Team
- I have MS Word 2007 and the spell check stopped working. How do I turn it back on. I have used the help and it was of no help.
-
- Network Interface Card (NIC) Enable/Disable programatically in VB 6
by Gilbee
- 1 Replies
- Last post
by Cringing Dragon
- Hi All I have 2 NIC in my pc and one Virctual NIC I want to Programatically (visual Basic 6) enable and disable these nic, if you have any idea please share with me any clue also welcome. programm codes are most welcome. gilbee
-
- Copying and Deleting the duplicate records in an excel sheet and Copying the same Deleted records into another sheet
by bharat baradia
- 4 Replies
- Last post
by magicalclick
- hi,
i want to delete the duplicate rows in the excel sheet and copy the same deleted records into another excel sheet by using Macro's . This should be possible even when i am selecting two columns for checking duplicates and even if one of the column is repeated ( is duplicate) it should be considered as a duplicate.
-
- Opening VBA Form (MS Forms) as child
by Ilianato
- 0 Replies
- Last post
by Ilianato
- Hi, I just need to open two VBA Forms (MS Form) and make one as an owner of another, just like VB forms do, like Form2.Show vbModeless, Form1 Where Form1 must be an owner (parent form) of the Form2. Thanks in advance, Ilia
-
- Microsoft Document Image Printer - MODI Settings via VBA without using registry
by Cheval
- 8 Replies
- Last post
by JoeDee
- Does anyone know what are all the available registry settings for MODI Through much searching in google (msn search finds nothing) I've found the following the following ' Write to File Only (uses current save folder and Note####.mdi as file name) SetKeyValue HKEY_CURRENT_USER, "Software\Microsoft\Office\11.0\MODI\MDI Writer", "PrivateFlags", 1, REG_DWORD ' Don't Show Popup Wi
-
- Convert decimal string to Chr$()
by Jade_Emeperor
- 16 Replies
- Last post
by Jade_Emeperor
- Hi. I'm currently writing a program for RFID using Visual Basic 6.0
But however I'm not sure how I can convert my decimal string to Chr$(). Because I currently wrote the code like this:
Code Snippet
decimal_string = CInt("&H" & hex_string)
Char_String = Chr$(decimal_string)
And an error pop up telling me that is an invalid procedure
-
- Importing excel spreadsheets over time into Access using a module in Access
by Nakli
- 1 Replies
- Last post
by Bruno Yu - MSFT
- Hi,
I am trying to create an access database that will allow to import excel spreadsheets at the click of the button on a switchboard.
I have been trying for hours to create a module in access that will import excel spreadsheets that contains a table with 12 columns and a different amount of rows for each spreadsheet.
I was able to create an almost complete macro in excel that
-
- Making an array in Excel with the file names of a particular folder
by Bartyb
- 5 Replies
- Last post
by Peter Mo.
- Hello, could anyone help me, I already have a macro in Excel that uses an array of filenames to process data, but so far I have to enter the filenames manually.
Basically, I want the macro to simply create an array in Excel with the files names and their extension (which will always be the same) located in a particular folder, sucha as:
Filename1.ext
Filename2.ext
...
Filename13
-
- CRM 3.0 "Server might be unavailable".
by trep
- 4 Replies
- Last post
by DavidJennaway
- Hi, I'm having an issue with CRM 3.0 Clients get this error message where it says "Server might be unavailable". Server is running, services are running, everything looks fine, so i started the Environment Diagnostics Wizard and i get the following: Some of the domain controllers do not appear to be running. The following list of servers should be checked. PrivUserGroup {9cd76ed6-ec49-4e
-
- Runtime Error '2001'
by Mona_D
- 6 Replies
- Last post
by cobolisdead
- I am using the following code to use an unbound text box to display the PM Name associated with the PM Number but for whatever reason, I keep getting the Runtime Error '2001' when I run the code.
Private Sub Combo59_AfterUpdate() Dim StrName As String Dim strPM_Select As String strPM_Select = "[PM Number]=" & Me![Combo59] & "" StrName = DLookup("[Plan_Center_Nam
-
- Simple thing: how to append to a jagged array?
by Stasiu
- 1 Replies
- Last post
by Shlizar Axis
- Hi, I'm a newbie in coding, sorry for an elementary question. ' I have arrays e.g. a = Array(1, 11, 111) b = Array(2, 22, 222) 'then I create a jagged array: bigarray = Array(a,b) 'this works ok, I can address it by bigarray()() 'But how can I declare this bigarray in the first place so I can then append next small array to it. c=Array(3,33,333) 'and here I'd like to append this c to existing biga
-
- CRM 3.0 detecting logged on user.
by HasanK
- 4 Replies
- Last post
by DavidJennaway
- Hi,
I am in the process of developing a callout assembly for CRM 3.0, part of this callout retrieves the user role of the currently logged on user.
I have worked up the code that extracts user role of a given user GUID. My problem is that I am unable to get the GUID of the logged on user (this code is available in the SDK).
This is my code for retrieving the user GUID
WhoAm
-
- Range
by Bortch
- 4 Replies
- Last post
by Bortch
- Hello,
I'm developing a macro to do some calculations on a worksheet, but I always get a problem when I pass a Range as an argument to my function. I need to pass the range as argument.
For example:
Sub Name()
Dim A As Range
Set A = Worksheets("Sheet1").Range("CD4")
MyFunction(A)
End Sub
Function MyFunction (ValueDoRange As Range)
etc...
End Fun
-
- Combobox Add Item Run-time error '13': Type Mismatch" Access Form
by john.w.keck
- 1 Replies
- Last post
by Cringing Dragon
- I have a database where I have a table set that populates a combobox that fills a field. They have requested that I allow them to directly add a new item directly into the combobox vs my link to the database. I though I found the answer below, but everytime I think I get close, I get the below error - "Combobox Add Item Run-time error '13': Type Mismatch". Thanks in advance! I used the
-
- Hope someone has an idea
by hooch
- 0 Replies
- Last post
by hooch
- I hate people that don't put what they want in the subject and I just did it. But I am not sure what I want. I am hoping someone has an idea for me.
I have a vb script that parses a file and sends it off to a server a line at a time. The server prossess it and then the next line is sent. Depending upon which server I am sending it to and how busy it is this can take from 10 minutes to 2 hou
-
- Attempted to read or write protected memory. This is often an indication that other memory is corrupt
by Girish Nair
- 4 Replies
- Last post
by Tan Check Leam
- I am getting this error when trying to open oracle connection from visual studio 2005.
I am pasting the stack trace here.
at System.Data.Common.UnsafeNativeMethods.OraMTSJoinTxn(OciEnlistContext pCtxt, IDtcTransaction pTrans)\r\n at System.Data.OracleClient.TracedNativeMethods.OraMTSJoinTxn(OciEnlistContext pCtxt, IDtcTransaction pTrans)\r\n at System.Data.OracleClient.OciEnlistContext.Joi
-
- vlookup and match and delete the rows that match
by keilah
- 0 Replies
- Last post
by keilah
- Hi
Cna any one provide a forumla or vba code to vlookup data in table one match it with data in table two and hen delete the matched items from table one ONLY.
regards
-
- Excel Data to PDF
by KevinS99
- 0 Replies
- Last post
by KevinS99
- I have developed a Fillabel PDF form; the users use basic data such as name address and so forth from an Excel Spreadsheet which is create from an SQL database by a VB App. Now they want where they can take a single record from the spreadsheet which might contain any where from 1 record up to a few hundred. We have created the app for the users to pull the data from SQL to Excel because they are o
-
- iexplore.exe - Application Error (EVERY TIME I CLOSE IE7) :(
by sapphireoceans
- 14 Replies
- Last post
by Jillytodd
- Hi, I am absolutely clueless as to why this keeps happening, but it is driving me insane!! The exact error message reads: 'The exception unknown software exception (0x0eedfade) occurred in the application at location 0x7c81eb33.' Could anyone shed some light on maybe what the cause is and/or how I can fix it Thank you in advance to anyone who reads and/or offers any information. Laura x
-
- Timer on macro execution run time
by une
- 8 Replies
- Last post
by Andy Pope
- I have written some text analysing code that takes a long time to execute if the text selection made by the user for analysis by the macro is too large. Therefore I would like to add the following functionality to the macro;
If after 15 seconds of execution the macro has not completed, I would like execution to halt and output a message to the user asking them to reduce the size of the sele
-
- Run time error 1004
by Donald Wm. Johnson
- 11 Replies
- Last post
by Phillb
- I am attempting to delete a range of cells in an Excel spreadsheet using a Macro. The range is one row by 8 columns. However, when the line of VBA code actually doing the deletion is reached I get a "Run-time error '1004': Delete method of Range class failed."
The actual line causing the error is:
Selection.Delete Shift:=x1Up
where I have previously selected the ra
-
- Run time error 1004
by Donald Wm. Johnson
- 11 Replies
- Last post
by Phillb
- I am attempting to delete a range of cells in an Excel spreadsheet using a Macro. The range is one row by 8 columns. However, when the line of VBA code actually doing the deletion is reached I get a "Run-time error '1004': Delete method of Range class failed."
The actual line causing the error is:
Selection.Delete Shift:=x1Up
where I have previously selected the ra
-
- How to turn OFF Simple File Sharing via Policy Editor in Server 2003
by TheTom
- 2 Replies
- Last post
by 1222256
- We are in the process of rolling out Sophos AV. One requirement is that you must turn off Simple File Sharing on clients (XP Pro). As we have 100 desktops to deal with, we'd like to do this via Policy Editor. I can NOT find any entry that will accomplish this in the editor. Any help out there Thanks!
TheTom
-
- Narrowing a query
by ram121
- 3 Replies
- Last post
by ram121
- The query displays several records with several fields. How can I narrow the query down to pull a single record of multiple records in which the account number occurrs more than once. (It is the account number that I'm trying to get to pull just once for an entire record.) The catch is, there is one work order for in-State, and one work order for out-of-State. However the in-State one sometimes mu
-
- Getting The Conten Of A Word Document?
by KAMACI
- 7 Replies
- Last post
by KAMACI
- How can i get my ActiveDocument's content