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!

Recent content by mikeH321

  1. mikeH321

    Moving Excel Chart/Shape???

    Thanks for the help skip I'm think I'm on the right track to get the charts where I want them placed but now I am running into another problem. No matter what I do all of the charts are being placed on the first worksheet. I've tried about a dozen different ways to specify on which tab I want...
  2. 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...
  3. 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...
  4. mikeH321

    #VALUE! When Exporting from Access to Excel

    Thanks Tyson, I changed my code a bit and opted to just create a new excel sheet rather can copying it from a "template" file. Once I did that and went through and set the word wrap and cell format it worked great.
  5. mikeH321

    #VALUE! When Exporting from Access to Excel

    That was my first thought too but it did not work. Still just seeing the #'s
  6. mikeH321

    #VALUE! When Exporting from Access to Excel

    Thanks Tyson, that partially solved my problem. Instead of getting the value error I'm now getting an entire cell filled with "############". When I click on the cell I can actually see the memo that should be there in the formula bar but when I click off it is still just a bunch of # signs...
  7. 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...
  8. mikeH321

    Can't close excel instance after excel automation

    Thanks Hugh, I used all of your suggestions about qualifying some of my statements and it worked perfectly.
  9. mikeH321

    Can't close excel instance after excel automation

    Thanks guys for the feed back... I've removed the redundant wks.'s from my code and simplified my autofitting of the columns. Still can't figure out why the Excel instance is sticking around though. One additional thing I figured out though... if I close Access after running the code the Excel...
  10. 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...
See more

Part and Inventory Search

Back
Top