Hi All,
I just wanna ask how can i remove the images/pictures in my worksheet. the ff code doest not work.
sheet1.range("A1:F100").clear
it removes only the texts.
thanks in advance
Hi all,
I have 1 workbook that contains 3 worksheets. On load i want to set the 2 worksheets hidden, then on set these visible on certain mouse or keyboard events.
Thanks in advance
Hi,
does anyone can give me sample codes how to read the content of text file?
sample:
Content of Test.txt
***************
Name: Aztec
Surname: Ocfemia
**************
I want to get the the Name: Aztec and store it in a vb variable.
Thanks in advance.
Rodel
Hi all,
Can i use two datasource for one datareport. I need this because the first one returns only one row from joined tables. The second datasource will be for the tables that will return more than one record. Is this possible?
Thanks!
Rodel Ocfemia
Hi,
I'm working with COM+ application. My question is not regarding with the code since my code is running in other workstation. My problem is that when i run the program or run with full compile, it did not continue. The reason is "Out of Memory". I've tried to modify the memory...
Hi,
Can u help me how to set the path for my excel application?
Private xlSrcApp As Excel.Application
Private xlSrcBook As Excel.Workbook
Private xlSrcSheet As Excel.Worksheet
How do i set the path or source for xlSrcApp?
tnx in advance,
Rodel
Hi,
Can u help me how to set the path for my excel application?
Private xlSrcApp As Excel.Application
Private xlSrcBook As Excel.Workbook
Private xlSrcSheet As Excel.Worksheet
How do i set the path or source for xlSrcApp?
tnx in advance,
Rodel
Hi,
I'm working with VBA Excel. Here's the situation.
I want to transfer the data from 1 excel file to
another file. How do i set the source file.
Here's what i started:
Private xlOutApp As Excel.Application
Private xlOutBook As Excel.Workbook
Private xlOutSheet As Excel.Worksheet...
hi all,
Anyone can help me how to copy a file in my vb app? I've tried to use FileCopy Function having parameters source and destination. I have variables which handle the source and the destination path. I'm sure i missed something in my code.
Thanks
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.