SKK*'s Q&A profile

• Visual Studio Team System EXCEL MACROS

  I have a doubt and I need to know if I can get some advice. I have a macro in an Excel file, which opens other 6 files and then format them. After that it creates a new file, where it copies all the information from the previous 6 files and starts a loop creating 1.000 files approximately. My problem is that after 50 files are created, the code starts taking 1 minute per file, when before that the macro takes only 1 minute to create 10 files. What should I do to improve the macro’s performance to continue with the initial speed I believe it should be related with the way excel handles files. Pls let me know if you have any tips…….Thanks in advanced for your help!!! Sorry, this forum is related only to development using Team Suite v ...Show All

• Visual Studio Problem with CreateProperty

  If I create a property like this: < CreateProperty " Value=" something" >   < Output TaskParameter="Value" PropertyName="MyProperty" /> </ CreateProperty> MyProperty will get "something" instead of " something", the space is gone. Is this expected or a bug Regards, Gustavo Guerra Well, I can workaround not having the need for the space at start of the string, or using %20, but I just wasn't expecting it and had a bug because of it Best regards, Gustavo Guerra ...Show All

• Visual Basic File.Exists and FileInfo.Exists fail to recognise existence of file

  I'm having problems in accessing files that are newly created in a SharePoint location. I'm mapping a drive to a SharePoint share, and using the path as expressed through that mapped drive letter. However, when I try to work with a file that is created within that path, .NET's file system classes fail to recognise the file. Some observations: 1. FileSystemWatcher seems unable to respond properly to file changes within the path, and won't recognise that the file has been created. 2. File.Exists and FileInfo.Exists return FALSE for a file that exists. 3. Windows Explorer doesn't list the file when it's created. Pressing F5 will list the file. From then, .NET's .Exists method seems to work. 4. Directory.GetFiles and Director ...Show All

• Visual C++ Compiler misbehavior and internal compiler error

  While messing around with some metaprogramming stuff, I have just found out that writing this: //*********************************** enum E { value = 0, }; int _tmain(int argc, _TCHAR* argv[]) { typedef void (E::* pEnumMember) (int); } //*********************************** The compiler does not say a word and compiles fine. If then you go on and do something like this: //*********************************** enum E { value = 0, }; struct S { void Function(int) {int a = 43;}; }; int _tmain(int argc, _TCHAR* argv[]) { typedef void (E::* pEnumMember) (int); pEnumMember p = reinterpret_cast<pEnumMember>(&S::Function); //upps } //*********************************** you get an internal compile ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Lauching another DX program in a window

  I know it's possible to run another DX/D3D program in a window, but how exactly would one go about doing this I've scoured the internet and I only get links to a dated program that allready does this, not how to do it myself. Well that program is for early versions of DirectDraw only so it might be doing something particular to those APIs [moving to DirectX general since this is not a 101/beginner problem - hopefully someone smarter than me will know an answer] ...Show All

• .NET Development Method can not be reflected

  Hi everybody, I'm using a Web Services that was not written by me. Anyway, when i call the client proxy (stub) i receive the follow exception An unhandled exception of type 'System.InvalidOperationException' occurred in system.web.services.dll Additional information: Method Selection_Archive.ListEntitledSelection can not be reflected. I can't understand why i have this exception. This is the client stub's code (automatically generated with wsdl.exe): public SL ListUserSelection(string user, string pwd) { object[] results = this.Invoke("ListUserSelection", new object[] {user, pwd}); return ((SL)(results[0])); } Hope you can help me. Cheers ...Show All

• SQL Server Matix: refering to TOT column

  I Have a Matrix: IN OUT TOT num avg max % num avg max % num avg max % r1 r2 I want calculate the "%" so: num(tot)/num(in/out) I added the column tot wiht right-click.... etc How I can refer to num of TOT Thanks abc_abc more details http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=673479&SiteID=1 ...Show All

• SQL Server R

  Hi I am using SQL Server 2005 Enterprise Edition. On this friday i was doing performance tunning for one if queries where i found that Estimated Execution Plan Costs Greater Than 100%. On http://support.microsoft.com/kb/274643/en-us#appliesto MS says that it applies to ? Microsoft SQL Server 7.0 Standard Edition ? Microsoft SQL Server 2000 Standard Edition Does any one knows if it's issue with SQl Server 2005 as well Regards; Rakesh Execution plans are never exact and will probably always have rounding errors which make it add up to greater than 100%. They are only useful to find the parts of the query which have the largest cost, not for the total percentages. ...Show All

• Visual Studio Tools for Office How to get screenshot of MS Word document?

  Is is possible to get screenshots of pages by Word Automation I use Select() then copy/paste to get picture (screenshot of page). This method works fine with text, but have some problems with tables. Can I render Word document into the picture I heard something about virtual printers, but I'm afraid that non-administrator users will have some problems with privileges for virtual printers. What you're looking for, specifically, isn't available in the Word object model. Closest it offers is the following property of the Selection or Range object (from the Help file): EnhMetaFileBits Property Returns a Variant that represents a picture representation of how a selection or range of text appears ...Show All

• Software Development for Windows Vista Does anybody know where I can find largeint.lib ?

  Hi I have C++ Visual Studio 2005 and I can`t build my project becouse compiler call error: I can`t find largeint.lib I installed Microsoft Platform SDK R2 and I made XP32_DEBUG in BaseClasses of it (I work under windows xp 32-bit). I looked all resources for largeint.lib but it returned nothing. Please help me ! In the Project you are building, remove largeint.lib from Properties/Configuration Properties/Linker/Input/Additional Dependencies. The later Platform SDK's include VS2003/2005 project files. See: Microsoft Windows Server 2003 R2 Platform SDK or later. ...Show All

• Visual Studio When Sharing a folder containing a project, the .vspscc files go crazy, or duplicate

  Following a suggestion from the VSS Help, regarding ways of maintaing to separate code version for a project, eg a released version, and a developement  version, where fixes from a released version would also be merged into the development stream. I shared our main project folder, instead of just branching it, to save space, so that for bug fixes, we would just need to branch specified files. An addition necessary step was to branch the actual project files (.vcproj) along with the associated vspscc files. This seemed to be necessary for visual sudio to be able to work with these projects and use source control. When I tried to branch the vspscc files they seemed to duplicate themselves. E.G. They would continue to to maintain a ...Show All

• Visual C++ How To Compare A Value in MS-ACCESS from the VC++

  Hi Friends, Iam doing a Project in VC++ about the Teachers Feedback... I have Username and default passwords in a table in MS-ACCESS in (.mdb) format. In VC++ and using ODBC, i can just add, view,and delete the data in the table(MS-ACCESS). But i want to compare the Username and password which i got input from the users in VC++ dialog box with the Username & password already saved in table(MS-ACCESS).. I cann't do it, can anybody help me how to do it.... Is it possible to compare the data as i mentioned... I need your help friends... You must be using CRecordset or derived class in you app. It has a function GetFieldValue( short nIndex , CStringA& strValue ). You can use it to g ...Show All

• Visual Studio Express Editions Help Needed

  Hi folks, I need to locate a tutorial for a craps dice game for learning purposes can someone help with a link or something any other information will be helpful. Thank you for your support.   DKB spotty wrote: Never played craps, Oh man, you're missing out. Craps is the king of all table games To the OP: are you familiar with the rules of the game If not, programming a simulator of it is going to be pretty tough. Are you having trouble with some specific issue, or do you just want somebody to do your homework for you ...Show All

• Windows Live Developer Forums Dynamically update PolyLines/Polygons and Update Cursor

  This is what I am trying to do. - Dynamically Show a Polyline/Polygon as the users moves his mouse over the map. E.g. user clicks a point and it should start to draw a line and then user moves the mouse accroos the map and as he moves the mouse he should be able to see a line from the start point to current mouse position and then finish drawing when he clicks again on the map - The other thing is, How to show a custom mouse cursor when hovering over a map (.cur file is a URL) Have a look at local.live.com, it has both these features. Now to work out how to implement them is another thing. I use: document.getElementById("MapDiv").childNodes[0].style.cursor = "crosshair"; to ge ...Show All

• Visual Studio Express Editions Datagridview set focus on cell

  How do I set focus on a specific cell in a Datagridview control I am trying DataGridView1.Item( "TotalQuantity" , e.RowIndex).Selected = True DataGridView1.CurrentCell = DataGridView1.Item( "TotalQuantity" , e.RowIndex) ...Show All