Answer Questions

• Aleniko29139 Simple thing: how to append to a jagged array?

  Hi, I'm a newbie in coding, sorry for an elementary question. ' I have arrays e.g. a = Array(1, 11, 111) b = Array(2, 22, 222) 'then I create a jagged array: bigarray = Array(a,b) 'this works ok, I can address it by bigarray()() 'But how can I declare this bigarray in the first place so I can then append next small array to it. c=Array(3,33,333) 'and here I'd like to append this c to existing bigarray How do I do it Many thanks in advance I don't know if this is what you are looking for but if do the following: a = Array(1, 11, 111) b = Array(2, 22, 222) bigarray = Array(a,b) The bigarray wil become like this: bigarray(0,0) = 1 bigarray(0,1) = 11 bigarray(0,2) = 111 bigarray(1,0) = 2 bi ...Show All

• Steffanp SQL Server pricing for ISV

  Is there a special pricing model for ISV's to use SQL server. I have a couple of applications that are using SQL Express to get by but would be much better using a full version. So is there a special model to deliver SQL with my program Thanks, Tim There are two license programs for ISVs, which Microsoft SQL is part of: ISV Royalty Program – allows ISV to embed SQL as part of their solution at lower cost. More details came be found at: https://partner.microsoft.com/global/40012214 PS=3 (If you can’t get all the relevant information from your local Microsoft Office, you can contact the program owners directly at: isvroy@microsoft.com The Microsoft Service Provider L ...Show All

• Seppe001 Text file search, return data from line other than search string line

  Hi all, I am trying to pull information from a text (.txt) file and input it into an excel spreadsheet. With the "instr" and "mid" statements, I can pull any information from the line that the searched text is on, however, I want to pull information from the two or three text lines after the searched line. The reason I want the lines after the search string line is because the search string line is always the same, but the information on the lines afterwards are never the same. Here's an example of one series of lines in the text file: Case 1005 1 35 66 90 4 22 5 99 What I want to do is search the file for "Case" and then extract the two lines of data beneath it and place them on individual cells in ...Show All

• MMerchant Sorry it may not have been clear as>>

  I have created a program that I plan on disbursing to other people, on this program, I have added a simple form with support info. I would like the text to be a hyperlink for a website and email. Any suggestions thanks Okay, stupid me, I did find where to put the web site, bt the system does not recognize the code in the () at the beginning - the part about ByVal and As.   Hi, Sorry i've just spotted you said VBA. Could below is VB.Net, you might be able to convert it though. =============================================== Yes use a linkLabel as follows>> '-------------------------START OF CODE----------------------------------------- Private Sub LinkLabel1_LinkClicked( ByVal se ...Show All

• Vishal Shah Macro stops running after a certain time, excel limitation???

  Hey guys i have this problem: I have to run a macro for Excel that calculates some values for the entire 2006 year. To do that it has to open 365 daily files check for some circuits and calculate a sum. It opens a file does some checking, writes some values then closes it, opens the next one and so on. For a smaller number of circuits it worked fine and took about 10 minutes. Second time it opened several files and then stopped with after a file is opened. I used a breakpoint for End Sub but it doesn't reach that. Do you know of any limitations in vba or maybe in Excel PS: I turned off autorecovery Thanks Thanks for the suggestion, no RAM error or warning about available resources...That seemed strange t ...Show All

• Alepodrakoulas Displaying Chinese Characters

  hi all... i'm trying to display chinese strings using the MsgBox...Instead only " " appear on the message box...can anyone help me regarding this issue... Thanks Manu Try the Chinese version Or generate a picture file for the Chinese characters and use it as the background lunaa ...Show All

• Chee Yong Open a Word Document

  Hello i need to find out how to open a word document from my access database any one know a good solution. i have an ole object and you can drag and drop the file onto it but i need a way to have it load up in Word so it can be read/written/printed via word 2003. There's a better way to open a word document using the Windows API. Copy this code to the top of your form/module under Option Compare Database... Private Declare Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" _ (ByVal hwnd As Long, ByVal lpOperation As String, ByVal lpFile As String, ByVal lpParameters As String, _ ByVal lpDirectory As String, ByVal nShowCmd As Long) As L ...Show All

• aur0ra Cell Change Alerts

  The situation: I have a table of a number of live share price links that are automatically being updated in real time within Excel. The goal: To receive an email each time the share price of a particular stock moves up or down by an increment of 1%. The progress: I have created a macro that can produce the email, using a number of concatenations to provide me with the desired text. The difficulties: I have been unable to find a way of working out how to automate the macro if a cell reference moves by increments of 1%. Now I have thought that if something goes from 0.99% to 1.01% and back to 0.98% then I only want one email on the initial occurance, and then the base to move to 1 rather than 0, and to rea ...Show All

• DQM Microsoft Office Document Imaging Printer Missing in Office 2007 (RFP) (86)

  Can anyone tell me how to install Microsoft Office Document Imaging Printer in Office 2007 (RFP). Although the Imaging program installs, the Printer does not, and the Microsoft Office 2007 Professional (86) Installer say that it is not an available feature. Here's a response that was posted on the Office discussion boards: Uninstall and then reinstall the MODI printer driver feature using your Office 2003 CD. Instructions courtesy of Windows MVP Carey Frisch: 1. Close all running applications. If you have any Office application running, the driver will not be installed properly. 2. Go to "Control Panel" and "Add or Remove Programs". 3. Click on "Microsoft Office 2003" ...Show All

• rsabadini Search Keyword in word

  How to search the keyword in word, which is another word file. searched and display the document file... please help! thank you very much~~ You can use the BuiltinDocumentProperties("Keywords").Value to get the value of KeyWords For entire code Refer : http://vbadud.blogspot.com/ Shasur ...Show All

• Brian Kramer 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 I think Ctrl-Break does what your looking for... if not try Shift-Break or Alt-Break or Punch-Kick-Break 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 Thanks D ...Show All

• Calvin Bell variable declarations

  Hi, this is kind of a basic and maybe a silly question, but also hopefully a simple one. in a few code snippets i have seen online, i have seen dim declarations made with variable names followed by ampersand or percent sign...such as dim Dim LastRow&, LastCol% what do these signs mean do they specify some kind of characteristic for the variable thank you, kriti I found one list on this page , there are probably better references around. Remember that this kind of declaring your variables is considered obsolete and should be avoided. Andrej Hi, those are variable type declarations: Dim LastRow& is the same as Dim LastRow As Long [& represents Long, % ...Show All

• Metaferia List Box Search

  I am developing in Access 2003. I have a form that has a record set associated to it. It allows you to edit one record at a time through text boxes for each field. To this form I added a list box (lstInstruments) from a query of the same table that the form is linked to. In the AfterUpdate event of the list box I entered the following code. Set rs = Me.Recordset.Clone rs.FindFirst "[InstrumentID] = " & Str(Me![lstInstruments]) Me.Bookmark = rs.Bookmark This allows me to have a list of all of the records on the form, select one in the list box and then the detail part of the form updates to the correct record. Now I need to do the reverse. When I click on the record navigator buttons and move from reco ...Show All

• CJ Clark Excel Time Help

  Hi all, This is my first time posting here , hope i will be able to find the answer i am looking for. I'm very new to vba so please bear with me. Here goes, this is the problem i'm having at the moment with my formulas and vba. I am currently desinging a roster for my workplace and the problem i am having is to work out the night shifts. these night shift start at 23:00:00 and end at 06:00:00, now because there is a change in date between 23:00:00 and 00:00:00 im finding it very difficult to find the appropriate formula. Let say the shift worked is starting at: 22:00:00 and ending at 07:00:00, what i would like excel to do is to calculate how many hours are worked from 22:00:00 to 23:00:00 and from 06:00:00 until 07:00:00 in on ...Show All

• Jackslu Dear DMan1 could you just be a little more explicit about how I name the Sub1?

  Hi folks, I've written several Subs on different worksheets in Excel but I'd like to set up a batch file to run them all. Is there a command that allows a "stack" of subs to be run one after the after I am sure there must be. Beats me. Hamish. Public Sub MyBatch() Call Sub1 Call NameOfSub2 Call Sub3 Call ..... End Sub Hi DMan1, I am going to set up a Blank Excel Worksheet qnd in the VBA section I will write your code. The macro wil have to include the names and locations of the files/workbooks and the names of the macros within them. This is where I am a bit lost. Lets say the workbook is C:\datafiles\process01 and at has ...Show All