Search results

Ok, let me attempt to be more specific. Within my DB, the table tblDetail is created from a command that is called on a form. This table contains the following field names: Vendor------OrderID-----Name-----Buyer-----Qty-----COGS and the data could change from one record (only one unique vendor...

Ok Bob, I am lost and obvious in over my head. Where exactly in your code provided below, do I insert the modifications that you provided in your last post? Again, this code works perfectly to transfer the table detail to the proper Excel file. Once exported, I would now like to rename the file...

Thanks Bob. The 2 field values (Vendor & OrderID) needed are stored in a table named tblDetails. I will make an attempt to update the current code with your suggestion and let you know how it turns out. Thank you for your help!

Really looking for suggestions on how to resolve this. Anyone?

Any feedback assistance here? Many, many thanks!!

Ok, I currently call a .bat file that copies the Test-tmp.xls (templated file with cover and formulas) and paste that file as Test.xls in the directory mentioned above. The code that Bob provided was perfect until I was asked to store the file by a specific name. What that mentioned, how can I...

Thanks DCrake, but unfortunately this did not work for me. The following error was given, "Unable to get the Open property workbook class". I failed to mention that the "Test.xls" workbook is a templated file that contains headings and other worksheet data that must remain intact. Set xlWBk =...

Hi Bob, thanks again for the code. On a related note, is it possible to modify this code to perform a 'save as' based on two field names from the table referenced in the above code (tblDetail)? The tblDetail has two pertinent fields: 1. Vendor 2. OrderID Basically, once the code is called, the...

Thank you very much!

Many thanks to Bob Larson for the code found below!! This helped me tremendously and I am hoping that someone could assist in adding some additional pieces. I would like to add a 'save', close and exit spreadsheet function to this code, however, I have been unable to do so. Much thanks for any...

I preface this with "Thanks" to any assistance provided. Basically, I have a workbook that contains a single worksheet named "Details". Within this sheet is a column named "Location" (Col B), which will be used as my criteria to perform the split. What I would like to do is create a new workbook...

Thanks Shades. I was able to extract everything to the left of the " with: Inserted into "K2" =MID(C2,1,FIND("""",C2,1)-1) and then I used =RIGHT(K2,2) to retriev the numeric values needed. This may not be the cleanest method, however it was the best results that I could produce at that...

Thanks in advance for any assitance. I have searched the forums and was unable to return any results (perhaps the incorrect combination of keywords to search). In any event, I have a spreadsheet that contains a text field in column C. The data in the text field is comprised of OEM part...

Disregard. I have it.

Can you share the code for the copy/paste functionality? Assuming the file you are copying is: C:/My Documents/Test.xls New pasted file would be C:/My Documents/Test2.xls Thanks again!

Just a thought, but is it possible to create a function in Access that would allow the Excel template to be copied/pasted? This would allow for a "blank" formatted template to exist, then the code would be directed to the path that the template was stored, copy it and paste with a new name...

Received "Compile Error, User Defined type not defined". Thanks for your help, I will approach this from a different angle. Just thought it would be efficient to automate as much as possible. Thanks again.

Yes, got that. However, being somewhat "green" with VB, I was uncertain how to clear contents of both worksheets. The following works well for a single sheet, however I am not certain how to incorporate VB language to clear data from both worksheets. Thanks in advance. Dim xlApp As New...

Thanks for the reply. Unfortunately, I cannot delete as the spreadsheet that I am transferring to contains code that performs multiple functions once the data is transferred. Any other suggestions?

Thanks in advance for any assistance! I currently have a DB in which a "transferspreadsheet" function is called and 2 tables are transferred to a "template" workbook in MS Excel named PM Upload. The tables transferred to Excel are (1) Listings & (2) Details. This is fine. What I am...