Answer Questions

• Yones For Next stops at 16

  The following code fails when I set the upper range of the For Next loop to any number greater than 16. The error: "Run-time error '9': Subscript out of range". The statement that it throws the error on is: If Vol(i, 1) <> OldVol(i, 1) Then It works fine for any upper range up to and including 16; but 17 or greater throws the error. Any help appreciated. Code Module: Dim NewVol As Variant Dim OldVol As Variant Dim Vol As Variant Dim RT As Variant Dim BSRT As Variant Dim ASRT As Variant Dim BSize As Variant Dim ASize As Variant Dim Start As Variant Sub Update() 'OldVol = Range("ab55:ab57").Value 'NewVol = Range("ab55:ab57").Value BSize = Range("n55:n70").Value ...Show All

• Malmer Refresh excel external data - then save macro

  I'm writting a little macro that refresh data from an external source, then saves the file. However, it starts to save to early, and I get a error message that saving will disrupt the refresh. How do I wait to save until everything is refreshed and calcualted I'm sorry I guess I was not that clear, I am refreshing data in two ranges, its a web request. I think the macro tries to save in between. It isn't entirely clear what you are doing but it sounds as if you could close the external file without saving and avoid the problem. ...Show All

• Edward Smeathers I want to create a "search" engine within my Excel spreadsheet.

  'm the type of person that likes to teach myself, BUT i'm having difficulties understanding the VB manuals. i figured their would be someone out there that could break it down for me, possibly at a high school level. lol I have a spreadsheet that has many tabs. In one of the tabs it lists client names and information, approx. 260 lines, starting in cell A15 and continuing down so forth. I want to create a "search" feature/engine within this one specific tab that fuctions much like the new media player 11 search engine (as you type the name, the names begin to appear with all the info as well). i want the "search" feature/engine in cell A5, kept seperate from the rest, I have frozen the panes so the search engine doesn ...Show All

• Lampkin Dynamic filtering of picklist values CRM 3.0

  Hi, I would like to create dynamic filtering of picklist values in CRM 3.0. But I have a problem for to delete dynamically my picklist option.it is really random. // It's here my problem var count = oSepcialisation.Options.length; for ( var i=0; i < count; i++) { try { oSepcialisation.DeleteOption(parseInt(i)); // sometime this function deletes option, sometime doesn't. } catch (ex){ alert(ex);} } ------------------------------------------------------------------------------------------------------------------------- For to reproduce the same condition, you must create 3 attributs of type picklist - new_dev_competency (parent picklist) - new_dev_specialisation (child picklist) - new_dev_orgi ...Show All

• Tomys Problem with MS Updates on New Dell

  I have a brand new Dell XPS Fully Loaded and Upgraded, but there is one MS security update that will never load. I have Windows XP Media Center Edition 2005. I also have PC-Cillan Micro Trends Antivirus/Firewall Internet Security Protection. Below is the update that I am not able to get as it fails every time. Security Update for Microsoft .NET Framework, Version 1.1 Service Pack 1 (KB886903) Failed to install The other issue I have: I use Outlook Express as my email client and often I get error pop up messages from Micro Trends regarding an OE problem with AntiSpam and it shuts down my email client. I have to then go into my windows processes and shut down the msmsgs.exe file so that I can relaunch OE. Does anyone have any ...Show All

• William Wong WebPart Problem (?) / BSM2005

  Hy. We have a Win2k3-Server (SP1) with SQL2k5, IIS6, Sharepoint Services 2. To tryout the features i've installed the BSM2005-Demo. Fortunately there where no problems during the installation, but after deploying a scorecard i get the following error: can you please let us know how you solved the problem.... Regards never mind, solved it myself -_- hi, can you tell me please how did you solved it ... i'm having the same problem. thanks Tatiana. Hi, I have the same problem. Could you please tell me how did you resolve the issue Many thanks, Andrej ...Show All

• SechMolinari [OTP] VBA Using combobox in Excel

  H i there,   I'm working on an engineering spreadsheet (Excel) and need some help in manipulating comboboxes / dropdown list.   Say i have 2 list, where list A has the list of countries and list B has the list of cities for the country chose. If all the data source (i.e. countries and cities) are to be extracted from the Excel spreadsheet, is it possible to make list B dependant on list A (that is to say when user selects a country in list A, list B will automatically gives the respective cities) WITHOUT creating a userform If so, please advise how.   Hope you can understand what i'm trying to ask here. Fyi i have minimum VB knowledge so a "dummyproof" explaination would be really ...Show All

• TooruN How to stop a never ending loop

  Hi, Is there a command to stop a executed function. It happends that I sometimes created loops that countious for ever. I have so far had to quit excel to make it stop. But I guess there some command to stop this process. Anyone that knows this Thanks in advance. \Jonas Thanks for your replay. But it wasn't the problem. I meant if I execute a macro and it's, off course by mistake a never ending loop in that macro how can a stop that macro At the moment I'm using Ctrl+Alt+Delete to end Excel but I'm sure that it has to be a way to just stop the macro. In matlab for instance I think it's Ctrl+c. \Jonas Hi Jonas You need to look at the EXIT command so that you can jump out of the loop if certain conditions are met. It ...Show All

• iSerg VBA - Create View

  Is it possible to create views using VBA Create view test as select field1 from tblRecords; Are you refering to a view in SQL Server or a query within Access, or where do you want to create this view, and what do you want it to be a view of (an Access table, a range in Excel, or what ). ...Show All

• PeterVrenken VBA communicating with .Net without registering COM Object

  Hi, We're planning to implement a solution where we have some VBA macros in Excel talking to some .Net code (that does database stuff, etc.) via the magic of .Net COM Interop. In order to make installation of our solution easier, I want to avoid having to register (i.e regasm) my .Net dlls. Note that I can't use VSTO or the PIAs because we need to support Excel 2000 and above. So this is what I'm planning to do: I will have a launcher application written in .Net that will start up an instance of Excel, call Application.Workbook.Open to load my workbook, and then use Application.Run to call a macro in the Workbook. This macro will have a parameter of type object, to which I will pass an instance of the .Net object that I want VBA t ...Show All

• cgkitab Application.FileSearch in Excel 2007

  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\SecondSet" Set rg = Range("MyFiles") fSearch.LookIn = defPath I have been frantically looking for changes in the VBA object model especially for Excel but cant seem to find them. Thanks! Brilliant! DieZeL wrote: Hi I went back to using VBScript to get the job done here is a snippet Function ReportFileStatus(fi ...Show All

• Sorean Can you use VBA to access a spread sheet embedded in a word doc?

  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. Nice piece of detective work ;) I can't find any documentation on an msoEmbeddedOLEObject, and wdOLEVerbHide seems to work fine. Also, DoVerb is limited to wdOLEVerb___ enumerations. Hi OM Gang, For me, in the very limited testing I did, the excel.exe thread was created and destroyed using that code. ...Show All

• Haldox Problem with Connection Strings

  Hi All, I have an excel spreadsheet, which I want to use like a database table and access using ADO from another spreadsheet, but whenever I attempt to assign my connection string to the ActiveConnection property of my ADODB Recordset, I get the following error: Could not find installable ISAM. Below is the connection string: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\Le09\kpl_biskra\personal_biskra\ksmith\Reporting\Weekly\Christmas Analysis\DataFile.xls;Extended Properties=Excel 8.0;HDR=Yes; Can anyone help Many thanks! Keith Now I feel a bit sheepish as I've gone and solved it after all that flapping about! I simply encased the WeekEnding field in a Format function per belo ...Show All

• harcrow Problem regarding VBA in excel - Combine 52 VBA codes for 52 weeks in a year to one VBA code

  I am very new to VBA, hope that anyone can help me on this.. I have some problem with creating a code which can Please refer to the code down there: 'the listbox will show week 1 to week 52 and let me choose one of the week. Private Sub OKButton_Click() If ListBox1.Text = "Week 26" Then Call week26 If ListBox1.Text = "Week 27" Then Call week27 ' all together 52 weeks in a year Unload Me Sheet7.Activate End Sub Sub week26() With Sheet7 .AutoFilterMode = False .Range("A1:I1").AutoFilter .Range("A1:I1").AutoFilter Field:=3, Criteria1:=">=26-Jun-06", _ Operator:=xlAnd, Criteria2:="<=2-Jul-06" End With End Sub Sub week27( ...Show All

• eXseraph VBA Harddisk serial

  Hi, How can I take serial number of harddisk by using Access VBA. Hi there, You can tip into the Windows API here's an example, Private Declare Function GetVolumeInformation Lib "Kernel32" Alias "GetVolumeInformationA" (ByVal lpRootPathName As String, ByVal lpVolumeNameBuffer As String, ByVal nVolumeNameSize As Long, lpVolumeSerialNumber As Long, lpMaximumComponentLength As Long, lpFileSystemFlags As Long, ByVal lpFileSystemNameBuffer As String, ByVal nFileSystemNameSize As Long) As Long Private Sub Form_Load() 'KPD-Team 1998 'URL: http://www.allapi.net/ 'E-Mail: KPDTeam@Allapi.net Dim Serial As Long, VName As String, FSName As String 'Create buffers VNam ...Show All