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 John Tel 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: hockeyboi16
- Content: Threads
- Order by date
-
PageOrientation and Page Breaks
How can i set the pageOrientation of my sheet to be landscape, instead of portraid, and how do i also move the page break further to the right so that my entire sheet can be printed width-wise on a landscape configuration? to start my excel object i did: dim excelSheet as object set excelsheet...- hockeyboi16
- Thread
- Replies: 14
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Excel cell padding?
Is there a way to set excel's cell padding size? right now the access to my sheet is: Dim ExcelSheet As Object Set ExcelSheet = CreateObject("Excel.Sheet") and i'm setting stuff through: excelsheet.application.cells(...).property or through a range of cells.- hockeyboi16
- Thread
- Replies: 7
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Excel Column or Cell word wrap?
Is there a way to set a column to have word wrap turned on through VBA?- hockeyboi16
- Thread
- Replies: 3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
MSAccess opening an excel file (*.xls)
How do i open a pre-existing excel file (*.xls) using VBA in microsoft Access? When i try to use dim workbook as Excel.Workbook i am getting an error, so i therefore cannot use any of the code i have found on the web. Any suggestions? Any help is much appreciated! Thanks in advance --whit- hockeyboi16
- Thread
- Replies: 7
- Forum: VBA Visual Basic for Applications (Microsoft)
