Microsoft ISV

Page 30




  • Topics
    Replies
    Last post
  • combobox Excell with data from Access
    by Norbertus van der Lei
    1 Replies
    Last post by Bruno Yu - MSFT
      • In excell i've got an userform with a combobox. These Combobox gets his data from an Access data base table. This works good. = 1 How can I use the selected item in the combobox for an variable in Excell = 2 How can make 3 columms with the data from the Access table Code Block Dim objConn As ADODB.Connection Set objConn = New ADODB.Connection objConn.ConnectionStri
  • Action Pack Question
    by Tone Southerland
    12 Replies
    Last post by Mark.Rowe
      • I am interested in the Action Pack. I understand that it comes with the Vista upgrade, not the full edition. I do not have 10 licensed copies of XP Pro to upgrade from. So does that mean I will need to purchase a licensed copy of XP Pro for each machine that I want to put the Action Pack upgrade version of Vista on
  • Replication of PivotTable Fields.
    by Muralidhar M S
    1 Replies
    Last post by ADG
      • Hi, I have multiple Pivottables connected to OLAP data. All the pivot tables are in the same worksheet. All of them have Time as the only page level field. When this page field of the first pivot table is changed, i want to change all the other pivot tables so that the Time page field for all the other pivot tables is set the same as the Time page field for the first pi
  • TypeOf ToggleButton is MsForms.Checkbox returns true !
    by Sebastien TANIERE
    4 Replies
    Last post by Sebastien TANIERE
      • Hello, I am experiencing a curious problem on VBA : ToggleButtons returns true on condition : TypeOf oControl Is MSForms.CheckBox It returns also true on condition : TypeOf oControl Is MSForms.ToggleButton My problem is that this behavior is due to a recent version of VBA. This bug has appeared on an existing Word application after installing Outlook2003 which installed visual basic 6.3 Ap
  • VBA ADO Error Handling Method
    by Fred Smith
    2 Replies
    Last post by Fred Smith
      • I am using VBA in Excel to take the information in Excel, place it in an array, and insert it into a database. The operation completes successfully, however, I'd like to record any ADO errors that come up in the operation. The code is shown below. It first opens the database connection, then it creates a worksheet to add any errors that come up during the add new operation (errors if a reco
  • Problem with converting numbers stored as text in excel.
    by Mr T
    12 Replies
    Last post by Mr T
      • Hi, I'm trying to make a macro that converts numbers that are stored in textformat for example "1.987,00 kr" to normal numbers so I can process them further. To accomplish this I am trying to replace the . with nothing. When doing this manually in excel it all works fine but when I let the macro do it for me I a get really wierd outcome. when doing it manually the above example tur
  • Office 10 \ winword.exe runtime error
    by Kdean6869
    14 Replies
    Last post by Jyh-Cheng Chen
      • I have downloaded the service pack 3 but I'm still encountering the problem when I try to open MS Word. MS Excel, MS Outlook , MS Powerpoint & MS Viso all work fine. Any time I try to open MS word I receice a Box vissual c++ runtime library. This application has requested the runtime to terminate it in an unusaul way. Microsoft Office\Office 10\Winword.exe.
  • Call Macro in Closed Workbook?
    by Joe Dawson
    2 Replies
    Last post by Joe Dawson
      • Hey Folks, Is it possible to call a macro from a workbook that is closed Joe
  • how can i call a stored procedure with vba and output data to excel spreadsheet?
    by lyosha
    1 Replies
    Last post by Shasur
      • I am trying to output data from a stored procedure to excel spreadsheet, i have searched for this but either cannot make sence of what i find or it is not relevant to what i am trying to do, i have gotten as far as outputing a select statement to a msg box. sorry for my newbishness ^^ Here is my code: Code Snippet Dim cn As New ADODB.Connection Dim sConnStrTags As
  • Reference a query rather than table as recordset source
    by RhysDavies
    1 Replies
    Last post by RhysDavies
      • Hi - my brain is frazzled at the moment. I have a form that exports contact information from an access table into a public folder in outlook. However i dont want the code to reference the table, i want it to reference a query which contains all contacts that have an email address. the relevant bits of code are dim rst as recordset Set rst = dbs![tblContacts].OpenRecordset(dbOpenTable,
  • Microsoft Office Document Image Writer -- partial print
    by EKorzon
    1 Replies
    Last post by MS ISV Buddy Team
      • Hello, I couldn't find this on the forum, so I'm hoping someone can help. I have a Publisher document that I'm merging with an excel mailing list. My printing-guy likes to use .mdi files, so usually I just do the merge, print to .mdi, and e-mail him the resulting document. For some reason, when I'm writing the .mdi file, it won't save the whole big merge into one document -- instead it wants
  • Web services Toolkit - No search results returned.
    by paulking123
    2 Replies
    Last post by Feng Chen - MSFT
      • OS windows 2000 SP4 office 2003 I've installed the Web Services Toolkit onto Access 2003 and cannot view web services when applying a URL to WSDL. Works fine with .net installation on same machine. Any suggestions
  • Worksheet.Copy causes execution to stop
    by pnp
    11 Replies
    Last post by pnp
      • Hi I am experiencing an odd behaviour from my VBA code in Excel. I have some code that has worked until recently. We have gotten XP instead of win2k, which i could suspect is causing this in some strange way. My problem is that i have the code below. In the line where i say Worksheet.Copy, the execution simply stops. No errors appears, nothing. <CODE> On Error GoTo ERROR: W
  • Using Vba to count occurences in excel
    by ageary
    2 Replies
    Last post by ageary
      • Hello, I am working on a little project that makes a list of files in a specific folder on every machine in a network. I have been sucessful so far, and I can get a list of files on every machine. I use excel to store this information. This leaves me with a list of every file on the network in this folder, like this. A.txt A.txt b.txt c.txt c.txt c.txt what I would
  • How to adress a single cell in a named area
    by Tsrwebman
    2 Replies
    Last post by Tsrwebman
      • I have a named area "Stock" on a spreadsheet (Office XP), the range is defined as follows: =OFFSET('Stock List'!$K$1,0,0,COUNTA('Stock List'!$F:$F),4) ie it starts at K1, is 4 cols wide and as deep as the number of used cells in Col F I want to access this in an array format using VBA, ie using variables to define the position of a single cell within the array and to either r
  • Using arrows to select in drop down list in access
    by RhysDavies
    4 Replies
    Last post by RhysDavies
      • Hi - anyone know how to get a drop down list combo box to allow you to select an option using the up/down arrows on the keyboard in access rather than having to click on the down arrow on the combo box in access - user wants to do it by tabbing into boxes and using the arrows to select because its quicker. thanks, Rhys.
  • Trying to extract data from one sheet and list it in another...
    by Scott Boyd
    2 Replies
    Last post by Scott Boyd
      • Hi, i have a sheet with lots of employee data on it including the manager name. I want to loop through each employee and make a list of the managers and display this in sheet 2. I only want each manager to be displayed once no matter how many times he occurs. Here is what i have so far - probably very messy but its the best i can come up with! Code Snippet Option Explicit Sub manag
  • Adding VB code to Excel sheet thru OLE
    by Ad Brandt
    0 Replies
    Last post by Ad Brandt
      • I've a program that creates - thru OLE - an Excel worksheet with data, some graphs and VBA code to maniupulate them. This works fine with MS Office 2000, but fails with Office 2003. I've set the 'trust access to visual basic project' flag. From within Excel, this indeed allows me to add VB code using VB code. My (external) program however still gets the following error mesage: --- OLE exeption fro
  • Trouble with Word
    by Anonymous584592
    1 Replies
    Last post by Eric Jacques
      • Hello, I'm having trouble with weird characters popping op in MS word. When I hit <return>, Word inserts a character that somewhat looks like a 'normal' (not capitalized) <q> but longer and with an extra vertical line behind the first one. Also, the little circle to the left of the stick is black. I can't copy-paste it so I include a description. Also, for every <space> I ente
  • Cann't kill excel.exe with Access VBA coding
    by mrtaktak
    3 Replies
    Last post by mrtaktak
      • Hi I use the below coding to quit Excel application 2003, but Excel.exe is remain in the Task Manager. Can anybody give me an idea. Thanks! objExcel.quit Set objExcel = nothing
  • Unbale To Read File
    by Karthik Doss
    4 Replies
    Last post by Eyal
      • Hi , I am generating an Excel File using the " Response.ContentType = "application/vnd.ms-excel" after generating the excel file when i tried to open the excel it give me an error "Unable to read file "..... This particuclar error gets only for a case ...
  • Macro To Delete Spreadsheet Columns if no data in column
    by GB Allan
    8 Replies
    Last post by AussieJames
      • Hi, I need a routine that will go across and delete any columns in a spreadsheet that don't contain any data. The spreadsheet will always be from columns A:BB. There are column headings on row 1 going across. Thanks for your help - I very much appreciate this forum. It has helped me out greatly! Gary
  • Assign an array to .values and .Xvalues in an excel chart
    by Jonas.S
    6 Replies
    Last post by Jonas.S
      • Hi, I'm having trouble with assigning arrays to a chart. Below is how I done. Anyone nowing how to make this work     Set MyDispl = Application.InputBox(Prompt:="Select displ.", Type:=8)     Set MyForce = Application.InputBox(Prompt:="Select force.", Type:=8)     Do '''Collects Displ data         
  • text parsing in excel
    by Derek at Potters Clay
    3 Replies
    Last post by Anonymous
      • I am collecting data that another person has done in excel to be used in a access database. The problem is that a lot of the cells have 5 spaces before the actual text. how do i write a macro to first check if there is a space at the beginning and then to delete the spaces. If there is a space, it is always 5 spaces.
  • Excel VBA: Copying from file to file
    by rodcon
    3 Replies
    Last post by Peter Mo.
      • Thank you Mr. Dawson for your help with copying formats using Excel VBA. But I still cannot copy from a workbook that is part of a separate .xls file. The code works between worksheets of a workbook in one .xls file. If I try to copy from one file to another I get an "Error '9': Subscript out of range". This occurs even if I specify the path. Anyone have any thoughts 'refe