Search results

You are my hero, thank so very much. This works perfectly just what I needed,.

Unfortunately this has to be a formal price sheet. This is for them to accept or not accept. What they do with it after that does not concern me.

So amazing it worked perfectly. One thing only that I am hoping that can be done. Not sure thought. Is there a way to put a row in between each model. Here is the excel sheet with what you designed. I just added another field and it worked great. But if I could have a row added, its not a...

The data needs to start on row 8 and here is the path to the template. S:\Allfiles\GLBT\BW\2022

Thank you sooooo much. I will get it to you shortly, my brain is fried LOL

Can this go to an excel template??

All, I do not know how my customers uses the spreadsheet for their system. I upload to my system and I have a template for that and use a text file, so I am sure it is something like that. It was just requested to be an excel price sheet. The price sheet must be formal with our logo etc. I...

The PDF BW report is the report and how I want it to look in the excel template. The PDF BW Price is what happens now when I send it to excel

That is a great code. Is there a way to only put the model once instead of each line in your example. This is my major issue. My example snip.

Yes, I already use a PDF but our customers now want excel spreadsheets instead. They upload the pricing in their systems. I realize they can convert the PDF to excel themselves but they are requesting us to send it in excel. I was trying to simplify it and eliminate some steps I have.

I have reports with headers and grouping. I would like to export this to a excel template. I know how to send to excel the data from the query to a template and export the report directly to excel. But I don't know how to do it so when it gets to excel it looks exactly like the report. I...

Hey there, Its been a long time. Hope you are well. I have run into a small problem and I know you will be able to help. I searched as much as I can to find the answer. As you know I have a template that my data exports to using all the codes you helped me with. Well I have to do drop down...

Thank u for getting back to me. Sorry to have bothered u, I tried to figure it out myself but couldnt find anything that worked. Yes you are correct. There are 2 reasons why...one is so that it will automatically save we are doing hundreds of records n adding a letter on to save it as a...

Ok so i have been trying to figure this out for a couple days and then i realized the problem.....when the export does the save as it puts the date and then runs the second code to put the footer in. obviously the names have to be the same so it will look for it to put the footer there. I am...

Hey there....havent heard from you but i am sure you are busy...just wanted to make you were notified that i sent you some stuff. thanks,

ok i figured out how to rename with time and date but i was thinking can you save as with a name that is in the cell like A2. so the file is saved as the part number in the excel sheet??? my mind is on a roll LOL... thanks,

got another question you have the template save as by the date. is there any way that it can be saved as a sequential number each time. we are doing many of these on the same day and we have to constantly saves as. if it can do it for us this will save us some time. can we add at number...

Hi its me again. everything is working great... except 2 things. 1). if there is not data in the subform but there is info on the main form that needs to export. It say not record so so it wont export. is there a way to tell it to export anyway. Here is the current code. Private Sub...

OK so I will have to do 3 separate exports to get the data in the places i need. Which is ok but this is getting so complicated that i am the only one that will be able to do this. our new system is not very good for my job but i didn't have a say lol..... Thank you for all your help. I...

Ok it works that way but is there a way to have 3 footers instead of 1... Reasons i have 3 part numbers (3 lines that export to the template) each line has these labors....it works to export 1 line but can it do more.... If not i would have to have 3 separate uploads im sure this will have...