I have an VB.Net/C# application that allows programatically:
Creates an RTF document
Open it up in Microsoft Word
Runs a Word macro that exists in the Word Template using code like this:
[code].....
My application (vb.net windows application deployed via ClickOnce) uses Word to open and fill .dot templates to create new Word documents. I reference Microsoft Word 14 Object Library and uses this code :
Dim oWord As Word.Application = Nothing
Dim oDoc As Word.Document = Nothing
Try
[code]....
On the last line I receive "could not open macro storage" error on deployed machines (not on my development machine).I develop with Windows 7 - Office 2010 - VS 2010 (.Net 3.5). My deployment machine is also a Windows 7 with Office 2010 installed.I tried to remove normal.dotm (I found some links advicing it) without success. The .dot template used contains no macro.
I have a Word macro that I want to run under Word 2003 and Word 2007. I would like to know if there is a way to check which version of Word is being used so that I can call different subroutines in the macro. Does anyone know how?
View 16 RepliesI would like to use Windows Scheduled Tasks to have a Word 2003 macro run automatically every week.I have automated an Excel 2003 macro by using Windows Scheduled Tasks and the Workbook_open event and was hoping to find somethings comparable to automated execution of the Word macro.I then start Excel by running a .BAT file from Windows Scheduled Tasks which in turn executes the workbook.xls file created above whic starts Excel, and runs whatever routines I called in the above .xls macro.
View 2 RepliesIs there a way to programmatically add a digital signature to a VBA Macro in a word document using C# or VB.Net?[code]...
View 1 RepliesWhen writing a manual in word I can create table of content. How can I get list of effective pages LEP with possible a loop checking for pagenumber & date then adding data to a table on a page in Word with VBA code/macro?
View 2 RepliesI am struggling with changing the Page Orientation of a WORD document I am creating programatically using VB.NET 2005.I need to change the orientation from Portrait to Landscape after the first page of the WORD document is created.I create a WORD document (2007) successfully and then begin to populate the WORD document with report information (taken from reading a text file and writing some if it to the WORD document)...I am using COM Microsoft WORD 12.0 Object Library....After the first page, the document needs to be changed from a PORTRAIT orientation to LANDSCAPE orientation.Since my application is generating several WORD documents from this one text file, it needs to be done programatically.provide assistance with small example of (writing text to word...page break...change orientation to landscape)?
View 3 RepliesI need some help regarding writing a macro to copy a particular paragraph from an active document. The criteria for copying is based on a particular word in a paragraph. The macro should scan the entire document and then copy and paste all the paragraphs that have that particular world. Kindly guide me in this.
[Code]...
I'm looking for a way to export a Word document as a PDF. I would like to do this without the use of a "software printer" (such as CutePDF, etc.) and stick to reference assemblies if at all possible. I'm using Microsoft Office Interop Assemblies to generate a Word Document which I save to a temporary directory. So its not necessary for this solution to interact directly with Microsoft Office, unless it needs to.
View 1 RepliesI'm have a program (GUI) that interfaces with excel to execute macros. We're using Microsoft.Office.Interop.Excel to call/run the macros and this works great.What I can't figure out is a good way to cancel the macros from the GUI.One idea we had was to use the excel.application variable that runs the macros to write a "stop" value to a specific cell in the workbook, and in the macros (they are all mostly loops), check for the "stop" value in that cell. This crashes my GUI with this The program '[2188] BVLReports.vshost.exe: Managed' has exited with code -336589910 (0xebf00baa).And excel gets tied up, and won't respond. I know how to Exit Sub from within the macro if the "stop" value exists, so I don't need answers on how to check/cancel from inside the macro. Any ideas on a better way to write this "stop" value or a better way to cancel the macros externally?
View 2 RepliesI'm learning about GAC and signing assembly! And I have some problems...1. I make a DLL having some basic functions in ONE SOLUTION (Signed and Compile)2. Then, I make a FormApp, add a reference to this DLL and using its function to do somethings in OTHER SOLUTION. No error appears!3. I run this project, so I get an error:A call to PInvoke function 'MyDLL.LunarDate:: ' has unbalanced the stack. This is likely because the managed PInvoke signature does not match the unmanaged target signature. Check that the calling convention and parameters of the PInvoke signature match the target unmanaged signature.
I tried 4 possible abilities that I can image:
1. I unsign DLL and re-add it to FormApp : It's OK
2. I sign FormApp with same pnk : The same error
[code]....
I'm searching for a way to validate (or bypass validation for) self-signed SSL certificates using VB .Net. I found code to do this in C# and tried converting it into VB code, but I'm not having any luck.
Here is the C# code. Here is what I tried:
Imports System
Imports System.Net
Imports System.Security.Cryptography.X509Certificates
[Code]...
I have an array of Bytes. Most of these are interpreted as Unsigned. On certain occasions I need to interprete the byte as signed. Why can't Byte convert to SByte? What I'm doing: I'm trying to program a disassembler for an 8-bit video game ROM. My program reads the ROM and processes each instruction. The instructions are interpreted as unsigned. Some arguments for instructions would be treated by two's complement in the original hardware, however, to make a signed number.
View 8 RepliesI'm working with byte arrays and building and disassembling Int16/UInt16 and Int32/UInt32 from them. I'd like to not worry about the Sign bit until I return the final value and just have the code return the appropriate value for the data type that was requested to be converted to/from the byte array
View 3 RepliesLooking for some .net snippet on accessing what users are logged into a domain. I have looked through all the AD namespace and okay with that in getting static items. Specifically, NOT looking for current logged in user for a given machine(have that as well). Looking for a list of users that are currently signed into a Domain.Essentially, I want to pass a user (or list of users) to a method that will check to see if the user passed in, is currently logged into the network (AD).
View 6 RepliesI have query that involves a cross-language operation, namely converting 4 SBytes to a signed integer. The source language for this operation is Java, which utilizes the ByteBuffer in order to extract a signed integer from the data stream. The inner workings of ByteBuffer are at best a black box to me, as I haven't been able to find any hints to what actually goes on when Java extracts the integer. [Code]
View 2 Replieshere know how to do to sign a file with certificate chain and crl embedded?I don't have ideia how to do that.
View 5 RepliesI'm looking for a way to locate signature field on PDF using VB.Net Or JavaScript and Acrobat and then I want to check if it is signed or not. Here is what I have so far:
Dim page As Acrobat.CAcroPDPage
Dim annot As Acrobat.CAcroPDAnnot
page = acroPDDoc.AcquirePage(0)
[Code]....
Im finding the annotations but I dont know how to check if it is signature field or not.
Im using the SSL stream class to connect to a server and authenticate their self-signed certificate. My authentication code gets an error: "RemoteCertificateChainErrors". When I drill down into the X509ChainStatuses, I only see a status of "UntrustedRoot" and status information of "A certificate chain processed, but terminated in a root certificate which is not trusted by the trust provider." This seems acceptable due to the self-signed nature of their certificate. I understand that I can ignore this error. However, Id like to do as much as possible to authenticate. I have a certificate from them. Ive been told to add their cert to my root certs somehow. How do I correct my code use this cert in authentication?
[Code]...
I need to be able to write signed bytes to a serial port using SerialPort.Write() method, except that method only takes byte[] arrays of unsigned bytes, how would i write a signed byte to the serial port?For what I'm working on the particular command takes values from -1700 to 1700.
View 1 RepliesHow can I write a signed byte (sbyte) to unmanaged memory using VB.NET? I can use Marshal.WriteByte() to write an unsigned byte, but there doesn't appear to be an overload for signed bytes.
View 1 RepliesNewbie here I need to send a email with and attached file (a *.xls file) The condition is that the e-mail need to be signed and crypted. I already got a digital certificate sign (provided by Verisign). I also read something about X509Certificate2 Class on MSDN, and something about Outlook interop Model. My idea was use the Outlook Interop Model Class (from Outlook 2007) but i have no idea how to do this.
View 1 RepliesSince I sign my project .exe files with my code signing certificate, I want to check in my application MainForm_Load if the executable is signed and the signature is valid?If not signed or signature has been tampered it must exit the code.
View 2 RepliesI need to read signed and unsigned 8 bit, 16 bit and 32 bit values from a file stream which may be little-endian or big-endian (it happens to be a tiff file which carries the byte order indicator at the start).I initially started by writing my own functions to read the values and was able to do so for unsigned values. e.g.
Public Function ReadUInt32() As UInt32
Dim b(4) As Byte
input.Read(b, 0, 4)
[code]....
But then I started looking at signed values and my brain broke.As an alternative, I found the IO.BinaryReader which will let me read signed values directly but doesn't seem to have any way to indicate that the data is big-endian or little-endian.Is there a nice way of handling this? Failing that, can someone tell me how to convert multiple bytes into signed values (in both byte orders)?
Im currently developing a custom logging component, that we will deploy with all our applications, windows services, webapps, windows apps etc. I have a few questions of various nature. The component is a single signed dll file:
1) Which is the "safest" way to get the current directory? For example, in the config file, in the config section I have a property "logpath". The application will read this and write a log file depending in what they write:
c:myapplog (it will write a log here, create whatever folders it need) /Log (directly under the installed app directory, like c:program filesmyappLog) Log (same as above) I need something that work with both windows and web apps, for webapps it will log under the virtual directory of the aspnet app.
2) For exception handling, if nothing special is happening, like in the DAL, I get a sql server exception, is there any point in using
[Code]...
I have been trying to compute the checksum for a line of hex code. This is to create a hex file which will be loaded onto an embedded micro.Some of you guys may not know how this is done so very briefly:
a line of hex bytes:
: 10 01 00 00 21 46 01 36 01 21 47 01 36 00 7E FE 09 D2 19 01 40
The underlined bytes are taken and summed. (in this case the decimal 960). and the bold is the checksum Only the 8LSB (or single least significant byte) is needed to compute the checksum... which in this case, 960 = 03C0 in hex, so only C0 is needed.Two's complement is then taken:
step 1) logical not of C0 which is
step 2) add one (integer)
BIN...........DEC...HEX
[code]....
So here is the code I have been using: (quick mention that in the string passed, the hex bytes are all grouped together, there are no space characters)
Public Sub CreateLine(ByVal Data As String)
'Dim BDataArray(DataLength) As Byte
Dim IDataArray(Data.Length) As Integer
[code]....
where i get into trouble is where i commented 'i get into trouble'. My code works, but it's rather crude Now, in that line i first convert the hex value (string) "SChecksum" into an integer. I want to NOT this, so I get my step 2 from my explanation. However, the results appears to be a signed logical NOT. which gives me the wrong answer. My hashed togther version simply subtracts 256 before the not, in order to give me the correct answer.
Basically, I would love for someone to chime in and point out the flaws in my function, and push me towards figuring out the 'proper' way of doing this. Also I can't quite wrap my head around what would happen in the case a string were passed to my function that is over 16 bits, but I imagine I would have to subtract a larger value than 256, before doing the NOT in this case?(whilst we're on the subject of functions, I've used a 'sub', in which case should I used a sub, and which case should I use a function?).
I would like to know how to convert a unisgned byte to signed byte
Atm I got this
a
Function readSignedByte() As SByte
'-128/127
Dim b As SByte
[Code]....
it doesn't work one that well works for numbers positive over 127 if lets say ReadByte() has 128 it would give overflow error which I don't want it to give I would like it to overflow the number to negivate value aka its signed value.
How can I download a pdf and store to disk using vb.net or c#? The url (of the pdf) has some rediection going on before the final pdf is reached. I tried the below but the pdf seems corrupted when I attempt to open locally,
Dim PdfFile As FileStream = File.OpenWrite(saveTo)
Dim PdfStream As MemoryStream = GetFileStream(pdfURL)
PdfStream.WriteTo(PdfFile)
PdfStream.Flush()
[Code]...
I have a .NET dll which I use from a C++ program. Now I have to register the dll programmatically on a deployment computer. How do i do that (programmatically! not using regasm)? I remember, when I once called a VB6 dll from a C++ dll, I had to use DllRegisterServer and DllUnregisterServer. Is that still so with a .NET dll? It seems I have to somehow add the dllregisterserver function to the .NET dll.
View 3 RepliesI have a customer that needs to convert XLS files to XLSB. Has anyone done this programatically, (with or without an add-on --- doesn't matter --- just need to be able to automate it)? I'm looking for a way to automate this.
As a side note, the customer is asking about this because they use Sharepoint, and it seems it has a way to analyze XLSB files quicker and easier than XLS??? I'm working to improve my Sharepoint knowledge, but in the meantime, I'm trying to find an answer to this XLSB issue.
