Web Development

Ask something
Discussion Locked

Visual Basic 6

0 helpful
6 replies

by crispy1

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have an application I have developed in VB6. The program works fine on my winxp home and pro, and it was developed on a win 98 machine. I installed it on another computer at my office, and it is not working correctly now on that windows 98SE machine. It takes information from a series of text boxes in my application and dumps them into excel for later manipulation. Durring the error process on the 98SE machine, it stops after opening excel and before writing to excel. I am recieving an automation error. I hope someone can help, or at least point me in the right direction. It is going to become a .net project, but I need this resolved before I get into that.

6 replies

by rrv

when you write your data to excel using cells(row,col).text, this might fail in different OS or environment.
Use Cells(row,col)=text1.text
this works without giving automation error.
If this did not solve purpose, make your problem more specific.

RV

by crispy1

The operating system we are trying to convert to is windows 98. Code from XP does not work. Automation error comes when trying to pinpoint specific cell to dump data into. Should we use a With command with some type of Active... something? can'tfind anything in books or online???!!!!

This discussion is closed to new replies.