Answer Questions

• histonftm Live Communications Server tab does not show up

  I have just installed Live Communications Server 2005 Standard in my test enviroment. I have a seperate server as a Domain Controller (all servers are Virtual Servers on one physical machine). When I followed all the steps during installation, no errors show up. Also, the HTML log files only display green 'success' items. However, when I open the User Properties window on my DC, there is no Live Communications Server tab. It should show up there, but it isn't. Also, when I open the Live Communications Server Management Console, I only see an empty screen and no 'tree-view' of possibilities. When I manually add the snap in after running mmc, it works and I can see the Forest, Domain, etc. Nothing, except the Management Console, di ...Show All

• EltonSky Upgrading from Excel 2000 to 2003

  Our office is upgrading from 2000 to 2003, and a lot of our old VBA code is starting to fail. I'm working my way through and finding and fixing all the errors... but I'm wondering if anyone knows if there's a tool for converting code to the newer VBA version, or if there's a definitive list somewhere of the code/syntax changes that have been made between the versions I know of no such tool to convert VBA. You should be able to find references on Microsoft's site that describe changes to VBA. Keep in mind that you'll need to see what's new in 2002, then in 2003, for your upgrade. Try a search like this: http://www.google.com/search hl=en&lr=&q=microsoft+office+vba+what%27s+new+2002+2003&btnG=Search ...Show All

• JerberSoft How to store data without database

  Dear all, I am developing a sales management application for small business use. Besides delivering program with MSDE or Access, is there any way to store data without database It is because I find it troublesome to deliver database togather. Please give some advice. Thanks. Javad Khadivi is right. If your classes aren't that complicated look up for XMLSerializer. Hi, Thanks for your reply, if I use XML to store data, can I use SQL like command to retrieve and search data from XML Any library recommended Thanks again. If your data not very large, you can use XML files. But if your data is important and you must secure it , you have to encrypt your data ...Show All

• m.eisenstein MS Office document and image writer print driver

  Besides removing this feature from Office during setup, is there a process to remove this virtual printer from 300 users with roaming profiles on an active directory network We are having an issue with this printer assuming the "default printer" selection for our users. As a work around we have changed their default printer, but after they reboot or log off / on it has defaulted back to the MS Ofc doc and image writer printer. Thank you! Per our support engineer: Thanks for using ISV Community Forum, according to your problem, I’m wondering whether you can simply log on the machine as administrator and delete the virtual printer (just select the icon and pr ...Show All

• Steveisok Pull data from .csv files into one main .csv file

  Hi all, Does anyone know how to pull data from specific columns from specific .csv files into one main .csv files / Help appreciated, thanks. Sure. Here's a quick piece of code that demonstrates grabbing data from a CSV file using the row and column number: Option Explicit Option Base 0 Public Sub Main() Dim fptr As Long, fnum As Integer fnum = FreeFile() Open "C:\temp\Book1.csv" For Input As fnum MsgBox GetDataFromCSV(fnum, 1, 2) Close fnum End Sub ' 1-based row/col parameters Private Function GetDataFromCSV(tFileNum As Integer, tRowNum As Integer, tColNum As Integer) Dim ll As Long, tInStr As String For ll = 1 To tRowNum Line Input #tFileNum, tInStr If ...Show All

• throll Check if an Excel workbook is opened and in use by somebody else

  Hi, I need to check if a workbook is opened and in use by someone else. workbooks.open does not return a trappable error How about the WriteReservedBy property of the workbook. May not work in networked situations. In which case may using some like this to get open files and username. http://vbnet.mvps.org/index.html code/network/netfileenum.htm Hi, Have at a look at these 2 options for checking a file. http://www.xldynamic.com/source/xld.FileOpen.html Excellent, thank you, the second worked very well. Now the second problem is to find out who that "somebody else"-person on the network using the workbook is. I know this is returned in an errormessage when I try to open the workbook direct ...Show All

• Krxtopher How to use pivot data in function?

  Using VBA, I created a pivot table and I want to write a function that uses data from the table. The function I am trying to write calculates what percentage one pivot data entry is of another pivot data entry. So for example if I have a data label "a" and a data label "b", I want to calculate a/b for each row. Do I need to loop through all the rows and extract the entries in each cell from column a and b for use in my function or is there an easier way Thanks, Mike ...Show All

• JamesZ Tables in Word 2003

  Hi, I am trying to solve a problem with tables that is causing some concern for my wife. She has various tables she uses in her job as a teacher and regularly has to update them. the problem is she would like the table to stay the same size and the text to change size if it cannot fit in a cell. In other words she may be changing the text in a cell on 12 point and it currently expands the cell to accomodate any additions, she wants the text to automatically reduce its point size to fit the cell. Is this possible anyone out ther done this or something similar Thanks Regards RobEJ53 Hi, There is a public newsgroup dedicated to Word tables that might be more helpful to you: http: ...Show All

• chongqing vba create and add a macro for excel programmatically

  Hi all I am currently traying to introduce into an excel spreadsheet a macro programatically. I have found examples on the net but they dont seem to work or they are for VB and not VBA. I was wondering perhaps someone knows how. I am currently generating many the excel spreasheets from through access vba. I am stuck when adding the macro to the sheets. They just dont seem to be there even though i save the data. Here are two examples i tried. The first one is VB so not a chance it will work but the second should and it doesnt. It does not give any errors or nothing. The excel sheets are created but no macro! hmmm EXAMPLE 1 myWrkb.VBProject.VBComponents.Add 1 'vbext_ct_StdModuleWith myWrkb.VBProject.VBComponents myWrkb.VBProje ...Show All

• Mehta Vikas Load userform returning variable not defined error (91)

  Hi there, I haven't previously had any problems loading/hiding etc userforms in vba, but I've just finished a project that runs fine when stepped through. However, when run properly, it returns a variable not defined error on the Load xForm command. The form is in the same templateproject and the load form command is the first to be executed. Any ideas Thanks in advance Thank you! Could you post the code that executes when the form loads This code runs on the form's initialize event: frmWeb.WebBrowser1.Navigate (" http://wokiisp.net/index_res.asp ") frmWeb.WebBrowser1.Document.all("ServiceID").Value = 71 WebBrowser1.Document.all("ServiceID" ...Show All

• F.Costa Search list

  Hello! I have a small problem that I do not know exactly how to solve. I have a macro that that searches a list in Excel for a certain date e.g. 2006-02-14. The date is stored in the array strSlutDatumArray(1). I look using rng(1).Offset(j, 0) (never mind that but it just loops down in a list). I apply this code on many lists. Almost all lists consist of dates based on a 5 day week. However some lists only contain one date per week. Assume that I am searching for the date 2006-01-10. The lists contain only 1 date per week. I want to somehow check so that I choose the date closest to 2006-01-10 in the list. Assume that the list looks like: 2006-01-01 2006-01-08 2006-01-15 Then I want to stop my se ...Show All

• Steve Dunn Record, playback, macros

  What's the keyboard shortcut to record a macro What's the keyboard shortcut to then play it back I don't think that there is a keyboard shortcut for recording. To record a macro use Tools - Macro - Record New Macro. Whne the dialogue comes up you can assign a keyboard short cut for replaying. ADG wrote: I don't think that there is a keyboard shortcut for recording. To record a macro use Tools - Macro - Record New Macro. Whne the dialogue comes up you can assign a keyboard short cut for replaying. Damn, wrong group. i meant to ask this in the C# forum. i'll mark the answer as helpful - even though it wasn't - because maybe it'll help someone else. ...Show All

• Alexander K Need help getting URL information via File Dialog

  I am wondeirng if there is a way to have the file dialog box (or something similar) return a URL value from the selected file. Basically the issue I am having is that I am trying to add hypertext links to files stored on a shared network drive into an access table. Currently, using a pretty basic file dialog approach, the hyperlink text will be based on the file path as defined for each user. In other words, if the user has the network drive mapped as the G drive, the hypertext value returned is "G:\\..." or if the user does not have the drive mapped at all, the network-assigned URL for the drive is returned (i.e. \\DriveName\... ). The latter (the user-independent URL) is actually what I desire to have returned as the value, so as to make ...Show All

• Balaji Srinivas Help Building a Custom Annotation Report View for BSM

  Hi, I am trying to make a custom report for MS Business Scorecard server. I have implemented the sample report from the white paper on building custom report. When I alter that code to output annotations it crashes the report or portal its self. The code is the same except I added the GetTheAnnotations()function and created a new PMServer() which is part of the Server class. Please suggest how to access the annotation with the scorecard API. This is the code used: using Microsoft.PerformanceManagement .Scorecards.Extensions; using Microsoft.PerformanceManagement .Scorecards.Client; using Microsoft.PerformanceManagement .Scorecards.Server; output.Write(HttpUtility.HtmlEncode(GetTheAnnotations())); ...Show All

• xdzgor subscript out of range

  I am getting an error when running the script Do While (Not (Workbooks(bookmonth).Worksheets("by associate").Cells(4, i) = "dsl") Or Not (Workbooks(bookmonth).Worksheets("by associate").Cells(4, i) = "hsi")) I am uncertain why this is coming up. i is currently set to 1, so it should be starting to search in cell a1. I can not see anything wrong with the code that would produce a type mismatch on that line. Any value contained in the cell A4 would be compared to the two string values and would either proceed into the loop or pass over it. What value do you have in the cell when the test raises the error thank you, there was an error in my code and it was not populating bookmonth ...Show All