joemo2003
Last Activity: Jun 26 '07, 05:28 PM
Joined: Feb 15 '07
Location:
-
EXCEL VBA. any idea?... -
How to use VBA check to see the Macro security setting?
Is there a way to use VBA check to see the macro security setting? I want to use VBA check to see is the "Trust access to VB project" setting is on? Such as it return "True" when set to Trust access to VB project, and "False" when it is not. That setting is under macro->security->trusted Publishers->trust access to visual basic project.
Thanks -
yeah, that help a lot, thanks...Leave a comment:
-
How to use VBA to check does a reference library exist?
How to use VBA to check does a reference library exist? In my case, some computer have visio installed, but some don't. So i want use VBA to check does that visio reference exist on that computer.
thanks, any help will be great. -
EXCEL VBA compile error help!
Need help, please!
In an excel vba automation, in my code have some codes like "Global vsapp as visio.applicati on", but in some other computer don't have visio installed, and i won't use that visio function but other functions at those computer, but that come out a "compile error:user-defined type not defined" when i use the other function. Is there a way to not refer the visio when there is no visio installed, but refer... -
ok, what i mean is in my code have some codes like "Global vsapp as visio.applicati on", but i won't use it in the computer don't have visio installed. but that come out a "compile error:user-defined type not defined" when i use the other function. So how can i use other functions without delete those "Global vsapp as visio.applicati on"?
thanks...Leave a comment:
-
Help!!! help!!! help...Leave a comment:
-
excel automation not refer to an ms application
Need help, please!
In an excel vba automation, I refer to the visio, but there is no visio install on other computer, and that automation won't work. Is there a way to not refer the visio when there is no visio applicaiton installed, but refer it when it is installed?
thanks, -
Excel VBA-memory Counter ?
'If A=B', then I need to do call a procedure, and then it will loop back to 'If A=B'. There are two procedures. What I want is to call the procedure1 for first loop 'If A=B', and call procedure2 for all other loop.
I am thinking is there a memory Counter function in VBA? which when first loop of 'If A=B', then the counter become 1, and it will call procedure1. and when the counter>1, it will call procedure2?
any... -
never mind, it is so easy.Leave a comment:
-
Excel VBA to change time
anyone help?
Three cells, A, B, & C.
A is start time and date, let's say 6/5/2007 10:00am
B is the end time and date, let's say 6/5/2007 11:00am
C is the time interval minute, which is 60 in this case.
what i want is when i change the C to 70, A will change to 6/5/2007 9:55am and B will change to 6/5/2007 11:05am. and when I change C to 50, A & B will change to 6/5/2007 10:05am & 6/5/2007 10:55am.... -
never mind ... got itLeave a comment:
-
in excel VBA macro, my full code is look something like this:
...Code:Sub copy_Click() Worksheets("Sheet1").Range("A1", Range("A1").End(xlDown)).Copy Worksheets("Sheet2").Activate Worksheets("Sheet2").Range("B2").Select ActiveSheet.Paste Worksheets("Sheet2").Cells(1, 1).Select Worksheets("Sheet3").Activate Application.CutCopyModeLeave a comment:
-
copy table data in excel
I try to copy one column of a table in excel, from top to end, so i use
Worksheets("she et1").Range("F6 ", Range("F6").End (xlDown)).Copy
, but it come out "Applicatio n-defined or object-defined error", anybody know what is wrong? The same code work for the column not in the table.
thanks -
thanks, it is working now...Leave a comment:
-
actually, it is not working well,
when i debug it, it have error message: run-time error'1001'; applicaiton-defined or object-defined...Code:ThisWorkbook.Worksheets("sheet1").Range("A5", Range("A5").End(xlDown)).Copy ThisWorkbook.Worksheets("sheet2").Range("C4").PasteSpecial Paste:=xlPasteFormats ThisWorkbook.Worksheets("sheet2").Cells(1, 1).SelectLeave a comment:
-
oh, somehow it is working this time, after it paste the selection to another sheet, how can I deselect it?
thanks...Leave a comment:
-
Not as far i try,
I try
Worksheets("she et1").Range("A5 ", Range("A5").End (xlDown)).Copy
and
Worksheets("she et1").Range("A5 ", Range("A5").Spe cialCells(xlCel lTypeLastCell)) .Copy
but both are not work for me
thanks...Leave a comment:
-
forget everything i wrote above, What i want just try to copy range("A5:xxx") , where cell "xxx" is in column A, but the row is not know, and cell "xxx" have text "*end". I can do it by use the "do untill" loop to copy the cell one by one, but it is too slow if the range is large. So what I want is something like
range("A5:xxx") .copy
Is taht make sense?
thanksLeave a comment:
-
well, i think all of you not got what i looking for, what i need help is on how to select the copy range. In my example above, the copy range I want will be various everytime, sometime range("A5:A301" ), sometime range("A5:A200" ), and there will be text "*end" specify at the end of the range (A301 or A200 in this example). So how to set the copy range from A5 to the cell with text "*end" (A301 in the example...Leave a comment:
No activity results to display
Leave a comment: