Search results for query: *

Gentlement, I have some weired stuff going on with my VB6/Excel module. The first time through, my program ran and produced the desired spreadsheet with the headings and all. But subsequent runs do not produce the same result. After the spreadsheet is generated and made visible, when I click...

Gentlemen, I am executing the following VB6/Excel: Dim xlApp As Object Dim xlWbk As Object Dim xlWksht As Object Set xlApp = CreateObject("Excel.Application") Set xlWbk = xlApp.Workbooks.Open("C:\BiWeeklyPeriod.xls") Set xlWksht = xlWbk.Worksheets("Sheet1") <======= this line Then I got the...

How everyone, how can I insert and center multiple page header in excel spreadsheet. I intend to use: With Activesheet.PageSetup .CenterHeader = "&""Arial,Bold"" NEW YORK CITY TRANSIT AUTHORITY " Telecommunication and Information Services Division Project Tracking System...

Hi everybody, I working with vb6 and I currenlty have a spreadsheet with data up to the range of (A2:G143) that requires sorting. But I do not want to hard code this range because the range of data in the spreadsheet may change at anytime (either more data or less data). How can I tell it to...

Good morning all, is there a format or way of displaying a blank on a form control (textbox)? For example, If a date field is blank, I want to display "_/_/2007". Thanks. Cassidy

Hello everyone, I need your assistance: I am runing VB 6.0. I created a spreadsheet from access table. Everything is working fine, except that I am generating both Total and count, but when I print the spreadsheet, the count prints on one page and the total prints on the next page. How can...

Please can anyone assist me with the VB code to export a spreadsheett to access table(database). I am doing this and it's telling me that object is required: DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "ExcelImport", "C:\UnclaimedChecksover60days_20070515_12.51.38.xls", True...

Hello everyone, I am working with VB6. I have a module that counts unique items in a spreadsheet. In the same spreadsheet, I want to sum a column that has Currency. The count function works okay, but when I try to sum the column that has the dollar value, it overrides the count. In...

Good morning Skip, I am trying to make my page header bold. How can I get this done? With ActiveSheet.PageSetup .CenterHeader = " Class of 2007". End with. How can I make the "Class of 2007" bold? Thanks. Cassidy.

Gentlemen, please bear with me: I am having a problem farmating one column("D"), whose value is currency. I am using this code which I got from recording a macro: Selection.NumberFormat = "$#,##0.00;[Red]$#,##0.00" Columns("D:D").select. Using the above code, all numbers in the spreadsheet...

Gentlemen, please bear with me. I learned that you can ask more than one question in one thread. how can I use vb code to put page numbering on a spreadsheet? Example: Page 1 or 2. Thanks. C.

Could someone please show me how I can put a page header on a spreadsheet, using VB6. Also, I want the header to repeat at every page when printed. In the routine that does the PageSetup, I don't know if the code below can accomplish that: With ActiveSheet.PageSetup .PrintTitleColumns =...

Hello everyone, Please could someone give me a little directive on how to a page setup in excel using vb code: Example: I need to set the Margin for the spreadsheet, gridline, repeat headers, etc. Thanks. C.

Hello everyone. I generated an excel spreadsheet from vb and saved it to my local drive, but I want to append today's date and time to the file: example: xlWbk.SaveAs("myspreadsheet_05/09/2007_00:00:00.xls") The next time I generate this same spreadsheet, I do not want to overlay the previous...

Gentlemen, I am performing a count of unique items using "Subtotal" function. It is giving me count of the unique items everywhere they appear in the column. What I want to do is first sort the unique items so that all unique items appear in a single location, then afterwards I can do my...

I am trying to quit excel after processing. Below is what I am doing: dim xlApp As Object dim xlWb As Object dim xlWksht As Object Set xlApp = CreateObject("Excel.Application") Set xlWb = xlApp.Workbooks.Add Set xlWksht = xlWb.Worksheets("Sheet1") process - process- process "" ""...

Gentlemen, I am using Visual basic 6.0 to import data from access table to excel spreadsheet. The process wss successful, but one of the fields in the spreadsheet is a date field but it does not display the date, rather it displays "#######". when I go into the spreadsheet and manually widen...

Gentlemen and ladies please assist. I populated an excel spreadsheet with data from access table, using "CopyFromRecordset" function. The excel spreadsheet has been populated accurately. My problem is that in the xls spreadsheet, there are 5 fields and each field has multiple occurence of item...

Gentlemen and Ladies, Please I nee your assistance. I am coding with vb6. I populated an excel spreadsheet using data from access table. I used the "CopyFromRecordset" to populate the excel spreadsheet. Now, my xls spreadsheet has 5 fields with records(items). Each item in the field has...

Gentlemen and Ladies, Please I nee your assistance. I am coding with vb6. I populated an excel spreadsheet using data from access table. I used the "CopyFromRecordset" to populate the excel spreadsheet. Now, my xls spreadsheet has 5 fields with records(items). Each item in the field has...