Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: mikeH321
  • Content: Threads
  • Order by date
  1. mikeH321

    Moving Excel Chart/Shape???

    I have the following code that generates an Excel chart on the worksheet that is passed to it. The creating of the chart works fine but I am having trouble moving the chart where I want to after it is created. I am passing several different worksheets through this code and it bugs out after...
  2. mikeH321

    Select Method of Range Class Failed

    The below code exports data from Access 97 to Excel 97. I'm writting data to two different tab in the Excel file. One the first tab everything works as it should, including the freezepane. When the code reaches the line in the code to freezepane on the second tab I get the error indicated in...
  3. mikeH321

    #VALUE! When Exporting from Access to Excel

    I'm using Access 97 and Word 97 and am using the following code to export records from from Access to Excel: Sub ecSPNEM() On Error GoTo ErrHandler ' Excel object variables Dim appExcel As Excel.Application Dim wbk As Excel.Workbook Dim wks As Excel.Worksheet Dim sTemplate...
  4. mikeH321

    Can't close excel instance after excel automation

    I hope I'm posting this in the right forum, I've never really used on of these forums before. I have the following code that I am using to move date from MS Access to MS Excel. The code itself work flawlessly except the after closing there is still an instance of Excel hanging around in my...

Part and Inventory Search

Back
Top