Search results for query: *

Thanks. That did it. Stars (*****) for you. Cassidy

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...

Sorry guys. Ignore my last post: I forgot to include MS Excel 9.0 object library in my references. Thanks again.

Yes, there's already an existing (template) "workbook", which I already opened here: Set xlWbk = xlApp.Workbooks.Open("C:\BiWeeklyPeriod.xls") However, as I'm stepping through the codes, I got RT-Error 424 (Object required) on the third line below: xlWksht.Activate...

Guys, there's an already existing spreadsheet, so my intension is to open it as thus: "C:\BiWeeklyPeriod.xls" then refer to or use the same opened sheet for data collection. Thanks. C.

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...

Thanks a million guys. I got it. I did the trick you taught me earlier by recording a Macro and tweaking it. Cassidy.

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...

Thanks guys. I'll try it out on monday in the office. Enjoy your weekend. Cassidy.

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...

Thanks Skip I see what you mean, but some "Dope" want to be able to see "_/_/2007" in the textbox whenever the date field is blank, so I'm gonna embed "_/_/2007" as a default string to show in the textbox. Thanks man. Cassidy.

Hi Skip, I don't understand what you mean by 3 textboxes. Could you please clarify? Basicly I want the form to default to "_/_/2007" until the user enters a desired date. Thanks. Cassidy

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

Skip, I sorta figured out something I was doing wrong. When I did the count, I grouped by a field (L3) and when I did the sum, I also grouped by the Check amount field and I was also page breaking on both fields. So I subsequently removed the second group by clause/pagebreak and now both Count...

Hi Skip, Yes, you are correct; the total appears on one page and the count appears on the next page for the same item, because I am doing grouping. However, I am not using the Data>Subtotal feature of Excel. I am doing all processing thru VB code: Here is my code: With xlApp...

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...

Thanks guys, after much tweaking, it worked like a charm, just as you said. Thanks and STARS for y'all. Cassidy.

No I just did a straight "DoCmd" as I'm in access environment. I guess that was wrong huh?

Thanks PHV, I instantiated the access object as such: Dim AccObj As object Set AccObj = CreateObject("Access.Application") Then I called the DoCmd, but I still got the same message: Object required. What am I doing wrong?

Okay. but I'm running VB 6.0. How can I tweak it? Thanks. C.