Microsoft ISV

Page 97




  • Topics
    Replies
    Last post
  • Trying to use XML Schema to import datas
    by Marcos H&&
    0 Replies
    Last post by Marcos H&&
      • Hello all! well, I've been trying to importing some datas of a XML document based in rules XML schema to an Acess Table. What I found about it was only the code Application. ImportXML _ DataSource:="employees. xml ", _ ImportOptions:=acStructureAndData then I used this Application.ImportXML _ DataSource:="d:\schema\users.xml", _ SchemaSource:="d:\schema\users.xsd
  • Hiding Access Application Window
    by Keithyboy1
    4 Replies
    Last post by palaemon
      • Hi Everyone! Apologies in advance for the long thread! I have an Access database, which I have developed to monitor and track assets issued to employees, and it is intended to be used by others, as opposed to myself. It therefore makes heavy use of forms in order to provide a friendly user interface for non-technical people. To really polish the application off, I want to be able to compl
  • Assigning keyboard shortcut to VBA macro programmatically
    by Ad Brandt
    3 Replies
    Last post by Ad Brandt
      • Using OLE, I create an Excel sheet with graphs and some macros to manipulate them. I'd like to assign keyboard shotcuts to the macros, so that the user has easy access to them. I can't figure out - however - how to do that. Any suggestions Thanks in advance.
  • Browse hard disk with VBA
    by gbvdh
    1 Replies
    Last post by Andy Pope
      • Hello, I want to read a text file into Excel with VBA. This all works fine with some code I found, the only problem is that the text file I want to open should either be written in the code, or in a textbox but than I have to type the complete location (C:\MyDocuments....) what I would like to have is a browser, similar to the one from Windows on "Ctrl O", which opens when I p
  • Microsoft Document Image Printer - MODI Registry Settings
    by Cheval
    8 Replies
    Last post by JoeDee
      • Does anyone know what are all the available registry settings for MODI Through much searching in google (msn search finds nothing) I've found the following the following ' Write to File Only (uses current save folder and Note####.mdi as file name) SetKeyValue HKEY_CURRENT_USER, "Software\Microsoft\Office\11.0\MODI\MDI Writer", "PrivateFlags", 1, REG_DWORD ' Don't Show Popup Wi
  • How to open a folder through excel macro!
    by Harish Singh Adhikari
    5 Replies
    Last post by Peter Mo.
      • Hi, I am a new learner in Macro field. I want to know how we can open a folder using macro. The scenario is ---> I want to open a folder having a no of files . After that i want to open these files one by one.......
  • Application-defined or object-defined error
    by Joe Marlow
    3 Replies
    Last post by Luiz Cláudio - MVP
      • Hello All, I'm receiving the error message in subject in the following code: Public Sub Err(ErrorID As Long , _ Optional AddInfo As String = "", _ Optional Source As String = "", _ Optional Log As Boolean = True ) If Log = True Then Me.Log MsgTypeError, ErrorID, AddInfo, Source MsgBox Me.GetErrorDescription(ErrorID), vbCritical + vbOKOnly , "
  • 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
  • Application.FileSearch in Excel 2007
    by DieZeL
    14 Replies
    Last post by Jon Peltier
      • There is an issue which I am facing after I installed Office 2007. I had written a small VBA which would search for a file and if found will rename the file. I used Application.FileSearch then. Now I am tying to do it again but unfortunately there is an error prompted stating that 'the object does not exist' Set fSearch = Application.FileSearch defPath = "H:\SourceSafe_1_Feb-28_Feb_2006\S
  • 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.
  • 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
  • problem with pivot table Visible property in excel 2003 SP2 vba
    by Jari Haaranen
    2 Replies
    Last post by Jari Haaranen
      • Hi there, I have problem with pivot table Visible property in excel 2003 SP2 vba."run-time error 1004: Unable to Set Visible Property" VBA code have a Pivot Item property for filtering pivot data. Pivot item is "DeliveryDay". In code i check that Visible value of items (true/false) and if it is False then i like to change it to True. Code using For Each loop for checking Vis
  • Subscript out of range with a simple sql :-( [newbie to VBA]
    by Maximus
    14 Replies
    Last post by Andy Pope
      • Hi all, can anyone assist on this one (I'm newbie to VBA) I'm trying to get the list of items from mySql (I have a successful connection) for some reason I get this error message: Run-time error '9': Subscript out of range. thanks for any pointers! Code Snippet Private Sub btnTestReadInMysqlData_Click() Dim objDB, arrRecord, strRecord, strOutput Dim oRS, nRec, oFld Dim row '
  • Run-time error '13': Type Mismatch *ignore this ^^!*
    by whateveritis
    2 Replies
    Last post by whateveritis
      • i always get this error when i try to run...does anyone know what's the problem Code Snippet Option Explicit Private Sub UserForm_Initialize() UpdateData cbxDept.AddItem "Marketing & Sales" cbxDept.AddItem "Supply Chain" cbxDept.AddItem "Purchasing" cbxDept.AddItem "Technical & Production" cbxDept.AddItem "R
  • Microsoft Office Document Image Writer driver
    by pneuma66
    3 Replies
    Last post by Joe Indian
      • Hi, I'm having the following problem with my installation of Microsoft Office Professional Edition 2003 on my Windows XP Professional operating system. I am trying to send a fax using my internet fax service, so I am in Microsoft Word, and click on File/Send to/Recipient Using Internet Fax Service..." and I get the following error message: "The Microsoft Office Document Image Writer driv
  • CRM 3.0 Outlook Client - Missing Price List
    by keithpsft
    9 Replies
    Last post by DavidJennaway
      • I have a question regarding the settings necessary for the CRM 3.0 Outlook client to be installed. I have the CRM and Exchange on seperate servers & networks, both running SBS 2003. I have the CRM server setup as localhost in my office, and Exchange is hosted off-site. Whenever I open outlook I am getting errors saying: "Your Web browser options are currently set to disable cookies. Mi
  • Problem: Macro not deleting columns I select
    by Donaghy
    6 Replies
    Last post by Donaghy
      • Hi all, I have a section of code in my macro which tells it to delete a selection of columns: Columns("C:F").Select Selection.Delete Shift:=xlToLeft this is the first bit of code in my macro but isn't working correctly. Instead of deleting columns C to F its deleting columns A to H. Any ideas why this could be happening
  • Using VBA in Word to slect and print a particular Record (recipient)
    by JBNV123
    4 Replies
    Last post by JBNV123
      • Hi, I am trying to set up Word so that I can get information from Excel and input this data into a form letter. I am using Mail Merge and that part works great. But now I want to be able to search for a particular record (recipient) and print the document only for that record. I know you can search through the "find" button on the mail merge toolbar but I want to make this more user frie
  • sending emails from MS Word with variable subject line
    by gve2002
    9 Replies
    Last post by Andy_F
      • Hi, I've searched these forums but have not been able to find exactly what I need. I know how to send emails with VBA in Word, but the only problem I have is that as far as i'm aware the subject line is always fixed in the code (    .Subject = "New subject"   ) What i'm trying to do, is send reports i have reviewed to an email address by clicking a button in
  • A question on the ISV/Software Solutions competency customer reference requirements
    by DmytroL
    5 Replies
    Last post by MS ISV Buddy Team
      • Could you please clarify the ISV/Software Solutions competency requirements for customer references The ¡°Competency requirements¡± web page ( https://partner.microsoft.com/40012621 ) reads: ¡°Submit at least three customer references for tested packaged software solutions. The solution must be a business application, deployed for a minimum of five users.¡± I have the following questions related to
  • Easy msgbox Query
    by jaxgev
    8 Replies
    Last post by Andy Pope
      • Here's what I'm looking to do in Excel: User inputs data in cell C7 A function in cell C11 calculates A function in cell C12 calculates I want to ensure that both C11 and C12 are positive based on C7 input If they are not, I want a msgbox to appear saying, "Enter a Larger Value." I used the Change event over the Calculate event because it's my understanding that the Calculate event wi
  • Getting word to understand html
    by Anders_73
    0 Replies
    Last post by Anders_73
      • Hi all!, I have some html content and want word to render it.. I'm using the word.application object, creating a new document and then using selection.typetext "<h1>test123</h1>".. That doesn't work as I want, it get typed exactly like that. I want word to understand that it should use headersize 1 and type only test123.. How to do that , would be nice wi
  • Problem with CWnd::RunModalLoop(DWORD dwFlags) in wincore.cpp
    by kpcnatraj
    5 Replies
    Last post by PaloMisik
      • Hello, We have created a VC++ application that has 2 menu options. - submenu 1 opens the VBA IDE - submenu 2 opens a Modal Dialog to execute a functionality (say FUNC1) Whenever we directly select submenu 2 the application executes properly. But the application hangs whenever we select submenu 1 (opening the VBA IDE) and then select submenu 2 (having the VBA IDE still open)
  • inserting row in excel
    by Cammyr
    2 Replies
    Last post by Cammyr
      • I'm using vb.net express to call excel with this code Private Sub Button3_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click Dim XL As Excel.Application Dim xlwb As Excel.Workbook Dim xlsheet As Excel.Worksheet XL = New Excel.Application xlwb = XL.Workbooks.Open( "C:\Documents and Settings\S. Ross\My Docume
  • How to write code for dynamically (programatically) generated combo boxes (excel-shape object) in excel?
    by Sajagesh
    8 Replies
    Last post by Sajagesh
      • How to write code for dynamically (programatically) generated combo boxes (excel-shape object) in excel If the combo boxes are named using the cell reference on which these combo boxes are placed and linked. For example, a combo box, placed over the cell "G23", will be named as G23.