Hello honorable members,
I want to include an attachment of my spreadsheet so you can see exactly how some data within the rows are are hidden.
However, I can see any option to manage attachments.
GiftX.
GiftX
Last Activity: Oct 29 '07, 04:31 PM
Joined: Sep 26 '07
Location:
-
Hello HTH,
thanks for your contribution. But my problem is not column width. Is there any way I could attach the spreadsheet so you can see exactly how it looks.
I populated my spreadsheet with input from access files. Because each record is too long to fit in my spreadsheet, I split each record into two lines. The first line prints on the first cells and the second line prints on the next row of merged cells this second...Leave a comment:
-
Hi Veena.
I used your code and still getting multiple underlines and 6 blank pages even though I processed only one record. It was supposed to underline only the one record records processed. Any more input will be appreciated.
Thanks.
GiftX.Leave a comment:
-
Vb 6.0 - Spreadsheet Rows Has Hidden Data
Hello members,
I need help with my spreadsheet display problem. I generated my spreadsheet in using vb6.
Everything is working except that when I display the display (making it visible), some of the data in the rows hides underneath the row lines. I have to physically go into the spreadsheet to expand the rows to see the hidden data. Also, if I print the spreadsheet, the hidden part of the spreadsheet is cut off unless I mannually... -
VB 6.0 - Spreadsheet - Underlines printing even when not necessary
Good morning members.
I am using VB6 to generate a spreadsheet. My module is working okay but one of my objectives is to print an underline after writing each record in the spreadsheet, just to show where one record ends and the next begins. However, even if I process only one record and try to print it, it prints several blank pages including underlines, even if there are no records.
How can I instruct it to strictly print... -
VB 6.0 And spreadsheet - Printing problem
VB 6.0 And Spreadsheet - Printing problem
Good morning West.
After much research, I found this code. It scans the spreadsheet and returns up to the last used cell.
Note: The above code returned all the data in the used cells.Code:xlWksht.Cells.Find(What:="*", After:=[A1], SearchDirection:=xlPrevious).Select
Print Problem#1:
Based on the code above, I execute this code:...Code:Sel
-
Spreadsheet - Prints Blank Pages And Unnecessary Underlines
Hellow everyone,
I am calling/manipulating Excel spreadsheet through VB 6.0. Most of my objectives are accomplished except some cosmetics.
Problem#1:
For example, after running my program to process a single record, when I proceed to print it, it prints the first page containing the processed record. It also prints 5 more blank pages without any record.
Problem#2:
Also, my intention is to print an Underline...
No activity results to display
Leave a comment: