Recent content by jonx

Hello everyone, I am creating a listbox in which throughout the program, I am adding new items to the listbox. Unfortunately, the listbox stays completely empty until the very end. I was hoping though that my program would populate the list box depending on which portion of the program it is...

Hello, I am creating a program that uses Excel. What it does is it copies and pastes large amounts of data to other cells, and every time I run my program and exit, it asks me if I want to keep the data that I copied onto the clip board. Is there a way to get rid of this annoying message? I...

Thanks but I needed the code in Vb .net How would i do this in .NET? The MSDN library says that there is a built in method in the worksheet class: ThisApplication.ActiveWorkbook.Sheets(1).Copy( _ After:=ThisApplication.ActiveWorkbook.Sheets(3)) but it won't allow me to copy and paste...

I have some code here, but for some reason I can't get it to work properly. tempExcel.ActiveWorkbook.Sheets(1).Copy( _ After:=oExcel.ActiveWorkbook.Sheets(3)) I could copy from one worksheet to another worksheet on the same workbook, but if I execute the code above in which I am copying...

With the code above, I would like to copy one worksheet to another worksheet in another work book

Hello, I have two workbooks, WB1.xls and WB2.xls and I would like to copy the worksheet from the first workbook to the first sheet on the second workbook in VB.net How would I go about doing this>? Thanks

Thanks

Hello, I have an excel macro defined within an excel workbook, in other words if I push alt+F8 in Excel with that workbook, the macro will automatically run. Is there a way I could run this macro from VB .NET? Thanks

How would I go about converting an excel worksheet to PDF?

Would there be a way to paste VBA code directly into my VB project? I would like to run a macro within my VB project on an open Excel workbook. The macro is defined already in the workbook, so all I need to do is run it. Is that possible? Thanks

Hello everyone, I have an excel worksheet I would like to print in pdf using VB. I have the Adobe Distiller tool which prints into pdf, but how would I use this? Do I just print normally ussing the adobe distiller? How would I print anyways? Thanks

I would like to convert a worksheet to PDF. Would this be possible? and if so, how? Thanks

Thanks for the help guys

Thanks, But what does that "_Before:=blahblahbalh" do? Its after the copy? Do you know of any online tutorials I could look at? Thhanks again for the help -Jon

I have 2 excel workbooks, and I was curious how I would copy one worksheet of one workbook to another worksheet on the other workbook? This is what I have.. but it takes like 2 minutes to copy everthing over, and it isn't that big. Is there an easier way? Code: Dim pathToSheetOne...