-
We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.
Visual Basic
- Thread starter glen
- Start date
BuckleDownBen
Banned
Yes VB can do that. However you are better off using VB for Applications, which is embedded in Excel (and all the Office apps). Open Excel and hit Alt-F11, that will get you started.
Whitecloak
Diamond Member
here's a way of doing in VB
use the "Microsoft Scripting Runtime" & "Excel" reference in the project
the code...
dim fso as filesystemobject
dim lfolder as folder
dim lfiles as files
dim lfile as file
dim objexl as excel.application
set fso = new filesystemobject
set objexl = new excel.application
set lfolder = fso.getfolder(filepath) ' filepath corresponds to the path to the folder which contains the files
set lfiles = lfolder.files
for each lfile in lfiles
objexl.workbooks.open filepath & lfile.name
' do stuff to the files here
objexl.activeworkbook.save
objexl.workbooks.close
next
hope that was helpful 🙂
use the "Microsoft Scripting Runtime" & "Excel" reference in the project
the code...
dim fso as filesystemobject
dim lfolder as folder
dim lfiles as files
dim lfile as file
dim objexl as excel.application
set fso = new filesystemobject
set objexl = new excel.application
set lfolder = fso.getfolder(filepath) ' filepath corresponds to the path to the folder which contains the files
set lfiles = lfolder.files
for each lfile in lfiles
objexl.workbooks.open filepath & lfile.name
' do stuff to the files here
objexl.activeworkbook.save
objexl.workbooks.close
next
hope that was helpful 🙂