I had made project for data accessing using VB 6.0. and generated diffrent reports in VB. but my requirement is to generate output in EXCEL sheet. I had developed some code for it. but i got jut o...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
hey thanks for the help anyone... i seem 1 step away from getting this prject done. What i have to do is create a text file with 9 test grades and then load it into an array and display in picture...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I want to receive data via Com1 (serial port-RS232) and use it in Excel.The data which is sent by an external device is in ASCII-format.
I am using the attached codes. (ComPort.doc)
I am u...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
How do you protect a Excel Macro from being change or edited by a user?
...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Is there any way to copy only the populated cells in a worksheet via VB code? I am creating a dasa base that pulls data from worksheets that will be constantly updated with new info. I would lik...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I found this piece of code on the web to verify whether or not a named range exists.
Code:
Function NameExists(TheName As String) As Boolean
On Error Resume Next
NameExists = Len(ThisWorkboo...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Dear All,
Recently, after dropping my computer, I had to install a new hard drive, and of course, re-install XP Home plus all my application programmes; one of which was Visual Basic 6.0.
...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
i've got a VB6 app that prints and views reports using Crystal Report 8. i've been tasked to add another option to export some reports to PDF on the fly thus i've used CR XI for this job. so now...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Okay, Basically i have created a program which works in just the same way as a macro.
The application listens for a key to be pressed before it sends the text which is inside one of the text ...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I am using this code to print a textbox:
Printer.Print " " & Text1.Text
Printer.EndDoc
and this code to print a MSHFlexgrid:
Printer.PaintPicture MSHFlexGrid1.Picture,...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hello,
I am stuck on a program that is supposed to seach in an Outlook sub-folder and save the attachments to a specified location, then proceed to do other stuff. I had written it in VBA (wor...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I have a msflexgrid on my screen that needs to be populated using a sql query linked to an access database. Can you please provide me the code to populate the grid?
...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi, how to make a button by vb? While I move the mouse into the area on it the shape of mouse'pointer would be changed.Thanks a lot.
...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I am writting vba code to extract data from an oracle db and report out in excel.
However, I get the following message, when I try to launch the program
Error 3704 Operation is not allowed w...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hello there, I have a problem with my project. In my app i could start powerpoint presentation by pressing label, then i will have to know when the presentation end. Any ideas? Thank you very much...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I am new to the VBA of excel and am trying to do something that may not be possible.
What I have:
Work book with 5 work sheets. (Old in, redeployment, disposal, device info, and location) the...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I'm searching for VBA code that can read data from Excel worksheet, calculate the logistic regression equation using an IRLS algorithm, and output the equation (intercept and coefficient(s)) to th...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
To all you Gurus out there, can you explain this?
I originally wrote a programme in Word VBA, and have converted to VB6. The programme reads from MS Word documents, copies one of the documents...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hello all,
I put together a macro to search through an inventory, find product matches, then copy and paste the corresponding row of data into another sheet.
I'd like to be able to run consecutive...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
in my listbox for example I have this inside it: "spell number [25262]"
and when I click it I want just the numbers "25262" to show up in my textbox.
loading the listbox from f...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi
I was unsure even what to give this thread as a title as I cant figure out what the problem might be.
I have a project which has a form, you input data into the form and this is print...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hello all,
I have a large sports-products inventory that I have to categorize based on teams. The inventory is in one Excel sheet, complete with product descriptions, and I'd like to run wildc...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hey,
I have this problem with this vba script in MS word that I use in the office. A button calls for a Form to be loaded, and sometimes the form gets hidden behind the MS word window, and the...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I run my script and it remains open on the desk top window.
Here is the question-I want to click the script icon , it runs now I want it to close or better yet how do you run the script and it ...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Can anyone tell me what is wrong with this code. I have trouble writing vba sql statements because of the quotes and escape quotes being non intuitive.
I get an error saying number of fields ...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Browse sub-categories 
