Search results for query: *

Thanks for the reply Mark. I just wanted to know if there was a way to do it without having a spreadsheet open and close, its not really a problem if it does cos its only for a second.

Anyone know if its possible to execute an excel macro using vbs without opening the excel file? I know how to execute the macro by opening the file first.

I created a report in crystal reports that has links to other documents, when exported to word or excel the links work but when exported to pdf the links don't work anyone know how to get links to work in pdf? Thanks

Got it to work by adding each array as a new column to a datatable and binding the datatable to a datagrid.

I tried adding the arrays to an arraylist and binding the arraylist to a datagrid and that worked but its showing the field properties in the datagrid and not the actual data. Can anyone help with this? How do I make it show that data?

I have 3 separate arrays that I would like to display in a form, can anyone help with this. I tried putting the arrays into a multidimensional array and binding it to a datagrid but I guess you can't do that.

I wrote the following function that returns a DataSet but I get the following Compiler Error: The compiler failed with error code 2000 .vb file: Imports System.Data Imports System.Data.OLEDB Namespace GlobalFunctions Class Global Public Shared Function GetDataSet() as DataSet Dim...

I am converting a bunch of asp pages to asp.net. These pages all connect to a database with a shared function in a vbs file I can do it in classic asp by using <!#INCLUDE filename.vbs-->. How do I share a function between apsx pages in asp.net?

Thanks ca8msm it worked perfectly, only thing I had to change was from Dim arrResults as ArrayList to Dim arrResults as New ArrayList()

OK. Input is from a form where a user would enter two dates, begin date and end date. The code would then get the month and year between those dates and put them into an array. for example if they entered 1/1/07 to 3/1/07 the array should be {Jan07, Feb07, Mar07} The reason for the array is...

Here is the error 'For' loop control variable cannot be of type 'Date'. Here is the code Dim TheDate as date Dim ThisMonth, MonthYear, x as String Dim arrayMonthYear(0) as string For TheDate = FirstMonthDate To LastMonthDate Select Case Month(TheDate) Case 1: ThisMonth ="Jan" Case 2...

I am trying to loop around two dates but get an error message when I use a for loop. Is there a where to loop around two dates to get a string array of the month and year between the two date

WebChartViewer1 is the image in the code above

ASP.net programming is new to me do you think you could provide sample code. This is what I am using now but I don't get an image: Private Sub ExportToExcel1(ByVal sender As System.Object, ByVal e As System.EventArgs) Response.Clear() Dim tw As New System.IO.StringWriter() Dim hw As New...

Thanks, I was hoping to get asp.net/vb.net sample code. The image I get is a dynamically created image thats not stored anywhere.

Thanks for the info jmeckley, I will research some more. I would appreciate any sample code if you have any. Eric

I have looked everywhere and I can't figure out how to export an image to excel. I have know how to export a datagrid to excel but I'm trying to export an image as well. I would appreciate any help. Eric