Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. douglashindle

    Error saving XLS file as CSV in VB Script

    Got the answer! - Must only have one sheet. First I make a copy Next delete all but the first sheet in the copy. Last save as CSV. (May include extra steps that are not required.) ChDir "S:\" Workbooks.Open Filename:="S:\000 041405. crletterlog5.xls" ChDir "S:\MERGE"...
  2. douglashindle

    Error saving XLS file as CSV in VB Script

    I re-ran the code. The error is further down in the code. However, the file created has no size.
  3. douglashindle

    Error saving XLS file as CSV in VB Script

    I had previously tried it. There is a DDE connection failure from Word to this file. However I can save it manually without issue. I have rights to the S drive. I plugged in your code. The same error is displayed.
  4. douglashindle

    Error saving XLS file as CSV in VB Script

    I created a macro by recording keystrokes. There were several prompts during recording. I need to automate the answers. One question required me to agree to only save the active sheet or be prompted for a name for each sheet. Another prompt suggested I will drop formatting. I agreed to drop the...

Part and Inventory Search

Back
Top