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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
reference to a non-shared member requires and object reference
Hey all, I have a problem with VB.NET and Excel. I'm creating an Excel sheet which goes fine except for setting the auto filter on: xlSheet.Range("A3", "R3").AutoFilter() The message I receive is:Reference to a non-shared member requires an object reference. but all other setting on the sheet...- nacco
- Thread
- Replies: 4
- Forum: Visual Basic (Classic)
-
program logic question
hey all, I'm coming from VB6 to VB.NET and want to create a webpage. I have a program logic question about objects creating and closing: I need to create an Excel file and define the xl application at class level with public shared. when the user clicks the generate button I create the excel...- nacco
- Thread
- Replies: 2
- Forum: Microsoft: ASP.NET
-
Excel is not quiting in VB.NET
Hey all, Is there any body in the world who can tell me why Excel is not quiting (still in task manager) part of my code is: public class Webform1 Public Shared xlApp As New Excel.Application Public Shared xlBooks As Excel.Workbooks Public Shared xlBook As Excel.Workbook Public...- nacco
- Thread
- Replies: 5
- Forum: Visual Basic (Classic)
-
IBM mainframe to AS400 ccsid 1047 to 37 problem
Hi, we use mqseries on mainframe with codepage 1047 and want to exchange data to AS400 (with codepage 037), but as400 says 'The program ended because, either the source CCSID '1047' or the target CCSID '37' is not valid, or is not currently supported.'(message on as400) It is no option to...- nacco
- Thread
- Replies: 0
- Forum: IBM: MQSeries
