10,989 Topics
| |
Hi All, I am new with the send keys in VBA. Basically I'd like to send a bunch of sendkeys. I don't have problem with the synthax but the problem is that excel only execute the 1st sendkeys I have written. [CODE]Sub test() SendKeys ("^+F") Wait SendKeys ("^+L") End Sub[/CODE] … | |
Please help, I want to write a macro to use the content of a cell in worksheet as file name and save the file at the desktop | |
I am using line function to draw line in the picturebox from the x1,y1 to x2,y2. I can draw it, but I also want to write a string on top of the line. My application is drawing a cable across with corresponded voltage, Something like 110 ------------------------------------------- but the line … | |
Dear friends! Can anyone tell me how can I connect an additional data query I created inside the tableadapter (inside dataset-editor) to a combo box list? So I will actually see the data in list. I managed to create a query inside tableadapter, which only contains data from one column … | |
I have an Excel workbook containing named variables across several worksheets. In one of these worksheets I have a "run solver" button, which kicks off a VBA routine. The first thing this routine does is allocate values of variables picked up from the workbook to local variables inside the VBA … | |
i was just wondering can anyone here give a concise explanation of how the statement : For Random As 1 executes and what is the syntax for this. Thanks | |
How can i find the difference between two date like '01/01/2008' and '01/01/2010' my date format is "mm/dd/yyyy" | |
Hi all I want the data shown in MSH flex grid to be shown in crystal report. I am using Crystal report 8.5 If the value in the grid changes then the crystal report must be updated accordingly. Is this possible to do? | |
Hi experts I am supposed to design a VB application wherein the following requirement is needed: The user will select the type of software and information about who uses the software available in my database to be shown in flex grid. Now the user can choose one, two or all … | |
hi all, I am completely stumped out but I did not find the solution of my query so far. so I am in hope posting this here in this forum. My query is: I have an application runs on my desktop. I want to take data from the desktop application … | |
Hello everyone! I am a geotechnical engineer and have been tasked with editing hundreds of excel files all in the same way so I decided to go back to my college intro to C days and make VBA do all of my dirty work! Anyhow, *I* think I am having … | |
Hello, I have a vbscript file whose file size is 0.9 MB. I opened this vbs file and copied all the lines in it and saved it into a new vbs file. And I noticed the size of this new vbs file became almost half reduced to 0.55 MB. Anyone … | |
Private Sub cmdusername_Click() Set adorsRAM = New ADODB.Recordset sSQL = "Select User from Master where CPU_No='" & txtcpuno.Text & "'" MsgBox (sSQL) With adorsRAM .ActiveConnection = cn .CursorLocation = adUseClient .CursorType = adOpenStatic .LockType = adLockOptimistic .Open sSQL End With If Not adorsRAM.EOF Then 'txtusername.Text = adorsRAM Else MsgBox "No … | |
Good day. Is it possible to send sms with vb6 via a wireless sms modem device like globe tattoo, smart broadband, etc..? Just need for costumer notification service. Thank you guys for giving time. God bless us. | |
I have a datagridview on my form called "mainGrid" and im not very good with XML buti found a small example to load but not one to save I wondered if there was a equally simple way to save! Heres the loading code: [code] Private Sub loadGrid() Dim ds As … | |
Hi I would Like to set my vb form caption from database can do this pls help me urgently | |
I wanted a feedback from people who have done this before: reading hundreds of data files and creating a chart for each using VB. Is this a viable approach to do this? as in, how is VB speed and does Excel give up on you when you do the plotting? | |
Hi i am doing one project in vb6.0 with ms-access 2003 database. i want bulk data updatation in one table from excel sheet. is possible , if possible pls give me a good solution. my table name : segment transaction its contain more then 20 columns , my updatation for … | |
hi experts please help me with this code [CODE]Private Sub cmdreport_Click() Set crApp = New CRAXDRT.Application frmViewReport.Show Set adorsRAM = New ADODB.Recordset Set report = crApp.OpenReport("D:\Ankush\created\proj11\Reports\Report1.rpt") sSQL = "Select type, user, location, cpu_no, model, speed, ram_unit from Master where RAM=" & Form1.cmbram.Text report.ParameterFields.Item("pRAM").Value = Str(cmbram.Text) report.DiscardSavedData 'CLEARS REPORT SO WE … | |
In VB6, how would I subtract 1 from a Hex? Do I need to convert to Integer first? (have tried HextoDec function, but not having success) Example Hex = FF FF Hex - 1 = FF FE | |
Hi How can i send data from vb text box to crystal report text object directly | |
Hai Experts, I need to convert the pdf files to word document , i have seen some softwares that converts pdf files to word document , i need the component or and activex dll to perform this work if anyone have done plz. plz try to help me | |
Having a guy help me with some code, however, he doesnt know VB6 and only has freebasic I need to convert the following into VB6 so I can make a user interface (comport selection etc) but not sure how to do it. Even a step in the correct direction would … | |
Hi I'd made a form using visual basic and added a few check boxes. I want to know you save the check box item into Microsoft Access Database when I click on Save. for instance: checkbox1: item1 checkbox 2: item2 checkbox 3: item 3 and in MS Access, I have … | |
Just downloaded Office 2010 to see what changes have been made in the VBA environment and all looks well. But i am having a big problem typing in my code! as soon as i type something it appears in red, it autocorrects so fast that if i type .range("A1") it … | |
Hi, i have got code: [CODE]Dim numbers(99) As String Dim howmany As String Private Sub Command1_Click() howmany = InputBox("how many number you want input?") For x = 1 To howmany numbers(x) = InputBox("Enter a number") Next x FontSize = 14 For y = 1 To howmany Print numbers(y) Next y … | |
Hi, i am trying to create a program where user can add picture to a form at runtime..and store it in a database as well...i am using following code to define array of picturebox and load a picture in it... [code] Dim mimage() As PictureBox ReDim mimage(0 To num1) As … | |
Please help. Can you help with the code I require? I have tried but I don't seem to beable to get it right. I have simple I/O Random FIle which works fine but I would like to be able to input a string into a textbox to find the record … | |
i have been trying to make a program to transfer any kind of files through [B][COLOR="Green"]serial port[/COLOR][/B] using [COLOR="Green"][B]VB6[/B][/COLOR], i was able to transfer the text file but not other files so please help me on this | |
|
The End.