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!

Register Log in
  • Congratulations derfloh 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: okeyuzosike
  • Content: Threads
  • Order by date
  1. okeyuzosike

    VB6 - Run-time Error 1004

    Hi everyone, I have a spreadsheet with information in some of the colums: ("A:Y"). I want to move(relocate the content of column "A" to any column that does not have data(values). In other words, I want to cut the content of Column "A", loop through the rest of the columns to find a column that...
  2. okeyuzosike

    Data import from Access file to Excel spreadsheet conversts to date.

    Please, I need some assistance. I am importing data from an acces table (file) into Excel spreadsheet. The data type in the access table is "Number"(numeric). When copied from the access file to the excel spreadsheet, some of the numbers converts to date. In the source file, the underlying...
  3. okeyuzosike

    Excel Spreadsheet - Move column content to another column

    Good morning gentlemen, I am working with VB6. Please, I need your assistance. I have a spreadsheet with 4 columns containing data. The 5th column "E" has no data. ----A----- -B-- -C- ---D--- ---E--- Totalhours|Name|Age|Address| ---------- ---- --- -------|------- 0000000005|Jack| 35|New...
  4. okeyuzosike

    VB code to relocated spreadsheet column content

    Good afternoon, please can someone show me how to move the content of a column in excel spreadsheet to another column in the same spreadsheet and also to set a specified range of columns to 2; for example I want Columns size of "D" thru "X" to be 2. Thanks. Okey.
  5. okeyuzosike

    Excel Fied headers not displaying properly.

    Good morning everyone, Please I need your assistance. I generated an excel spreadsheet (report) from access file. I have the report headings in Cell (A5) all the way accross to Cell(Q5). I mean, each cell, starting from A5 through Q5 contains the entire 17 headings(fields). On display, the...
  6. okeyuzosike

    Too much space (gap) between data in Excel spreadsheet

    I used fuction:"CopyFromRecordset" to move data from access file to excel spreadsheet. When I display/print the contents of the spreadsheet, the records are too far apart. Also, each cell size is very large. How can I get the records to display/print normally, like close enough: for example...

Part and Inventory Search

Back
Top