Recent content by Snappy1263

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,