Answer Questions

• Jackobolo about macro....

  hi all. if any1 can help me... i hav simple form having 1 command button...on click event of it i hac call 1 function.... the code is as shown below.... *****code******* Function Macro2() On Error GoTo Macro2_Err ' all data DoCmd.TransferSpreadsheet acImport, 8, "tableimport", "D:\hetal\vb\tempxl.xls", True, "" Macro2_Exit: Exit Function Macro2_Err: MsgBox Error$ Resume Macro2_Exit End Function Private Sub cmd1_Click() Call Macro2 End Sub ******* after running and clickin on button.. i m getting error like...." Object required".... so... how to add macro object on form... error is for line... DoCmd.tran... line of above code... plz help me... ...Show All

• gafferuk API (HLLAPI) errors when accessed from VBA.

  Hi, thanks for taking a look at this. I use VBA often to create macros that screen-scrape from a 3270 emulator. (Attachmate Extra 6.7 if important.) I am trying to access the HLLAPI (from Attachmate) from Excel. I am declaring as follows: Public Declare Sub WinHLLAPI Lib "WHLAPI32.dll" (Func%, ByVal HllDataStr$, HllDataLgth%, PsPos%) Public Declare Function WinHLLAPIStartup Lib "WHLAPI32.dll" (ByVal version%, ByVal Buffer$) As Long Public Declare Function WinHLLAPICleanup Lib "WHLAPI32.dll" () As Long Then the first time I call I am using: WinHLLAPIStartup 257, Space(100) I get a runtime error, #53 - file not found. The file is there and the calls are ...Show All

• Adminanup MAil merge problem with amounts with spanish regional settings

  Hi everyone... thanks for stopping by at this thread. I appreciate your kind suggestions. I have a piece of code that does mail merge automaticall using Excel as the source of data. In US format everything was working fine but when I changed my regional settings to Spanish(Spain) I ran into problem. The amounts in US currecy were showing as 1,234,567.12 which was correct and the same need to be displayed as 1.234.567,12 (In spanish setting comma is interchanged with period) Just to add.. when I manuall perform the mail merge from the word template, everything was fine... Please find me a way SK New York ...Show All

• mcdonaldn Gantt Chart component/library

  Hi, I am looking for a component or a library or a framework to draw Gantt Charts much like MS Project. Either a free or a paid solution will do. I need to be able to incorporate it with my .Net application (written in C# 2005). I have searched around and found several solutions which more or less come close to what I am looking for. But I would like to hear from someone who might have researched it in the past and know about some good components or libraries out there. Basically, I would like to simulate MS Project's project management charting solution, but in a simplified version. Thanks in advance for any pointers. Mehdi Thanks kroxa, we have already checked that one out. It is good, has alm ...Show All

• mpco Need help getting filepath 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

• nwilliams Table or Array in the header of an excel sheet

  Hi everyone! I'm trying to add a table or something like this in the header (right part) of an excel sheet in order to align datas ,there are 2 columns with 3 lines. I'd like to have something like that: Name Mr XXX Function Blah Blah Age 24 When I add these as a string, I get something like : Name Mr XXX Function Blah Blah Age 24 Does someone know if it's possible and if it is, how Regards, Christophe. Seems like the alignment is not set correctly Chas ...Show All

• Mark Jewett - MSFT Office 97 / Windows 2000 Compatability

  Im having trouble referencing Office 97 objects in Windows 2000. I'm in Word 97 and trying to set my object appWord to equal a new word application. My code is: Dim appWord As Word.Application Dim docCP As Word.Document Set appWord = New Word.Application Set docCP = appWord.Documents.Open(OutputDirectory & FileName, False, False, False) However on running I get a prompt telling me the document can not be found. This code errors on the line Set appWord = New Word.Application not where the application sets the filepath and name. I get a similar problem when using he same method for Excel only the message I get is around a missing DLL but its doesn't tell me which one. If anyone could shed any light on this id ...Show All

• REspawn "Bizzare" Sendkey Code in Excel

  Following is my code... Range("A1").Select 'Select cell A1 Application.SendKeys "BIZZARE{ENTER}", True 'Enters BIZZARE in A1 and focus goes to B2 Application.Wait (Now + TimeValue("0:00:02")) Application.SendKeys "{UP}", True 'Again focus on A1 Application.Wait (Now + TimeValue("0:00:02")) 'Range("A1").Select 'Just in case {UP} doesnt work Selection.Copy 'Path 1 Range("B2").Select 'Path 1 ActiveSheet.Paste 'Path 1 Application.SendKeys ("^C") 'Path 2 Range("B2").Select 'Path 2 Application.SendKeys ("^V") 'Path 2 My code wanted ...Show All

• MShetty Using Tabs in MSComctlLib.TreeCtrl.2 control

  Ive set up a treeview using the MSComctlLib.TreeCtrl.2 control that has a series of information, currently seperated by commas and hyphens etc. Because of the proportional text used it all looks a bit messy. Is is possible to use tab characters to better lay out the displayed text of a node, if so how (I've tried Chr(9)). How would the tab spacing be set up etc. Thanks Hi, It is not possible to put a tab alignment within the text of the treeview node. Try to set the font of the treeview to some fixed width font like courier new. That's what I was afraid of. Thought of a fixed font, but they just look so unappealing Thanks for your reply ...Show All

• Echo Making changes to Access database table - via Recordsets or Update Queries?

  Hi, firstly, sorry if this is the wrong part of the forum for this question (things seem to have changed recently). My question is this: I am writing some VBA code to automate a job that I perform regularly, in MS Access. I need to carry out updates to data in an Access table, in a repetitive manner. The data needs to be put in a format that is mailable, I need to create fields like Age (from dob), Age Bandings, Gender (from title) etc. Before I knew any VBA, this was all done with Access Update queries and some lookup tables, but I never bothered writing a macro to speed this up. Now that I understand recordsets a little better, I've written some code to automate much of what I need to do, but to be honest, I dont know whether t ...Show All

• *Jinx Multiple series addition problem

  I am not sure whether thisis the right place for this question. This is a problem which i am facing when coding in VB.net The problem is, I want to draw a line graph (3 series) in excel from the data present in designated positions in Excel. I worte a code which is as below charts = XLSheet.ChartObjects() ' Adding a chart chartObj = charts.Add(450, 200, 350, 200) Dim lIntI As Integer = 1 Dim xlsAxisCategory, xlsAxisValue As Excel.Axes With chartObj .Name = "Cumulative Defects1" .Chart.ChartType = Excel.XlChartType.xlLineMarkersStacked .Chart.ProtectGoalSeek = False '.Chart.SetSourceData(chartRange) seriesCollection = .Chart.SeriesCollection() ...Show All

• Hir&#233&#59;n 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. Sounds great, but that might work for Office 2003.... but the question here is for Office **2007**, in which case Office 2003 is no longer installed! Thank you this solution worked for me! I needed the tool for the OCR capability and had not tried what you are attempting. I opened an existing word document, clicked the print icon, selected Microsoft Office Document Image Writer as the printer, selected my deskto ...Show All

• QWERTYtech Change format of cells

  Hello! I have have a macro that seaches several spreadsheets for certain cells. The problem is that some of the spreasheets has cells with strange formatting e.g. some customized formats. If a cell that I am searching for has one of these formats it cannot be found. The cells are identfied by their content that is unique in the sense that only one cell on a certain spreadsheet has e.g. the conent "FX TRADE". Other cells may share parts of the cell contents e.g. "FX POS" but they are not to be found. I search like this: Worksheets(worksheetName).Cells.Find(Array(i), LookIn:=xlValues, LookAt:=xlWhole) This works except when the cells that I am looking for has strange formatting. I tried recording a macro that chang ...Show All

• Demonslayer startup properties in Access

  I want to prevent others from changing the startup properties using VBA in another access file. I don't use User level security because I am not in a position to prevent either the database file being copied onto another machine or a workgroup file from being over written. In either of these cases I find the owner becomes unknown. There is a password on the VBA code. Hi Derek, Thanks for the reply. I do already have a password on the code. If I try and insert a form from another database it asks for a password, but I can change the startup properties from inside another database without the password being asked for. I have just checked it again in case I made a mistake. Dani ...Show All

• kcon inserting row in excel

  I'm using vb.net express to call excel with this code Private Sub Button3_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click Dim XL As Excel.Application Dim xlwb As Excel.Workbook Dim xlsheet As Excel.Worksheet XL = New Excel.Application xlwb = XL.Workbooks.Open( "C:\Documents and Settings\S. Ross\My Documents\sales invoice1.xls" ) xlsheet = xlwb.Worksheets(1) XL.Visible = False Try xlsheet.Cells(8, 2).select() XL.Selection.value = Me .NameComboBox.Text.ToString xlsheet.Cells(9, 2).select() XL.Selection.value = Me .AddressTextBox.Text.ToString xlsheet.Cells(10, 2).select() XL.Selection.value = ( Me .CityTextBox. ...Show All