Answer Questions

• Tucker2985 Help required.....

  Can someone help me please I am trying to create a VBA User form to open up individual Spreadsheets rather than having to have all the sheets open (as with a workspace). I have designed the user form and now need to code the command_buttons. However I am stuck with what code I need to use. If it helps, I need to program 7 buttons, 6 will open spreadsheets and one will open a MS Project file. This is fairly urgent as I have to have ready ...Show All

• iamhtran copying links from specific cells in a worksheet to specific cells in another worksheet

  Would greatly appreciate any help with the following code - am having difficulty assigning the first inputbox range to a variable and making the code work. I have labelled the lines with the problems. thanks. Sub CopyPasteLink() Dim i As Integer Dim CopyCells As Range 'the cells into which links will be copied Dim TargetCells As Range 'the cells that copycells will be linked to Dim CopyAddress As Variant 'the address of the copycells Dim T ...Show All

• Cyberpro60 Browsing Selection.InlineShapes forces Word to crash

  In Visual Basic Editor/Debugger: If I Trap when a Selection is made of an Inline Shape, and then try to browse the selection, Word crashes when I try to open the selected InlineShape: Sel.InlineShapes.Item(1) Anybody have an idea why that happens and what I can do to avoid this Thanks :-)an Little clarification I am not talking about browsing throught code, I am talking about browsing ...Show All

• Dan Radu Programatically Changing Excel Default Delimiter in VB.NET

  Hi, Is there a way you change change the default delimiter used by Excel when saving the spreadsheet as csv file format in VB.net I change the default delimiter from "," to "|" in: >Custom Control > Regional and Language Option > Customize button > Numbers tab > List separator It only works if I save it manually. However, when I attempt to save the spreadsheet into CSV in vb.net, it revert ...Show All

• bslim Problems when accessing a text file using ADO

  Hello, I am having trouble with some code and I was hoping someone could help me out. I am writing an excel macro that uses ADO to connect to a comma delimited text file and retrive data. The following are the problems I am having: 1. I have no headers in my text file, but it is being treated as if it had a header row when I fill my record set ( it automatically starts on row 2) how do I get it to look at row1 first 2. I am using "Mo ...Show All

• lmaster 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, Hi Daryl, Here's some info on your question from the support engineer: Thank you for contacting Microsoft ISV Partner Support. If you want to change some cells format,I hope the following can help you. These examples set the number format for cell A17, row one, and column C (respectively) on Sheet1. ...Show All

• JonathanSt ActiveX Control Problem

  I've developed an ActiveX control, try to run it (hit F5) in VB, it works fine. When I try compile it and package and deploy it to .cab file using the wizard, it produces a folder package with one .cab and one .htm file (lets name it x.cab and x.htm). Everything seems working so far, but when I open x.htm, the component doesn't really load i think. There was a message prompt me to select whether to install or not. I've installed it and yet th ...Show All

• Cocotteseb Intersection IM and Telephone

  Hello, I have one question concerning the LCS 2005 and MOC 2005. There are 2 persons, person A and person B having the Microsoft Office Communicator. If the person A has launched the Communicator (Person A is on line), and if the person B has not launched it (Person B is deconnected), can the person A see by Communicator if the person B is on the phone or not. In another words, if the person B has not launched the&n ...Show All

• mqh777 Code to call MS SQL Server 2000 SP

  Hi Champs I am .net developer and working on pivot tables/excel right now. I am in position right now that i need to write code to call MS SQL 2000 SP in VBA code. Can u please send me code for this and also any good site for getting VBA code help. Thanks, Hi, You need to use ADO to access stored procedures in SQL Server from VBA. If your used to working with ADO.NET then you should have no prob ...Show All

• Maarten Zaagman Getting Images embedded in Word

  Hi all, I'm finding it very difficult to solve a seemingly simple problem. I have inserted an image in an AutoShape in Word. I am not able to get the control of the image. I need to get the original image that was inserted into the AutoShape. When I open the Fill Picture Dialog in 'Format AutoShapes'. I can see the original image. It is there somewhere, but its acting too elusive for me, or maybe I'm looking in the wrong place ...Show All

• Yolip day of the week

  hello all. my macro must include some logic that's based on whether certain events happened on the weekend or a week day. does anyone know the code to tell what day a certain date falls on it certainly does. thankyou The WeekDay function might help http://msdn.microsoft.com/library/en-us/dnvbadev/html/pullingpiecesapart.asp ...Show All

• Piotr_S Strange Error

  I have an Access 2002 SP3 DB and on occasion it seems to corrupt and all forms are no longer accessable any 1 else had this problem i am unsure to what causes it so cant fix it. i open it and it reports a corrupt error offten after a change to some code has been made and saved i always test before before closing so i know it works fine then on next load it corrupts and the MDB file is reduced to only half its original size. any help or adv ...Show All

• mhojlund Opening a Word file from a macro in Excel

  I have some code that will open a Word document from a macro in Excel, but for some reason it won't recognize the Word file if the folders in the filepath have any spaces in their names. Here is the code: Sub MergeToWord() ActiveWorkbook.Names.Add Name:="MyData", RefersTo:="=Sheet1!" _ & Range(Selection, Selection.End(xlDown)).Address Shell "C:\Program Files\Microsoft office\Office11\winword.exe F: ...Show All

• Dylan Phillips Accessing a subform control in MS Access

  Hi All, I have a option button in a subform. I am trying to access this option button value from the main form with the following statement: Forms!frmSubForm!OptA.value But this gives an error. Could you please tell me how to access the subform control's value Thanks & Regards, Ashwin. http://support.microsoft.com/ kbid=294212 ...Show All

• Somebody Else How to put text in a listbox heads ?

  Tried to find in help but to no avail. listbox.heads = True listbox.column = 8 but how to put some text in the headers. Thanks..... Using office 2000 on Windows XP Hi Michael, The support engineer found the following... I have setup up a office 2000 machine for this case. And do test on ListBox control. First, ListBox control has a property ColumnHeads, we can set it ...Show All