Hi,
I need to insert a PDF file into a SQL Server 2005 varbinary(MAX) field using Visual Basic 6. I have successfully coded a different C# application to do this by loading the file into a...
Bit of background first:
I have 3 Oracle queries that need to be populated into an Excel file. My IT department set-up a website where I can enter an Oracle query and it will display the r...
I have a string variable in a VB6 windows program.
eg: strwhere string
I tried to save a big sentence with 400 characters in this string variable, but found that the complete sentence wa...
Hi,
I need to prepend the current date time to the name of a file, then create the file. The date time needs to be in the format yyyymmddhhmmss For example the file name could be:
2008083...
Hey Guys,
Is there a way to create a pop-up of an image when the user scrolls over a particular cell?
More specifically, i need the image to pop up to the side when the user is scrolling ...
I am looking for some code that I can use in a VBA EXCEL project that will create an email and attach a file using the default mail client on a users machine. I see lots of examples of using ...
Afternoon Experts,
I am writing a piece of VBScript that will remove the shortcut and folder of an application.
The shortcut and folder exist under the All Users profile, I have to use...
I have an application which stores data in a few multi-line text boxes. Sometimes this data is destined to be sent out through emails to the parties concerned. The emails are HTML formatted....
I have a VBA macro I use in Reflection for IBM, it also runs some data through Excel.
This macro contains a loop where it continues to run until there is no more data left in the Excel file...
I am trying to setup a print button on a form so when its clicked it automatically prints the form to PDF and names it. I installed a program called BullZip PDF Printer that gives you Visual B...
Hello,
I'm developing a software that needs to register an ocx when opening the program.
It works on XP but it does not register the dll on Vista.
Does anybody have some code to registe...
I'm taking an intro to VB class and I'm hoping someone could help me out. Is there a way to return more than one value from a function and use them independently else where in the code? For th...
We get delimited text files from our business partners that include part orders. The files are supposed to be tab delimited with a specific column arrangement. They are not. Instead the fil...
In a VB6 App, I have a button that calls the below code. The code basically opens up an Excel Workbook via automation and loops through a column making its contents a hyperlinked cell. The c...
Hi,
I have setup a form to send emails via Outlook and the emails are sent containing just text.
However, I want to send these emails containing HTML. Can anyone show me how I can set th...
can I arrange all items on x-axis in a chart in ascending order based on values on y-axis? Is it possible to do so through Vba in excel 2003?
Hi,
how can I embed inside an Excel file a Word file, and then with VB module launch the word file (In MS-Word, not as an Excel object) and control it?
untill now i just used 2 seperate fi...
Hi
I made user forms in excel vba and everytime i click on the form for editing record it gives me a pop-up message saying "Object required. Run time error 424".
Any help would be appre...
Hi,
I have a spreadsheet with column c being the hostname and d being ip addresses.
I need to determine which of these machines are alive, and the ttl (if possible)
I do have data in cell...
I have a DataGridView control on my form. In one column I've set the columnType to DataGridViwComboBoxColumn. How do I populate this combo box using only VB.NET?
I've found lots of exampl...
Blue helped me with this.. working good after a few bugs.. now what I need it to do since it creates the appointment on the person running the macros calendar is actually move it to a differen...
I have a sheet with several columns, and around 200 rows. I need to setup a web query for each name/url (see below)
I want to return each query on a new sheet, renamed to the corresponding n...
Hello,
I'm trying to write a program that will open up an ODBC connection to a SQL Server database and look up a value for each item in an array. For example I have an array of 20 purchase o...
Hi,
I'm writing an application using vb script and I wanted to log all the error messages to a text file in the local drive so I can refer back to that file as and when I needed. Can somebo...
nedd a 128 bit encrypt/decrypt in vb6.0
