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

  1. V

    Want to filter >180

    Thanks a lot for the Help Vijay !!!! It is working perfectly now !
  2. V

    Want to filter >180

    Hi, I have a column with data as 0-30 31-60 61-90 91-180 >180. I am able to filter out all values using VBA but when it comes to ">180", I am not able to select that value as criteria in autofilter. Can somebody please help me in this !!!! Thank you.
  3. V

    Separating data entered using Alt+Enter in a cell

    Hi All, I want to separate out data tht was entered using Alt+enter. I have used TTC but the problem is that it does not give the desired output. With TTC, the data gets separated into different columns. I do not want that. I want to separate the data into single column but in different rows...
  4. V

    read files in zip folder one by one

    Resolved by the fololowing link: http://www.rondebruin.nl/windowsxpunzip.htm
  5. V

    Reading excel Files without opening it

    I have understood it now.. !! I am sorry but I am new to Macros :) but thank you for your patience and posts !
  6. V

    read files in zip folder one by one

    I have declared "filesInSource" i am not clear on the Object variable it is refering to ... oPP is also declared !!!!
  7. V

    Reading excel Files without opening it

    HI Kanti, It is not just consolidation of hte data from different workbooks but it also needs processing it like filtering, separating data in different columns based on tabs and spaces, calculation etc... So, I wanted to know whether there is a way to read the files without the need to...
  8. V

    read files in zip folder one by one

    I have a zipped folder of excel files (around 16). I want to process these files using a macro one by one. I used the following code: Set folderPicker = Application.FileDialog(msoFileDialogFolderPicker) With folderPicker .AllowMultiSelect = False .ButtonName = "Pick Folder" .Show End With...
  9. V

    Reading excel Files without opening it

    Thanks Luke. I have written a similar code for this but my concern is that: "Set mybook = Workbooks.Open(MyPath & MyFiles(Fnum))" ... this call, physically opens the excel file. For me it takes a lot of time as there is huge amount of data in the file to be read. I was wondering if I could...
  10. V

    Reading excel Files without opening it

    Hi, i have huge data in the excels which i need to process. All the processing is done with the help of Macro,which is working fine. But it takes a lot of time for the macro to open the excel file (list of files) as the data is huge. Is there a way by which i can read the data in the workbook...
See more
Back
Top