Answer Questions

• Syed Hasnain Ali VBA Editor Crashed

  Dears, I installed a couple of Excel Addin and uninstalled now, but the VBA Editor can't view code right now. I can pop out the VBA Editor in Excel, but I can't double click any file nor insert a new module/class -> it crash immediately. ( Screen here) I also tried to unregister the VBE6.DLL and re-install the component in Excel, but it doesn't fix the problem. Anyone know the resolution (FYI: I installed Excel 12 in the past but now remo ...Show All

• DennisCastro Excel memory issues

  Hello everyone, I have been involved in the development in a graphical user interface which is used to sort large amounts of data, (thousands of rows, 30 columns). After sorting the data according to required ranges on column data, the columns can be plotted with any column against any other column. The number of plots can reach the hundreds and are displayed in a half-sqaure fashion. Anyway, I originally needed only 10,000 or so rows of ...Show All

• RE Elliott ftp using vba

  I hope I am posting this to the right place. I am trying to do a save as to an ftp location. The following works ....but... I have to establish the ftp connect each time the computer is started, So somehow I need to establish the Initial ftp connection within the code.. And once the save as is done I need the ftp connection to be stoped so that it does not remain open In short the need is to open an ftp location save the file to the loc ...Show All

• LuckyStarfo VBA Collection Object

  Is it possible to use the key of a collection object to scroll through items in the order of the key I know that either I can work through from 1 to Collection.count or by using For .. Each .. Next, but a method to work through in key order would be very useful. Hello ADG, Looking at the collection object it doesn't look like it's possible, there is no property to get the keys used by the collection. The way ...Show All

• shaen170013 Excell VBA: displaying values from the sheet in user form

  A simple question probably, but I got stuck on it. I have a user form that allows users to select and run some reports and what I'm trying to do is to put on that form a value from one of the sheets that will show the latest report date used. I tried with the text box and label on the form: Trx_Date = Sheets("Trx_Reg").Range("K1").Value Trx_Reg_Date.Caption = Trx_Date where "Trx_Reg_Date" is the text box ...Show All

• Vishal_LogicaCMG A Simple question about vba editor and vsto

  Is it possible that we write vba code in visual studio 2005 In addition, what are differences between vba and VSTO   Aside from exploring the site below, you might take a look at this article that details a VBA migration. http://msdn.microsoft.com/office/understanding/vsto/default.aspx pull=/library/en-us/odc_vsto2005_ta/html/officevstomigratingwordvbatovbnet.asp http://msdn.microsoft.com/office/understanding/vsto/defaul ...Show All

• Raconteur971 read only file opening

  hi Josh, Thank you for the mail. some of the excel files i am trying to open to read values have a input box or message box which prompts up when the file open command is run on them. Now once a value is not entered into these the master file gets hung there. there is this particular slave file which when opens asks for a password or to press enter for a input box prompt. if i press enter the slave file pops up with many command butto ...Show All

• Friction Runtime Error '1004': Copy of method Worksheet Class Failed

  I have a function designed to create a new worksheet by copying and pasting a template. It works fine for the first many sheets, but beyond a certain number of worksheets, it fails. I am confident that I have ample memory to continue creating new worksheets, however, at a certain point i get Runtime Error '1004': Copy of method Worksheet Class Failed . Here is the function I am calling: Function MakeNewSheet() As String Dim shtcount As Integer ...Show All

• GoodNews Just gotta have a moan

  Jeez this is the pits. I hate, really, really ,really hate, trying to anything at all via IE in W2k3. Nothing works ever. You cannot visit a website without it moaning. You cannot turn off anythinhg without it turning something else on. Listen to interneat radio, you must be joking. Do some Microsoft e-Learning don't be silly you need Flash for that which IE has made sure you can never ever absolutely no matter what you try to do ,download ...Show All

• Alan Churley How to create a DLL in VB.net for MS Access 2003

  Hi, I've been searching high and low on the net but I cannot find out how to create a dll in VB.Net that I can call from VBA in MS Access 2003. I know that I need to add a com interop to allow vba to reference it but I've not found out how to do that. Does anyone know Moving from VSTO Forum to VBA Forum as this would be a more appropriate place for your question. Thanks! Mike Hernandez Community Program ...Show All

• Ian Bates excel file open failure

  hi, i am trying to open an excel file with the following statement Dim xlApp As Object Set xlApp = GetObject(, "Excel.application") xlApp.Workbooks.Open sFileName, False, True this line does not return a value. i want to make sure incase of file open error the application continues with the next file thanks . You'll get an error if the Open is unsuccessful. A good way to trap it is: Dim xlApp As Object Dim ...Show All

• ILV Runtime Error #13 Type mismatch

  Ok I have a speadsheet with a userform that adds data into the spreadsheet when the add button is clicked. This has worked fine and all of a sudden today it decided to give me a runtime error. Here is the code it seems to have a problem with. Do While Not Cells(row, col).row = Range("InsertRow").row frmDate = frmMonthlyExpenses.txtDate rowDate = Cells(row, col) row = row + 1 Loop I don't understand what is ...Show All

• suparna_tech Does KeyPress event trap "Backspace" key?

  according to VBA-Help KeyPress event can occur when BACKSPACE key is pressed. but it doesn't occur in my code. why can it happen can you share a sample of your code for us to test out thanks, -brenda (ISV Buddy Team) per our support engineer: All of the documents have some problem. KeyPress can’t capture the backspace event. Only KeyDown can do it. Private Sub TextBox1_KeyDown ...Show All

• pknudtson printing .doc, .xls, and .pdf files from a list of filenames using an excel vba macro

  Hello all! I'm Jim from Western NY. Forgive me if I have posted in the wrong forum. If I have, just let me know and I'll comply. Here's my question: I am wanting to develop a macro for excel which will read (from a worksheet) a list of hyperlinks to pdf, .doc, and .xls files and print them using the appropriate application ( acrobat, word, excel). Theoretically, I know I would have to use some kind of for-next and/or case s ...Show All

• DurgaG How to create a DLL in VB.net for MS Access 2003

  Hi, I've been searching high and low on the net but I cannot find out how to create a dll in VB.Net that I can call from VBA in MS Access 2003. I know that I need to add a com interop to allow vba to reference it but I've not found out how to do that. Does anyone know Hi Cheval, Yip, I know how it's done however I do not have the time to write about it now. Your not the first person to ask so I'm going to w ...Show All