-
- Regarding getting references that can be applied towards ISV Competency
by H Patil
- 2 Replies
- Last post
by Dean Cline
- Hi:
We are an ISV that has developed a financial software using .NET. We are currently in the process of certifiying this product for Windows Vista.
I had a little confusion over getting customer references for the purposes of getting the ISV Competency: The MSPP Program Guide mentions that we can get references for projects that we have done, but since we are primarily a product company,
-
- Display information as a whole
by Jade_Emeperor
- 2 Replies
- Last post
by Jade_Emeperor
- Hi. I'm having trouble displaying the RFID tag's infromation. The program display like this:
PC > Reader: 07 FF B0 01 00 1C 56
PC < Reader: E0 05 40 00 00 5C 2B 34
PC > Reader: 11 FF B0 23 01 E0 05 40 00 00 5C 2B 34 00 01 1F 21
PC < Reader: E0 05 40 00 00 4C 2B 34
PC > Reader: 07 FF B0 01 00 1C 56
PC < Reader: 35 64 64 61
PC > Reader: 11 FF B0 23 0
-
- WSS 3.0 "This stock feature has been retired."
by bafadam
- 14 Replies
- Last post
by cis365
- What is this error No hits on google, nothing wrong with the page....nothing (that I know of) has changed recently.
Anyone have any clue with this could possibly be referencing
-
- How to activate a listbox selection using Excel VBA?
by Kven
- 14 Replies
- Last post
by Andy Pope
- Hi,
I am very new to VBA Progamming. I have created a tool which checks for error in excel file. The below is my problem.
First i will select a file using Openfile method. Then the combobox will display all the sheets which are present in the selected excel file. Here i will select a excel sheet and run a code to check errors. The procedure will check the errors and shows how many errors
-
- VBA function similar to the Count(DISTINCT) function in SQL
by Payback
- 1 Replies
- Last post
by Bruno Yu - MSFT
- I am trying to find a function in VBA which is similar to the count(DISTINCT) function in sql. Can any one help me
-
- Run Time Error 9 when Calling a Userform
by Joe Dawson
- 6 Replies
- Last post
by Joe Dawson
- Hi folks, I am getting a run time error # 9 when I run a macro that calls a Userform or when I try to run code in a Userform module. The code performs beautifully on my computer, but it did not work on a coworker's computer. It ended up working on 3 out of the 5 computers I have tried it on. I have tried changing security settings to low, and a bunch of other stuff, but I cannot get the code to r
-
- appactivate error
by Brad2007
- 1 Replies
- Last post
by Shasur
- How to know if the appactivate has activated a window or if it has not....
-
- WMI.Net 2.0
by GUYO
- 11 Replies
- Last post
by Gabriel GHIZILA
- The next manged code library for WMI was discussed at TechEd this year and has popped up in a couple of webCasts. -- The WMI.Net 2.0 is supposed to provide writeable properties and invokable methods from managed code.
Is there an update on the release Beta program etc... --
-
- How to get the filename into the "Insert Picture" dialogue?
by Jess Chan
- 3 Replies
- Last post
by Andy Pope
- Our company written a marco that used in MS Words and it as same as the "insert -> picture -> from file" dialogue,
but we want to enhance it to get the filename automatically when the dialogue box is opened to instead of blank.
-
- response.setHeader in IE
by ksrk
- 2 Replies
- Last post
by WillSBoston
- Hi All,
I am trying to develop an web application java, thru which i can download an xml file.
My code is working fine in FireFox. But the same code is not working in IE 6 & 7, the file contents are displaying in the browser itself. I am not getting any download option.
Here is my code
response.setContentType("application/xml");
response.setContentType("applica
-
- 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
-
- Setting the Data Format for a Column via VBA
by HMote
- 1 Replies
- Last post
by HMote
- I need my datetime stamp to show both, but by default, I guess, when VBA compiles my data from SQL Server, only the date shows. I change this and save the workbook, but the format gets over-written each time the data is placed into the sheet. I hope that there is a way to change the data format for a given column via VBA after I compile by data from SQL Server...Any help on this issue
-
- Compatibility Issue Excel 2000 and Excel 2003
by rcash864
- 11 Replies
- Last post
by Jon Peltier
- I wrote a macros for a customer in Excel 2003. He didn't tell me he used Excel 2000 until after the project and like an idiot I forgot to ask. The macros will not run on his version of Excel 2000. A compile error shows up.
So he got a version of Excel 2003 and the macros will still not work for him. I have tested this macros on other machines using 2003 and they all work correctly for me. I liv
-
- IsError function from VBA6.3 to v6.0
by SuzukiBandit
- 8 Replies
- Last post
by SuzukiBandit
- Hi All, I'm having problems with a small VBA script that I wrote in v6.3 but need to implement in 6.0. Excel 2002 -> 2000.
The following code works fine in the later version:
For i = 2 To LastRow ' select the next row based on loop vString = "A" & i If IsError(Application.VLookup(Range(vString).Value, vRange, 31, False)) Then Y = "NEW" Else
-
- Once copied, can we export as a GIF file?
by Perry Choy
- 28 Replies
- Last post
by Perry Choy
- How to convert MS Excel to jpg or gif and paste/insert to MS Word thank you very much
-
- How to activate a listbox selection using Excel VBA?
by Kven
- 14 Replies
- Last post
by Andy Pope
- Hi,
I am very new to VBA Progamming. I have created a tool which checks for error in excel file. The below is my problem.
First i will select a file using Openfile method. Then the combobox will display all the sheets which are present in the selected excel file. Here i will select a excel sheet and run a code to check errors. The procedure will check the errors and shows how many errors
-
- Edittin Macors in EXCEL
by Ahmad Jamal
- 2 Replies
- Last post
by Ahmad Jamal
- Hi
This is ahmad, My question is "How can i move one column to the right "
Sub Macro5() ' ' Macro5 Macro ' Macro recorded 6/2/2007 by Administrator '
' Range(Selection, Selection.End(xlToRight)).Select Range(Selection, Selection.End(xlDown)).Select Selection.Cut Selection.End(xlUp).Select Selection.End(xlToRight).Select it should move one column towards ri
-
- TexBox.InputMask error message
by Jo&#38;&#35;22
- 0 Replies
- Last post
by Jo&#38;&#35;22
- Hi all, in Access 2000 i have a form with a textbox that i set the InputMask propertie. When i "run" the form and the value i put in the text box aren't "approprite", the Access pop's up a messagebox with: "The value you entered isn't appropriate for the input mask ... , specified for tis field". Please, can someone tell me how can I capture this message or change
-
- Refining MS Access data and saving to csv file using VBA code (Answered)
by kareshi
- 1 Replies
- Last post
by kareshi
- Hello, I have a table with these sample data pattern: Col1 Col2 001 2 002 1 002 2 002 1 003 4 003 4 003 3 003 3 003 5 The expected output in the csv file will be exactly like this: 001,2 002,4 002, 002, 003,19 003, 003, 003, 003, In the csv file, the number next to the topmost 002 is the sum of the Col2 where Co
-
- Email Form from MS Word
by agill
- 3 Replies
- Last post
by Shasur
- I want to be able to automatically attach a MS Word protected form and email from within Word. Need the email address, subject line and attachment to be done automaically, and will have to turn document protection off and then back on after email has been sent.
Help! This is what I have so far...
Sub SavenEmail() ActiveDocument.SaveAs FileName:= _ "4-7 3-2 New_Change Produ
-
- Excel 2003 CommandBarButton
by RonBonBon
- 4 Replies
- Last post
by RonBonBon
- Hi
I have added a CommandBarButton to my excel workbook.
My question is how can i make it load with my workbook (i mean when i open my file)
Thank's.
My code sample is:
Dim cb As CommandBar Dim b As CommandBarButton Set cb = Application.CommandBars("Standard")
Set b = cb.Controls.Add(msoControlButton, , , , True) b.Caption = "Hello" b.FaceId = 234 b.Style =
-
- 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
-
- Conditional Formatting Problem/Bug?
by FaV1105
- 8 Replies
- Last post
by FaV1105
- This is my first time in a forum. I have mostly found all the answers I could but I can't seem to find the answer for this:
I don't know if this is a bug in excel or if I am doing something wrong.
I start a new Excel application from another workbook and apply a conditional format that uses an array formula for its condition (I have read that conditional formatting always formulates
-
- Help needed: Retrieve tables in word and copy them to Excel
by Rz1986
- 3 Replies
- Last post
by bi-lya
- Hello everyone,
I have been assigned a task at work to write a VBA for automation. We have many word documents in a folder that have hundreds of tables within them. I want to create an automation program that is going to retrieve tables from the word document specified and go through the document table by table copying these tables into a separate Excel sheet named after the document itself
-
- Compatibility Issue Excel 2000 and Excel 2003
by rcash864
- 11 Replies
- Last post
by Jon Peltier
- I wrote a macros for a customer in Excel 2003. He didn't tell me he used Excel 2000 until after the project and like an idiot I forgot to ask. The macros will not run on his version of Excel 2000. A compile error shows up.
So he got a version of Excel 2003 and the macros will still not work for him. I have tested this macros on other machines using 2003 and they all work correctly for me. I liv