Answer Questions

• MarkIDQ excel vba

  Dim rng As Range Dim rngSelect As Range Set rngSelect = Selection For Each rng In rngSelect.Rows Selection.Offset(2, 0) = rng.EntireRow.Select 'need to add each modified range to selection Next rng I want all modified ranges to be selected in code I need like all rows in different locations selected so I can cut and copy to clipboard Hello MarcuslCox OK try and figure this out, and see if you can use ...Show All

• moacmoii Copy and Paste Values

  I cannot figure out how to copy and paste as values using VBA without acually selecting the cells when I paste and using the same code the macro recorder generates when I record a copy and paste as values. What would be the code for copying cells a1:a10 and pasting as values in cells b1:b10 without selecting the cells range("a1:a10).copy Then what Hi Joe, Here's some info from our support engineer: ...Show All

• -=kussi76=- print out to .pdf or calling a macro with parameter

  Hi, I created an .hta application that generates XML from Excel Sheets and the reverse, the thing is that when I do the reverse, generate Excel Sheets from XML files, i need to print that sheet to pdf. I try creating a macro that receives as a parameter the name of the final pdf file like this: Sub print2pdf(filename) ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True, PrToFileName:=filename End Sub and then i call the macro in ...Show All

• ivanc Saving all individual worksheets in a workbook with names derived from a cell range

  I'd appreciate any help with this - I am trying to cycle through the worksheets in a workbook and save each of them individually with a name which is partially fixed and partially derives from a cell range in one of the worksheets. The For loop is working just once and then I am getting an out of subscript range error the second time around, at this line If Workbooks(wkbk).Worksheets(cellcounter).Visible = True Then Here is the full code b ...Show All

• Miquella work localy with database

  hello, i have a database on the network and when i run a function with many queries it works really slow. is there a way to copy the database to the local computer, make the queries and continue working on the database on the network other users also work on the network database so it's important that the file stays linked to that DB. please help... refael is there any tutorial on how exactly can i link convert to SQL Serve ...Show All

• JeffMN OWC10 Chart to print on a report

  I am trying to create a Stacked bar chart dynamically in Access VBA to include on a report.  I have to build it with VBA because I need to manipulate the color of the stacked bar slices based on the data values.  This graph gives me the exact results I need, however, I cannot get the graph to run when the form opens (loads) and cannot get it to function when dropping it onto a report as a subreport. Create a form called frmChart_ ...Show All

• Aatif latif Trim$ function in VB

  Per the support engineer: Our buddy reported that Trim$ function can not work on his side. I have done some testing on my machine, but I  can not repro his issue. Please ask him to refer following code: Sub Demo()  Dim strViewName As String  strViewName = Trim$(InputBox("Please enter a name for the jMap Projection: "))  MsgBox strViewName End Sub I suppose our buddy has an ...Show All

• DanC# Help On Error GoTo

  Hi Everyone, I`m creating a Workbook that protect and unprotect the sheets... The part of protect and unprotect is ok! But, the part of tratament of errors I don't get to do... I want that when the workbook show the error, it go to Erro: Thiago If you whish to continue your program, you you must put your error-routine before 'Next' Your err-routine can be something like this Regards, FiftyFive Erro: Select ...Show All

• LccTom Migrate Access Forms with VBA to VB.NET

  I have a lot of Access Forms with VBA code and now I need a tool or method to migrate them to VB.NET Per the support engineer: Base on my understanding, our partner wants to migrate Access forms to .NET. Be honest, I don’t think there’s a directly way or an import wizard to fulfill this task. However, this question depends on the real scenarios. For example, if we only want to leverage Access as the database and left all the forms to ...Show All

• Gabriel Rdz Accessing Tables in Access 2000 that are linked from an SQL Server using VB code

  Hello, I am not sure if I am posting to the correct forum, but here it goes: I am trying to create an Access 2000 application to pull data from a table that is linked to a SQL Server Database using VB code. However, I cannot seem to get it to work, as I keep getting type mismatches and object not defined errors. I would post my code, but I have made a complete mess of it. Would anyone be able to show me simple code to accomplish setting u ...Show All

• BarryIOS VBA SDK with VB.NET(2005)

  I'm trying to build a Project in VB.Net 2005 Beta2 which includes the VBA Editor from the VBA SDK. But i didn't find any sample Code in the SDK, and so i don't know how to do this. Could anybody help me e.g. with a small sample ciao stephan Per one of our support engineers: Please let us know the details of the application are you trying to develop so that we can suggest appropriate technologies for the same ...Show All

• Mashuri Problem With Code That Writes a Change To Itself

  I have written a sub that modifies the code in the if statement of a functon in a different module. Trouble is that during runtime, I haven't found a way to get the equivalent of a Compile VBAProject to occur so that the behavior of the function actually changes on the fly. Even though the code is changed by the technique, the behavior when called always stays v1 > v2. Isn't there a way via the VBIDE classes or something to get the recompile ...Show All

• UFAnders excel file open failure

  hi, i am trying to open an excel file with the following statement Dim xlApp As Object Set xlApp = GetObject(, "Excel.application") xlApp.Workbooks.Open sFileName, False, True this line does not return a value. i want to make sure incase of file open error the application continues with the next file thanks . You'll get an error if the Open is unsuccessful. A good way to trap it is: Dim xlApp As Object Dim ...Show All

• Yousuf Khan Problem with VBA script

  Dear all, Can you please help me with the following problem I wrote a script to get the data out from the SQL Server and then format the cells. However, it seems it doesn't run the part B to format the cells. Any idea Thanks. 'Part A : Get the data from the SQL Server sqlstring ="select custid, custname from customer" connstring = "ODBC;UID=uid;PWD=p123;DATABASE=prod;DSN=HK0001" With ActiveSheet.QueryTables.Add( ...Show All

• Mac7 InlineShape.AddOLEObject method formatting wrong

  I'm trying to write a macro to embed OLE objects into word. I want the object to show up as an icon, ("display as icon option") but without any icon label. (The default behavior adds the file path as the icon label, and it does not matter whether or not the 'auto caption' option is enabled). It is easy enough to remove the text of the label itself, but the icon still retains the space for the label, such that the size of icon object is ...Show All