• 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.

Recent content by akashbest@gmail.com

  1. A

    Excel Pivot Table not bringing back any data from Access Database Query

    I dont why but if you remove all wildcards (i.e Like, *) from your access query and re-create your pivots. It should work.
  2. A

    Updating PowerPoint Charts using VBA

    I have charts in my powerpoint slide and I have to often modify the chart data. That is, I modify the data into those embedded excel files in each of the chart. Would it be possible to connect to that excel file and modify the data using VBA.
  3. A

    VBA to update data from Excel to Sharepoint Tables/Lists

    Check this link to know more about SharePoint and Excel data transfer: http://msdn.microsoft.com/en-us/library/aa159897(v=office.11).aspx
  4. A

    VBA to update data from Excel to Sharepoint Tables/Lists

    @ S23: How are you planning to save your data into SharePoint - Would it be an excel file or on a SharePoint list? Comment on Option 1: If excel files, you can command files in a SharePoint list just like you do with one saved on your local machine. Just disable the Checked Out option for...
  5. A

    Why no Yahoo tag Codes to enable download of one mth, 3 mths, 1 yr 5 yr perf

    Please explain in detail, what are you trying to do?
  6. A

    Dashboards on Outlook email body (HTML)

    I want to publish charts/tables on week on week basis and need to send it to distribution list as visual dashboard in emails. Any suggestions? I have tried Ron De Brun's code, but its not giving the right clarity I am expecting. New suggestions?
  7. A

    Import Data from SQL Server to MS Access Table

    I was looking for a working syntax: Below is what I found and seems to be working well. SELECT * FROM [ODBC;Driver=SQL Server Native Client 10.0;SERVER=Your_Server_Name;DATABASE=DB_Name;UID=User_Login;PWD=Your_Password]
  8. A

    VBA manipulation of PivotTables

    Its simple - Use PT.DataFields(1).Function = xlCount. PT being your PivotTable object. You can use DataFields Index to loop through multiple data fields.
  9. A

    Import Data from SQL Server to MS Access Table

    I am trying to import data from a SQL Server Table to MS Access Table. Could any help me on can I get it done? I am using ADODB Connection and Select Into (from SQL Server to MS Access DB) query to perform this task. The VBA Code is written in MS Access Database. [SELECT * INTO...
  10. A

    Excel VBA - Checking Out and Checking In files In SharePoint Document Library

    @ Hui Macro recording does not help. I dont see any written when I manually perform this task. Any other suggestion?
  11. A

    Excel VBA - Checking Out and Checking In files In SharePoint Document Library

    @Hui: I have not tried recording but I believe 2007 recorder is not as good as 2003, but I will surely give it a try. @Dan: Funny. Well this is something because of which even I have been scratching my head for months. I am using SharePoint 2007 and someone just told me its possible with .Net...
  12. A

    Excel VBA - Checking Out and Checking In files In SharePoint Document Library

    I have number of files with OLAP Pivots in SharePoint Document Library. All I am required to do is to refresh these files on a weekly basis and save them at the same location. However, this whole process is very very time consuming partially due to size of the files and partially due to poor...
  13. A

    What Chart Types would you like Excel to have ?

    I would prefer Thermometer, Speedometer charts in the gallery.
  14. A

    Email Charts in Outlook Mailitem

    Hello Chandoo, Could you please suggest me the best/automated way to publish dashboards in the mail items. I want to publish charts/tables on week on week basis and need to send it to distribution list as visual dashboard in emails. Please suggest.
See more
Back
Top