• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

New profile posts

Hi Narayan

good afternoon.

We are looking to create an excel templet to get the cost estimation of any printing job. I am working for a printing press and the estimation system here is manual, which i need to move to excel automation. I can share you some video link available on youtube which will give an idea what we are expecting.

Please let us know, if you can create if for us.

Thanks
need help in exporting excel to csv, we need " in each field when exported to CSV
A
augustus
Public Sub ExportWorksheetAndSaveAsCSV()

Dim fn As String

fn = "_" & Format(Now, "yyyymmddhhmmss")

ThisWorkbook.Worksheets("Data").Copy

With ActiveWorkbook
Application.DisplayAlerts = False
.SaveAs Filename:="C:\TMU-Export\TMU_Sales" & fn, FileFormat:=xlCSVUTF8
Application.DisplayAlerts = True
.Close savechanges:=False

End With

End Sub
A
augustus
this is what we use for exporting to csv with date & time stamp
A
arifanmol
is there any way to automatically sum the cells and with automatic change in data range as the cells decrease or increase
Hi Luke,
Hope everything is great there!

I really need your help with my recent forum post. It seems easy at first, but somehow is beyond my excel skills.


Can you please have a look and check if this is possible?

Many many thanks!

Regards,
Amit
Hi Narayank991 - you have helped me in the past (thank you). I am not sure where to ask this question so I am asking you where I should post it. Is it possible to create a document from the questions and your drop-down list of answers from excel? ex: I have answered all the questions from the drop-down, can I export the questions with the answer I have chosen to a word or PDF file? Thank you kindly for your help.
Hi Deepak, Dear Sir , i would like some help for this small lotto application if it is possible i will pay you, thank you in advance.
Deepak
Deepak
Hey, Share me the link, if will help if i can
How Can I list only certain lines to another work sheet? Advance filter is not working! I have 100`s of Job numbers and 1000`s of invoice number. I need to copy certain job transactions into another worksheet. How can I do that?
I have just started learning VBA with excel and still finding challenges especially how to update the spreadsheet with marks against student names using text box in userforms. Can I find assistance?
Deepak - do you provide consulting work. I have some Excel formulae to write. I will pay you. How can I reach you?
Deepak
Deepak
Send me a private message.
M
maniniinfotech
hi am very new this excel and vba i need a formula to find the difference between two cells,and it should highlight the two cells based on the output value i have created if statement find the difference and output will be other cell "=IF(I1>=H1,(I1-H1),(I1+10)-H1)"
Hi Faseeh - I am looking for a copy of your Violin Plot example - would you be able to email me a copy please - peter.urbani@gmail.com

Many thanks,
Chandoo, I know that you have in the past been in contact with Mike Alexander of DataPig. I am having difficulty opening his Blog. Do you know if Mike has shut down his sites or if not, then I will have to determine why my PC does not let me access his sites. Appreciate your input on this matter. FYI--enjoyed your interview with Mike a few years back.

Alan
Wishing you a very Happy Birthday Deepak...God Bless you. Have a wonderful year ahead.
i Team,

I would like to get a macro code for the below activity.

I have bank statement in CSV format, my macro code code should read the close csv and get relevant data and create another csv and paste it there.


I have a database of account , account number and manageent company hence the code should only copy details for matching account from closed CSV .


Can someone please help me.
i Team,

I would like to get a macro code for the below activity.

I have bank statement in CSV format, my macro code code should read the close csv and get relevant data and create another csv and paste it there.


I have a database of account , account number and manageent company hence the code should only copy details for matching account from closed CSV .


Can someone please help me.
Back
Top