Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. EricBonsu

    Execute excel macro without opening file

    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.
  2. EricBonsu

    Execute excel macro without opening file

    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.
  3. EricBonsu

    Links in pdf

    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
  4. EricBonsu

    Display multiple arrays in table format

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

    Display multiple arrays in table format

    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?
  6. EricBonsu

    Display multiple arrays in table format

    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.
  7. EricBonsu

    Share Connection string between aspx pages

    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...
  8. EricBonsu

    Share Connection string between aspx pages

    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?
  9. EricBonsu

    loop around dates

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

    loop around dates

    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...
  11. EricBonsu

    loop around dates

    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...
  12. EricBonsu

    loop around dates

    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
  13. EricBonsu

    Exporting image to excel using asp.net (vb.net)

    WebChartViewer1 is the image in the code above
  14. EricBonsu

    Exporting image to excel using asp.net (vb.net)

    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...
  15. EricBonsu

    Exporting image to excel using asp.net (vb.net)

    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.
  16. EricBonsu

    Exporting image to excel using asp.net (vb.net)

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

    Exporting image to excel using asp.net (vb.net)

    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

Part and Inventory Search

Back
Top