hia
i want to get info from visio 5 into excel... using vba
i need to get all the drawing on a page(the charts enz..) into a excel sheet.
with as much info as possible(width, height, place on drawing, colors enz..)
does anyone has an example of that because i cant find anything of that on...
hia
if you can give me your mail adress
then i can send you some files with courses of vb6
you can mail that adres to me at
c.govaarts@ever.nl
Grtzz...
chris
hia
mabye
try this
vbTab(8)
Date
vbReturn
first you will do 8 tabs Then you fill in the date and go to the next line....
i m not sure its going to work but i think it will
grtzz
Chris
hia
mabye this is an answer to your problem
try to unload excel before you close excel...
wrkBook.Unload
xlApp.Unload
i hope its going to work
if not tell me
and mabye i have another anwser
Grtz
chris govaarts
:-)
hia
i want to save a excel worksheet and then send it as an attachment at a specified time....
i've got an tekstbox to show me the system time and at bv.
17.30 he has to save the excelsheet and send the sheet as an attachment by mail to one adres...
anyone any idear of how to do that...
hia
This time i want to print when there ar 30 rows filled with data, but while testing he has an error that he has not enough memory
i use this as code to print....
If ActiveSheet.Rows >= 30 Then
Worksheet.Print
End if
What am i doing wrong
B-(
hai
i would like to know how to insert new rows in excel or how to move for example row 2 to row 3 so row 2 is free again...
i'm using vba so there has to be an solution to my problem,
hope someone knows the answer....
Grtz....X-)
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.