Microsoft ISV

Page 153




  • Topics
    Replies
    Last post
  • 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
  • Excel - Resize image to specified target cells' dimensions
    by suznal
    4 Replies
    Last post by suznal
      • I have a command button on a worksheet that calls up the ¡®getsaveasfilename¡¯ dialog, and inserts the selected image file into a merged range of cells. The images are automatically re-sized to fit into the cell (aspect ratio maintained). Everything works well, but I ran into a problem. There are about 70 sheets in the workbook, and this command button can be found about 250 times throughout the
  • LBound and UBound functions
    by Keithyboy1
    7 Replies
    Last post by Shlizar Axis
      • Is there a reference library I need to enable in the VBE to get LBound and UBound functions They don't appear to exist in the Object Browser with the current reference libraries I have enabled. Many thanks!
  • VBA Using InsertObject function to insert graphic file into Form
    by ThomasStricker
    0 Replies
    Last post by ThomasStricker
      • I use the a Module attached to OnDoubleClick Property of Form named ModelPicture1 to InsertObject into the ModelPicture1 form. The Object (*.bmp graphic file) is inserted correctly into the Form during runtime (MS Access Runtime), but is not saved Form when closed. How do I get this file to save into the form Please and Thank You.
  • 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,
  • CRM 3.0 "Server might be unavailable".
    by trep
    4 Replies
    Last post by DavidJennaway
      • Hi, I'm having an issue with CRM 3.0 Clients get this error message where it says "Server might be unavailable". Server is running, services are running, everything looks fine, so i started the Environment Diagnostics Wizard and i get the following: Some of the domain controllers do not appear to be running. The following list of servers should be checked. PrivUserGroup {9cd76ed6-ec49-4e
  • How to check if a date exists
    by HMote
    5 Replies
    Last post by HMote
      • Could anyone point me in the right direction I just need a way to see if a date exists...example: "6/31/07" doesn't exist, whereas "6/30/07" does exist. Thanks!
  • Subscript out of range
    by NutoVBA
    6 Replies
    Last post by NutoVBA
      • I am new to VBA and am trying to create a copy of a sheet from one workbook to another workbook using the following code: Workbooks.Open Filename:=bw_path & "\" & bw_file 'Opening the file from which I want to copy. Sheets(bw_sh).Copy After:=ThisWorkbook.Sheets(3) 'Trying to copy the open worksheet into the workbook housing the macro. I am getting the "sub
  • iexplore.exe - Application Error
    by bennett1016
    14 Replies
    Last post by rreynard
      • I get the following error message when I close my internet explorer. The instruction at "0x62304320" referenced memory at "0x62304320", The memory could not be "read". Click on OK to terminate that program. Any ideas what is causing this
  • using keyDown event to stop non-Hex input in Access form textbox
    by .ken.
    3 Replies
    Last post by .ken.
      • Trying to only allow hex input into a text box. I just started to learn visual basic a few days ago and it is all very neat how powerful it is. My code doesn't work, but any help would be appreciated. or any other ways of only allowing 0-F into a text box would work as well. Doesn't necessarily have to not allow G-Z into the box but needs to stop the program from running if it is entered.
  • Excel ComboBox and VBA
    by truongn2
    1 Replies
    Last post by ADG
      • Hi, I am really stuck on this, please help!!! I would like to have a ComboBox on a worksheet (worksheet1) that is populated by a list on another worksheet (worksheet1). Each time I select something from the ComboBox, it would display text in a cell within worksheet1. For example, the ComboBox would have "Cat", "Dog", "Cow". And when I select "Dog" from th
  • Microsoft Access 2465 Application Defined Error - Form control code reference/Compile issue.
    by Jamie Clayton
    2 Replies
    Last post by Jamie Clayton
      • G'day, One of the problems we have faced recently with an Access application that our company has written and supported for the last 11 years (Access 2 originally and now in Acccess 2003 ) is global variables and the VBA compiler. We had some significant development, debugging issues with global variables going out of scope. So in a crude solution to this problem we have move them all to fo
  • vlookup
    by Namrata Prashar
    14 Replies
    Last post by Namrata Prashar
      • Hello can anyone help me with how to write the excel vlookup function in vba the function in excel looks like this VLOOKUP(O2,'[Consolidated list of supplier.xls]Sheet3'!$A$5:$F$218,6,FALSE) how can i get something similar working in a macro. thanks namrata
  • excel 2003 - sp2 - OpenTextFile(,ForAppending,,)
    by jdrean
    1 Replies
    Last post by Peter Mo.
      • in vba the following command will generate an execption: Set fs = CreateObject("Scripting.FileSystemObject") Set f = fs.OpenTextFile(filename, ForAppending, , 0) Instead one needs to replace ForAppending by 8 (the default value from the system is 3) note: it is confusing because it is working for ForReading and ForWriting
  • Problems with VB solver code
    by Stacy B
    1 Replies
    Last post by Jon Peltier
      • I am writing visual basic code behind an excel spreasheet and am having difficulty making it work. It involves using the solver function. The code is listed below: Sub signif_control_pop() Dim cntlpc Dim pop 'Clear any previous solver settings. SOLVERReset 'Prompt user for population size. pop = Application.InputBox(Prompt:="Population Total:", Type:=1) Range(&qu
  • Inserting rows and columns in protected sheet.
    by Anulas
    2 Replies
    Last post by Anulas
      • I have got a protected sheet in which some of the columns and rows are locked. Hence the user will not be able to edit these cells. But they can edit the unlocked cells. i have set the lock property of all the cells in the sheet to unlock. Then i locked only the requried cells manually. But when i am trying to create a new column next to locked column or new row next to the locked row, the newl
  • CreateWorkspace() call fails after installing Office(Excel) 2007 - using ODBC
    by HedleySohn
    3 Replies
    Last post by HedleySohn
      • We have a VBA component that we've used for a long time. Our users have recently begun to report that the component no longer runs once they install Office 2007. We have always created an ODBC workspace as in the following: DIM workODBC As DAO.Workspace Set workODBC = CreateWorkspace("ODBCWorkspace", "Admin", "", dbUseODBC) This call
  • 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 to reference a reference error in an XL worksheet cell using VBA
    by kiloez
    1 Replies
    Last post by kiloez
      • Hello, I need to know how to reference a cell in an XL worksheet that is showing a reference error (#REF...). I have a number of huge workbooks where I need to be able to delete any row that is showing a REF error in column 1. I see that ERROR 2023 is returned but I get Type mismatch errors when trying to reference this error in code when using something like: dim strErr as String st
  • Use cmdRename to rename Excel worksheet as yesterday's date
    by Wendy582482
    1 Replies
    Last post by Keithyboy1
      • Hi, Does anyone know what's the code for renaming an Excel Worksheet (sheet1) as yesterday's date in mmddyy format I've made several attempts and was not successful. Thanks
  • Now Button
    by DinnerPlates
    1 Replies
    Last post by sjoo
      • Hi I'm new to coding macros and am wondering if anyone knows how I can create a button that jumps to today's date on a spreadsheet I have a long column of different dates and would like to make it easier for anyone who accesses the worksheet to go straight to today's date... I've been trying to use several combinations of the code "Range(Now).Select" but have yet to succeed..
  • Programming Adobe Acrobat Reader 7.0
    by Microhands
    1 Replies
    Last post by Alexei_shk
      • I have succesfully programmed Adobe Acrobat Standard 7.0, see code snippet below:- Dim objAcroApp as AcroApp Set objAcroApp=CreateObject("AcroExch.App") ' Starts up Adobe Acrobat Standard 7.0 Dim objAcroDoc as AcroAVDoc Set objAcroDoc=CreateObject("AcroExch.AVDoc") ' Create an object to allow a file to be opened However, when it comes to using the ActiveX
  • Web Part Editor Doesn't Postback
    by NeroArizona
    1 Replies
    Last post by NeroArizona
      • Hi All. I have created a master page (as a feature) that I am using on a Moss 2007 site. Everything seems to work fine except when you have webparts. I can add web parts (eg. Content Editor Web Part) and make changes in the editor for the web part (eg. HTML source editor). However, when I click any of the buttons at the bottom (OK, Cancel, Accept), there is no postback. Its as if the
  • Windows Error Reporting - handling unanticipated errors
    by John Blight
    7 Replies
    Last post by John Blight
      • For Vista certification, is any handling of unanticipated errors prohibited (other than throwing them) Let's say an application has to process a large number of files. If an unanticipated error occurs when processing one of those files, I wouldn't want that to prevent the application from processing the rest of them. Could we report the error through WER, but also handle it
  • Problem with converting numbers stored as text in excel.
    by Mr T
    6 Replies
    Last post by MyLady
      • Hi, I'm trying to make a macro that converts numbers that are stored in textformat for example "1.987,00 kr" to normal numbers so I can process them further. To accomplish this I am trying to replace the . with nothing. When doing this manually in excel it all works fine but when I let the macro do it for me I a get really wierd outcome. when doing it manually the above example tur