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!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by 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"...- douglashindle
- Post #6
- Forum: VBA Visual Basic for Applications (Microsoft)
-
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.- douglashindle
- Post #4
- Forum: VBA Visual Basic for Applications (Microsoft)
-
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.- douglashindle
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
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...- douglashindle
- Thread
- Replies: 6
- Forum: VBA Visual Basic for Applications (Microsoft)
