Perhaps all of these things can be done in one macro or module. How can I do what this site shows but completely automated via macros and/or modules in VBA?Ģnd Issue: If a solution to issue 1 is found, and a CSV file is saved after every time running that macro, is it possible to PUT that CSV via the API call in the same workbook the file was created? Again I am trying to make everything automated to make it as easy as possible for the people who will be using this workbook the most. I am trying to make this as automated as possible so others can just click a button in the workbook to do this export. I have a constant range of cells that will be converted to CSV (although they do not have constant value) and I don't really want the user to do anything with the CSV. XFileString = Application.GetSaveAsFilename("", filefilter:="Comma SeparatedĪ Filename:=xFileString, FileFormat:=xlCSV,ġst Issue: This example requires a couple extra steps after running selecting the range and saving/naming the file. Set xFile = CreateObject("Scripting.FileSystemObject") Set WorkRng = Application.InputBox("Range", xTitleId, WorkRng.Address,
Api vba range.cells() code#
I have code from this site that converts a range of cells into a CSV. The specific API that I am using requires the data to be in CSV. I am trying to export a bit of data from an excel workbook via API PUT.
0 kommentar(er)
