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!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How do access Excel objects if excel is not loaded
I am trying to execute a VB executable on a SLQ 2000 server to create a new excel spreadsheet from data query to the sql database, and then to modify the columns of the same spreadsheet using VB code. I wrote the VB app on my machine, which has excel 97, and I tested it, and it works just fine...- chas036
- Thread
- Replies: 1
- Forum: VBA Visual Basic for Applications (Microsoft)
-
CreateObject(excel.application) run time error 429
I am trying to execute a VB executable on a SLQ 2000 server from a scheduled DTS task to create a new excel spreadsheet, and then to modify the columns of the same spreadsheet using VB code. I wrote the VB app on my machine, which has excel, and I tested it, and it works fine. I also included...- chas036
- Thread
- Replies: 1
- Forum: VBA Visual Basic for Applications (Microsoft)
