Answer Questions

• noluckmurphy Programming Adobe Acrobat Reader 7.0

  I have succesfully programmed Adobe Acrobat Standard 7.0, see code snippet below:- Dim objAcroApp as AcroApp Set objAcroApp=CreateObject("AcroExch.App") ' Starts up Adobe Acrobat Standard 7.0 Dim objAcroDoc as AcroAVDoc Set objAcroDoc=CreateObject("AcroExch.AVDoc") ' Create an object to allow a file to be opened However, when it comes to using the ActiveX Adobe 7.0 Type library with Reader 7.0 it seems it can't be done - DDE technology is the only answer. Has anyone out there got prior experience as I seemed to have strayed into a bit of a minefield ! Somewhere where I can look at code samples would be a great help. Thanks you Robert Snedden, Edinburgh Hi, How ca ...Show All

• Alvin Kuiper Help with comma separated values in report

  Hi! A bit of a stuck-up. It’s no problem in creating a coma separated fields in .txt kind of file. But I have another problem which is probably simple to manage (not for me though - my brains work 24hrs/day and don’t come up with nothing). I want to show several different values from one field (in query) on the report - now check this - They have to be separated by a comma in one line. If anybody is familiar with the solution just show me the direction and I’ll try to solve it by myself. Thanks in advance Hi! I tried following: On reports open event: Private Sub Report_Open(Cancel As Integer) '------------------------------------------------------------ ' Dodaj_stevilke_faktur_na_report ' '------------------------- ...Show All

• ravi_nilesh Need help getting URL information via File Dialog

  I am wondeirng if there is a way to have the file dialog box (or something similar) return a URL value from the selected file. Basically the issue I am having is that I am trying to add hypertext links to files stored on a shared network drive into an access table. Currently, using a pretty basic file dialog approach, the hyperlink text will be based on the file path as defined for each user. In other words, if the user has the network drive mapped as the G drive, the hypertext value returned is "G:\\..." or if the user does not have the drive mapped at all, the network-assigned URL for the drive is returned (i.e. \\DriveName\... ). The latter (the user-independent URL) is actually what I desire to have returned as the value, so as to make ...Show All

• Navya Jeevan Sort table based on array

  I have table and an array, both have the same length. I want to sort the array and the table based on the array. The array is never seen to the user so I cannot paste it next to the table. I have to deal with the array. Is it possible If so, any ideas on how to do it Any help appreciated! Thanks very much! How do you want to sort them ...Show All

• Cerberuss 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

• djkiz precisely position embedded charts in worksheet

  I am embedding 4 charts into a worksheet and would like to position them into a nice 4 quadrant view. However, when recording a macro, the position of the chart at the end of Chart.Add, etc routine is arbitrary. Similarly, when I record manually repositioning the chart and then replay the macro, the results differ. Here is the code for creating 2 of the 4 charts. The recorder uses the ActiveSheet.Shaped("chart 1").IncrementLeft nnnn and .IncrementTop nnn statements to perform the repositioning. Any suggestions for predicatably positioning embedded charts within a sheet KC Charts.Add ActiveChart.ChartType = xlLineMarkers ActiveChart.SetSourceData Source:=Sheets("Cancellation - Swap Analysis"). _ Range(&q ...Show All

• alumni MS Access 2003

  simple, i want to activate other folder from access 2003 form, and show the content of this folder (folder contains pictures linked to a record in this form). moving from VB Language to VBA forum ...Show All

• Greenmtnsun OnChange ?

  I'm looking for the proper way to trigger a sub when the value in a cell changes. Any suggestions Thanks K-2 Hi K-2 Try using the Worksheet change event, checking the target value to see if your cell is in the range that has been changed Private Sub Worksheet_Change(ByVal Target As Range) Dim myR As Range Dim Resp, c Set myR = Worksheets("Sheet1").Range("A3") For Each c In Target If c = myR Then Resp = MsgBox("A3 has been changed", vbOKOnly) End If Next End Sub ADG, I've tried this and it does not seem to run as a sub / macro. How do I use this Thanks, K-2 The code is ...Show All

• Nilay Opening af text file in VBA

  I want to open a random text file in Visual Basic for Applications under MS Access. First, I just want it to open. Down the road, I would like to also be able to parse it and take some parts of the file and put those in one table, other parts in another table, do some looking up in the table based on the fourth parts and depending on the result of that look-up insert some fifth parts of the text file in a specific cell. I've tried the regular import function but it can only put data into one table and there's no mean of manipulating data. One of the entries in the text file is "05MAY2006" which I want to have read as a data. I only have little experience in the mystic world of VBA and really advanced MS Office usage. I do, howe ...Show All

• gmoniey vlookup

  Hello can anyone help me with how to write the excel vlookup function in vba the function in excel looks like this VLOOKUP(O2,'[Consolidated list of supplier.xls]Sheet3'!$A$5:$F$218,6,FALSE) how can i get something similar working in a macro. thanks namrata buddy, the lookup is used in a different excel worksheet and the 'consolidated supplier.xls' is a different file. if i do not close the consolidated.xls there will be again a problem of active worksheet as the macro is not being written in the consolidated.xls... its just being used for the lookup range purpose. What happens if you wait until after the lookup before closing the workbook Sheet3.Cells(2, 16) = Application.WorksheetFunction.VLookup(Look ...Show All

• su45937 loop problem

  Hi! I have a problem with a loop. I want to search the entire spreadsheet for a cell that contains the text “Sec type”. However there are two rows that I do not want to search. These to rows are: segment.row and secID.row. These two rows each contains a cell with the text “Sec type”. Thus, I want to search for any additional cells with that text. If an additional cell containing the text “Sec type” is found I want to store the address of that cell in the variable c. If no additional cell is found I want to set c = Nothing or something that indicates that no additional cells were found. With Range("b1:aa5000") Set c = Worksheets("Berakning").Cells.Find("Sec type", LookIn:=xlValues) If Not ...Show All

• Jehan Badshah Send Outlook message via VBA Macro in Excel

  I have some macro code in an Excel workbook. It has been working fine for several years under various combinations of Excel 97, Excel 2000, Excel 2002(XP) and Excel 2003 along with Outlook 97, Outlook 2000, Outlook 2002(XP) and Outlook 2003. We have one new computer that has Office 2003 (SP2) that was recently setup and the macro generates the following error: Run-time error '-2147024770(8007007e)': Automation error The specified module could not be found. Here is the VBA code in the Excel Macro.  The error happens when it reaches the line that reads: Set theApp = CreateObject("Outlook.Application") .  I tried to run the macro on two other Office 2003 SP2 computers and they worked OK, which shot my theory that ...Show All

• Whoisit Export excel sheet as text file with macro code

  Hi, How do I export a specific excel sheet (say sheet1) as a text file I would like to do this with macro code. Grateful for ideas on this. \Jonas This code will do it: Sheet1.SaveAs "C:\output path\output file.txt", <format> The <format> parameter is of type XlFileFormat; for a CSV text file, use xlCSV or xlCSVMSDOS. The VBA documentation enumerates all the possible format options. Thanks a lot, it works like a sharm! ...Show All

• prk asp .Net 2.0 --> The specified module could not be found. (Exception from HRESULT: 0x8007007E)

  Anybody know where this comes from The server has ASP .Net 1.1 and 2.0 installed. This error is returned when trying to access the 2.0 website. It seems there's a missing assembly, but I cannot figure out which one it is, or if it's asp.net's or the application's... Here is the error return: The specified module could not be found. (Exception from HRESULT: 0x8007007E) Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.IO.FileNotFoundException: The specified module could not be found. (Exception from HRESULT: 0x8007007E) Source Error: ...Show All

• Rajesh batchu Strange problem with saving to a FTP-server

  Hi, I have made a small app that saves an xml-file on an ftp-server. I use FTP.exe , as was recommended in another thread on this forum. And it works just fine. The problem occurs when I try to put the file on the sever. It doesn’t work. I have tried to log on to the server with two different ftp-programs and the same problem occurs. But when I try it with Internet Explorer it works. I have tried using all different ftp-commands, "put", "appe" and "stor", but nothing works. What have I done wrong ok, that's windows explorer. :) try uploading your file through ftp.exe from the command prompt, maybe there is an error message your not seeing. This is very tric ...Show All