Search results for query: *

it seems Mike's tip is much more applicable. thanks a lot guys!

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 Vec Thanks 4 your great codes. But in my case, Namlop's codes would be much more applicable. Thanks Namlop.

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, try this one: Sub BackUp() dim strDestination, strSource as string strSource = "C:\Source_db\current_filename_orig.mdb" 'just update with the correct path of your source dbase strDestination = "C:\backup_db\current_filename_bak.mdb&quot...

Hi Josh, Tnx so much for codes you provided. Sorry for the late response. I was able to fix the bug using the first code you gave: Workbooks.Add "C:\SourceExcelFile.xls" Set xlSrcSheet = Workbooks(2).Worksheets(1) Workbooks(2).Activate Regards, Rodel Ocfemia

Hi Josh, Tnx a lot! Sorry for the late response. Rodel

Hi Justin, Here's the problem. I want to copy the data from one excel file to another excel file. I already have done the destination file which im created using filesystemobject in my code. Before im getting data to be copied in the destination file from one excel file but in this case i used...

Hi Rob, Here's the problem. I want to copy the data from one excel file to another excel file. I already have done the destination file which im created using filesystemobject in my code. Before im getting data to be copied in the destination file from one excel file but in this case i used...

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 Cube, Yup i have active document which happens to be the Destination file. My app is running prog but just want to modify some functionality. Before i am getting data using recordset: Something like this continuation of the code. xlOutSheet.Cells(Inc1(nRow), 2) =...

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

tnx transcend!

thanks all guys! baltog

Hi, Can you give some code using FileCopy function tnx

Hi, Here's the code: *********** Dim strSource, strDest as string strSource = "C:\Source\samplefile.txt" strDest = "C:\Destination" FileCopy(strSource, strDest) *********** With that, the line 'FileCopy(strSource, strDest)' is expecting "=". So i placed a to...