Search:

Type: Posts; User: zmagic; Keyword(s):

Search: Search took 0.00 seconds.

  1. Replies
    11
    Views
    212

    Hi Maudibe, After the last post there is no...

    Hi Maudibe,

    After the last post there is no response from your side, please reply with udpate i am awaiting.

    Thanking you in adavance
  2. Replies
    11
    Views
    212

    Hi, Thanks for the response. You are...

    Hi,
    Thanks for the response.



    You are absolutely correct, I don't now the future, please don't bound to 4 columns tomorrow the columns may increase, so what ever must be appended.
  3. Replies
    11
    Views
    212

    Thanks Maudibe for helping, I have created...

    Thanks Maudibe for helping,



    I have created the conversion list in the attached workbook sheet.

    Regarding writing directly to their perspective CVS was not in mind, but if its possible than...
  4. Replies
    11
    Views
    212

    Thanks Maudibe, Your codes are faster. I need...

    Thanks Maudibe,

    Your codes are faster. I need a small change in Column B (sheet names) in Column B if 3 then create sheet as 100000003, if its 19 then 700000019 i have a list for all of them. Its...
  5. Replies
    11
    Views
    212

    Thanks Zeddy, I neeed your advise/decision....

    Thanks Zeddy,

    I neeed your advise/decision.
    This data which we will append in the sheet will grow to large voulme approx. 2/3 Hundred Thousand Serials will be stored from Column F onwards.
    Is...
  6. Replies
    11
    Views
    212

    Import, Append and Split

    Hi,

    To import and append the data in the existing master sheet which have records in them, While importing the data, column E all 24 digits to be imported then the zeros are to be trimmed in this...
  7. Replies
    2
    Views
    9,482

    Hello, RG, Thanks for Help, Solved.

    Hello,

    RG, Thanks for Help, Solved.
  8. Replies
    2
    Views
    9,482

    Run Batch files in Powershell script

    Hello,

    I want to run the batch files from powershell script and i searched the net & according to me this is good: [ & 'C:\somefolder\batchfile.bat' ]
    I have 3 batch which i want to run...
  9. Replies
    1
    Views
    289

    Concate email address

    Hello,

    I have a database of our clients wherein from column C to column F i have email address now i want to concate them with a semicolon [;] and to have them in column G. At times i have email...
  10. Replies
    0
    Views
    502

    FTP Download - Needs Help

    Hello Experts,

    I found this VBA script online and i use to download the files from FTP Server, .img & .xml files from an ftp server. It works fine, successfully.
    However, there are some issues...
  11. Replies
    4
    Views
    1,305

    Thanks Paul, It's amazing,amazing i never thought...

    Thanks Paul, It's amazing,amazing i never thought it.

    Thanks.
  12. Replies
    4
    Views
    1,305

    Hi Paul, Well said Paul, if you extend me...

    Hi Paul,

    Well said Paul, if you extend me help, this is scenario the folder contains multiple files and they are infact the response files to xml files.
    File names:...
  13. Replies
    4
    Views
    1,305

    Run Batch file inside the selected folder

    Hi,

    I import multiple xml files via this script. Once i select the folder for xml files to append i want to run a batch file. The batch script renames the files inside the folder. Then to...
  14. Replies
    20
    Views
    9,659

    Thanks Maud, You have done it, Maud 1 help more...

    Thanks Maud, You have done it, Maud 1 help more while importing multiple xml it imports the Header Row for each file, Please delete that header rows. Not required
  15. Replies
    20
    Views
    9,659

    Hi Maudibe, I open the file with option of 'As...

    Hi Maudibe,
    I open the file with option of 'As an XML Table'. This option set xml file in order of column and rows automatically.
  16. Replies
    20
    Views
    9,659

    Hi Maudible, The data from the XML files are...

    Hi Maudible,

    The data from the XML files are imported out of sequence into the Excel columns. Is there a simple fix to the code for this. Secondly it only imports the first file and other xml...
  17. Replies
    20
    Views
    9,659

    Importing multiple XML files into Excel

    Hello,

    I want to import all the XML files into Excel for reports. I was doing this one XML file at a time but this is of course silly.
    Anyway a Excel VB Macro code for importing multiple XML...
  18. Replies
    4
    Views
    457

    Thanks steve for your script, I tried it gives...

    Thanks steve for your script, I tried it gives run time error '53' on this line "Open sFile For Input As lFileNum"
  19. Replies
    4
    Views
    457

    Search Files in Folder

    Hello everyone,

    My spreadsheet has names of files listed in column A and i want a macro to search for that files in folder and found search result in column B 'Yes' 'No'.

    Part 2 The search...
Results 1 to 19 of 19