Microsoft ISV

Page 204




  • Topics
    Replies
    Last post
  • Beginner in VBA
    by VBNewby
    2 Replies
    Last post by VBNewby
      • I'm using a macro that runs before saving the workbook and allows the user to spell check each individual protected worksheet. How do I also allow the user to be able to format cells, format rows and insert rows while still doing what it is already doing Please see the code below that I am currently using...I can't figure out how to modify as stated above.... Private Sub Workbook_BeforeSav
  • Calculate hieght
    by YaelS
    1 Replies
    Last post by Bruno Yu - MSFT
      • Hi, This method change the hieght and Width of the sub form in the form calling in form resize event. I don't know what is 6615 parameter meens ctrl.height = fHight - 6615 + DEF_H Code Snippet Sub sub_forms_hieght(frm As Form) Dim FLeft As Long Dim FTop As Long Dim fHight As Long Dim FWidth As Long Dim ctrl As Control Const DEF_H = 3850 Const DEF_W = 7335 Call GetFormD
  • MS EXCEL VBA Project password message
    by PCNUT
    1 Replies
    Last post by Luiz Claudio - MVP
      • Hello! I am trying to write a macro for one of the worksheets in a workbook, and keep receiving a prompt for "VBAProject Password". I am not sure what that is as I did not set a password before. Can anyone please provide some guidance. Thank you
  • Searching for a string value and copying the first row and colum entries.
    by NeilNeil
    3 Replies
    Last post by AussieJames
      • I have a spread sheet that gets data from a data logging software and puts it into my spread sheet. The first colum contains the name of the tags for the data ("On" or "Off"), the top row contains the time when the data was sampled. What I am trying to do is write a macro to search the data for "On" entries and if it finds a cell that contains "On" it will t
  • TextBox height
    by suznal
    8 Replies
    Last post by suznal
      • Excel 2003 - TextBox What would the code look like to have a text box maintain a specific width and a minimum height but increase in height as data is entered
  • Outputting to a Listbox
    by UniRyan
    7 Replies
    Last post by Andy Pope
      • Hi; I have a list of data, and need for values outside a lower and upper bound to be flagged up to the user. I was thinking of outputting to a listbox, but cant get the code to work. I was wondering if anyone had any ideas for possible code, or a better way of outputting to the user. Ryan
  • Are these valid bucket ids ?
    by DHON
    14 Replies
    Last post by Claus Brod
      • Hi Jason, Saar, The reports at my end is having following bucket id : 456012092, 455976259, 455999458, 49984945. But these reports are not available in Winqual - atleast I can't see when I log in to Winqual. One of them is as old as 6 days. Others are one day. Could you please, confirm whether these are all valid bucket id If not then reason. Thanks, DHON
  • Local Folders - Inbox
    by DivaMaggie
    1 Replies
    Last post by DivaMaggie
      • In Outlook Express 6, under Local Folders - Inbox, I have a (1) and there is no actual mail. In other words if beside Inbox it says (5), there really are only four emails and the (1) always stays beside inbox. Was hoping maybe someone could help.
  • Search & Replace macro, formatting characters
    by Robin Haynes
    0 Replies
    Last post by Robin Haynes
      • I am writing a (supposedly) simple macro with VBA to take a log file and slice it to create several smaller files to ease troubleshooting. All my formatting and naming and path placement work beautifully. But I'm spawning over 1000 handles to do so, which strikes me as odd. The original file is local, as are all the created files. The original file is rather large, some 10MB for ~2000
  • Automatic Updates
    by rodcon
    2 Replies
    Last post by rodcon
      • Using Office 2002. How do you have a master Excel spreadsheet update automatically from a separate, source Excel spreadsheet whenever the master document is opened This is new to me; I hope I am not wasting people's time Thank you, Rodney Conroy
  • LCS 2005 - Configuration and Archival facility
    by Bikash Kali Maity
    2 Replies
    Last post by Bikash Kali Maity
      • I have installed Live Communication server 2005 and SQL SERVER 2000SP3a. But I am unable to activate and create pool. Can you please tell me the steps how to activate and create domain/pool etc Has LCS SERVER 2005 facility to archive all the communication between the users
  • Corrupt CDs received
    by RPKJBP
    0 Replies
    Last post by RPKJBP
      • I joined Microsoft Empower ISV Program and received my first set of software last month. After installing the products one by one, I was stunned to see that few DVDs contain corrupt installation of Visual Studio 2005 Professional and SQL Server 2005. I guess what's the use of getting licensed software in this manner.
  • Can you use VBA to access a spread sheet embedded in a word doc?
    by Trisped
    13 Replies
    Last post by Trisped
      • I am trying to use VBA code written in MSWord to access an embedded spread sheet. I can't find any documentation on how this is suppose to work. Does word access the sheet through an instance of excel Is the sheet part of the document so I can find it in the "ThisDocument " I have tried everything I can think of, so any help would be appreciated.
  • Dusting up on VBA - Excel/Powerpoint
    by Rockstar
    2 Replies
    Last post by Anonymous
      • I have a few projects requirying knowledge of VBA for PPT and XLS - can anyone recommend any online guides to get me updated and back into VBA ...... tis been so long since I have touched this language! Cheers
  • Application.ScreenUpdating Problems
    by SethEden
    6 Replies
    Last post by SethEden
      • I've been developing this really massive VBA Excel Application as part of a government contract and it's gotten to be about 55,000 lines of code, optimized down from more than double that of course. Everything seems to be working nearly perfect and I think I've even solved my problem with the call to Application.ScreenUpdating, but I'm not really sure why, and I couldn't find documentation
  • Directss Install
    by Edday
    4 Replies
    Last post by AzmathMoosa
      • hey i have written a program in Excel using VBA and it used a module called DirectSS which is like the application.speak but is much more customisable (speed, tone, visual) which is why i used it. When i got home, i went to work on it and DirectSS isn't installed on my computer. I have googled quiet abit and found next to nothing on DirectSS. Does anyone here know how to install it or where to get
  • Worksheet_Change event and dropdown list
    by ADG
    4 Replies
    Last post by x_centric
      • Hi all In Excel I have a cell with validation set , (restricting input to values in a range), and a dropdown list for the user. When the user changes this cell by using the dropdown list it does not seem to trigger the worksheet change event. I want the change of cell to trigger an event to collect data relating to the selection. Any ideas why the drop does not trigger the event as expected
  • seek for a file
    by Bortch
    1 Replies
    Last post by ADG
      • Hello I want to seek for a file in a directory from Visual Basic and to know if is opened or closed.
  • Visual Studio 2005 and Sharepoint
    by David M Barlow
    0 Replies
    Last post by David M Barlow
      • Have just bought a new server with Windows 2003 R2, and Visual Web Developer 2005 for laptop. I have been learning and developing my app locally with local iis - no problem. Network dude says server is ready, and instead of good old fashioned IIS with FP server extensions, there is this strange sharepoint stuff!!!! If I try to create a new website from within VS2005, I get an error saying sharepoi
  • What are the main parameters of my application on winqual account?
    by Nikolai Bochkarev
    2 Replies
    Last post by Nikolai Bochkarev
      • Hello! I'm build my app with ver (for example 5.0.0.0), map my main .exe with Microsoft Product Feedback Mapping Tool and upload .xml file on WinQual account! Do I need to repeat to map my .exe and upload .xml file after rebuild my appliaction (after some chage) What are the main parameters of my application on winqual account - main parameters application of filtering crashes e
  • opc
    by ksona
    14 Replies
    Last post by MartinBrasil
      • I am trying to develop an opc - da client using .net technology. Have gone through the documents on opc and opc client and all, but am still not sure how to implement it, can someone give me a direction on how to start with it
  • WMI / Office2003 Critical Updates
    by jslusher
    0 Replies
    Last post by jslusher
      • An attempt to download and install critical updates for Office2033 failed (Error Code: 0x57E) on two separate events, once using the Automated Updates and once through the Windows Update Website. Also, I'm having a new and continuous issue with the WMI feature of my XP(SP2) Professional operating system. I am using a home network with three computers and a router to access the Internet. I've ran W
  • Can't select option button in Access
    by Keithyboy1
    1 Replies
    Last post by Keithyboy1
      • I don't understand why Access has to be so temperamental and fiddly!! I've got a simple option group, which contains two option buttons, with values of 1 and 2 respectively. On the Form_Load event of the form that contains the option group, the default value of the group is set to 1, per below: Private Sub Form_Load() fraReportInterval.DefaultValue = 1 End Sub I then have an event
  • Cannot Find Library
    by HowDoIComeUpWithAUniqueName50
    8 Replies
    Last post by HowDoIComeUpWithAUniqueName50
      • I developed an application in VBA for office 2003. I tested and sent it to a client. Works fine on my machine but compiling or running it on their machine give the error "Cannot Find Library". It then highlights the function LCase$. I tried using LCase$ in the immediate window and it gives me the same error. I open the object browser (F2) and browse VBA. The String library shows as does
  • How could I count the last column in row 1?
    by lyp_sj
    5 Replies
    Last post by Duane in Japan
      • Hello, I'm new for VBA, so I'm wonderring how I can count the # of column in row 1. Thanks so much for help! B.regards/Yaping