Answer Questions

• Mahender Help with interface?

  Hey Just completed my set of macros that i need to fully automate a process i am responsible for in work.  However, i am a bit lost as to the best way to run them i.e. link them to buttons in excel etc.  Is is possible to design some sort of interface in VBA and have it load with the spreadsheet    Normally i will be recieving a spreadsheet containing reams of data which have to be sorted and updated.  This is what my macros will achieve.  But what is the best/most efficient way of loading or applying those macros to a different set of data each month Any help is much appreciated Cheers  EDIT: I have since managed to design a form in visual basic and have all my sub ...Show All

• vtortola MS Access VBA: How to solve the problem, when i using the ADO [Error 3021]?

  When i using MS Access ADO recordset to retrieve the Field Name that prompt the error message (Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record. 3021. Who can help me to solve this problem '****************************Code Start************************************ Sub Export_Excel_Report(ByVal cnndb As ADODB.Connection, _ ByVal rs As ADODB.Recordset) Dim objXls As New Excel.Application Dim rst As New ADODB.Recordset Dim str As String Dim strSQL As String Dim strSQLTemp As String Dim i As Integer, z As Integer Dim intRcd As Long str = rs.Fields(0).Value strSQLTemp = "SELECT [F1], [F2], [F3], [F4], [F5], " strSQLTemp = strSQLTemp & "[F ...Show All

• Justin Learning autocomplete

  Hi all, I have a form with several combo boxes. I would like the users to be able to start typing in the field and it automatically completes the box. Can someone tell me how to get my form to autocomplete Thanks Where's the autocomplete property. I right click on the properties of the form and field and I don't see it. Thanks It's combobox property not form's. Hi, You can use AutoComplete* properties to accomplish this task. If you want to give your own list for suggestion use AutoCompleteCustomSource, You can also set mode either suggest or change by setting AutoCompleteMode, There are also few builtin Source you can set them by setting AutoCompleteSource. N ...Show All

• TiberiusOne Changing back color of a field based upon another field

  I am interested in changing the back color of a field based upon a second field's value. This field is contained within a continuous form. All that seems to happen currently is every occurance of that field changes its color. Each field has a different value, can this be accessed for the formating as well Unfortnuately, this does not work for my senario, because this only updates when the record first appears. This change of formatting is needed when ever I click a check box and change its value. I tried you method and yes it did change the intital value of the screen but did not allow me to update the formating on the fly. The problem with a continuos form or a datash ...Show All

• NormBCI Sharepoint Error

  Hi, I am facing a problem in Sharepoint 2007, I have a web app in which I am accessing a document library using the following code SPWeb spsSite = new SPSite (strSPServer).OpenWeb(); spsSite.AllowUnsafeUpdates = true ; SPFolder spFold = spsSite.GetFolder(strDocLib); where strSPServer = “http://localhost:port/” , strDocLib is the library name Doing running the application from Visual Studio IDE I am able to access the site and upload a document to the library. Now when I deploy the same app in IIS as a virtual directory under default web site on the same machine where Sharepoint is installed and I run the app and try accessing the site it gives me the f ...Show All

• ZopoStyle Excel function PRICE

  Hi Everyone, I'm having a hard time solving for the Excel function PRICE and COUPDAYBS using VBA or ASP. Do anyone know how to convert its formula to ASP or VB Because i try to reference excel in my code but there is no PRICE function available. Hope you could help me. Thanks. Hi The above functions are not Excel functions to my knowledge. What do the fuctions return and what parameters are passed to them Hi This function looks like it uses coupon rate, payment interval and maturity data to generate a cashflow stream, which is then discounted by the yeild to give you a net present value. This is effectively a discounted cashflow calculation, the importa ...Show All

• Wolfgang Kamir Windows XP Thread Starvation

  What is the longest time Windows XP will starve a thread if multiple threads are competing for processor time Is there a set threshold (let's say 1 second) that will automatically put the thread onto the cpu if that thread has been starved from the cpu for that amount of time. Thanks. Four minutes if memory serves. It's a situation you want to avoid. ...Show All

• z3n 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 shtcount = ThisWorkbook.Sheets.count ThisWorkbook.Sheets("Template").Select Sheets("Template").Copy After:=Sheets(shtcount) End Function The debugger identifies the text in bold as the location of the problem where shtcount = 42. Solutions ...Show All

• monkeynova How do I open CSV using Excel without deleting leading zeros?

  Hello, Whenever I open up a CSV file or a Text file, Excel treats string like 05710 as a number and turn it into 5710. How do I open up a CSV file and still keep the leading zeros Thank you very much. Thank you very much. That sounds like a good idea because it skips the screen refresh slowness. Maybe I can create a Range object and then swap that with Cells. That will be so fast. If you are populating it into Excel, specify that the cell should be Text format. See my post here Scientific Notation where I specify how it is done. In the CSV file place a ' (single quote) in front of the number such as 123,'0456, Thanks. But the thing is I don't want t ...Show All

• Selectis Disable events in userform

  Is there a way to disable Userform events within Userform code I am trying to dynamically set scrollbar.max without triggering the Scrollbar_Change event procedure. All are checked Joe D This is strange because I have just tried the same technique within my code and set breakpoints to track code incrementally and I find that dynamically setting the scrollbar.max triggers the scrollbar_change event within my form. Which version of Excel are you using I am using Excel 2003. (Incidentally, setting the scrollbar.max within the Form_Initialize procedure is also triggering the Scrollbar_change as would be consistent with dynamically changing the scrollbar.max.) Jo ...Show All

• clint 2 protect,unprotect question help needed

  Hi, I need help with a excel file. I know very little about VBA. I have excel pro 2007 beta loaded. I would like to lock or protect all the sheets the workbook using vba. And still be able to add data to unprotected cells on one any worksheets. I need vba macro to do this so all the sheets are protected and run the macros but still be able to edit cells that are unprotected. The code below does not protect all the worksheets. Only the 1 st 2 out of 3. The two that are protected are where the macros run from. The third is not. If you need any answers to my questions. I can e-mail it so it can be reviewed. My code is below. Sincerely, Tom Robert Public K(7) Sub Pick6() ActiveSheet.Unprote ...Show All

• rviswa MS Access & Windows Media Player

  Hi Im using Windows Media Player on a MS Access form and I can't get the current Time of the video. Any ideas Thanks Sean WindowsMediaPlayer1.Controls.currentPositionString will give you the current position of the video clip or music file while WindowsMediaPlayer1.currentMedia.durationString will give you the total duration time of the selected video clip or music file. So, in that case you could try: Label1.Caption = WindowsMediaPlayer1.Controls.currentPositionString & "/" & WindowsMediaPlayer1.currentMedia.durationString Hope this helps. (^_~ ) ...Show All

• G. Dean Blakely Worksheet.Copy causes execution to stop

  Hi I am experiencing an odd behaviour from my VBA code in Excel. I have some code that has worked until recently. We have gotten XP instead of win2k, which i could suspect is causing this in some strange way. My problem is that i have the code below. In the line where i say Worksheet.Copy, the execution simply stops. No errors appears, nothing. <CODE> On Error GoTo ERROR: Worksheets(SN_MonthYearAct).Copy After:=Worksheets(Worksheet.Count) .... ERROR: MsgBox(Err.Description) </CODE> The variable SN_MonthYearAct is a constant containing the string "MonthYear Act", and a sheet with this name does exist. Worksheet.Count returns currently 8, and there are 8 sheets in the workbook. I have trie ...Show All

• bruce bubello Load userform returning variable not defined error (91)

  Hi there, I haven't previously had any problems loading/hiding etc userforms in vba, but I've just finished a project that runs fine when stepped through. However, when run properly, it returns a variable not defined error on the Load xForm command. The form is in the same templateproject and the load form command is the first to be executed. Any ideas Thanks in advance This code runs on the form's initialize event: frmWeb.WebBrowser1.Navigate (" http://wokiisp.net/index_res.asp ") frmWeb.WebBrowser1.Document.all("ServiceID").Value = 71 WebBrowser1.Document.all("ServiceID").FireEvent ("onchange") While WebBrowser1.Busy DoEvents Wend ...Show All

• mark aoki Ajax in CRM

  Hi, i have a problem in CRM. I have a custom field named "new_number" and this field is disabled in form Order. I want to fill this field with autonumbering system which it must working with CRM Web Services, so i make a code that will return the new_number data into the field new_number in CRM Order form. To do that, i think i must working with AJAX (for example if the last record of new_number is A0001, then ajax will return A0002), where i can write my ajax code in Order Form Properties (onSave function at Save button). This is my AJAX code : function OnSave() { var xmlHttp = null; if (window.XMLHttpRequest) xmlHttp = new XMLHttpRequest(); else if (window.ActiveXObject) xmlHttp = new ActiveXObject("Microsoft.XMLHTTP&quo ...Show All