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...
Is it possible for a VBscript to open a maximized (not fullscreen) Internet Explorer window and bring it to the foreground? I am using a VBscript to call an IE window and uses it as a form to...
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...
Hi experts,
I am opening a picture with mspaint by using the shell command. (I will actually be using something other than paint when I get this to work)
This works fine:
(Assume the pic...
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...
I have the following VBA code:
Private Sub Command1_Click()
Dim StateData(,) As Integer
StateData(0, 0) = 1
StateData(0, 1) = 2
StateData(0, 2) = 3
StateData(1, 0) = 11
StateData(1,...
I want to run this excel with a macro that runs to import this particular txt file in the same directory as the excel file is in. At the moment directory is hard coded but I want to make a cha...
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 want to send email using Vb6 through Outlook using current profile of my outlook which includes tail signature and also filling all adress in BCC only and also without opening OUTLOOK.
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 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'm working on a VBA macro for a spreadsheet. I need to be able to take cells such as these:
2 LIVE CREW
BANNER,DAVID
SNOOP DOGG & DEBBOUZE,JAMES
And rearrange the text to say:
2 LI...
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 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...
Dear Experts,
I'm having trouble with the LoadPicture function. Some corrupted images raise the 481 error, which I can trap, but other corrupted files do not raise an error and just freeze ...
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...
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...
Hi,
I'm trying to create a function which 1. logs errors to a text file within the same directory the module it is handling and 2. rolls over on a monthly basis. I've worked out basic logg...
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...
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,
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...
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,
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...
