| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA SaveAs function generates blank CSV file
This is a very simple line and it just doesn't work. What it did is just creating a blank csv file with nothing in it (the file name is correct though).
ActiveWorkbook.SaveAs Filename:="C:\temp\test" & ".csv", _ FileFormat:=xlCSV, CreateBackup:=False And it only happens on one PC. The other PCs runs it perfectly. Can anyone tell why? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ActiveWorkbook.SaveAs Function - Can I specify the user account tosave the file with | Excel Programming | |||
| "SaveAs" Generates error on shared drive | Excel Programming | |||
| How do I reference my current file in saveas function? | Excel Programming | |||
| workbook saveas function, xlText file format | Excel Programming | |||
| overwrite Excel SaveAs function from File menu | Excel Programming | |||
Threaded Mode
