Search results

This code works fine and gets me what I need. But is there a way to have this code tell it to start on a certain line and not do headings. I want the template to have the headings. Thanks,

I think I did it Private Sub Command8_Click() Dim filepath As String Dim sSheetName As String filepath = "S:\Allfiles\SUE'S STUFF\WORKING DESKTOP\2021 WESTLAND\ACCESSORIES\2021\2021 ACCESSORES .COM PRICING.xls" DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "BOM EXPORT", filepath...

This is a code I use to send the report to excel. I just want it to go to a template :) Private Sub Command8_Click() Dim outReportData As String Dim xlFileName As String outReportData = "SHARKSKIN EXPORT PRICING" xlFileName = "S:\Allfiles\SUE'S STUFF\WORKING DESKTOP\2021...

Thats fine. I know how busy you are. I will keep trying too. Thanks

Hi there, it has been quite a while. I hope are doing well. I have something probably pretty simple for you. I have tried figuring this out from everything you have taught me but I am stumped. I have a report that I would like to export into an excel template. Can you give me an example of...

the color codes are A08 S08 i need to copy the entire line but change the A08 to A01, A04 A07 and so on. there are 12 colors for the "A" and 10 colors for the "S". (they do not go in number order unfortunately) also the JBK-S on the end of the description needs to change to PBL-S, NAT-S...

i have attached a file of how it looks currently what i was hoping to get it to do is add all the other colors that need to be upload. right now i just insert lines add the colors and it is very time consuming. everything is the same except the color code and the description has the 5 digit...

I am not sure if this is even possible. I do a bill of material in a form with part numbers for (4) types of material in one color. Each material has several different colors. I do not do a BOM for each color because the cost is the same no matter the color. I then run a VBA to export all the...

I am trying to export 4 reports to excel so all reports got to one workbook and uses 4 tabs/worksheets. I can use the following for a table/query and it works great i get the tabs/wooksheet. DoCmd.TransferSpreadsheet acExport, , "90JJ AR by Rej", "C:\Documents and...

I used this and it worked great for a table or query in access but I need something exactly like this to export a report. I have formulas in this report and I can export it doing the outReportData command with no problems but I need 4 reports on specific worksheets in one workbook. The...