I am creating some Jpegs on the fly using the copy method within Office products. Effectively I am taking a snapshot of some tables in Excel. I know how to copy the data. I now want to store the copied data into files in a temp directory. How do I take the information which is now on the Clipboard and paste it to a file which can be saved in a temp drive?
View 7 Replies
As part of test automation framework building, I need to record the activities done by the user in a video. Since I could not find a way to record a video directly in vb, I opted to capture a sequence of screen shots (print screens) and then convert it to a streaming video.
View 4 RepliesWe are using VB 2008. Because we want to make an service of an project we need also the settings of that project. We copy the app.config from the project to the service project but if we are starting the service project we don't see the original settings.
View 1 RepliesI'm trying to copy data from one workbook to another. The program first grab this data that comes in from a data collector and puts it in a excel spread sheet. It then closes its link to excel. I'm trying to grab that data out of the first spreadsheet and put it into a workbook thats set up like a template that will crunch the numbers. I'm currently dim-ing a varible called "grabber" as an Excel.range and setting it equal to the range of my raw data. Can I then say grabber.copy(Destination:=oWS.cells("A1")). I've been beating my head against a wall on this one.
View 6 RepliesI have 2 sheets in a workbook that have links on them. I need to copy both sheets into this new workbook at the same time to update the links and not have sheets looking for the original workbook (it just temporary and deleted after the copy). I thought I had it, but I cannot figure out how to deal with the array that is needed (I copied the code from macro builder in excel)..
oExcel.Application.Windows("EP Labor Calculator.xlsm").Activate()
oExcel.Application.Sheets(Array("Rates", "Labor Calc")).Select()
oExcel.Application.Sheets(Array("Labor Calc", "Rates")).Copy(Before:=oExcel.Application.Workbooks("SAP Test.xlsx").Sheets(5))
I have a large problem with inheritance in vb.net. The problem is the following:
I have 2 forms => frmBase and frmChild
In frmBase i want to create a method Called StartWorking() and i want frmChild to inherit this method.
But here is the tricky thing: when frmChild.StartWorking is called i would like the following => without calling MyBase.StartWorking()
I want frmBase.StartWorking() to be executed first and after a test in frmBase.StartWorking if blnValue is true then frmChild.StartWorking has to be activated. if blnValue is false that frmChild.StartWorking cannot be activated.
I am using Visual Studio Professional 2008. I am writing a program in Visual Basic 2008 that copies the Used Range from one worksheet to another worksheet, I am able to achieve this by the following code segment:
[Code]...
i am using itextsharp and creating a PDF with images. currently the images i am using in the application are on my desktop, but i will need to make an installation file that will put the images in a specified directory on the users computer and be able to call them from the specific directory.how do i include pictures with my build?how do i reference the pictures? currently i am using:
Dim jpeg3 As Image = Image.GetInstance(Environment.GetFolderPath(Environment.SpecialFolder.Desktop) & "2.jpg")
I've been working on a project for months now (vb 2008 express). There is one final which I can't solve.I need to send images to a client from a 'server'(listener). The code below works most of the time but sometimes the image is incomplete. I believe this might be something to do with the tcp packet sizes varying, maybe limited by how busy it is out there on the net. I have seen examples of code that splits the image into chunks and sends them out, but I can't get them to work maybe because I'm using a different vb version. The pictures to be sent are small 20k max.
Any working code examples would be wonderful. I have been experimenting and failing with this final hurdle for weeks.
[Code]...
when i am building the installation file i need to be including some jpegs and i need them to be saved to a specific location how do i include jpegs in the installation? how do i have them be extracted to specific directories?
View 1 RepliesPublic Shared Function EncryptRSA(ByVal infilename As String, ByVal outfilename As String, ByVal pubkey As String) As String
[Code]...
I'm saving a bitmap as a jpeg using: savedImage.Save(fileName, System.Drawing.Imaging.ImageFormat.Jpeg) which is resulting in a JPEG with a 96dpi x 96dpi resolution and a 24-bit color depth. Is there a way in VB .NET 1.1 to change this to say a 72 x 72 dpi resolution and a 16-bit color depth?
View 7 RepliesI created a VB.NET Winforms app a while ago that printed drawings. The way it did this was to copy files from a network share to the folder for a plotter's que. This plotter would automatically just print anything that was dropped into this folder, which was specified with a path like \Btltmkeng_plt_q. I would do this by using the System.IO.File.Copy method. This worked well, until the company switched to a new printer. When my app copies the file, the printer only prints blank pages.
However, if I open two Windows Explorer apps, and manually drag the file from the network folder to the printer que folder, it works! This proves that the printer can handle these files if they are properly copied. Therefore, I was wondering if there were "alternate" methods for copying files in VB. I tried using the My.Computer.FileSystem.CopyFile method, but that just error out saying it could not find the target folder. Is there another method that more closely resembles what happens when files are copied using Windows Explorer?
Part ot my program is to simple copy a range of cells ~21 000 rows from one WB (oSH) and copy it to another WB (oSHOut).I've red a lot of posts,tried a lot of variants, but nothing helps..Strange here is that if I copy less than 8500 rows, the paste to the destination range is OK.But if I copy the whole range ~21000 rows, vb.net trigers an error - "Copy method of Range class failed".So I tried to do this in several parts - 1 row to 8000, 8001 to 16000 ect.The first copy-paste works OK, on the secon - there's an error.[code]
View 5 RepliesI have a function that I use to copy files from one location to another.I want to incorporate a status bar to illustrate the progress of copy.I am assuming that I need to put additional logic after my File.Copy stmt below. [code]
View 9 RepliesI have a function that I use to copy files from one location to another. I want to incorporate a status bar to illustrate the progress of copy. I am assuming that I need to put additional logic after my File.Copy stmt below.
Public Sub CopyFiles(ByVal sourcePath As String, ByVal DestinationPath As String, ByVal fName As String)
If (Directory.Exists(sourcePath)) Then
[code]......
I've almost finished my multimedia project. On the photobrowser (which constructs thumbnails of every photo in a folder and draws them onto a bitmap which I then make persistent and from which the user can select a thumbnail and the image is shown in full on a new form). You can print the bitmap consisting of 100s of thumbnails or the full image associated with a thumbnail. The onloy thing missing is getting all the Exif info - which is proving more difficult than I expected despite the propetyitems in vb.net. Yes, I have set the encoding to UTF8 etc.
View 3 Repliesds.Tables.Add("OpenTickets") ds.Tables("OpenTickets") = ds.Tables("AllTickets").Copy()
View 2 RepliesPart of my program is to simple copy a range of cells ~21 000 rows from one WB (oSH) and copy it to another WB (oSHOut). I've red a lot of posts,tried a lot of variants, but nothing works. Strange here is that if I copy less than 8500 rows, the paste to the destination range is OK. But if I copy the whole range ~21000 rows, vb.net trigers an error - "Copy method of Range class failed". So I tried to do this in several parts - 1 row to 8000, 8001 to 16000 etc. The first copy-paste works OK, on the secon - there's an error
Imports Microsoft.Office.Interop
Imports System.Data.Odbc
oRNG = Nothing
oRNGOut = Nothing
oSH = Nothing
oSHOut = Nothing
[Code] .....
I am trying to split an array into a jagged array for easy manipulation, but I am having a bit of trouble with the Copy method of Array.This is what I have:
Dim masterData()() As String = New String(splitCounter.Count - 1)() {}
For i As Integer = splitCounter(0) To splitCounter.LastIndexOf(splitCounter)
Array.Copy(ServerResponse, splitCounter(i), masterData(i) = New String(), i, splitCounter(i
[code]....
I'm trying to use the sendkeys method SendKeys.Send(
[code]...
Function to copy whatever the user has highlighted. I have a console ap with hotkeys to open it. It locks up the computer and I have to use TaskMan to free it up. I know this is a simple piece of code but I must have something wrong with the sendkeys line.
How do I create a zoom bar like the one in Office? I mean the one that has a circular + and - button, and a numeric button that you can click on. I just assumed it was part of VB.net, but I can't see it anywhere.VBA VB.NET developer
View 7 RepliesI have a couple of Excel macros that are working exactly as I want, and I would like to load them on other computers that may have different versions of excel. I have VB 2008 Express, and I was hoping I could use this to create the add-ins, but I am unable to find the Add-In wizard. Am I overlooking it, or do I need some other version of VB?
View 3 Repliesi would like to create a private chat for our office branches.for sending simple message for the designated employee.and have a list of online employees.
View 1 Repliesthe create object command is not responondingi try createobject("Excel.Application") or ("Word.Application") but nothing happen.i have office 2007 i have added the references Microsoft Excel 12.0 object library and Microsoft Word 12.0 object library. I have added Imports Microsoft.Office.Intercop
View 1 RepliesI have a customer who wants to send emails to his customer and suppliers with confirmation of order, purchase orders etc. instead of printing them and mailing them (postal strikes in the UK, and threats of more).
I have the following code which works on a Vista machine:
Code:
'Created Outlook Application object
Dim OLApp As New Outlook.Application
'Creating outlook Namespace object
[Code].....
ive been asked to write a program to deal with supply chains (tracking commodities, personnel, etc). I want to create a program that will allow multiple office to run the same software and update their local databases as well as a central database.how to best send the data/ recieve it, and store it so that all offices can see, edit, and store the data both locally, and over the internet.
View 13 RepliesI'm trying to create a save button on my infopath form that when clicked, it automatically saves the infopath form to a directory. I'm running into some issues, I thought it would be simple but is quickly becoming confusing. [code] I've tried searching all over but couldn't find an answer that pertained to xml documents such as an infopath form.
View 4 RepliesI am working on a large spreadsheet with Macros. It worked fine when I only had one spreadsheet that the code was pulling from. When I added an array, I get the an error on the Activesheet.unprotect stating 'unprotect method of worksheet failed'.
View 2 Repliesfollowing error message:
Method not found: Void Excel.Range.set_Value(System.Object,System.Object)
