Search results

Thanks again. All I could do was screenprint and copy what I could see. I must look into how I upload to the site. However, instead of using the macro wizard, I created one, copying what I could see in it's contents posted on the forum, saved it, and then found the convert to vb tab was enabled...

I tried to insert a picture, but do not have a URL. My macro looks like this ExportWithFormatting Object Type Report Output Format Output File Auto Start No Template File Encoding 0 Output Quality Print Don't know if that is any help?

Thanks for coming back to me. Macros in 2010 and me generally are things I have not worked with before. In 2010 the macro design section opens up in a full page of just headings. Maybe I should read up a bit more, I was just hoping there would be a VB equivelent to what's in the macro thats been...

Thanks for your help, however still does not work. If I fill a listbox on a form (LP) with selected records and click the command button with the code above, the Excel application opens up and is filled. If I then manually close Excel nd repeat the operation by refilling listbox LP and clicking...

Thanks Richard. The code shown is on a command button, so I would have thought it would have gone through the same process again? But it just makes an Excel Application open showing nothing being entered in the page? So I need to know why it's not reusable code

Can someone tell me why I can only fill an Excel sheet once. If I run the code again it just opens a blank xls document. I have to close Access to make it work again. Thanks Dim oXLApp As Excel.Application Dim oXLBook As Excel.Workbook Dim oXLSheet As Excel.Worksheet Set...

I am using Access 2010. I have a dynamic report generator form, it fills a listbox filtered with user selections, and the listbox recordsource is used for the printed Access report. However I am now trying to send the report data to Excel. I tried using the command button wizard, selecting...