o
k
q
u
e
s
t
i
o
n
s
.
c
o
m

Excel:Detect row a button is located on with VBA -

I have a button on a spreadsheet that inserts a row. simple, trouble is there are other buttons below it. if the 1st one is fired then the next button creates the row in the wrong place cos each button is hardcoded to the row it starts at.

How do I on the button click code detect the row the button sits on? Its as if the button just floats on top of the spreadsheet. I want to assign a button to a cell. Either that or use an image or can u get a cell click event? If so it would solve my problem.

any comments appreciated
j

 

Excel:Detect row a button is located on with VBA -
I have a button on a spreadsheet that inserts a row. simple, trouble is there are other buttons below it. if the 1st one is fired then the next button creates the row in the wrong place cos each button is hardcoded to the row it starts at. How do I on the button click code detect th

detect - MS Excel version -
My question is: how can I programmatically detect MS Excel Version , like for example Excel 2000 or 2002, 2003, 98 .... and so on thanks a lot for your help

HOW TO: Excel: Detect a return of "Nothing" from a function -
Esteemed Forum Participants and Lurkers: =============================== EXCEL VBA I have a function that returns a calculated range from a sheet or "Nothing" if the sheet is blank. How can I detect that "Nothing" in my code? One of the Help Heap screens

Finding the SendTo in Differents OS -
I believe that the SendTo folder is located in different place depending which OS is running, for example I know that in is located under C:\Windows\SendTo, how can I detect where this folder is located depending on the OS? (WNT,W2000,Wxp etc..) HELP.

How to launch a app -
Guys can you please tell me how do i Launch a .exe with command button ? & How do i detect the path of where the .exe is located ?

Using VB6 to Capture Excel Commandbutton Press -
I am using a webrowser on my userform to display an excel workbook. I have command buttons on that workbook. Is there a way to detect in vb6 that the button has been pressed or a way of redirecting that click to the vb6 code? I want to try to avoid placing the sensitive code in

Detect MS App and set to prev. instance -
Does anyone know how to use a running instance of an MS App via VB code? For ex., I can set an object to Excel.Application, but it creates a new instance of Excel. I would like to check for an active instance (via Detect MS App code - thanks!) and then set the Xlobj to the already ope

Detect Excel or Open in a different way -
I have a program that opens excel and a certain template through a shell statement, and then exports text form textboxes into certain cells of excell. Everything worked great in trial runs until I compiled it and put people on the program. It ends up that if Excel is already open the

Where oh, Where has the cd drive gone What letter is it located under *Case Closed* -
How do i get vb to determine what drive/directory the currently running program is? I need a program to detect where it is located.

Advanced: Excel VB File Code Help Needed -
Hello I am needing some information/code to do the following: I am using the infamous macro Sub Auto_Open() to do this. For this example we will use a .txt filename called 'users.txt' which is always located in 'C:\store\'. Keep the following in mind: The 'C:\store\' directory is l

how to detect end of file of my excel page -
Hi, I have windows application that use com interop. This app successfully read and write to the excel page. My problem if have 10 or more lines how to detect the End of File? thanks

How to detect if mouse is out of the button -
Hi, I'm developing an Activex Command Button like IE Button. It's my first experience in making OCX and I'm in trouble. When the mouse is over the button I draw the frame around it (using the MouseMove method), but when the mouse is out of the control I need to erase that Fra

How to find the path to the current directory where the program is located -
Hi! I am developing a tool based on vb.net. in one of the procedures, i need the path to the folder where the tool will be located as i need to access an excel file which will be located in the same folder. Is there any method to get this path other than gett

Detect Excel Password with VB -
Is there a way to detect whether an Excel worksheet is password protected utilizing VB6??????

Selecting a file Excel/Access -
i'm trying to automate the import of an excel spreadhseet into Access 2000. The following code does so and imports this into a table called 'New'. However as you can see i have put the full path of where the spreadsheet is to be located everytime a user wants to import it. What i n

exe program that includes excel sheet does the user have..... -
I have a quick question, I am making a program which calls an excel sheet located on a cd, eventually I will convert the stuff on excel to java : ) but until then its on to excel and back to the question. Does the user have to have microsoft excel inorder to run the program, since it u

Detecting Hardware -
How do I Detect the following hardware: -Detect CD-ROM -Detect ZIP Drive -Detect JAZ -Detect Sparq -Detect Floppy -Detect DVD ------------------ Thanks, In Christ, Ben

detect excel version for an addin -
Hi i have used the built in addin template of vb and i have created an excel addin .My problem is that in the developing machine i have installed excel 11 and i want that plugin to run at excel 10 ,9 how could i make it so? thnks

msgbox with an OK and a Help button. -
I want to display a msgbox with an OK and a Help button. I'm not using the Help button to open a help file. I just want to detect when that button is pressed so I can display a simple help message. Problem is, I can't detect when the help button is pressed. Only the OK button ret

Detect when a browser window is closed -
Hi, I want to detect when a browser window is closed when clicking on the [X] button or through File option and Close option. Is there any way to do that? I know that a WM_CLOSE message is passed when the user clicks on the [X] button which in turn calls the DestroyWindow API. If not

[2005] open a file... -
Hi, how can I make it so that when a button is pressed, the excel file specified in a text box is opened, if it is located on the desktop? e.g: text box says "report1" the "open" button is clicked. I want it to run "report1.csv" in excel. how

Clicking a button located within another program (exe) -
I need to know how to click a button located within another program (exe) I do not have the source to the second program. Can someone provide me with some sample code. I assume I need to use the sendmessage API... It's just one button that i have to click on another program.

Detect Right Mouse Button -
i am creating a listbox that when an item is clicked, popupmenu appears, however i don't know how to detect the right mouse button. Someone pls help me thanx urgent thanx

how to create excel file when clicking on the button. -
Hi All, I have one vb form in that one button is there.when I click on the button Excel file should create in "C:\Program Files\Admin\test" path. I don't want to open the excel file when click on the button just i want create the excel file in above specified path.

Detect Form Control Changes -
Can anyone help me? I am looking for a way to detect when a control has been changed from its initial value, also for it to detect if it is changed back again to that original value. This is to be used to set the enabled property of my Apply Button? Any help greatly appreciated.

Excel Problem! -
im having a problem in running the excel in vb... i used the macro for generating the excel in vb... this is my problem... i run the vb and press the command button that contains the excel code and the excel appears and run properly and after it, i close the excel after generating the

Determine EXCEL is opening -
Hi, Is there any way to determine the EXCEL application is running? since my app use EXCEL app object to import/export the XLS file and what a way to detect if the excel is open then ask the user close it first before start the import/export process. Thanks!

How to detect image button change on external window -
I have a image button in external window and it changes to diffrent color on certain times. I want to detect such changes and do for example play a perticuler sound. Could any one tell me how i can detect image button color change.Thanks

How to see if user has Excel installed -
How can I detect if the user has Excel installed other than to trap an error when I try to instantiate the Excel application? I don't have any Excel-less machines around here to test this on either so I don't even know which error it would show.

opening two projects -
Hi All, I would like to know how I can open one project by pressing a button. For example: Project1 has a button in form1, and I want to open project2 by pressing the button in form1. The reason why I want to do this is because I want to pass in values from fproject1 so t

[2005] 2 Questions - Remove maximize box How to detect mouse button click -
Hi all I've been doing some search but couldn't find anything helpful, so I have 2 questions to make. 1- I know how to disable maximize box. However, I don't want a gray maximize box in my form. Is there a way to hide it? To leave close and minimize buttons only? 2- How can I

Saving Data on Excel -
On one form I open an excel sheet run a search to detect a particular string and delete it. I save the excel application and close it. Now when I enter the search string again, though it is already deleted from the excel sheet(which i can see after the opening the excelsheet), the va

VB2005 Detect changes in txtbox -
How can I detect changes that have been made to the textbox so I can enable or disable a button???

automatic detect and bind a Link to .mdb -
1.) Does anyone know how make an executable program (.exe) that has the capability to automatically detect a database regardless of where the database is located in the harddisk? (E.g. Everytime the (.exe ) program is executed, it will first locate for a datab

Launching Excel and including XLstart files -
I am very familar with referencing the excel object in a project and by using createobject("EXCEL.Application"). What I need to do is open excel(without actually knowin the path), grap the open application and do my work. I need the users to be able to execute macros in t

detect if a combobox text has changed -
Hello, On a form I have a combobox that displays either YES or NO. I also have a SAVE command button that saves any changes to a database, If the PAGE CLOSE command button is clicked, I need to detect if the YES NO text has changed and if it has been changed and the SAVE button has

Export Out to Excel -
Hi All, Im trying to write a small proceure from access to call excel and construct a small macro. My question is how do I write a macro to make a macro? For example in my Access applicaiton the user would click an export to excel button. THis button would launch excel and populate

Excel Files -
Hello everybody: I am using Visual Basic 6.0. I am reading an Excel file and downloading its information into a server. --I am using the For ... Next fucntion to access the Excel file and be able to get the information. For i = 1 to 2000 ........ code here ........ Next i

*Resolved* OnSheet_Selection -
Is there a VBA command (in Excel) that will run a procedure located in a sheet when that sheet is activated? I was thinking of something along the lines of the Selection_Change command but instead of having to change the focus on the sheet, I want the procedure to run when that sheet i

[2008] Detect Mouse Clicks -
OK I'm not really sure how to explain this so bare with me. I would like to have a form with, say, a button on it. When the button is clicked I would like to be able to click a control in a different application, and have my program (with the button) detect that click (first click a