Answer Questions

• ajhuddy Excel edit mode

  How can i detect "edit mode" in excel macros Thank's for idea(s) Hi Vladislav, If you could provide a detailed scenario our engineer will be better able to assist. Also, why do you want to force "Edit mode" When Excel is in "Edit Mode", macros will not run. thanks, -brenda (ISV Buddy Team) Per the engineer:   Depending on the version of Excel, you can check the "Application.Read ...Show All

• Kim9999 SaveAs question

  Hi, I have a piece code that does SaveAs at the end of the program but it always tells me that file already exists and do you want to replace it. I do not want that message to pop up and i want program to just overwrite it. I had in the code both application.displayalerts and screenupdating set to false but still does not work. I had the same code in another macro and it works fine. Any ideas why this does not work. I am exahausted trying to ...Show All

• Sal M html tag not working

  Anybody can tell me why the COLGROUP tag below does nothing to my table Sub send_email_confirm() Dim objMail As MailItem Set objOL = New Outlook.Application Set objMail = objOL.CreateItem(olMailItem) ' determines if sale or purchase Dim side As String If Sheet2.Cells(6, 8) < 0 Then side = "Sold at " Else side = "Bought at " End If With objMail .To = " tradeallocations@trade.com " .C ...Show All

• MuradAkram Openening an Excel file from within Project

  Does anyone know how to open and read/write to an Excel file from using Microsoft Project Visual Basic Thanks, Thank you, thank you, thank you. The bit I was missing was setting the reference. Best, Mark Edmonds Per our support engineer: Hi Mark, you can use excel automation from visual basic to open /read/write to an excel file. How To Automate Microsoft Excel from Visual Basic http://support.microsoft.com/kb/ ...Show All

• John W Powell Metadata driven Applicaiton Composition Framework

  Hi, I am looking for an ISV application for .NET that helps end users define business entities, establish relationships and create business workflows. The above requirements mandates metadata driven approach and any informaton ISVs with this kind of solution will be helpful. Regards, Hanu Hello Hanu, This site might be really helpful in finding a solution for your needs: http://www.microsoft.com/dynamics/solution_finder.mspx ...Show All

• timlshu VBA WORKSHEET

  COMPILE ERROR END IF WITHOUT BLOCK IF Sub EnterDates() Columns().Clear Dim EilDownloadSheet As Worksheet Set EilDownloadSheet = Workbook.Worksheets("Name of worksheet") Dim startDate As String, stopDate As String, startCel As Integer, stopcel As Integer, dateRange As Range On Error Resume Next Do startDate = InputBox("Please enter start Date: format (dd/mm/yy)", "Start Date") If startDate = &q ...Show All

• Amit Copy...Paste...by Macro!

  Hi, I am writing a macro. It should enable to copy rows ( i presented) that satisfy .Cells(i.11)>0 and .Cells(i,2)>.Cells(3.17) among rows(4:307), and paste them to rows (j presented) with the first cell blank. My wrong macro is as follows: Sub Datatransfer() With ActiveSheet For i = 4 To 307 For j = 309 To 400 If .Cells(i, 11) > 0 And .Cells(i, 2) > .Cells(3, 17) Then Rows(i).Select Selection.Copy If ...Show All

• Turru HELP: Business Scorecard Manager 2005

  Hi all, Good day! We have Sharepoint Portal Server 2003 installed in our system. I installed both the Business Scorecard Manager Server and Builder (demo_ in the same server with sharepoint. The installation went well but there seems to have no change at all. I have use scorecards before with scorecard accelerator. I don't know if this is an issue but we don't have SQL server 2005 installed. Then again, it would have prompted an error if its a ...Show All

• Guillermo Proano MSFT Documentation on use of Me

  I cannot find any documentation on the use of Me as in "Me.Range("a10:a59").EntireRow.AutoFit". What does the "Me" stand for or where can I find documentation Thanks Hello Joe, In the Visual basic and VBA world Me refers to the current class/object that you are in. When you are in a User Form Me refers to the UserForm (see documentation for UserForm), Same thing for when you ar ...Show All

• jfk123 vba5.0 doesn't work on dual core computer with Windows2003 system

  We have tested at Dell dual core computer(PRECISION 670 and OPTIPLEX 620). If we uses Windows XP, it works well. But it doesn't work at Windows2003, even can't work when disable one CPU and disable Hyper-threading. The VBA initialization succeed, but the application crashs at call CallMacro function. I don't know what's the matter with it. Update to VBA6.X seems not easy and also not sure if it can work. H ...Show All

• yhhuang MSFT OWC10 Chart to print on a report

  I am trying to create a Stacked bar chart dynamically in Access VBA to include on a report.  I have to build it with VBA because I need to manipulate the color of the stacked bar slices based on the data values.  This graph gives me the exact results I need, however, I cannot get the graph to run when the form opens (loads) and cannot get it to function when dropping it onto a report as a subreport. Create a form called frmChart_ ...Show All

• doug_hettinger amjad

  whay the massenger is net eccept sgin in with to emails it's just only one emial it sign in This Independent Software Vendor (ISV) forum isn't the best choice for your question. You might try posting your question to the Messenger newsgroup: www.microsoft.com/windowsxp/expertzone/communities/messenger.mspx -brenda (ISV Buddy Team) ...Show All

• Jonas Roineslien Adding an Outlook Feature

  What I want to do is relatively simple. I'm not asking for someone to do this for me, I just want to pick people's brains for a little direction and I can take it from there. What I'd like to do is write a script that would give Outlook users the option to right click on an email message and have a function, say "report spam" that would create a new message with the selected message as an attachment that has a specific email address in ...Show All

• anthonyjl What's your experience with the buddy program?

  Started by admin at 03-28-2005 5:11 PM. Topic has 2 replies. 03-28-2005, 5:11 PM admin Joined on 12-16-2004 Posts 14 What's your experience with the buddy program We've already received a couple of posts on buddy experiences (thank you!) and would love to see more of them, so feel free to jump in and reply to this post and share yours! Thanks, Brenda [msdn/isv] ...Show All

• Kirk Brote Program code fro sorting coloumns in a listbox VB Excel

  Hi I have in my UserForm a listbox, where I capture the A2:G10 in Spreadsheet1 And my problem is that I want to manage to click on the column header (in the listbox of the userform) to sort the coloumns. I hope that someone pls can help me sort this out! tullaolsen;) Hello tullaolsen In addition to Derek's reply, I would say your best bet is one of the following approaches: 1) Have a button with code be ...Show All