I have an Access database on our network. If I start this file by double clicking it, all works fine.
If I make a shortcut to the file and I use this shortcut to start the file, it starts Access and load the file. After some time I get an error message "Windows can't find the file...
Thanks,
Indeed the landscape part have some more columns to print.
I hoped I could define different print-ranges with different settings in one sheet.
Ok, I try the macro
Robert
Hi there,
I want to print an Excel sheet. The first 3 pages has to be portrait. Then I want a landscape page, and after that I want to go back to portrait.
Does anybody know if it is possible (maybe even an other papersize)?
Thanks
Does anyone know if it's possible to use a webservice with a VB6 com object, or do I have to switch to VB dotnet?
If it is possible with VB6: how?, what do I need?
Thanks a lot.
I understand you don't want to quit your program? Is this correct?
How about removing the exit command button and the controlbox from your form ?
Or set the Cancel on true in your form unload event.
Robert
Hi,
I want to open an excel file, but before I open it in VB6 with oXls.Workbooks.Open "c:\temp\afile.xls", I need to find out if there are any macro's (like forms wich need some user input) in the workbook?
Is this possible, and how?
Thanks a lot.
Robert
Hi,
I have a (MFC) program that creates some information.
Now I want the program send an email with that infoformation to an e-mail adress the user can give.
Can anyone tell me how to do this or what class I have to use.
Thanks Geoff,
But the problem is that I fill the sheet from a VB exe and I want the row automaticly to increase. I don't know how much text the user will put in the merged cells.
I guess I have to determine the number of characters in the text and divide it by an estimated number of characters...
Hello there,
I want to place a large amount of text into some merged cells in an Excel sheet, and I want the text in these cells to continue on the next line (increasing the row-height) if it is to long for one line.
If I use "Wrap text" in "Format Cells" for a single cell...
If you have an range object you can loop trough it by using the property .cells
range.cells(1,1) references the top left cel in the range
Therefore the address is reletive to the top left corner of the range
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.